Using GET Method to Download a File from FCCS / DM Using the ODI 18.104.22.168 InvokeRestful API
(Doc ID 2611002.1)
Last updated on MAY 18, 2023
Applies to:Oracle Data Integrator - Version 22.214.171.124.0 to 126.96.36.199.221018 [Release 12c]
Oracle Data Integrator on Marketplace - Version 1.0.2 to 2.1.0
Oracle Data Integrator Cloud Service - Version 17.1.3 to 17.2.1
Information in this document applies to any platform.
In Oracle Data Integrator (ODI) 188.8.131.52, when attempting to use the GET method of a Restful API to download the desired .csv file to the ODI server from Financial Consolidation Cloud Services / Data Management (FCCS / DM), nothing happens and the file is not downloaded.
Also, changing the Restful API URL parameters to a new file name results in the following error on the Data Management (DM) side on the cloud:
The issue can be reproduced at will with the following steps:
- Use the Restful API with a POST to create a .CSV file in the outbox of the FCCS / DM cloud server.
- Use the Restful API with a GET to try to download the .CSV file from the outbox to the ODI server, to save it locally.
- Switching POST to GET while giving the same parameters does not change the results, it gives the same file exported in the outbox location as it does when using a POST with the Rest API.
- Changing the fileName parameter to a local directory get the above error as it is still trying to put the file somewhere in the cloud, not downloading the file locally.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!