13 March 2025 |

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

In March 2025, we’ve updated the Xero Accounting models, Xero Assets models and Xero Projects models to include an additional Page Size setting.

Configuring this setting can increase the performance of the OdataLink OData feed for Xero. This in turns makes Excel, Power BI or others refresh faster.

Understanding how Xero pages your data?

Historically, many endpoints in Xero were paged to return data 100 records at a time. This means that to retrieve a list of 1000 invoices, your Excel, Power BI or other dashboard would would need to request data 10 times. These requests all took place seamlessly under the hood.

The Xero API hardcoded this limit of 100 records per page. It could not be changed.

In 2025, Xero provided the ability on some endpoints (not all) to support more records per page. As soon as this was announced, we enhanced OdataLink to include this feature.

Now, you can configure and optimise your Xero Odata Feeds by using the new Page Size setting within the OdataLink Model. We decided to provide a configurable option rather than forcing every Odata Feed to use the same page size. This allows you to fine tune the performance to suit your data set.

What are the benefits of configuring the Page Size setting?

Correctly configuring the Page Size setting can greatly increase the performance of the OdataLink when pulling data from Xero.

Firstly, it eliminates the amount of communication involved between your client technology, the OdataLink OData Feed servers and the Xero API servers. This in turn reduces the time spent communicating between different networks.

Secondly, it can also resolve the dreaded 5000 calls per day limit that Xero imposes. By requesting larger sets of data, it reduces the total number of calls required. In turn, this allows OdataLink to stay within the limit of 5000 calls per day that Xero imposes.

For example, to pull 100,000 invoices could require as little as 100 requests instead of 1000.

What value should you use to configure the Page Size setting?

The possible and optimal number of records per page, otherwise known as the page size varies depending on the type of model.

Xero Accounting Models

For Xero Accounting models, so as not to impact existing customers, we have kept the default value at 100 records per page. Possible values range from 50 to 1000 records.

At the moment, we recommend using 1000 records per page.

If you need to pull large amounts of data (over 10,000 records), this value definitely seems to provide the best overall performance.

If the volume of transactions is lower, you may also get a small performance increase but the effects are less noticeable.

Xero Assets Models

For Xero Assets models, the legacy value was 10 assets per page.

With the new enhancement, you can now configure your model to pull up to 200 records per page. We strongly recommend you set the Page Size to 200.

Xero Projects Models

For Xero Projects models, Xero’s API uses a default page size of 50.

However, it is now possible to choose any value from 50 to 500.

Which endpoints does the Page Size setting apply?

Not all endpoints make use of this setting. Some endpoints (such as Accounts) are unpaged and therefore are returned in a single request. In these endpoints, the Page Size setting is simply ignored.

Xero Accounting Endpoints

The Page Size setting applies to the following Xero Accounting endpoints.

Xero Assets Endpoints

The Page Size setting applies to the following Xero Assets endpoints.

Xero Projects Endpoints

The Page Size setting applies to the following Xero Projects endpoints.

How to configure the Page Size setting in the OdataLink Model

You can control the Page Size of your OData feeds by going to the performance settings of your model.

To configure the Page Size, follow these steps.

  1. Login to app.odatalink.com.
  2. Select Models on the menu on the left-hand side.
  3. Click View to view the model.
  4. Select the Settings tab.
  5. Click the Edit Model button.
  6. Find the Page Size and select the desired value.
  7. Click Save to save the changes.
  8. Repeat the process for each model.