How to get Airtable data and insert it in my table?
1. Get some data from Airtable table 'products'
2. Delete my data from table 'products' from Xano
3. Insert the data from Airtable 'products' into my Xano 'products'
First I created my Xano tables and populated the data by importing from Airtable everything. I have a couple of referenced fields and everything worked.
BUT, when I try to add it , by myself , with my function, I get the data from Airtable, I delete my data form Xano and when I try to insert the new data, I receive errors tellimg me that 'reccfnsfMCuWQnFJX' is not an integer. It tries to add this value insead of the integer id, to the referenced fields.
When I import tha data it must be some kind of script that automatically replaces the 'reccfnsfMCuWQnFJX' with the integer value .
Does anybody know how to solve this? to replace that 'reccfnsfMCuWQnFJX' to the proper integer value?
Other
5 replies