upsert: invalid column filtering formula
When I put down key = "Name" as the search key for airtable.upsert, I got this error:
{ "errorType": "object", "errorMessage": "The formula for filtering records is invalid: Invalid formula. Please check your formula text.(INVALID_FILTER_BY_FORMULA)[Http code 422]", "trace": [] }
In my Airtable Column, I have a list of names: if I find a matching name, I want to update the record; if not, I want to create a new one. However, the upsert method offered by doesn't seem to be working correctly. I give it the name of the column to compare on, and it errors out every time (creates records flawlessly).
@czhao028 Can you provide a full example? This package doesn't manipulate the filterByFormula when sending to the Airtable SDK so it would most likely be that your formula is incorrect or there is a deeper underlying issue in the SDK.