My Oracle Support Banner

Using GET Method to Download a File Using the ODI 12c InvokeRestful API (Doc ID 2611002.1)

Last updated on JANUARY 10, 2020

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

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

2019-10-22 20:16:22,922 INFO [AIF]: ------------------- Export Map Offline - Starting -------------------
2019-10-22 20:16:22,923 INFO [AIF]: ------------------- Export Map Initialized -------------------
2019-10-22 20:16:22,982 INFO [AIF]: EPMFDM-140274:Message - appId:2
user identity:<USER>@example.com
2019-10-22 20:16:22,982 INFO [AIF]: EPMFDM-140274:Message - Export Mappings: Current Dimensions
2019-10-22 20:16:22,982 INFO [AIF]: EPMFDM-140274:Message - partitionkey: 10 directory: <NAME>: fileName: <NAME OF CSV FILE> tdatamaptype: ERP dimName: <NAME>
2019-10-22 20:16:24,042 ERROR [AIF]: EPMFDM-140098:Unexpected error occurred.
2019-10-22 20:16:24,058 INFO [AIF]: ------------------- Export Map Offline - Finished -----------------

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.

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!


In this Document
Symptoms
Cause
Solution
References


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