Exporting data from REST API OAC to CSV/XML/JSON or similar format

User_6WR9W

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.

Brendan T

Try following these examples

https://docs.oracle.com/en-us/iaas/Content/Identity/api-getstarted/Exporting.htm

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/export-data-csv-and-tab-delimited-files-text.html

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/examples-system-setting-rest-apis.html#GUID-27E789A9-7E46-4BB9-A99B-1C27DEAD1726

https://medium.com/oracledevs/get-to-know-the-oracle-analytics-rest-apis-e547fa0bf575

Gianni Ceresa

Did you also consider a DV dataflow? It can write the resulting dataset into a database table.

Mike Durran-Oracle

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.html

Regards
Mike