Download filtered data kobo automatically

[osmanburcu]

Hi @febyinka,

As far as i know, it is not possible to filter the data though saved export settings, but if you are familiar with the JSON format and SAS allow you to import data from from web. You can use JSON format to filter and import your data to SAS direct. The formula below will filter the submission after 25/09 and allow you to view it JSON format.

https://kobo.sid-indonesia.org/api/v2/assets/{assetid}/data.json?query={“_submission_time”:%20{“$gt”:%20"2025-09-03T00:00:00"}}

I believe you have more than 30.000 submission in your form as you get time-out error. I suggest you to check the topic below as well.

Power BI export - submissions limit

Dear Community, Please help with next issue: I have 138000 submissions and i cannot export them to power bi, it is always this error 504 (Gateway Timeout). I read that it was a submission limit of 30000. Could it be the case? Please suggest the method to connect it all to power bi. Thank you!