Asynchronous Export of Compressed Content

A simple POST message to immediately export content for entire business object and save as multiple GZIP files or a single GZIP file based on the Content-Type.

Use Case Description

  • Export content that has been inserted or updated in the SHIPMENT table for the month of September 2022 and save as a GZIP file.
  • Save as a GZIP file.
  • Uncompress the GZIP file.
  • You can use the uncompressed data as you wish, including potentially loading it into an archive system or another instance.
curl -u username:password -X POST -H "Content-Type: application/json" -d '
 {
    "schema": "PRIMARY",
    "contentType": "text/plain",
    "contentCompression": "GZIP",
    "rangeAfter" : {
        "value": "2022-09-01T00:00:00Z"
    },
    "rangeBefore": {
        "value": "2022-09-30T23:59:59Z"
    },
  "targetSystem" : {
        "targetURL" : "https://objectstorage.us-ashburn-1.oraclecloud.com/p/oJpOXb5vLm7uessZIkB2XykY5iHBy0Bog4AYvls2FIB0aup3xgS2hUiGtAb7LNK6/n/oracleotmgtmdev/b/OTMQA/o/",
        "httpMethod": "PUT",
        "appendName": true
},
    " objects" : {
        "items" : [
            {
                  "resourceName": "shipments"            
}
        ]
    }
}'
https://servername.us2.oraclecloud.com/logisticsRestApi/data/v1/exportRequests -o shipment_data.gz

Note:

The Oracle Cloud Object Storage bucket referenced will contain one file on completion. The file name is DATA_303_shipments_1_1_1.json.gz. That file is a compressed GZIP file and you must uncompress it using a supported tool to use the contents.

Specifying the contentType of text/plain (or allowing to default) will export the content as multiple gz files one for each table export.