Default Page Size - Revision history

Ash: updated Xero developer page URL

2026-10-22T02:44:02Z

updated Xero developer page URL

← Older revision		Revision as of 21:44, 21 October 2026
Line 94:		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]

Nic at 00:06, 10 September 2026

2026-09-10T00:06:44Z

← Older revision		Revision as of 19:06, 9 September 2026
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 ==

Nic at 00:06, 10 September 2026

2026-09-10T00:06:13Z

@@ Line 23: / Line 23: @@
 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 with values ranging from 50 to 1000.
@@ Line 61: / Line 84: @@
 *[[Xero Projects Endpoint: GetTasks|GetTasks]]
 *[[Xero Projects Endpoint: GetTimes|GetTimes]]

Nic at 00:05, 10 September 2026

2026-09-10T00:05:48Z

← Older revision		Revision as of 19:05, 9 September 2026
Line 25:		Line 25:

	=== Xero Accounting Models ===		=== Xero Accounting Models ===
	The recommended page size for Xero Accounting models is 1000.		The recommended page size for Xero Accounting models is 1000 with values ranging from 50 to 1000.

	~~The current page size can range~~ from 50 to 1000 ~~records returned per page~~.

	The Page size settings apply to the following endpoints:		The Page size settings apply to the following endpoints:
Line 43:		Line 41:
	*[[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 63:		Line 64:
	=== MYOB Models ===		=== MYOB Models ===

	The recommended 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 values ranging from 50 to 1000 results per page.

	* Smaller data files will perform faster using a larger page size (1000).		* Smaller data files will perform faster using a larger page size (1000).

Nic at 00:03, 10 September 2026

2026-09-10T00:03:36Z

← Older revision		Revision as of 19:03, 9 September 2026
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]]

Nic at 07:11, 4 June 2025

2025-06-04T07:11:58Z

← Older revision		Revision as of 02:11, 4 June 2025
Line 70:		Line 70:

	== References ==		== 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/integration-health/paging/#overview Xero Paging Overview]		[https://developer.xero.com/documentation/best-practices/integration-health/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__

Ash at 02:25, 21 March 2025

2025-03-21T02:25:54Z

← Older revision		Revision as of 21:25, 20 March 2025
Line 12:		Line 12:
	OdataLink recommends setting the largest default page size for '''Xero''' datafile based models.		OdataLink recommends setting the largest default page size for '''Xero''' datafile based models.

	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''.		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.

	== Xero Accounting Models ==		== Xero Accounting Models ==

Ash at 02:25, 21 March 2025

2025-03-21T02:25:37Z

← Older revision		Revision as of 21:25, 20 March 2025
Line 7:		Line 7:

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

			OdataLink recommends setting the largest default page size for '''Xero''' datafile based models.

			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''.

	== Xero Accounting Models ==		== Xero Accounting Models ==

Ash at 02:20, 21 March 2025

2025-03-21T02:20:22Z

← Older revision		Revision as of 21:20, 20 March 2025
Line 60:		Line 60:

	== Related Topics ==		== Related Topics ==

			[[Editing a model's details]]

			== References ==

	[https://developer.xero.com/documentation/best-practices/integration-health/paging/#overview Xero Paging Overview]		[https://developer.xero.com/documentation/best-practices/integration-health/paging/#overview Xero Paging Overview]

Ash at 02:18, 21 March 2025

2025-03-21T02:18:08Z

← Older revision		Revision as of 21:18, 20 March 2025
Line 51:		Line 51:
	*[[MYOB Endpoint: CompanyPreferences\|CompanyPreferences]]		*[[MYOB Endpoint: CompanyPreferences\|CompanyPreferences]]
	*[[MYOB Endpoint: TaxCodes\|TaxCodes]]		*[[MYOB Endpoint: TaxCodes\|TaxCodes]]
	*[[MYOB Endpoint: BalanceSheetSummaryReport\|BalanceSheetSummaryReport]], [[MYOB Endpoint: BalanceSheetSummaryReportTable\|BalanceSheetSummaryReportTable]], [[MYOB Endpoint: BalanceSheetSummaryReportMultiPeriodTable\|BalanceSheetSummaryReportMultiPeriodTable]]		*[[MYOB Endpoint: BalanceSheetSummaryReport\|BalanceSheetSummaryReport]],
			*[[MYOB Endpoint: BalanceSheetSummaryReportTable\|BalanceSheetSummaryReportTable]],
			*[[MYOB Endpoint: BalanceSheetSummaryReportMultiPeriodTable\|BalanceSheetSummaryReportMultiPeriodTable]]
	*[[MYOB Endpoint: PayrollTaxes\|PayrollTaxes]]		*[[MYOB Endpoint: PayrollTaxes\|PayrollTaxes]]
	*[[MYOB Endpoint: PayrollTaxTables\|PayrollTaxTables]]		*[[MYOB Endpoint: PayrollTaxTables\|PayrollTaxTables]]

← Older revision		Revision as of 21:18, 20 March 2025
Line 51:		Line 51:
	*[[MYOB Endpoint: CompanyPreferences\|CompanyPreferences]]		*[[MYOB Endpoint: CompanyPreferences\|CompanyPreferences]]
	*[[MYOB Endpoint: TaxCodes\|TaxCodes]]		*[[MYOB Endpoint: TaxCodes\|TaxCodes]]
	*[[MYOB Endpoint: BalanceSheetSummaryReport\|BalanceSheetSummaryReport]], [[MYOB Endpoint: BalanceSheetSummaryReportTable\|BalanceSheetSummaryReportTable]], [[MYOB Endpoint: BalanceSheetSummaryReportMultiPeriodTable\|BalanceSheetSummaryReportMultiPeriodTable]]		*[[MYOB Endpoint: BalanceSheetSummaryReport\|BalanceSheetSummaryReport]],
			*[[MYOB Endpoint: BalanceSheetSummaryReportTable\|BalanceSheetSummaryReportTable]],
			*[[MYOB Endpoint: BalanceSheetSummaryReportMultiPeriodTable\|BalanceSheetSummaryReportMultiPeriodTable]]
	*[[MYOB Endpoint: PayrollTaxes\|PayrollTaxes]]		*[[MYOB Endpoint: PayrollTaxes\|PayrollTaxes]]
	*[[MYOB Endpoint: PayrollTaxTables\|PayrollTaxTables]]		*[[MYOB Endpoint: PayrollTaxTables\|PayrollTaxTables]]