API dropping columns with no response

[Josh]

Hi @bucaneve, you can follow a discussion related to this here:

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…