Hi @iker.montes,
Thank you for sharing this wonderful resource in the forum. It should help and benefit the entire community users. Expecting the same in the upcoming days!
Have a great day!
Hi @iker.montes,
Thank you for sharing this wonderful resource in the forum. It should help and benefit the entire community users. Expecting the same in the upcoming days!
Have a great day!
Hi @Kal_Lam and @iker.montes,
I got this working this morning, thank you. I had to edit the query so that it hooked up to kc.kobotoolbox.org. But once I got that done, it loaded the data.
Thank you!
Are you able to suggest how to link to Power BI when we have sensitive data that we don’t want to share publicly? I think it could be through the REST Services, but if either of you can advise, would really appreciate it!
Speak soon,
Janna
If you ket me know the address used for the kc.kobotoolbox.org, I can make a dual one for both . I actually tried but no success ( I dont use kc.kobotoolbox.org myself)
It is just a case of having something similar to …
https://kobo.humanitarianresponse.info/assets/FORMID/submissions/SUBMID/edit/?return_url=false
It would be great as more people could use it!
About getting the labes in a private way … I would love to have it also, but no luck yet.
I think it’s literally the exact same url construct, I believe… Just replace kobo.humanitarianresponse.info with kc.kobotoolbox.org
If you want me to send you my form id, let me know (public test data, nothing sensitive). If you want to test it out.
Sure, please share the URL path…
I tried:
https://kc.kobotoolbox.org/ikermontes/reports/aZPyLmRWbCDZT554JcNp2b/export.csv
and
https://kf.kobotoolbox.org/ikermontes/reports/aZPyLmRWbCDZT554JcNp2b/export.csv
both times same error
DataSource.Error: Web.Contents failed to get contents from ‘https://kc.kobotoolbox.org/ikermontes/reports/aZPyLmRWbCDZT554JcNp2b/export.csv’ (404): NOT FOUND
If I manage to make it works I’ll create another parameter to choose the instance, simpler for people than editing the query!
Hi @iker.montes,
Try my form ID and userid:
user: jannadata
form id: ady8SUPNiuBFaZ6xUWfSFn
and the url is kc.kobotoolbox.org
so the full url becomes: https://kc.kobotoolbox.org/jannadata/reports/ady8SUPNiuBFaZ6xUWfSFn/export.csv
Hope that helps! I think it would be really useful to put the selector, whether people use the humanitarian version or the “everyone else” version of kobotoolbox!
Janna
Hi @janna,
THnkas for sharing the data, I made it work.
TUrns out that my data is not reachable (thus Error404?)even if it is shared. Maybe because it is a very old form.
Your works though. Then I have refreshed the file in the link and now we can Connect to both instances of Kobo. (munanitarian and “Everyone Else”…
Hello everyone,
Just to mention, i am using the OCHA server and in this case if much easier to use this Website:
https://im.unhcr.org/kobosupport/#form
It also allow data to be private
Hi quentin,
I used this also in the past but you get the names (AKA: machine code) rigth?
Whereas with the link I provided you get the label ( AKA, this I can read)
EX, in my forms countries get number in alphabetical order (…1,2,3), whereas I need names (Angola, Benagadesh…)
I could do a lot of manipulation in PBI To change this… but I dont want…Lazy person.
The unlucky bit is that I need to get my data public…
@Quentin Do you know a way of getting the labels ( even for different languages) been private…that would be the best way forward?
True, it’s only the names
I usuelly try to have names that have a sense both in the survey and choice sheets in order to understand the data and in PowerBi i only show the data and writte down the titles or transform the labels.
However there could be a way integrating your XLS in your powerBi model and using some DAX, however i’m also too lazy to do so…
Hi @iker.montes
First of all thank you for your answers and posts, it has been very helpful.
I would like to ask if you can still getting data from the URL:
https://kc.humanitarianresponse.info/ “USERNAME” /reports/“FORM ID” /export.csv
As today, i am always receiving error 404, i have checked my form is public and i dont have set any specific language. I was searching another way to get an export from API, as we can get it from the export function in the platform and i always end reaching this solution.
Can you confirm the url is still working?
Regards,
No it does not.!
dear @Kal_Lam , is there any improvements on this?
It would be great to some of us, using this way to access data, if we could get this fixed:-)
Regards
HI @Kal_Lam, I’ve tried this method, but all it shows is a list of urls for “user”:“https://kc.humanitarianresponse.info/api/v1/user “forms:”“https://kc.humanitarianresponse.info/api/v1/forms””"
“submissions:”“https://kc.humanitarianresponse.info/api/v1/submissions”"" , etc.
Using json option worked for me