Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 55 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Exporting data from REST API OAC to CSV/XML/JSON or similar format
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.
Answers
-
-
Did you also consider a DV dataflow? It can write the resulting dataset into a database table.
2 -
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
Mike2 -
I'd also like to lobby for adding Parquet to the list of supported output formats, given that Oracle now officially supports the Iceberg Metadata/Catalog standard (https://www.oracle.com/news/announcement/ai-world-oracle-introduces-autonomous-ai-lakehouse-2025-10-14/).
Parquet Benefits:
- A native file type within Iceberg
- Typed columns (Integer, Decimal, Floating Point, Date, Datetime, etc.), plus null handling
- automatically compressed on save (similar to 7zip's native compression) without the separate step
- Supported as a data source by most major BI tools (i.e., Power BI - http://learn.microsoft.com/en-us/power-query/connectors/parquet)
- Well supported with the Python ecosystem (Polars, DuckDB, Pandas, etc.)
0 -
@User_6WR9W , Welcome to the Oracle Analytics Community!
While there is not REST API support yet, have you considered extracting data from source instead of OAC. It might be faster provided you can come up with the query. Hope it helps!
1 -
If you have not already, please file an Ideas Lab request for features that are not currently present in the product.
1
