Changing language when connecting kobo to excel (power Query)

User Support API
, ,
1

Hi
I have a problem when importing data from kobo to excel using API my assessment has three language one of them the English data but I need the other languages when importing to excel and updating automatically when refreshing the query.

2

Welcome to the community @Alaa_Ali! Could you share the API you tried?

3

Thank you Kal_Lam for response.
I did not use any code to import xls file just I went to
Http:\kc.humanitarianresponse\api\v1
Then I downloaded data file then I opened it with Word and copied the link for assessment then to excel import data from web
The problem that I want data in Turkish not in English
I did not see any option to convert th language

4

@Alaa_Ali, could you share the sample of what it looks like when you open it with Word as said above:

This should give us some understanding of your issue.

5

@Kal_Lam
by using API, it return only xml values, no choice for labels.

before it was working like this:
https://kc.kobotoolbox.org/USERNAME/reports/UID/export.xlsx?lang=English

is there another solution to do it?

6

Welcome to the community, @shadowmise! Will reach you back when we fix this issue.

1 Like
7

@Kal_Lam

thanks, i tried many solutions via API v1 and v2, all not working.

so thanks in advanced and waiting your solutions while i will keep trying to find one also

1 Like