Issue with returned results using pagination and query parameter

Hey KoboToolbox team and everyone,

I’ve noticed that when using the v2 api and the data endpoint I’m getting different results when using the gt query parameter. Is there any place or github repo where I can open an Issue so your dev team can investigate what is happening please?

Just as an example, if I use the https://kf.kobotoolbox.org/api/v2/assets/{assetID}/data.json/?query={“_submission_time”:%20{“$gt”:%20"2024-09-01T01:02:03"}}&limit=1000&start=10000
I get a 10286 count in return for a given asset I have in a form
https://kf.kobotoolbox.org/api/v2/assets/{assetID}/data.json/?query={“_submission_time”:%20{“$gt”:%20"2019-09-01T01:02:03"}}&limit=1000&start=10000
I get a 10287 count in return for the same asset. I’ve checked and the _submission_time for all records in both returns are with dates of this year (which means they are greater than both dates provided in the query parameter) so they should be returned right?

@fred, could you kindly provide me with the following details through a private message? Maybe I could have a closer look at your case?

  • Username
  • Project name
  • Server

You should be able to send me a private message as outlined in the post discussed previously: