You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTM Data Export REST API - rows returned limitations

edited May 12, 2025 2:41PM in Transportation Management 5 comments

Summary:

We're evaluating OTM Data Export REST API's for extracting ARCHIVE schema data and ingest that into our data bricks for various reporting needs. And couple of challenges we're running into,

  1. We're noticing inconsistency in the number of records returned when querying different tables. For example, extracting data from the shipment table seems to be limited to approximately 500 rows per run. In contrast, other tables like X_LANE return a larger number of rows.
    We were wondering if there are any constraints on the number of rows returned that might be related to the size or number of columns in a table.
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!