API get sequential dataset always returning the first row

#1

I am using a dataset and wish to get a new value each time I call the API.
If I choose “random” it works just fine, but if I choose “sequential” it always returns the first row.
I was expecting to get the next row with each call, until cycling back to the first one when the end of the dataset is reached.
=> how can I achieve the desired behaviour ?

Thanks

#2

Hi,
just to be more specific, I generate a list but only wish to get one row in the list with each call.
I have set the following parameters for my query:
schema “xxxxx”
generate 1

with “generate 1” I actually get only one row. So far so good. Except this row is always the first in the list. How can I get the “next” row with call ?

thanks