Retrieving API monetization data problem

Hi

QUESTION #1
Does the api have the option to return the data in another format other than CSV? It would make it much easier to parse data with a script if JSON format was available.

QUESTION #2
I cannot get the API for monetization to return me data for just one particular day. I always get a weeks worth of data. How can I get only one specific day? Here are the calls I have tried:

http://gameads-admin.applifier.com/stats/monetization-api?apikey=MYAPIKEY&fields=adrequests,available,offers,started,views,revenue&splitBy=source&startDate=2015-01-16T00:00:00:000Z&endDate=2015-01-16T23:59:59:000Z

http://gameads-admin.applifier.com/stats/monetization-api?apikey=MYAPIKEY&fields=adrequests,available,offers,started,views,revenue&splitBy=source&startDate=2015-01-16T00:00:00.000Z&endDate=2015-01-16T23:59:59.000Z

http://gameads-admin.applifier.com/stats/monetization-api?apikey=MYAPIKEY&fields=adrequests,available,offers,started,views,revenue&splitBy=source&startDate=-2&endDate=-2

http://gameads-admin.applifier.com/stats/monetization-api?apikey=MYAPIKEY&fields=adrequests,available,offers,started,views,revenue&splitBy=source&startDate=-2&endDate=-1

Thanks

Okay, ignore QUESTION #2 ā€¦ the issue was that I was using startDate= instead of start= and endDate= instead of end=

Still wondering about JSON format though?!?

Hi jshrek,

Currently only CSV is available from the API.

However, if you need your data in JSON from, then there are lot of tools that can convert the CSV to JSON for you.

Cheers,
Heikki

1 Like

iā€™m unable to get ecpm in api ā€¦ how i can ecpm field in api

And can you post the format of the the api ?