locked
Consume JSON in SSIS RRS feed

  • Question

  • Dear Team,

    I have a below JSON script. I need to run the below script, fetch the json files and parse them in SSIS.

    var client = new Keen({
      projectId: "<PROJECT_ID>",
      readKey: "<READ_KEY>"
    });

    var extraction = new Keen.Query("extraction", {
      eventCollection: "purchases"
    });

    I tried using script component, but unable to find any ideas on how to capture these JSON.

    Any ideas are really appreciated.

    Thanks in Advance.

    Tuesday, June 23, 2015 10:54 AM

Answers

  • refer this

    https://jsonsource.codeplex.com/


    Please Mark Answer if it solved your issue, Vote As Helpful if it helps to solve your issue

    Tuesday, June 23, 2015 11:00 AM

All replies

  • refer this

    https://jsonsource.codeplex.com/


    Please Mark Answer if it solved your issue, Vote As Helpful if it helps to solve your issue

    Tuesday, June 23, 2015 11:00 AM
  • thanks for the quick reply. 

    I will install it and get back. :)

    Tuesday, June 23, 2015 11:21 AM
  • The project at the above link as of today has not resolved issues with installation.
    Tuesday, September 1, 2015 1:12 PM
  • Having looked at https://jsonsource.codeplex.com/ which l did eventually manage to install successfully (using manual process) in Visual Studio 2013.  This tool could be of use for a simple RESTful service.  For the one l am looking at JIRA cloud l require to supply some headers.  Which the current version is not able to add.  From a postings on the project the developer is addressing the installation issues and adding other features such as the facility to add headers.  So l would recommend having a look to see how far the project has progressed.

    The ZappySys tools are also worth looking.  Based on both price which compared to other tools is very reasonable.  The feature set for the tools l used are good, not as intuitive as l would have liked.  That said l was able to get up and running fairly quickly, and to the companies credit they responded very quickly to the automated help request.  Documentation is a little sparse, the video for the tool used was good.   Overall l would recommend and giving it a try 30 day free trial should be more than enough time.

    Or you could write your own using a Script component?

    Friday, September 4, 2015 9:12 AM