I’m trying to setup a simple API but I’m not exactly sure what APIs to use.
I want to check for a unique value in a field (userID) and return the RecordID.
If recordID exists, overwrite record with new data
If recordID doesn’t exist, create new record with data
At the moment I’m stuck on 1. I’ve tried List Records, using filterbyFormula & the API Encoder tool, Retrieve a record, I just can’t get the single results returns like I’m after.
Can someone please provide me with an example API request to for number 1? If you could help with the others that would also be really great but at the moment 1 is where I’m stuck.
I know it’s a really simple API setup but I’m new to this and have been trying for hours. I have also posted to the Airtable forum but my posts aren’t getting approved for some reason.
Thanks so much.