2 Replies Latest reply on Jun 21, 2017 7:16 AM by xcheung RSS
    xcheung Newbie

    I have the url that contains JSON file data, hope to convert into infotable

    Hi all,

     

    I want to convert JSON file (have url) into infotable, so I:

     

    1.Found snippets have GetJSON function, so i edit the scripts:

    var params = {

       // headers: undefined,//"{'data'}" /* JSON */,

        ignoreSSLErrors: true /* BOOLEAN */,

        useProxy: undefined /* BOOLEAN */,

        proxyHost: undefined /* STRING */,

        url:"http://localhost:8080/test" /* STRING */,

        timeout: 500 /* NUMBER */,

        proxyPort: 8080 /* INTEGER */,

        password: "MyPassword" /* STRING */,

        username: "MyUsername" /* STRING */

    };

     

    // result: JSON

    var result = Resources["ContentLoaderFunctions"].GetJSON(params);

     

    2. Created the DataShape based on the Key of JSON file.

     

    3. After I save the script and test, cannot get the infotable.

     

    Anyone can show the detailed steps to convert from JSON file to infotable? Thanks!