in the v2 link there is an example where you can edit a form via:
curl --silent --user jnm_api:some-secret-phrase --header ‘Accept: application/json’ -X PATCH https://kobo.humanitarianresponse.info/api/v2/assets/apLBsTJ4JAReiAWQQQBKNZ/ --form name=‘My New Name’
Looking at the API the xlsx file is kept in the “xls_link” with value:
(https://kf.kobotoolbox.org/api/v2/assets/.../xls/)
I think it is possible to update the xlsx file by
modifying the curl in the sample with
curl --silent --user jnm_api:some-secret-phrase --header ‘Accept: application/json’ -X PATCH https://kobo.humanitarianresponse.info/api/v2/assets/apLBsTJ4JAReiAWQQQBKNZ/ --form xls_link = “published google sheet link”
But I wasn’t able to try since I was able to may it work using google form+sheet+script
Being able to update the form/replace the choices is nice.
I would be able to create a dropdown of prior incidents (submission id/text value entered in the form) so respondents can link prior incidents to a new incident with only google script, as requested by my boss.
I think I misunderstood you, possible to replace only the external file via api?
Then use the external file as choice?
Like this?
