I am working on putting together a “sync” with another system to our airtable base.
Basically i want to be able to pull a GET request on a members table on the field “CRM AGENT ID” and it find all the records with the matching ID’s.
for example. I check a CRM system and find these agent ID’s: 3, 60, 67, 30.
I then want to find those ID’s corresponding airtable records with a GET request.
Then update all of those records with a PUT.
Where i’m running into issues is the URL having the right search formula to search the field for all the agent ideas and return them all.
Hard to explain, but how can i do this?