Kobo API & Beyond

[me216]

Dear Kobo users and devs,

Wishing you well. Please note that my colleagues might use Kobo for data collection. As a developer, I am thinking to write a script (nodeJS / Python) for the purpose of capturing data and inserting it into our database. How can I achieve that?

Best wishes,
Mohamad

[Kal_Lam]

Welcome to the community, @me216! Maybe this post discussed previously should help you with how a script is written in python:

Importing xls data into KoBoToolbox

@sareep, a while back have created a method for converting XLS data into XML with a Python script so that they can be submitted via the API. This requires an existing deployed form to be in your account. Everything is documented in this repository: https://github.com/kobotoolbox/xls-import. I hope this works for you.

Another one:

Cannot export and download my data

Hi @locust, that is concerning. Would you mind please sharing the following with me in a private message so that I can take a look: Server (OCHA/HHI) Username Project name In the meantime, you can do the following to meet your original need of pulling data based on specific criteria. Let’s assume you have a question called country and you also want to limit the _submission_time property to submissions after a certain date. In a terminal (or with a REST client), you can do the following: cur…

And this one too:

Uploading users in bulk in Django

Hi @djole, Lets assume you have some projects already created and are wanting to create users and give them permissions to particular projects. You could create a spreadsheet with the following structure for creating new users (let’s call it users.csv): username first_name last_name email johndoe John Doe johndoe@gmail.com … … … … And a second sheet with your projects and permissions for each user (let’s call it permissions.csv): username project_uid permission johndoe qW…

[wroos]

Hello,
Why do you need to do own programming on this? KoBo Toolbox / KoBo ODK Collect normally offers enough for data collection, submission and storage.
Did you go through the KoBo manuals already?

[me216]

I want to collect the Kobo data so that I insert them into my database.

[aronzara]

You should be able to do this using the KoboToolbox API with Python or Node.js. Once data is submitted to Kobo, your script can fetch the responses automatically and insert them into your database. The API documentation and token authentication setup would be a good place to start.