Can you filter large API data pulls based on Date ranges?

Question

There are large tables generated by the API where filtering doesn’t work and/or the developer is unable to identify a way to make the payload smaller.

/integrator/erp/directory/containers - ~1.2 million records, no obvious date field to filter on.
/integrator/erp/accounting/contracts - ~600K records, can filter on StartDate if appropriate
/integrator/erp/transport/routeVisits - ~10 Million records, can filter on OriginalDate if appropriate

Is it possible to filter these sets to pull on date ranges?

Answer 1

It's not the intention that the REST API support heavyweight queries into the operation ERP database. If this is the requirement the REST API should be used to synchronize the collections with a disconnected data warehouse and the queries run from there.

I think this question may have been triggered by a lack of change?since functionality on the container and routevisits endpoints. We will address this gap shortly.

Comments

any further change on this one?

we are also having issues with these endpoints below, they return too many records
1. Routes endpoint
we want to filter it by RouteDate

2. Schedule
we want to filter it by ScheduledDate

3. Jobs
we want to filter it by RelatedScheduleGUID