Data Pulling Error in Excel And Google Sheet

User Support API
, ,
1

Hello Sir,
This is to inform you that I am facing a problem with Kobotoolbox api key i am pulling data of kobotoolbox from excel by API key but the API link is telling invalid and downloading data from the same link by browser. Sir Please solve the issues…
Thanks
Regards
Rahul

2

@frhsindia, are you trying to pull your data to Excel Power Query or to a Google Sheet?

3

Sir I am trying excel and google sheet both.

4

@frhsindia, if you are using the Excel Power Query, you could follow our support article that has been shared here:

5

Thank you sir, i will check.

1 Like
6

i am not able to link kobotoolbox data into excel, sir please suggest how can do it.

7

Did you follow the exact steps? Did you make your data public?

8

Yes, during the process show error link is invalid.

9

What is the error message that you see? Could you share it with the community?

10

error

11

There could be 2 possible issues you will need to verify:

  • You have selected the wrong project that is not available on the server. for e.g. 92453 may not be there and you may have chosen the wrong project.
  • The other is that you may have chosen the wrong server. Are you on the humanitarian server or on a non-humanitarian server? You should see https://kc.humanitarianresponse.info if you are using a humanitarian server while https://kc.kobotoolbox.org if you are using a non-humanitarian server.
12

Hello sir,

Sir when i checked the project link by 'https://kc.humanitarianresponse.info/api/v1/data url then the code of my project is showing the same so how can i know which is the correct link of my project