ArcGIS REST Services Directory
Login
|
Get Token
Home
>
services
>
Test
>
HMOToExcel (GPServer)
>
Table To Excel
>
submitJob
Help
|
API Reference
Submit Job (Table To Excel)
Input Table:
(
GPFeatureRecordSetLayer
)
{ "displayFieldName": "", "geometryType": "esriGeometryPoint", "spatialReference": { "wkid": 27700, "latestWkid": 27700 }, "fields": [ { "name": "OBJECTID_1", "type": "esriFieldTypeOID", "alias": "OBJECTID_1" }, { "name": "CORPUPRN", "type": "esriFieldTypeString", "alias": "CORPUPRN", "length": 18 }, { "name": "PKEY", "type": "esriFieldTypeString", "alias": "PKEY", "length": 12 }, { "name": "FULLADDR", "type": "esriFieldTypeString", "alias": "FULLADDR", "length": 255 }, { "name": "CSTDATE", "type": "esriFieldTypeDate", "alias": "CSTDATE", "length": 8 }, { "name": "CENDATE", "type": "esriFieldTypeDate", "alias": "CENDATE", "length": 8 }, { "name": "TYPE_", "type": "esriFieldTypeString", "alias": "TYPE", "length": 4 }, { "name": "STATSIZE", "type": "esriFieldTypeString", "alias": "STATSIZE", "length": 4 }, { "name": "STRUCTUREDESC", "type": "esriFieldTypeString", "alias": "STRUCTUREDESC", "length": 30 }, { "name": "AGEBANDDESC", "type": "esriFieldTypeString", "alias": "AGEBANDDESC", "length": 30 }, { "name": "MXNOHOUSEHOLDS", "type": "esriFieldTypeSmallInteger", "alias": "MXNOHOUSEHOLDS" }, { "name": "MXNOPERSONS", "type": "esriFieldTypeSmallInteger", "alias": "MXNOPERSONS" }, { "name": "NOROOMSSLEEP", "type": "esriFieldTypeSmallInteger", "alias": "NOROOMSSLEEP" }, { "name": "NOSELFCONTUNITS", "type": "esriFieldTypeSmallInteger", "alias": "NOSELFCONTUNITS" }, { "name": "NONONSELFCONTUNITS", "type": "esriFieldTypeSmallInteger", "alias": "NONONSELFCONTUNITS" }, { "name": "NOROOMSLIVING", "type": "esriFieldTypeSmallInteger", "alias": "NOROOMSLIVING" }, { "name": "NOSHBATHSHOWER", "type": "esriFieldTypeSmallInteger", "alias": "NOSHBATHSHOWER" }, { "name": "NOSHTOILETWHB", "type": "esriFieldTypeSmallInteger", "alias": "NOSHTOILETWHB" }, { "name": "NOSHKITCHENS", "type": "esriFieldTypeSmallInteger", "alias": "NOSHKITCHENS" }, { "name": "NOSHSINKS", "type": "esriFieldTypeSmallInteger", "alias": "NOSHSINKS" }, { "name": "LICENCEHOLDER", "type": "esriFieldTypeString", "alias": "LICENCEHOLDER", "length": 104 }, { "name": "LICENCEHOLDER_ADDRESS", "type": "esriFieldTypeString", "alias": "LICENCEHOLDER_ADDRESS", "length": 255 }, { "name": "HMO_MANAGER", "type": "esriFieldTypeString", "alias": "HMO_MANAGER", "length": 104 }, { "name": "HMO_MANAGER_ADDRESS", "type": "esriFieldTypeString", "alias": "HMO_MANAGER_ADDRESS", "length": 255 }, { "name": "REMARK", "type": "esriFieldTypeString", "alias": "REMARK", "length": 30 }, { "name": "CONDITIONS", "type": "esriFieldTypeString", "alias": "CONDITIONS", "length": 7 }, { "name": "LICENCEDURATION", "type": "esriFieldTypeSmallInteger", "alias": "LICENCEDURATION" } ], "features": [], "exceededTransferLimit": false }
Use field alias as column header:
(
GPBoolean
)
false
Use domain and subtype description:
(
GPBoolean
)
false
Options:
Output Spatial Reference:
Process Spatial Reference:
ReturnZ:
True
False
ReturnM:
True
False
Format:
HTML
JSON
KMZ