Default Page Size: Difference between revisions

From OdataLink
Jump to navigation Jump to search
← Older edit
No edit summary
Ash (talk | contribs)
Write
604 edits
m updated Xero developer page URL
 
(3 intermediate revisions by one other user not shown)
Line 18: Line 18:
# Select the required '''[[Default Page Size]]'''.
# 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.
#: 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 ==
== Recommended Default Page Size ==


The recommended default page size varies based on the type of model or data file you are pulling from.
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 ===
=== Xero Accounting Models ===
The recommended page size for Xero Accounting models is 1000.


The current page size can range from 50 to 1000 records returned per page.
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 43: Line 64:
*[[Xero Accounting Endpoint: PrepaymentsExpanded|PrepaymentsExpanded]]
*[[Xero Accounting Endpoint: PrepaymentsExpanded|PrepaymentsExpanded]]
*[[Xero Accounting Endpoint: PurchaseOrders|PurchaseOrders]]
*[[Xero Accounting Endpoint: PurchaseOrders|PurchaseOrders]]


=== Xero Assets Models ===
=== Xero Assets Models ===
The recommended page size for Xero Assets API was 10 Assets per page.
 
The current page size for a Xero Assets model can range from 10 to 200 records per page.
The recommended page size for Xero Assets API is 200 with possible values ranging from 10 to 200 records per page.
''Note: We strongly recommend you set the Page Size to 200.''
 
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 ===
=== Xero Projects Models ===
The recommended page size for Xero Projects API is 50 Projects per page.
 
The current page size for a Xero Projects Model can range from 50 to 500 records per page.
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 60: Line 84:
*[[Xero Projects Endpoint: GetTasks|GetTasks]]
*[[Xero Projects Endpoint: GetTasks|GetTasks]]
*[[Xero Projects Endpoint: GetTimes|GetTimes]]
*[[Xero Projects Endpoint: GetTimes|GetTimes]]
=== MYOB Models ===
The recommended page size for MYOB Business API is 400 records per page, with a maximum of 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]]




Line 90: Line 94:
[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://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/integration-health/paging/#overview Xero Paging Overview]
[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]

Latest revision as of 21:44, 21 October 2026

Page Size in Model settings

A Query or call sent to MYOB or Xero returns a Page of results wherever Pagination is possible.

The Default Page Size setting controls the number of Records returned per page.

A Record contains all Line Items details for that particular endpoint.

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

To change the default page size for a [Models|model]] details, follow these steps.

  1. Click on Models on the menu in the left-hand side;
  2. Find the model you want to work on and click View;
  3. Select the Settings tab;
  4. Click on the Edit Model button;
  5. 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.
  6. 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 error 8002 or error 8003.

The page size settings apply to all the endpoints except the following:


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:


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:


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:


Related Topics

Editing a model's details

References

Increase the performance of your Xero OData Feed using the Page Size setting

Xero Paging Overview

MYOB Paging Overview


Retrieved from "https://help.odatalink.com/index.php?title=Default_Page_Size&oldid=4721"