Issue pulling survey response data from API - Can pull survey information

User Support API
1

I am trying to connect to the KoboToolbox to pull survey response data using a call to the API. I can pull survey configuration but cannot pull survey response data using the API Key. I get a “detail”: “Not found.” when trying to pull response data – See below.
I am using PostMan for testing.
JSON response:

{

"detail": "Not found."

}

2

hi @wrmkbt63,

can you provide more information? Which url using, configurations etc. to understand better to answer your question

3

I am working on a test ETL pipeline and am trying to pull data from the Kobo Toolkit API. I can successfully pull Asset information using the API Key and following URL - “/..eu.kobotoolbox.org/api/v2/assets/{Asset ID}/”
I get a response of “200 OK” and the full JSON containing the asset data.

When I try to pull survey response data using the API Key and the same Asset ID and the link - “..eu.kobotoolbox.org/api/v2/assets/{Asset ID}/data/“

I get the following response:
”404 Not Found”

JSON —
{

"detail": "Not found."

}

I am using Postman for testing. I can see 1 survey response in Kobo Toolkit so I know there is response data.

Could there be a security setting that is not set correctly for my account?

Any guidance would be appreciated.

4

Can you try this instead - I believe you need the .json on the end

“..eu.kobotoolbox.org/api/v2/assets/{Asset ID}/data.json“

For example, if this is my asset data:

{
“url”: “``https://kf.kobotoolbox.org/api/v2/assets/aBPV5L5oZF2gTo35DrhDUc.json”``,
…
“exports”: “``https://kf.kobotoolbox.org/api/v2/assets/aBPV5L5oZF2gTo35DrhDUc/exports/”``,
“export_settings”: [],
“data”: “``https://kf.kobotoolbox.org/api/v2/assets/aBPV5L5oZF2gTo35DrhDUc/data.json”``,
…
}

The data field indicates you need to fetch data.json

5

I found the issue and it was not the API Key. It was a setting under SETTINGS/Sharing - I need to have the “Anyone can view submissions made to this form” selection checked. Once I checked this option I was able to download the data json.

Thanks for your help.