Dear Airtable + Apple Shortcuts Mavens,
N00B, here with a N00B question.
Using Airtable's API Encoder, I crafted a GET URL with filterByFormula.
curl "https://api.airtable.com/v0/app[Redacted]/Items_Table?filterByFormula=%22%7BItem%7D%3D'D123'%22" -H "Authorization: Bearer [redacted]"
The resultant URL works fine in CURL.
When I store the URL (minus the Authorization bit) as an element in a DataJar Dictionary like this:
https://api.airtable.com/v0/app[Redacted]/Items_Table?filterByFormula=%22%7BItem%7D%3D'D123'%22
Shortcuts fails with a TABLE NOT FOUND diagnostic message.
HOWEVER, when I store the URL as an element in a DataJar Dictionary like this:
https://api.airtable.com/v0/app[Redacted]/Items_Table
The query works fine. The Table is found...except, of course, it returns all entries in the Items_Table, not restricted to item 'D123'.
Any ideas? Suggestions?
Thank you in advance for any assistance you can provide on this matter.