How to Import Xero Online Invoice URLs to Airtable

Importing your Xero invoices into Airtable allows you to use Airtable's powerful automation and workflow features on your Xero data. Importing Xero online invoice URLs takes this one step further, allowing you to access the invoices from Airtable or build interfaces to let your Xero contacts view their own invoices!

You need to have already imported your Xero invoices into Airtable, including the Invoice ID field (note: this is different to the Invoice number). To do this, follow this guide to importing Xero invoices to Airtable, then come back here!

How to Import Xero Online Invoice URLs into Airtable

On the Data Fetcher home screen, click Create Request.

On the create request screen in Data Fetcher, for Application, select Xero to use the Airtable Xero integration.

Under Authorization, select your existing Xero connection or click New to create a new connection.

In Data Fetcher for Endpoint, select Online invoice. The endpoint determines what data is imported from Xero to Airtable. This one gives us the Xero online invoice URL.

Add a name to help you remember the request, like Import Online Xero Invoices.

Then click Save & Continue.

We want to make Invoice ID a reference to our Airtable field with the long invoice IDs in. Click the + icon on the right had side of the Invoice ID input.

On the modal that opens, make sure the Table is your Invoices table, the Field is the Invoice id field. Then click Confirm.

The Invoice ID field will now have a reference to our Invoice id Airtable field. This means when we run the request, it will loop over the view and import the Xero online URL for each invoice.

We're ready to go! Click Save & Run in the bottom right-hand corner.

The request will run and the Response Field Mapping will open. This has a preview of our response and lets us map it to our existing or new Airtable fields. You only need to set this up the first time you run the request, but you can always come back to it to make changes to the mapping.

There is only one field imported, the Xero invoice URL, so we can just click Save & Run.

The request will now run for every record in our invoices table and import the Xero online Invoice URLs into Airtable!

Next time we run the request, it will import invoice URLs for lots of records that already have them imported. To make things more efficient.

Create a new Grid view in your base called Data Fetcher - Needs invoice URL. Add these two filters:

1. Invoice id is not empty.
2. Online invoice url is empty.

Open your Import Online Xero Invoices request in Data Fetcher and change the output view to the new Data Fetcher - Needs invoice URL view you just created:

Then click Advanced Settings at the bottom of the screen. Scroll down to Run on Multiple Records and change the view here too:

Click Save. Now, when you run the request, it will only fetch Xero online invoice URLs for those invoices that do not already have one!