Kobo Toolbox _APIs

[sumeyye_hnap]

I get (json) data form Kobo using (Pandas) python requests.
When i transferred data to DataFrame, I noticed that there are missing columns in the data .

My data contains more than 500 columns in one sheet and the the second sheet about 25 columns, but only about 460 columns were appeared, for some projects and less than it in other projects .

[Kal_Lam]

Welcome to the community, @sumeyye_hnap! Could you also share the snippets so that the community could try the same at their end and help you troubleshoot?

[dickoa]

Hi @sumeyye_hnap

There can be many reason why not all columns are available.

First columns with no submission are not exported:

All columns do not appear in API

Hi @abeeharry, just to summarize our discussion: The /data.json endpoint returns questions that have had data submitted to them. This means that there can be instances where columns will show up in the Excel export but not at the endpoint. As mentioned, there are several reasons why there might not be data for a particular question in a submission: a note-type question (doesn’t receive submissions) skip-logic that moved to the next question for that person it wasn’t a required response and wa…

Also, compared to the exported Excel sheets, a select_multiple column is not automatically turned into multiple dummy columns.

There’s probably other reasons, but just wanted to point out the first two.