I’m currently working on a script that will allow me to fetch submissions data from a form, clean and format the data and eventually store it into a MySQL database. One of the issues I’m facing is that the submission data stored in Kobo MongoDB (formhub → instances) has keys that correspond to the survey questions but these keys are incomplete in case of very long questions,
In the above screenshot, you will see that one of the questions is “group_ex2km22/In_what_year_was_you_organiza” - the original question in the survey is “In what year was your organization founded?” Since this data is incomplete, it is becoming very difficult to identify the question (from mysql, which I already have). Is there any way that I can obtain the entire question text in the mongo document? Can someone help with this? Thanks!