Help

I want to filter multiple data using json url

Topic Labels: API
Solved
Jump to Solution
4134 7
cancel
Showing results for 
Search instead for 
Did you mean: 
1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

First, your formula should be a valid Airtable formula. In Airtable’s formula syntax, the & operator combines items into a string. To get a valid test of both conditions, you will need to wrap the test in Airtable’s AND() function. Also, Airtable’s string comparisons are case-sensitive, so “male” should be “MALE” to match the data in your table. The modified formula should be:

AND(class="2", sex="MALE")

Then, as @Bill.French pointed out, you need to properly URL-encode that formula.

See Solution in Thread

7 Replies 7

Assuming the filter is correct, that URL needs to be URL-encoded.

can you pls hlp me to this url

Sure, simply take the URL to this site and it will URL-encode it for you.

It’s not working for me :frowning:

This is not enough information for anyone to help you.

Justin_Barrett
18 - Pluto
18 - Pluto

First, your formula should be a valid Airtable formula. In Airtable’s formula syntax, the & operator combines items into a string. To get a valid test of both conditions, you will need to wrap the test in Airtable’s AND() function. Also, Airtable’s string comparisons are case-sensitive, so “male” should be “MALE” to match the data in your table. The modified formula should be:

AND(class="2", sex="MALE")

Then, as @Bill.French pointed out, you need to properly URL-encode that formula.

Thank you for your feedback