Build Adobe Analytics API Requests for Data Warehouse Report | Community
Skip to main content
A
aartisoft
January 20, 2019
Solved

Build Adobe Analytics API Requests for Data Warehouse Report

  • January 20, 2019
  • 1 reply
  • 934 views

Hi everyone -

I schedule data warehouse report to be delivered to my email regularly. And connect to the csv file via Tableau to build a dashboard. Now I want to use the API and send that AA data to Oracle Data Mart so Tableau can automatically connect and refresh data. How can I get Json request for my original data ware house request.

Please advice.

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 Gigazelle

The Data Warehouse API (analytics-1.4-apis/docs/data-warehouse-api at master · AdobeDocs/analytics-1.4-apis · GitHub​) can be used to manage and generate data warehouse requests. However, once it arrives at its destination, it is simply a spreadsheet file and cannot be manipulated by any Analytics API at that point.

If you'd like to take the resulting spreadsheet file and do something with it, you'll want to use server-side software to parse the data warehouse file in a format Data Mart can use, then send it off. I know that there are some Adobe consultants who specialize in data connections such as this. If this is something you'd like to pursue, you can get in touch with your organization's account manager.

1 reply

Gigazelle
Adobe Employee
GigazelleAdobe EmployeeAccepted solution
Adobe Employee
January 29, 2019

The Data Warehouse API (analytics-1.4-apis/docs/data-warehouse-api at master · AdobeDocs/analytics-1.4-apis · GitHub​) can be used to manage and generate data warehouse requests. However, once it arrives at its destination, it is simply a spreadsheet file and cannot be manipulated by any Analytics API at that point.

If you'd like to take the resulting spreadsheet file and do something with it, you'll want to use server-side software to parse the data warehouse file in a format Data Mart can use, then send it off. I know that there are some Adobe consultants who specialize in data connections such as this. If this is something you'd like to pursue, you can get in touch with your organization's account manager.

Terms & ConditionsAccessibility statement

Loading footer...