I am trying to export the data from Kobo to Google sheet. To do this I am testing the “Api Connector” Addons, which loads the data, but the questions do not appear in the order defined in the questionnaire. At first I thought it was some problem with the Addons, but when I checked the JSON file corresponding to the questionnaire, I realized that the questions (which would later be columns in google sheet) were in a different order.
For example, I have a matrix type question that requires entering the number of tests applied to people by age group and sex, as shown in the attached image. However, as you can see in the JSON file, they (the question) are included in an unordered way, this being the one that the Connector API uses in the end to insert it into googlesheet. (See Matrix question and JSON images)!
Is there any way to garanty that JSON follows the pre-defined question order? And, what could be happening in my case?