Skip to main content
Solved

I want to filter multiple data using json url

Forum|alt.badge.img+4

this is my table
https://api.airtable.com/v0/app7MvgC7cKX7Zq7n/student?filterByFormula=class="2"&sex="male"

Best answer by Justin_Barrett

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.

View original
This topic has been closed for replies.

7 replies

Bill_French
Forum|alt.badge.img+19

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

Forum|alt.badge.img+4

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


can you pls hlp me to this url

Bill_French
Forum|alt.badge.img+19

can you pls hlp me to this url


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

Forum|alt.badge.img+4

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


It’s not working for me :frowning:

Bill_French
Forum|alt.badge.img+19

It’s not working for me :frowning:


This is not enough information for anyone to help you.

Justin_Barrett
Forum|alt.badge.img+21

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.

    Forum|alt.badge.img+4

    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

    Terms & ConditionsAccessibility statement