Get even or odd rows from table (http request)

[Sash_S]

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 https://api.airtable.com/v0/xxxxxxxxx/${even-rows} or something else.

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

Thanks a lot!

[goksan]

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.

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

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