The data from API are unstructured/are different when we compare with CSV or XML data extracted from form created

Hi @tetobrasil,

Thank you for providing some more detail :slightly_smiling_face: This is the expected behaviour of the JSON API — it will return the question and choice names (including their group hierarchy) and not their label as you can do with the CSV or XLS exports. Please refer to my explanation here as to why there are “missing” items in the JSON response compared to CSV or XLS.

You will have to do some post-processing on the JSON data to get the labels back but, as has been recently requested here, we may look at a more convenient way to do this in the future.

I hope that helps to clarify things.

2 Likes