Summary
The user is facing an issue where the sync from Xero to Postgres in Airbyte is completing successfully but the Postgres tables are empty. They have verified that the data is present when accessing Xero API directly. They are seeking guidance on troubleshooting this problem.
Question
Hello team!
I wanted to ask for some help with OSS Airbyte. I’m trying to get the Xero to Postgres.
I’ve configured Xero to Posgres integration. the sync completed successfully, but the postgres tables are empty.
I can see that accessing Xero API directly, the data is there.
How is it possible to troubleshoot this?
Attaching the log file.
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.
Join the conversation on Slack
["troubleshooting", "xero-connector", "postgres", "sync-issue", "empty-tables", "log-file"]
<@U01MMSDJGC9> thanks for the help! I just got the latest version and still getting the same problem. Unfortunately I’m pretty new to Airbyte, so not sure how to provide information to troubleshoot. I have a feeling it could be that the data is not being received from the Xero, but not sure who can help with Xero connector troubleshooting
Sounds good. I’ve reverted back to 0.2.5 for now which works. Incremental tends to miss records (or so our finance team has said) so I have it set to full refresh
The version you’re running is quite old I strongly recommend to latest versions.
The log you share doesn’t provide the sync log for investigate if the data was properly loaded to destination.
The Xero connector is brutal. On the latest version, using OAuth will succeed but give no results like you mentioned. You need to use Bearer Access Token and pray it actually gets refreshed before it expires.
<@U05GDKP6STY> I’m going to share your feedback with the connector team.