Help

How Use filterByFormula with Apple Shortcuts? URL via CURL Works. URL via Shortcuts: TABLE NOT FOUND

Topic Labels: Formulas
348 0
cancel
Showing results for 
Search instead for 
Did you mean: 
planewryter
4 - Data Explorer
4 - Data Explorer

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'.

  • Baffled, I am.

Any ideas? Suggestions? 

Thank you in advance for any assistance you can provide on this matter.

 

 

 

0 Replies 0