Skip to main content

It was referencing the Api for the ‘Favorite Movies’ demo database.


To test and learn the api, I was trying to retrieve data from the

table Movies and only bring back a description of the movie The

Godfather.


I tried various codes using the method ‘Query Parameter’ (airtable’s

description with this name inside the api) see below:


https://api.airtable.com/v0/appID/Movies?fieldsiThe%20Godfather]=Description&api_key=MyKey


I tried other possibilities but I was returned an error or the

descriptions of all the movies in the table.

@Charles_Haughey


Maybe something like:



https://api.airtable.com/v0/_YourAppID_/Movies?fields[]=Description&filterByFormula=(Name="The Godfather")&api_key = _YourAPIkey_



however this will still return the hidden id and createdTime fields, by design I think?


I must admit that I have struggled with the syntax, a bit more documentation with examples would help.

Hi Peter,


Thank you for your reply.

I got this to give back something, though it was empty.

https://api.airtable.com/v0/MyAppID/Movies?filterByFormula=FIND("The%20Godfather"%2C"Name")
&api_key=MyKey

I think all has to be urlencoded.

This might help: http://www.urldecoder.org/

And this:https://en.wikipedia.org/wiki/Query_string


Yes I agree with you on the Doc examples… incomplete.


The filterByFormula definitely could do with more info and examples.


See Below


FIND(stringToFind, whereToSearchcstartFromPosition])


Finds an occurrence of stringToFind in whereToSearch string starting from an optional startFromPosition.

FIND(“fox”, “quick brown fox”)


=> 13


My test query above uses this but I am unsure what to put in 'whereToSearchrstartFromPosition]


If I use Name I receive an null response, but at least not an error where if I try other guesses I receive errors.


Anyway please continue to share with me your discoveries


Charles

Reply


Terms & Conditions