Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Get even or odd rows from table (http request)

Topic Labels: API
340 1
Showing results for 
Search instead for 
Did you mean: 

Hello together,

is there a way to get just even or just odd rows from a table?
Even: 1,3,5,7,9,…
Odd: 2,4,6,8,10,…

I want to use${even-rows} or something else.

Maybe someone high skilled can help me with this issue :slightly_smiling_face:

Thanks a lot!

1 Reply 1

Hey @Sash_S

Create an Autonumber column field, I called mine row id.

Once you’ve got that in place here’s the filterByFormula query parameters you’ll want to append to the URL.

?filterByFormula=MOD({row id}, 2)

?filterByFormula=NOT(MOD({row id}, 2))