Hi Team ,
I wanted to fetch day wise and market channel wise data from using report suit Jason in Azure. I am not able to fetch together from one Jason file.if I use date date range day as dimensions , in response I am getting aggregate data of all channel day wise and not showing channel name also .So I need to fetch each market channel data day wise from json response
Hi ,
Thank you for explanation, I understood. I need one more information about JSON output, when we fetch data using using JSON, we get response, in that response, in rows arrays, in “value” variable either its mention date
or market channel name (if we use market channel breakdown). So can we get both date and channel name in output response then we can easily find out , data is belongs to which market channel and on which date.
For each row returned by the API, you will have the Date, and data for each column:
"rows": [
{
"itemId": "1234567",
"value": "Dec 1, 2023",
"data": [
23455,
3435,
7568,
68678,
5675,
567,
765
]
},
....
The Date is obvious (Dec 1st, 2023 in this example), and each data in the array corresponds to each column...
In my example, I have 7 columns, 7 data values are returned... in the order of the columns.. So if your column 1 is "Organic Search", then you know that 23455 belongs to that channel, and column 2 "Page Search" corresponds to 3435, etc....
The columns/data will always be returned in the order specified by your request columns.
In addition to the above documentation, here is a little known trick for building out API calls:
Workspace Reports are all built using the API, and you can get all the calls that are used to make your tables of data.
You first have to enable the debugger:
This will add a new icon onto your tables:
When you click on this, it will first ask you if you want to get the calls for the Freeform Table or for the Sparkline (choose the Table)
Next, it will show you different timestamps, some complex tables may need multiple calls, you can check each of these, and when you choose them, it will take you to a new screen that will show you the API requests in different languages (you can take the one relevant to you and use it as is, or modify it to suite you better.
Basically, if you can build a basic freeform table that returns the data you need in Workspaces, you can use those same calls to get the same data into your external data pulls.
Good luck.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
