How to upload a CSV to a web service?

Question

I thought this would be a good place to figure out how to set up a web service to accept a CSV as an input. To keep it short, I want a user to upload a CSV file with lat/long pairings, and the tool will perform a spatial join and give the user the joined fields in an excel spreadsheet. I already have a script tool that works perfectly, but I cannot figure out how to set up a web service to do this.

Currently the (successful) script tool has two parameters: input and output, both of which are File Data Types. Any suggestions on the best way to go about creating a web service to perform this?

MichaelKozub · Answer

import arcpy

inputTable = arcpy.GetParameter(0)

#When running in the python window in ArcMap, I comment out line 3 above and un-comment line 6.  
#inputTable = "C:\Users\user1\Desktop\example.csv"

arcpy.MakeXYEventLayer_management(inputTable, "Longitude", "Latitude", "tableXY")

arcpy.FeatureClassToFeatureClass_conversion("tableXY", "%scratchfolder%\Scratch.gdb\", "tableXYfc")

arcpy.SpatialJoin_analysis("%scratchfolder%\Scratch.gdb\tableXYfc", "Database Connections\example.sde\example.polygons", "in_memory\_join","","")

arcpy.TableToExcel_conversion("in_memory\_join", "C:\Users\user1\Desktop\final_export.xls")

Here's the script which (which works perfectly in ArcMap).

RebeccaStrauch__GISP · Answer

Michael,

Wish I could help more, but I'm away from my server for another week, so anything more would be speculation. But I am interested in the topic so will follow and jump in if/when I can think of anything more.  Is it possible to share your script?

MichaelKozub · Answer

Thanks Rebecca. I do have access to ArcGIS Server and I have created a GP service with this script tool. I just haven't been able to figure out the proper way to allow CSV uploads. It seems that setting the input parameter is where my issue lies.