dkuria
June 17, 2021, 12:13pm
1
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.
dkuria
June 17, 2021, 1:20pm
5
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:
What is the general goal of the feature?
To allow API users (e.g. those pulling KoBo data into Power BI) to be able to directly access the values by label (in the specified language) rather than by name.
This is a frequently-requested item with multiple forum posts. There are several workarounds listed (e.g. make forms public and do a join, make submissions public (!!!), use a separate connector, or export as csv etc.) but ideally it would be more intuitive for a user to just have a flag/para…
dkuria
June 17, 2021, 2:35pm
9
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.
1 Like
pkhn
June 17, 2021, 3:14pm
11
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.
pkhn
June 17, 2021, 3:33pm
13
Kal_Lam,
I managed to solve it with the following instructions:
https://support.kobotoolbox.org/pulling_data_into_powerbi.html
Thanks
1 Like
dkuria
June 17, 2021, 4:21pm
14
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.
Welcome to the community, @absbd84 ! Could you also explain your issue so that the community should also be able to help you out?