{ "name": "ExcelAnalyzeServer", "displayName": "ExcelAnalyzeServer", "description": "This function returns information about an excel file.\n\nThe function is used by the Analyze and Publish operations in on-premise Portal.\n\nFor each sheet in the excel file it will return the sheet name, id, and the list of fields.\nThe result is a json with this syntax:\n\n { \"sheets\" : [ , ,...]}\n\nwhere each sheet is an object like the following:\n\n { \"name\" : , \"id\": , \"fields\": [ {\"name\": , \"type\": , \"length\": }, ]}", "category": "", "helpUrl": "https://gis.legis.iowa.gov/arcgis/rest/directories/arcgisoutput/System/PublishingTools_GPServer/System_PublishingTools/ExcelAnalyzeServer.htm", "executionType": "esriExecutionTypeAsynchronous", "parameters": [ { "name": "excelFile", "dataType": "GPString", "displayName": "Input Excel File", "description": "", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeRequired", "category": "" }, { "name": "validateWorkspace", "dataType": "GPString", "displayName": "Validation Workspace", "description": "", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "fieldTypeVersion", "dataType": "GPString", "displayName": "Field Type Version", "description": "", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "excelInfo", "dataType": "GPString", "displayName": "Excel Info", "description": "", "direction": "esriGPParameterDirectionOutput", "defaultValue": "", "parameterType": "esriGPParameterTypeDerived", "category": "" } ] }