We have build a react front-end connected to Xano APIs/backend. Our data is manually curated and manage across a bunch of tables in Airtable. The tables contain master tables and transaction tables (with fields linked to the master table)
This data needs to be synchronised daily (one way from Airtable to Xano). The table schemas are a replica in both places (50+tables).
Possible challenges/questions:
Should we do a daily wipe/replace of all Xano data with airtable data
Challenge with wipe and replace is the primary key id from Xano master tables will not be in sync with the airtables data.
Should we put a layer in between to see changes in data between Airtable and Xano and push (add, delete, update entries) - but this will be painful to code and manage as the fields change.
Any suggestions