The REST API to query Submission_Time in JSON is NOT filtering the correct Data

[carlfost7]

Eventhough the Data in KoboToolbox shows 5 submissions for January 19, 2025, 3 submissions on January 18, 2025, and 3 submissions for January 17, 2025. The Query returns zero data when I check for the data on January 18. If I check for data on January 17th, I received those 3 submissions; but the 18th and 19th (today) returned zero.

endpoint = ‘https://eu.kobotoolbox.org/api/v2/assets/SOMEPROJECTID/data/?format=json&query={“$and”: [{“_submission_time”: {“$gte”: “2025-01-18T00:00:01”}},{“_submission_time”: {“$lte”: “2025-01-18T23:59:01”}}]}’

This is the response:
{“count”:0,“next”:null,“previous”:null,“results”:}

When
This was working in December, but somewhere in January it is no longer working. Please help!!

[wroos]

For the “missing” cases, what are the _submission_time values you see on server level, please? (Could you share a screenshot?)
Which server are you using?

[carlfost7]

Here is the image

[wroos]

Could you enlarge the _submission_time column, please, so that the full datetime string is visible? And better avoid publishing personal data (e.g. trainer names) to the forum, please.

[carlfost7]

Here is the screenshot with the Submission_Time column expanded

[carlfost7]

Image with expanded Submission_Time column.

[carlfost7]

[carlfost7]

Here is another view of the submission_time data. I can download January 17, 2025 via REST API , but January 18th or 19th return zero.