In the documentation, there is a optional field to enable offset for “get items”, but it doesn’t seem to work.
So could you check it, and please let me know the proper usage.
I checked it and from my point of view I can confirm it works as expected.
The offset refers to the created_at field: items in a collection are sorted in the descending order (new items come first) and then filtered out if their created_at >= query param. date (i.e. only older items are kept).
So, when you want to iterate over more batches, you fetch the first one, then take the last item created_at value and use it as parameter to get the second batch… and so on.
This is an example of usage: https://kvstore.p.mashape.com/collections/my_collection/items?offset=1476496846.550855
Let me know if it works or you have different results
In the meantime I close this. In case you’re still experiencing unexpected results, please open a new ticket.
I checked it and from my point of view I can confirm it works as expected.
The offset refers to the
created_at
field: items in a collection are sorted in the descending order (new items come first) and then filtered out if their created_at >= query param. date (i.e. only older items are kept).So, when you want to iterate over more batches, you fetch the first one, then take the last item
created_at
value and use it as parameter to get the second batch… and so on.This is an example of usage:
https://kvstore.p.mashape.com/collections/my_collection/items?offset=1476496846.550855
Let me know if it works or you have different results