Synchronous Export of Compressed Content

A simple POST message to immediately export content for one table and save as a GZIP file.

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"
    },
    "tables" : {
        "items" : [
            {
                "tableName": "SHIPMENT",
                "selectList": "SHIPMENT_GID,SHIPMENT_NAME,PERSPECTIVE,INSERT_DATE,UPDATE_DATE"
            }
        ]
    }
}'
https://servername.us2.oraclecloud.com/logisticsRestApi/data/v1/exportRequests -o shipment_data.gz

Note:

• No "Prefer: respond-async" header
• No "targetSystem". Any target system details would be ignored.
• Only one table item.
• The cURL command is saving the content to a file called "shipment_data.gz" which can then be uncompressed using a supported tool.