Write, Bureaucrats, Administrators
3,244
edits
Difference between revisions of "OdataLink Error Code 9008: Xero imposed a limit of 100,000 records per request"
OdataLink Error Code 9008: Xero imposed a limit of 100,000 records per request (view source)
Revision as of 18:49, 27 August 2024
, 27 Augustno edit summary
| Line 9: | Line 9: | ||
== Apply additional filters to your power queries == | == Apply additional filters to your power queries to prevent this error == | ||
One way you can prevent this error from occurring is by applying additional filters to your queries. Typically, the '''Date''', '''Type''' and '''Status''' fields of their endpoint are associated with additional optimised indexes. By filtering by these fields, Xero can look at smaller indexes to provide your data. | One way you can prevent this error from occurring is by applying additional filters to your queries. Typically, the '''Date''', '''Type''' and '''Status''' fields of their endpoint are associated with additional optimised indexes. By filtering by these fields, Xero can look at smaller indexes to provide your data. | ||