I’m wondering if it is possible, or if anyone has tried, connecting to a BI Publisher report directly via a REST API connection in OAC.
@J Gatdula Please refer to "Connect to Data from REST Endpoints"
https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/connect-data-rest-endpoints.html#ACSDS-GUID-EDEB66AF-D759-4B12-A6ED-73A1EC6EE721
You can download example JSON files from the Oracle Analytics Public Library for Oracle Analytics Publisher. See JSON Examples for Common Data Sources with REST Endpoints.
https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/json-examples-common-data-sources-rest-endpoints.html#GUID-0E5A1664-21DC-4861-A3C2-894B975603DF