Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 273 Oracle Analytics and AI News
- 48 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Exporting data from REST API OAC to CSV/XML/JSON or similar format
User_6WR9W
Rank 1 - Community Starter
Hi,
I'd like to export data from an OAC analysis or workbook via the REST API to CSV, XML,JSON, or another format that's easy to import into a database.
If this isn't possible via the OAC REST API, perhaps there's another similar solution.
Tagged:
0
Answers
-
-
Did you also consider a DV dataflow? It can write the resulting dataset into a database table.
1 -
Please could you log this as an idea in the ideas lab - it's something we'd like to implement for the REST API.
Currently, you'd need to use the SOAP APIs:
https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/c_xmlviewservice_service.html
https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/to_analysisexportviews_service.htmlRegards
Mike1
