Your data. Anywhere you go.

New Relic for iOS or Android


Download on the App Store    Android App on Google play


New Relic Insights App for iOS


Download on the App Store


Learn more

Close icon

Feature Idea: Insights API - change the json format? (using facets keys are missing)

nrql
insights
feature-idea
json

#1

I have an NRQL query that produces a count from Transaction FACETed by multiple different Transaction values (appName, name, dateOf(timestamp))

It works as expected, producing the required tabular data via the Insights web GUI.

When I examine the json output (the format I need), it looks like this:

    {
      "facets": [
        {
          "name": [
            "myAppName",
            "WebTransaction/Custom/request/myAction",
            "August 26, 2019"
          ],
          "results": [
            {
              "count": 463267
            }
          ]
        }
      ]
    }

The faceted values are in a ‘name’ array, not shown as key/value pairs.

Is there any way to add keys to the facet values, so that the output is more like this:

    {
          "facets": [
           {
            "appName": "myAppName",
            "name": "WebTransaction/Custom/request/myAction",
            "date_of_timestamp": "August 26, 2019"
           }
          ],
          "results": [
            {
              "count": 463267
            }
          ]
    }

or better still:

    {"appName": "myAppName", "name": "WebTransaction/Custom/request/myAction", "date_of_timestamp": "August 26, 2019", "count": 463267}

New Relic Edit

  • I want this too
  • I have more info to share (reply below)
  • I have a solution for this

0 voters

We take feature ideas seriously and our product managers review every one when plotting their roadmaps. However, there is no guarantee this feature will be implemented. This post ensures the idea is put on the table and discussed though. So please vote and share your extra details with our team.


#2

That sounds like a good idea to me! @edwardo - but not currently possible. I’ll get a feature idea filed for you though. :smiley: