We have been working on a custom block to write data from airtable into the Sanity CND with great success. We were able to use the record ID’s from airtable as the ID’s in Sanity.
Now we are attempting the reverse with a GET request and this has been much more difficult. We have had to create logic for the id’s to be created in each application to be used by the other. This became even more complex today when we realized that a reference tag from a tag able was itself a record and still and instance of a record all over our second table.
We are using a listener and Sanity uses documents and each has an id but the json response does not include the document id along side the transaction id. Any advice on how to go about patching multiple tables together? Or is this just over all a really bad idea? We have also requested from Sanity to see if they can add the document ID to the json response or if somehow we can find it using the transaction id.
Thanks so much!