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

API to Report "Limit" not working as expected

Received Response
39
Views
5
Comments
edited Jun 8, 2022 12:01PM in General Technical Discussions 5 comments

Content

We're trying to export data from some large tables, like transactions.
 Basically the Object model doesn't work for dozens of reasons so we have to use the RunAnalyticsReport API call to call a report we've written in the application to retrieve the data.

Unfortunately we're running into major problems with some of the tables. For example, "Transactions"...

It doesn't have a unique Key or Single index for us to sort on.
We can sort on date, but that's not unique at all.
The API's row limit is 10,000
But we have no way to limit the report itself to 10,000 records because there is no unique id.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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