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.