Using Request Offset

The current system limit for any one table export is 10,000,000 (10 million) rows.

If, for example, the "totalResults" response property showed a value of 15,000,000 (15 million) then a second request would need to be submitted for the remaining 5,000,000 (5 million) rows.

This is achieved by specifying the "offset" request parameter, which in this example, would have a value of "10000000". The request message would be as follows:

{
    "schema": "PRIMARY",
    "rangeBefore": {
        "value": "2022-09-30T23:59:59Z"
    },
    "tables" : {
        "items" : [
            {
                "tableName": "SHIPMENT",
                "offset": 10000000
            }
        ]
    }
}

Note:

The query result set for exported rows is ordered by primary key column. Therefore, if the row limit is exceeded and the use of "offset" is required, care must be taken to ensure that rows can't be added or removed from within the range being exported otherwise this "paging" isn't100% reliable.

Note:

Offset can also be set on export by business object. The entire parent and child table output will be split into batches if the row limit is exceeded.