My Oracle Support Banner

Using GET Method to Download a File from FCCS / DM Using the ODI 12.2.1.3 InvokeRestful API (Doc ID 2611002.1)

Last updated on MAY 18, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 to 12.2.1.3.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.

Symptoms

In Oracle Data Integrator (ODI) 12.2.1.3, 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:

  1. Use the Restful API with a POST to create a .CSV file in the outbox of the FCCS / DM cloud server.
  2. 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.
  3. 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.
  4. 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.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.