Unable to extract JSON REST API data, any recommendations

[egliptor]

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.

[yesoreyeram]

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

[egliptor]

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”:[]}}

[yesoreyeram]

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

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

[egliptor]

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