Downloading data directly through an API

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?

What I got

What I expect

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.

1 Like

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

1 Like

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.