4.10.2.4 Data Export Downloader Utility

Public API to retrieve the manifest file. This feature allows the automation of file download process. The API returns a manifest file in JSON format. Manifest includes file details and URLs for downloading. This reduces the manual download steps.

This utility uses configuration from a `.env` file and securely fetches export files from Oracle Object Storage using token-based authentication. For more information, refer to Data Export Download document on My Oracle Support.

1. Retrieve the manifest fileInvoke the REST service below to obtain the manifest file details:

   /dataextractor/getDataExportManifestFile?code=<export_definition_code>&batchRunId=<batch_run_id>

2. Enter Export Definition Code and Batch Run ID.

   Note:

   You can retrieve the data using export definition code and batch run ID. The Code value shown as a tooltip in Data Export UI (move-over Name field on Data Export Summary UI). Batch run ID visible in the Export Details UI. Also, these details are available in LogViewer Service UI.

   It will download the JSON . Below is an example:

   Example request:

   /dataextractor/getDataExportManifestFile?code=987654321&batchRunId=DATA_EXTRACTION_RUN1

   Sample response:

   {

   "payload": {

   "executedBy": "caqa_user",

   "batchRunId": "Data_Extraction_111111_2022-04-26_2",

   "fileDetails": [

   {

   "fileName": xyz.gz,

   "fileSize": "247"

   }

   ],

   "dateFormat": "MM-dd-yyyy HH:mm:ss UTC",

   "executedOn": "11-18-2025 06:31:14",

   "rowsLoaded": "4916",

   "exportFilePrefix": "Data_Extraction_111111_2022-04-26_2/Task1",

   "parUrlExpiryTime": "12-13-2025 13:28:05",

   "statusName": "Success",

   "asOfDate": "04-26-2022",

   "endTimestamp": "11-18-2025 06:31:16",

   "taskId": "Task1",

   "startTimestamp": "11-18-2025 06:31:14",

   "statusCode": "SUCCESS"

   },

   "status": "Success"

   }

3. Parse the response

   Parse the JSON response to extract the “fileName” attribute, which contains the PAR (Pre-Authenticated Request) URLs for the exported files.

4. Download the files

   Use the PAR URLs obtained from the manifest response to download the exported files directly.