API Export to Excel Drops Hyperlinks to Photos

@mark_ej, we will be updating our support document very soon. Till then, maybe you could follow the steps outlined below:

Step 1:

Open your survey project and then make some downloads (by specifying a name to the Save selection as ...) as shown in the image below:

image

Step 2:

Now in a new tab, use the following API:

https://[kpi]/api/v2/assets/{asset_uid}/export-settings/

Here,

kpi refers to kobo.humanitarianresponse.info if you are using the humanitarian server else kf.kobotoolbox.org if you are using the non-humanitarian server.

asset_uid refers to a9aCgg3mE9JjcziiYddMtX if you are at https://kf.kobotoolbox.org/#/forms/a9aCgg3mE9JjcziiYddMtX/summary.

So, the API should be https://kf.kobotoolbox.org/api/v2/assets/a9aCgg3mE9JjcziiYddMtX/export-settings/

You will need to paste this API to a new tab under the same browser where you have opened your KoboToolbox account.

Step 3:

Now, you should see a screen as shown below:

Copy the URL from data_url_csv or data_url_xlsx upon your preference. It’s, however, advised to choose the latter one if you have data from repeat groups in your project.

Step 4:

Go back to your account and then make your data public by checking Anyone can view this form and Anyone can view submissions made to this form that is located under SETTINGS>Sharing as shown in the image below:

image

You could then follow the rest from the existing support article.

1 Like