I’ve set up a Zap to copy the event ‘New Sales Invoice’ in Xero to AirTable with the output being ‘Create Records (Advanced)’ so that each line item of the invoice is a separate record.
I’ve then set up another Zap for the event ‘Updated Sales Invoice’ to update the AirTable records with changes made in Xero. I can’t use ‘Create Records (Advanced)’ again because there isn’t an option to tell it which line item needs updating, so I’ve used ‘Create or Update Record’. I’ve told it to link via the Line Item ID (which is unique), but instead of updating the particular Line Item, it’s creating a new record with all the line items in one record for the invoice.
I’m going around in circles but can’t seem to figure out a way of getting it to update an invoice that has been created in AirTable with a record for each line item. Any ideas? Thanks.