You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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/'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!