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)

606 bytes added , 27 August

no edit summary

3,244

edits

@@ Line 1: / Line 1: @@
 '''Error 9008''' will be logged when [[Xero]] imposes the limit of 100,000 records per request. This is also known as the High Volume Threshold limit.
-You can work through this issue by configuring using the [[Archive Paging]] option of the model and setting it either to '''By Month''' or '''By Year'''.
+Note that Xero can raise this error even if the number of records that it would return is considerably lower. This is due to how builds it's pages of data. It uses specialised indexes that look at a subset of your data. While the actual records that gets returned could be lower, the error is triggered when the indexes have more than 100,000 records.
+You can work through this issue by configuring using the [[Archive Paging]] option of the model and setting it either to '''By Month''' or '''By Year'''. Doing so ensures that OdataLink asks for small amounts of data. In other words, it asks for a single month or a single years worth of data. This instructs Xero to look at a different kind of index and should allow you to retrieve all the data you need.
 See [[Editing a model's details]] for instructions on how to configure your model.