With legacy I could download data directly to excel using the below format if the data is publicly sharable:
https://kc.humanitarianresponse.info/username/reports/uniqueformcode/export.xls
This is no longer working since today morning.
How do I go about this since this is an important feature that we have been using
Could you also share the screenshot of the error message it throws?
Maybe you could do it using the following API:
https://kc.humanitarianresponse.info/api/v1/data/1314.xls
Here you will need to find the 1314 number as outlined in the support article Pulling Data Into Excel Power Query. Once you find this number you could replace the number and then place the same in the browser to directly download your data.
Thank you @Kal_Lam
I was able to download using this method. But still have an issue since the data download has xml values and headers.
How do I download the one with labels?
@dkuria, could you also share (maybe a screenshot of) what you were able to download and what you expect with the download?
OK. FYI please be informed that we do have a features request for this that should solve your issue:
Back to my first post, can this feature be returned, since it worked well, simple steps and we were able to get data with labels
https://kc.humanitarianresponse.info/username/reports/uniqueformcode/export.xls
I believe it only existed in legacy, but stopped working after some of the legacy features were dropped. It is frustrating since we had automated some of our functions involving many forms.
Hi,
I am getting this same issue but trying to access a CSV:
https://kc.humanitarianresponse.info/user/reports/form_id/export.csv
Any suggestions?
Pablo
Welcome back to the community, @pkhn! We will get back to you after having a closer look at this issue.
Kal_Lam,
I managed to solve it with the following instructions:
https://support.kobotoolbox.org/pulling_data_into_powerbi.html
Thanks
We were able to download reports/data to excel by creating the below simple url:
https://kc.humanitarianresponse.info/username/reports/uniqueformcode/export.xls
It is not working anymore., I believe because of the changes to legacy interface. Can this be integrated/reinstated to the new interface.
The new interface, for data download, to csv/xls, a new url is created every time.
https://kc.humanitarianresponse.info/api/v1/data/1362432.xls
Using the URL not able to pull data in power quary
Welcome to the community, @absbd84! Could you also explain your issue so that the community should also be able to help you out?
