Automatically updating XLS form

232
2
Jump to solution
05-28-2021 01:14 AM
MatteoDeMinicis
New Contributor

Dear all,

it is possible to automatically update a xlsform and then republish a survey through programming api's (without using Survey Conect) ?

Solution is based on ArcGIS Enterprise 10.8.1 and Survey 3.12

Thanks Matteo

1 Solution

Accepted Solutions
Philip-Wilson
Esri Notable Contributor

Hi @MatteoDeMinicis,

No, unfortunately at the current time it is not possible to automate publishing Survey123 forms using APIs. You must use Survey123 Connect or web designer to successfully publish a Survey123 form item.

Can I ask what workflow or use case you have to automate the form publishing? Is it just to update a choice list or external CSV file in the media folder? If so, it is possible to do this via a Python script. Please see https://community.esri.com/t5/arcgis-survey123-blog/updating-the-media-folder-of-a-survey123-form-it... and for more updated Python script refer to https://community.esri.com/t5/arcgis-survey123-questions/updating-csvs-in-agol-for-select-one-from-f....

Regards,

Phil.

View solution in original post

2 Replies
Philip-Wilson
Esri Notable Contributor

Hi @MatteoDeMinicis,

No, unfortunately at the current time it is not possible to automate publishing Survey123 forms using APIs. You must use Survey123 Connect or web designer to successfully publish a Survey123 form item.

Can I ask what workflow or use case you have to automate the form publishing? Is it just to update a choice list or external CSV file in the media folder? If so, it is possible to do this via a Python script. Please see https://community.esri.com/t5/arcgis-survey123-blog/updating-the-media-folder-of-a-survey123-form-it... and for more updated Python script refer to https://community.esri.com/t5/arcgis-survey123-questions/updating-csvs-in-agol-for-select-one-from-f....

Regards,

Phil.

MatteoDeMinicis
New Contributor

Thanks Phil,

use case is related to an external system which can be queried to retrieve new plants to be inspected. For each new plant there are many infos that shall be added in the inspection forms such as plant code, description, suppliers, ecc.

Thhat means that are at least necessary cascading selects with dynamic lists and perhaps other constrains (to be verified). 

Currently the survey owner manually insert all these data and publish updated form, but in the future they want that a server process query the external system and perform all the job. 

I don't know if I can use select_x_from_file for upgrading lists that are used in cascading selects (I tried but it don't work and probably i'm doing something wrong), which should solve 90% of the scope. If it is not possible I guess that I have to wait until the dynamic lists via feature service enhancement.