Fetch Multiple Dimentions using Adobe Analytics Reporting 2.0 API | Community
Skip to main content
M
mrgupta
New Participant
July 6, 2023
Solved

Fetch Multiple Dimentions using Adobe Analytics Reporting 2.0 API

  • July 6, 2023
  • 1 reply
  • 2032 views

Hi Everyone,

I am able to generate JSON object for single dimension. But unable to get 1 object for multiple dimension

When I use debugger in workspace > select Freeform table > select timestamp its generating only 1 response which has very limited values in object. Even though I have selected a week date range.

 

Thanks,

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jennifer_Dungan

Do you have multiple breakdowns in your table? I believe that API 2.0, in order to return data immediately (instead of how API 1.3 and 1.4 worked, where the request first was placed into a queue that had to be repeatedly checked for the request to be complete, after that finished, only then could you query the actual report - which was slow, and sometimes got stuck), API 2.0 has to make multiple calls, one for each breakdown... they need to be run in order... so if on a fresh report load, if there are multiple timestamps, you will have to get all the API calls and run them in order....

1 reply

Jennifer_Dungan
Jennifer_DunganAccepted solution
New Participant
July 6, 2023

Do you have multiple breakdowns in your table? I believe that API 2.0, in order to return data immediately (instead of how API 1.3 and 1.4 worked, where the request first was placed into a queue that had to be repeatedly checked for the request to be complete, after that finished, only then could you query the actual report - which was slow, and sometimes got stuck), API 2.0 has to make multiple calls, one for each breakdown... they need to be run in order... so if on a fresh report load, if there are multiple timestamps, you will have to get all the API calls and run them in order....

M
mrguptaAuthor
New Participant
July 7, 2023

Thanks @jennifer_dungan. Yes I have multiple breakdown in my table.

API 2.0 has to make multiple calls, one for each breakdown - So for each time stamp it is showing different object with limited values. As an example my freeform table has 3 dimensions day, product, and user ID and but when i try to create JSON object its not showing complete data for each request.

We need 1 object which shows complete value for each time stamp. Do i need to create it manually 1 object with all value for each time stamp. Could you please share any document for reference.

Jennifer_Dungan
Jennifer_Dungan
New Participant
July 7, 2023

Hmm... it's been a few years since I used API 2.0 (basically it was in a lab at 2019 Summit, when the API was new, and a few times using the online Swagger). That was where they showed us the debug trick (and it returned the same data as the freeform from what I remember)

 

 

Here is where I normally go for API related documentation (and also a place to test calls) https://developer.adobe.com/analytics-apis/docs/2.0/apis/

 

Terms & ConditionsAccessibility statement

Loading footer...