Get even or odd rows from table (http request)

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,…

Maybe someone high skilled can help me with this issue

Thanks a lot!

Page 1 / 1

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))

Sign up