{ "name": "TablesToExcelServer", "displayName": "TablesToExcelServer", "description": "This function is used internally by ArcGIS Enteprise to export hosted feature services to Excel\nThis function takes multiple tables and writes them to an output Excel file.\nEach table will become a worksheet in the excel file.\nThe function returns the excel file path.\n\nThe first parameter is a json string with this syntax:\n\n {\"tables\" : [ , ,...] }\n\nwhere each table object is:\n\n { \"path\": \", \"targetName\": , \"where\": , \"includeGeometry\" : true/false, \"xColumnName\": , \"yColumnName\" : }\n\nThe path property is required. The others are optional.\nThe targetName will be used as the worksheet name. Otherwise the name of the table will be used.", "category": "", "helpUrl": "https://gis.legis.iowa.gov/arcgis/rest/directories/arcgisoutput/System/PublishingTools_GPServer/System_PublishingTools/TablesToExcelServer.htm", "executionType": "esriExecutionTypeAsynchronous", "parameters": [ { "name": "tablesSpec", "dataType": "GPString", "displayName": "Tables to Export", "description": "", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeRequired", "category": "" }, { "name": "targetSrId", "dataType": "GPString", "displayName": "Target Spatial Reference", "description": "", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeRequired", "category": "" }, { "name": "excelFile", "dataType": "GPString", "displayName": "Excel File", "description": "", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeRequired", "category": "" } ] }