Append Geoprocessing Service

286
1
02-07-2019 06:54 AM
AndrewMilanes
Occasional Contributor

I would like to perform a very simple geoprocessing task in WAB:

  1. User uploads a CSV file ( 3 text columns and schema matches table in SQL)
  2. Records from CSV are appended to existing table in SQL

So far I have been unable to get this to work.  Steps I've taken:

  1. From Pro 2.3.0, use the append geoprocessing tool to perform the task
  2. Share the result as a Web Tool in Portal 10.6 (upload and asynchronous selected)
  3. Add the GP service in WAB widget

No matter what parameter options I choose, this is the error I receive:

ERROR 000820: The parameters need repair. ERROR 000800: The value is not a member of Input schema must match target schema | Use the Field Map to reconcile schema differences. ERROR 000820: The parameters need repair.

So I tried from ArcCatalog 10.6.1:

  1. Use the append geoprocessing tool
  2. Share the results as a geoprocessing service to Server 10.6 (upload and asynchronous selected)
  3. Add server to GP widget in WAB

Different error with this service:

ERROR 000840: The value is not a File.

The output table is registered with the geodatabase and the SQL connection is registered in Server.

What am i missing?

Thanks

Reply
0 Kudos
1 Reply
SimonSuo1
Esri Contributor

File upload is not supported yet in the WAB, and it is currently under discussion to add support for it for the next release. Meanwhile, file upload UI is available in the map viewer of portal.

Reply
0 Kudos