Default Page Size: Difference between revisions

From OdataLink
Jump to navigation Jump to search
← Older editNewer edit →
No edit summary
No edit summary
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.


== Recommended Settings ==
== How to change the Default Page Size for a model ==


OdataLink recommends setting the largest default page size for '''Xero''' datafile based models.
To change the default page size for a [Models|model]] details, follow these steps.


For '''MYOB''' datafile based models, we recommend setting it to 100. Increasing the page size can be beneficial for smaller datafiles, but detrimental to large datafiles.
# 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.


== Xero Accounting Models ==
 
The default page size for Xero Accounting models is set to 100, which is the default page size for all Xero APIs.
== Recommended Default Page Size ==
 
The recommended default page size varies based on the type of model or data file you are pulling from.
 
=== 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 current page size can range from 50 to 1000 records returned per page.
Line 34: Line 44:
*[[Xero Accounting Endpoint: PurchaseOrders|PurchaseOrders]]
*[[Xero Accounting Endpoint: PurchaseOrders|PurchaseOrders]]


== Xero Assets Models ==
=== Xero Assets Models ===
The legacy page size for Xero Assets API was 10 Assets per page.
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 current page size for a Xero Assets model can range from 10 to 200 records per page.
''Note: We strongly recommend you set the Page Size to 200.''
''Note: We strongly recommend you set the Page Size to 200.''
Line 41: Line 51:
*[[Xero Assets Endpoint: Assets|Assets]]
*[[Xero Assets Endpoint: Assets|Assets]]


== Xero Projects Models ==
=== Xero Projects Models ===
The default page size for Xero Projects API is 50 Projects per page.
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 current page size for a Xero Projects Model can range from 50 to 500 records per page.
The Page size settings apply to the following endpoints:
The Page size settings apply to the following endpoints:
Line 51: Line 61:
*[[Xero Projects Endpoint: GetTimes|GetTimes]]
*[[Xero Projects Endpoint: GetTimes|GetTimes]]


== MYOB Models ==
=== MYOB Models ===
The default page size for MYOB Business API is 400 records per page, with a maximum of 1000 results per page.
 
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:
The page size settings apply to all the endpoints ''except'' the following:
*[[MYOB Endpoint: Company|Company]]
*[[MYOB Endpoint: Company|Company]]
*[[MYOB Endpoint: CompanyPreferences|CompanyPreferences]]
*[[MYOB Endpoint: CompanyPreferences|CompanyPreferences]]

Revision as of 19:03, 9 September 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.


Recommended Default Page Size

The recommended default page size varies based on the type of model or data file you are pulling from.

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 Page size settings apply to the following endpoints:

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. Note: We strongly recommend you set the Page Size to 200. The Page size settings apply to the following endpoints:

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 Page size settings apply to the following endpoints:

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 error 8002 or error 8003.

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


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=4706"