0 Replies Latest reply on Sep 27, 2018 11:06 AM by Stephen Crocker

    JSON format question from Azure Application Insights

    Stephen Crocker

      I'm trying to GET a query from Azure Application Insights to bring into tableau.  The method I was using was bringing back a bunch of unwanted results.

      Long story short.  I created a query that would run in postman and bring back the desired results but the JSON is not in the same format, it's in Tables Rows type of format.

      Has anyone worked with this and could help with how to loop through this and get it into tableau?

       

      Here is the json

      {JSON.png

          "tables": [

              {

                  "name": "PrimaryResult",

                  "columns": [

                      {

                          "name": "timestamp",

                          "type": "datetime"

                      },

                      {

                          "name": "url",

                          "type": "string"

                      },

                      {

                          "name": "user_Id",

                          "type": "string"

                      }

                  ],

                  "rows": [

                      [

                          "2018-09-25T19:51:53.9520312Z",

                          "https://dealanalyzer.azurewebsites.net/doitrade/?location=31737863-c431-e611-9420-90b11c44c42f&limit=70858860-dcf7-4b69-a04f-d13f804a5041",

                          "test@test.com"

                      ],

                      [

                          "2018-09-25T19:52:03.0066707Z",

                          "https://dealanalyzer.azurewebsites.net/doitrade/api/v1/limits?location=31737863-c431-e611-9420-90b11c44c42f",

                          "test@test.com"

                      ],

                      [

                          "2018-09-25T19:52:03.7258903Z",

                          "https://dealanalyzer.azurewebsites.net/doitrade/api/v1/reports/dealanalyzer?limit=70858860-dcf7-4b69-a04f-d13f804a5041&location=31737863-c431-e611-9420-90b11c44c42f",

                          "test@test.com"

                      ],

                      [

                          "2018-09-25T13:57:44.8168206Z",

                          "https://dealanalyzer.azurewebsites.net/doitrade/api/v1/limits?location=0bce6564-26c5-468e-84a2-2f5f59457fff",

                          "test@test.com"

                      ]

                     ]

                }

           ]

      }