Unable to extract JSON REST API data, any recommendations

Grafana Time Series Panel
1

Hi,

I am trying to visualise some JSON API data, however when trying to extract the data it’s like the data does not exist and there are no headers to extract from. I was under the impression it could be the output format of the JSON not allowing the plugins to recognise the information to be extracted.

I have tried using the following plugins

  1. Infinity: No data found
  2. Simple Json: Failed to fetch data

See the attached images of the JSON API call in browser
The API setup with Infinity and Simple Json

Any recommendations on how to approach solving this challenge?

Much appreciated your assistance and support.

Infinity Display
Infinity Display1916×1016 107 KB
JSON in Browser
JSON in Browser1913×499 235 KB
Simple Json Display
Simple Json Display1919×1010 54.4 KB

2

I can help you in case if you post the json response. It is hard to read the data structure from image.

3

Hi yesoreyeram,

Are you the Infinity creator?
Below is a copied raw output from the browser

Thanks

{“Status”:“OK”,“StartDate”:“2020-01-01 00:00:00”,“EndDate”:“2020-03-31 00:00:00”,“Rows”:{“Target”:[{“Keyword”:"",“Views”:“5”,“Cost”:“0.850”,“Clicks”:“0”,“CTR”:“0.00”,“Conversion”:“0”,“CR”:“0.00”,“CPA”:“0.000”,“Revenue”:“0.00”,“Profit”:"-0.85",“ROI”:"-100.00"}],“Ad”:[{“AdValue”:“Ebony 338x235-Image+Text Banner630”,“Extra1”:"",“Extra2”:“338x235”,“Extra3”:“teen,brunette,heels,stockings”,“Extra4”:" desktop",“Extra5”:“403137”,“Extra6”:"{user.browser}",“Extra7”:“BC”,“Extra8”:“1842687”,“Extra9”:“snippet A Headline 57”,“Extra10”:“snippet B Image 65”,“Views”:“1”,“EngageRate”:“0.00”,“Cost”:“0.170”,“CPV”:“0.170”,“Clicks”:“0”,“CTR”:“0.00”,“CPC”:“0.000”,“Subscribers”:“0”,“SR”:“0.00”,“CPSUB”:“0.000”,“Conversion”:“0”,“CR”:“0.00”,“CPA”:“0.000”,“Revenue”:“0.00”,“EPV”:“0.000”,“PPV”:"-0.170",“Profit”:"-0.17",“eCPM”:"-170.00",“ROI”:"-100.00"},{“AdValue”:“Ebony 338x235-Image+Text Banner630”,“Extra1”:"",“Extra2”:“338x235”,“Extra3”:“teen,brunette,heels,stockings”,“Extra4”:" desktop",“Extra5”:“403137”,“Extra6”:"{user.browser}",“Extra7”:“BC”,“Extra8”:“1842687”,“Extra9”:"",“Extra10”:"",“Views”:“1”,“EngageRate”:“0.00”,“Cost”:“0.170”,“CPV”:“0.170”,“Clicks”:“0”,“CTR”:“0.00”,“CPC”:“0.000”,“Subscribers”:“0”,“SR”:“0.00”,“CPSUB”:“0.000”,“Conversion”:“0”,“CR”:“0.00”,“CPA”:“0.000”,“Revenue”:“0.00”,“EPV”:“0.000”,“PPV”:"-0.170",“Profit”:"-0.17",“eCPM”:"-170.00",“ROI”:"-100.00"},{“AdValue”:“Ebony 338x235-Image+Text Banner630”,“Extra1”:"",“Extra2”:“338x235”,“Extra3”:“teen,amateur”,“Extra4”:" desktop",“Extra5”:“403137”,“Extra6”:"{user.browser}",“Extra7”:“ON”,“Extra8”:“1842687”,“Extra9”:“snippet A Headline 18”,“Extra10”:“snippet B Image 65”,“Views”:“1”,“EngageRate”:“0.00”,“Cost”:“0.170”,“CPV”:“0.170”,“Clicks”:“0”,“CTR”:“0.00”,“CPC”:“0.000”,“Subscribers”:“0”,“SR”:“0.00”,“CPSUB”:“0.000”,“Conversion”:“0”,“CR”:“0.00”,“CPA”:“0.000”,“Revenue”:“0.00”,“EPV”:“0.000”,“PPV”:"-0.170",“Profit”:"-0.17",“eCPM”:"-170.00",“ROI”:"-100.00"},{“AdValue”:“Ebony 338x235-Image+Text Banner630”,“Extra1”:"",“Extra2”:“338x235”,“Extra3”:“teen,amateur”,“Extra4”:" desktop",“Extra5”:“403137”,“Extra6”:"{user.browser}",“Extra7”:“ON”,“Extra8”:“1842687”,“Extra9”:"",“Extra10”:"",“Views”:“1”,“EngageRate”:“0.00”,“Cost”:“0.170”,“CPV”:“0.170”,“Clicks”:“0”,“CTR”:“0.00”,“CPC”:“0.000”,“Subscribers”:“0”,“SR”:“0.00”,“CPSUB”:“0.000”,“Conversion”:“0”,“CR”:“0.00”,“CPA”:“0.000”,“Revenue”:“0.00”,“EPV”:“0.000”,“PPV”:"-0.170",“Profit”:"-0.17",“eCPM”:"-170.00",“ROI”:"-100.00"},{“AdValue”:“Ebony 338x235-Image+Text Banner630”,“Extra1”:"",“Extra2”:“338x235”,“Extra3”:“teen,amateur”,“Extra4”:" desktop",“Extra5”:“403137”,“Extra6”:"{user.browser}",“Extra7”:“ON”,“Extra8”:“1842687”,“Extra9”:“snippet A Headline 39”,“Extra10”:“snippet B Image 65”,“Views”:“1”,“EngageRate”:“0.00”,“Cost”:“0.170”,“CPV”:“0.170”,“Clicks”:“0”,“CTR”:“0.00”,“CPC”:“0.000”,“Subscribers”:“0”,“SR”:“0.00”,“CPSUB”:“0.000”,“Conversion”:“0”,“CR”:“0.00”,“CPA”:“0.000”,“Revenue”:“0.00”,“EPV”:“0.000”,“PPV”:"-0.170",“Profit”:"-0.17",“eCPM”:"-170.00",“ROI”:"-100.00"}],“Landing”:[{“LandingPageID”:“8”,“LP”:“Ebony Milfs-L1-Lander11-N4-ON”,“Extra1”:"",“Extra2”:“338x235”,“Extra3”:“teen,amateur”,“Extra4”:" desktop",“Extra5”:“403137”,“Extra6”:"{user.browser}",“Extra7”:“ON”,“Extra8”:“1842687”,“Extra9”:"",“Extra10”:"",“Views”:“1”,“EngageRate”:“0.00”,“Cost”:“0.170”,“CPV”:“0.170”,“Clicks”:“0”,“CTR”:“0.00”,“CPC”:“0.000”,“Conversion”:“0”,“CR”:“0.00”,“CPA”:“0.000”,“Revenue”:“0.00”,“EPV”:“0.000”,“PPV”:"-0.170",“Profit”:"-0.17",“eCPM”:"-170.00",“ROI”:"-100.00"},{“LandingPageID”:“8”,“LP”:“Ebony Milfs-L1-Lander11-N4-ON”,“Extra1”:"",“Extra2”:“338x235”,“Extra3”:“teen,amateur”,“Extra4”:" desktop",“Extra5”:“403137”,“Extra6”:"{user.browser}",“Extra7”:“ON”,“Extra8”:“1842687”,“Extra9”:“snippet A Headline 18”,“Extra10”:“snippet B Image 65”,“Views”:“1”,“EngageRate”:“0.00”,“Cost”:“0.170”,“CPV”:“0.170”,“Clicks”:“0”,“CTR”:“0.00”,“CPC”:“0.000”,“Conversion”:“0”,“CR”:“0.00”,“CPA”:“0.000”,“Revenue”:“0.00”,“EPV”:“0.000”,“PPV”:"-0.170",“Profit”:"-0.17",“eCPM”:"-170.00",“ROI”:"-100.00"},{“LandingPageID”:“8”,“LP”:“Ebony Milfs-L1-Lander11-N4-ON”,“Extra1”:"",“Extra2”:“338x235”,“Extra3”:“teen,amateur”,“Extra4”:" desktop",“Extra5”:“403137”,“Extra6”:"{user.browser}",“Extra7”:“ON”,“Extra8”:“1842687”,“Extra9”:“snippet A Headline 39”,“Extra10”:“snippet B Image 65”,“Views”:“1”,“EngageRate”:“0.00”,“Cost”:“0.170”,“CPV”:“0.170”,“Clicks”:“0”,“CTR”:“0.00”,“CPC”:“0.000”,“Conversion”:“0”,“CR”:“0.00”,“CPA”:“0.000”,“Revenue”:“0.00”,“EPV”:“0.000”,“PPV”:"-0.170",“Profit”:"-0.17",“eCPM”:"-170.00",“ROI”:"-100.00"},{“LandingPageID”:“9”,“LP”:“Ebony Milfs-L1-Lander11-N4-BC”,“Extra1”:"",“Extra2”:“338x235”,“Extra3”:“teen,brunette,heels,stockings”,“Extra4”:" desktop",“Extra5”:“403137”,“Extra6”:"{user.browser}",“Extra7”:“BC”,“Extra8”:“1842687”,“Extra9”:"",“Extra10”:"",“Views”:“1”,“EngageRate”:“0.00”,“Cost”:“0.170”,“CPV”:“0.170”,“Clicks”:“0”,“CTR”:“0.00”,“CPC”:“0.000”,“Conversion”:“0”,“CR”:“0.00”,“CPA”:“0.000”,“Revenue”:“0.00”,“EPV”:“0.000”,“PPV”:"-0.170",“Profit”:"-0.17",“eCPM”:"-170.00",“ROI”:"-100.00"},{“LandingPageID”:“9”,“LP”:“Ebony Milfs-L1-Lander11-N4-BC”,“Extra1”:"",“Extra2”:“338x235”,“Extra3”:“teen,brunette,heels,stockings”,“Extra4”:" desktop",“Extra5”:“403137”,“Extra6”:"{user.browser}",“Extra7”:“BC”,“Extra8”:“1842687”,“Extra9”:“snippet A Headline 57”,“Extra10”:“snippet B Image 65”,“Views”:“1”,“EngageRate”:“0.00”,“Cost”:“0.170”,“CPV”:“0.170”,“Clicks”:“0”,“CTR”:“0.00”,“CPC”:“0.000”,“Conversion”:“0”,“CR”:“0.00”,“CPA”:“0.000”,“Revenue”:“0.00”,“EPV”:“0.000”,“PPV”:"-0.170",“Profit”:"-0.17",“eCPM”:"-170.00",“ROI”:"-100.00"}],“Landing2”:[],“Landing3”:[],“Landing4”:[],“Landing5”:[]}}

4

You need to specify Rows.Ad as Rows/Root. Basically this plugin looks for an array of data.

image
image2164×1480 228 KB

You can post any queries related to this plugin in the plugin repo where other community members using this plugin also actively responding.

5

I’m not sure if I’m setting up correctly, data is still not displaying.

Json-02-Grafana
Json-02-Grafana1920×1080 196 KB