Hi, hope you're well.

We have reports built off of non-Fivetran data that currently use Xero Invoice information, as it was at the time the Invoice was created. We'd like to migrate these over to running on Fivetran data but this key bit of info is missing.

It's important to us to know the Contact name at time of Invoice creation (since we have a lot of historic data and Contact names have changed over time). As far as I can tell Xero offers this information bundled in its responses on the "GET Invoices" endpoint (https://developer.xero.com/documentation/api/accounting/invoices) - you can see each Invoice returned also includes summary Contact info.

This info is also available in Xero's UI.

It is however not included in the schema built by the Fivetran Xero connector. The closest thing we have is using the Contact table itself and joining it from Invoice. This doesn't cover our use-case since it only stores the current name of each Contact.

A related but separate issue we see due to not having access to Contact info bundled with Invoices is that new Invoice records coming in have no Contact info attached, since Contact records are only synced once daily - no matter how often we trigger the Xero sync on our end.