Data Public Necessary for Query Links? [NO, it is not]

[nat]

@BPlayfair123

In PBI using this (.xls) pulls the data so that the column headers are quite long. I think maybe the name of this is combined column. But in order words it might read: consent/hhsize/gender/… etc for many columns so that it is hard to read in PBI.

Were you able to change the API link in anyway to have a more readable format for the fields in PBI?

@BPlayfair123 I just logged a suggestion - please feel free to comment/vote so it can be considered by the KoBo team! All the best.

API - assets (submission data) - flag to omit 'Group' from the JSON response key

Spin off from What is the general goal of the feature? To streamline ability for API users to easily import data into Power BI/PowerQuery and similar tools, as they will no longer have to put in code to extract the “name” of each field without including the “group”. At the moment, if a user calls API (v1 or v2) to get submissions data (https://[kpi-url]/api/v2/assets/{asset_uid}/data/ (access submitted data), e.g. https://kobo.humanitarianresponse.info/api/v2/assets/a6krNsaSnJFJDM9BgMSU3r/da…