Kobo Toolbox _APIs

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 .

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?

Hi @sumeyye_hnap

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

First columns with no submission are not exported:

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.

1 Like