Download Extract Output from Oracle Managed Storage

Extract output files can be downloaded using the Job File Manager API for the extract job request instance and output file.

Endpoint

Attribute	Value
URL	/api/saas-batch/jobfilemanager/v1/jobRequests/{{jobRequestId}}/outputFiles/{{fileName}}/content
HTTP Method	GET

Request

Example Request

GET /api/saas-batch/jobfilemanager/v1/jobRequests/42075/outputFiles/result_42075.json/content

Response

The response contains binary compressed file contents.

Once uncompressed, it contains full or partial results of the extraction query in CSV or JSON format, based on the extract group definition.

Example (Uncompressed CSV)

ACTIVEFLAG,CARRIERID,CREATEDBY,MANIFESTINGENABLEDFLAG,NAME,TIMECREATED,TIMEUPDATED,UPDATEDBY
Y,12516,1000049,,ADL Trucking,2001-06-13T07:21:57Z,2001-06-13T07:21:57Z,SCM_IMPL_CONSULTANT
Y,12517,2330,,AIR,2000-01-10T16:14:28Z,2000-01-10T16:14:28Z,SCM_IMPL_CONSULTANT
Y,12518,2209,,Abbitual,2000-01-25T15:07:32Z,2000-01-25T15:07:32Z,SCM_IMPL_CONSULTANT
Y,12519,1068,,Airborne,2005-06-09T15:22:17Z,2005-06-09T15:22:17Z,SCMOPERATIONS
Y,12520,1653,,BNAF,1998-01-14T12:55:31Z,1998-01-14T12:55:31Z,SCM_IMPL_CONSULTANT

Tip

If needed, large files can be downloaded more efficiently by implementing multithreaded download using the Range HTTP header:

Range: {{startByte}}-{{endByte}}/{{fileSize}}