Hi I’m posting as I can’t seem to find this anywhere.
I have a form being pulled into a Google Sheet with the ‘API connector’ extension. When the data pulls through the headers are long which is making identifying them difficult in Google Data Studio.
i.e. “results.group_Observations/Obs_products”. In this case the data column name is “Obs_products” but “results.group_Observations” is being added.
Is there any way that I can get only the data column name to pull into the Google Sheet?
Thanks so much!
@Chris123, maybe try this API as outlined in the post discussed previously. It should help you solve your issue:
Hello, I would like to know if it is possible to modify the field names of a csv file before export with the kobotoolbox api.
Thanks in advance
Hello !
this other solution (which does not rely on a CSV import and does not require you to make your data public) may help because it allows you to select and rename the column headers.
Kind regards,
Serge
