Kobo Toolbox _APIs

[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.