Skip to main content

Im trying to filter the next api request: 

https://api.airtable.com/v0/appn8Dg5iLM042oZh/tblDamHA046rqdTJF?fields%5B%5D=client_address_(from_deal_id)&fields%5B%5D=client_name_(from_deal_id)&filterByFormula=assignee%3D+9650 

but instead of the assignee being 9650 i need to filter it by names like "Nick Smith", how could i do it?

The error i get when i try to put a string instead of a number like:

https://api.airtable.com/v0/appn8Dg5iLM042oZh/tblDamHA046rqdTJF?fields%5B%5D=client_address_(from_deal_id)&fields%5B%5D=client_name_(from_deal_id)&filterByFormula=assignee%3D+samantha 

is: 

"error": {
        "type": "INVALID_FILTER_BY_FORMULA",
        "message": "The formula for filtering records is invalid: Unknown field names: samantha"
    }

Solution:

https://api.airtable.com/v0/appn8Dg5iLM042oZh/tblDamHA046rqdTJF?fields%5B%5D=client_address_(from_deal_id)&fields%5B%5D=client_name_(from_deal_id)&filterByFormula=SEARCH ("Samantha", ARRAYJOIN(assignee))

assignee is a lookup field thats why it is a ARRAYJOIN, and it also works with full names with spaces like "Nick Smith"

Reply


Terms & Conditions