We would like to use kobo app as a support tool for our web platform. The data entry will be from different sites (using the app) and frequency is daily once. We will not use the kobo web platform for any data handling, we just want the data to move seamlessly to our MySQL database.
All I found in the discussion is to use REST API that will export ALL DATA, but we do not want to export all data, we just want to move ‘new data’ which has not been sent to the server yet.
Does it mean you will not set up the data to get to our servers first? If that is the case, then your next query would not be possible,
When you pull data via API, you will need to be pulling it from our servers using API. If you however need to bypass our servers completely, then I suggest that you set up KoBoToolbox on your own servers.
Now, if I enter more data - it will accumulate and the JSON builds up continuously. As our data entry in the app is daily, 300+ facilities, the accumulated JSON becomes unusable soon.
How can we filter by ‘date’, say - ‘give me data of date X’.
Thanks for the hint, but it seems you gave an example with v1 API end point and /data/, which in my case shows ‘not found’. I am getting data using this endpoint -
And I could not make use of parameters, struggling for last 2 days. Can anyone help to properly add this parameter to my query - ‘Date >= [certain date]’.
Scroll down to see the data links for the individual forms.
The link to retrieve the data from the form is https://kc.kobotoolbox.org/api/v1/data/form_uid where the form_uid is a numerical value unlike for the v2 API.
Thanks a ton! Managed to have the data api running and extracting data with ‘date’ parameter. On interesting finding, instead of the ‘gt$’ which is mentioned in the API page, the following worked ($gt) -