Curl get records by field

[panorama530540]

Hi,

I want to get from a table all the records, filtered by one of the columns.
For example: I have a field called “SKU”. There are many records in the table with the same SKU, different dimensions of the same products.
I want to get, with CURL, all the records with SKU = 1000.
How can I do that?

Thanks!

[Bill_French]

panorama530540:

want to get, with CURL, all the records with SKU = 1000.

Airtable Support

How do I sort, filter, or retrieve ordered records in the API?

To retrieve records in the same order as they appear in a specific table view, you can pass in the "view" parameter in the list records request (see the API docs). Additionally, you can filter and ...

[panorama530540]

Thanks for your reply, but it doesn’t work for me yet.
I try to write like that:
https://api.airtable.com/v0/MY_APP_KEY/MY_TABLE_NAME?filterByFormula=SEARCH(“SKU”%2C+“1001”)

or in a language that human can understand: SEARCH(“SKU”, “1001”)

I get an empty array. I have more then 30 records with 1001 in the SKU column.

What can be the problem?

[kuovonne]

panorama530540:

SEARCH(“SKU”, “1001”)

Put your field name in curly braces, not quotes.
If your field value is a text string, make sure you put the value in straight quotes, not curly quotes. Also put the string to find first.
If your field value is a number, remove the quotes and use an equation.

SEARCH("1001", {SKU})

or

{SKU} = 1001

Try testing the formula in a formula field in the base to make sure it works.

[Bill_French]

panorama530540:

or in a language that human can understand

Nothing about cURL is a language humans can understand. :winking_face: But now that this additional requirement has been exposed, I shall ponder it. In the meantime - I suspect you are experiencing URI encoding issues in your attempt.

[panorama530540]

kuovonne:

{SKU} = 1001

It works!! Thank you so much :slightly_smiling_face: