What are you trying to achieve?
I’m trying to get Xero invoice data (new invoices to be created + existing invoices to be updated w payment info) into Airtable. I’ve tried in at least 5 different ways and nothing is creating a clean link.
The latest issue I’m having is trying to filter the input from Xero (to be, for example, Last-Modified), but am not sure how this is supposed to be configured under “Advanced Settings”. I’ve tried {Status}=‘PAID’ in any number of configurations, but it keeps throwing a “Syntax error ‘{’ (16, QueryParseException)” Error.
Steps taken so far
Some previous versions I’ve tried have created items in Airtable, but it either creates 5-10 duplicates of the same invoice, or can’t pull the “Payments:Date” and “Payments:Amount” info through because they don’t exist (for outstanding payments).
