How to filter and export accounts from xero

This article will show you how to search and export accounts data from xero.

Are you looking to migrate your data from xero or maybe you just want more advanced filtering on your xero accounts data? This is how.

First create a Cloudslurp account and click the connect for xero account.

You will be directed to xero to authorize Cloudslurp and then directed back to Cloudslurp.

You can then optionally invite your team members you would also like to have access to your live xero accounts data. Click Next, and you will be in the data search page.

Now you can see all your xero data sets listed.

You can use the dataset selector to select only the xero accounts data set. Easy!

How to search on specific fields within xero accounts?

You can use the search box to filter across all your xero data in one place. Or even connect other systems and search across all of them in one place.

filter specific fields in the accounts table by clicking on the filter icon.

How Can I download my xero accounts data?

The data is available to download just by clicking on the download button in the top right corner of the xero accounts table

How to do advanced filtering on xero accounts?

You can also use our advanced query builder or pure SQL to do more advanced queries to filter your data sets. Click on the filter icon and go to the advanced SQL mode.

How to get xero accounts data via an API call?

Sometimes you want to pull the xero data programatically, but you may not want to deal with the oauth flow involved, Cloudslurp gives you a way to access your data with just an authorisation token which is great for using it with REST connectors in analytics tools.

curl --location --request GET ''         --header 'token: YOUR_CLOUDSLURP_API_TOKEN'

Is this data up to date?

Cloudslurp data is pulled from xero every time you do a query. So yes!

How can I give my team access to xero data without giving everyone a xero licence?

Available data sets from xero

You can also retrieve your other xero data sets:

What is Cloudslurp?

Cloudslurp is a productivity tool for you and your team. It is one place to search and download data from tools like xero and loads of others.