Download Attachment File from Oracle REST API (HCM/SCM) without Middleware
I was able to successfully retrieve the download URL from Oracle Fusion REST API within BI Publisher (Data Model only), and the link works correctly. However, when downloading the file, it is saved as a generic "content" file instead of preserving the original file name and extension (e.g., test.pdf). Is there a way to force the downloaded file to use the original Title or FileName from the API response using BI Publisher only (without middleware)?
This is the query I used to retrieve the download link:
WITH r AS (
SELECT APEX_WEB_SERVICE.MAKE_REST_REQUEST(
p_url => '{instance url}/fscmRestApi/resources/11.13.18.05/purchaseOrders/'
Tagged:
0