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 was left blank
- it was part of a previous revision of your form that never received submissions and is not longer displayed.
If any of these conditions happen to be true for all submissions for a specific question, you won’t find that question in the response data from /data.json, however you may find that /data.xml will have what you’re looking for.
