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!
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?
+29Thanks 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?
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.
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?
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.
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.
It works!! Thank you so much :slightly_smiling_face:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.