Default Page Size: Difference between revisions
mNo edit summary |
m updated Xero developer page URL |
||
| (9 intermediate revisions by 2 users not shown) | |||
| Line 8: | Line 8: | ||
Increasing the default page size decreases the calls required to fetch data, which in turn makes refreshes faster. | Increasing the default page size decreases the calls required to fetch data, which in turn makes refreshes faster. | ||
== | == How to change the Default Page Size for a model == | ||
The | To change the default page size for a [Models|model]] details, follow these steps. | ||
# Click on '''Models''' on the menu in the left-hand side; | |||
# Find the [[Models|model]] you want to work on and click '''View'''; | |||
# Select the '''Settings''' tab; | |||
# Click on the '''Edit Model''' button; | |||
# Select the required '''[[Default Page Size]]'''. | |||
#: This controls the number of records that will be returned on a single call for most endpoints. See the recommended page size below for more information. | |||
# Click '''Save'''. | |||
== Recommended Default Page Size == | |||
The recommended default page size varies based on the type of model or data file you are pulling from. | |||
=== MYOB Models === | |||
The recommended page size for MYOB Business API is 400 records per page, with a values ranging from 50 to 1000 results per page. | |||
* Smaller data files will perform faster using a larger page size (1000). | |||
* Larger data files will perform more reliably using a smaller number (200). | |||
* MYOB recommends a value of 400 to resolve [[OdataLink Error Code 8002: MYOB timed out while servicing the request|error 8002]] or [[OdataLink Error Code 8003: MYOB encountered a runtime exception while servicing the request|error 8003]]. | |||
The page size settings apply to all the endpoints ''except'' the following: | |||
*[[MYOB Endpoint: Company|Company]] | |||
*[[MYOB Endpoint: CompanyPreferences|CompanyPreferences]] | |||
*[[MYOB Endpoint: TaxCodes|TaxCodes]] | |||
*[[MYOB Endpoint: BalanceSheetSummaryReport|BalanceSheetSummaryReport]], | |||
*[[MYOB Endpoint: BalanceSheetSummaryReportTable|BalanceSheetSummaryReportTable]], | |||
*[[MYOB Endpoint: BalanceSheetSummaryReportMultiPeriodTable|BalanceSheetSummaryReportMultiPeriodTable]] | |||
*[[MYOB Endpoint: PayrollTaxes|PayrollTaxes]] | |||
*[[MYOB Endpoint: PayrollTaxTables|PayrollTaxTables]] | |||
*[[MYOB Endpoint: PayrollWages|PayrollWages]] | |||
=== Xero Accounting Models === | |||
The recommended page size for Xero Accounting models is 1000 with values ranging from 50 to 1000. | |||
The Page size settings apply to the following endpoints: | The Page size settings apply to the following endpoints: | ||
| Line 28: | Line 65: | ||
*[[Xero Accounting Endpoint: PurchaseOrders|PurchaseOrders]] | *[[Xero Accounting Endpoint: PurchaseOrders|PurchaseOrders]] | ||
== Xero Assets Models == | |||
The | === Xero Assets Models === | ||
The recommended page size for Xero Assets API is 200 with possible values ranging from 10 to 200 records per page. | |||
The Page size settings apply to the following endpoints: | The Page size settings apply to the following endpoints: | ||
*[[Xero Assets Endpoint: Assets|Assets]] | *[[Xero Assets Endpoint: Assets|Assets]] | ||
== Xero Projects Models == | |||
The | === Xero Projects Models === | ||
The recommended page size for Xero Projects API is 500 with values ranging from 50 to 500. | |||
The Page size settings apply to the following endpoints: | The Page size settings apply to the following endpoints: | ||
*[[Xero Projects Endpoint: Projects|Projects]] | *[[Xero Projects Endpoint: Projects|Projects]] | ||
| Line 45: | Line 85: | ||
*[[Xero Projects Endpoint: GetTimes|GetTimes]] | *[[Xero Projects Endpoint: GetTimes|GetTimes]] | ||
== Related Topics == | |||
[[Editing a model's details]] | |||
== References == | |||
[https://odatalink.com/2025-03-increase-the-performance-of-your-xero-odata-feed-using-the-page-size-setting/ Increase the performance of your Xero OData Feed using the Page Size setting] | |||
[https://developer.xero.com/documentation/best-practices/ | [https://developer.xero.com/documentation/best-practices/api-call-efficiencies/paging/#overview Xero Paging Overview] | ||
[https://developer.myob.com/api/myob-business-api/api-overview/retrieving-data/#PAGING MYOB Paging Overview] | [https://developer.myob.com/api/myob-business-api/api-overview/retrieving-data/#PAGING MYOB Paging Overview] | ||
__NOTOC__ | __NOTOC__ | ||