RecordSet

Summary

RecordSet objects are a lightweight representation of a table. They are a special data element that contains not only schema but also the data. The RecordSet object is also how tables are sent and received from the server.

Discussion

Note:

If loading a table into a new RecordSet and modifying the RecordSet with a geoprocessing tool that modifies the input like Calculate Field or an arcpy function like UpdateCursor, the original table will also be modified.

Syntax

 RecordSet  ({table})

Parameter	Explanation	Data Type
table	Table to be loaded into the RecordSet object.	String

Properties

Property	Explanation	Data Type
JSON (Read Only)	Returns an Esri JSON representation of the geometry as a string. Tip: The returned string can be converted to a dictionary using the Python json.loads function.	String

Method Overview

Method	Explanation
load (table_path)	Import from a table.
save (table_path)	Export to a table.

Methods

load (table_path)

Parameter	Explanation	Data Type
table_path	The table to be imported.	String

save (table_path)

Parameter	Explanation	Data Type
table_path	The output table to be created.	String

Code sample

RecordSet example

Import a server toolbox; get the recordset from the server tool's specified parameter.

import arcpy

# Add a custom server toolbox
arcpy.ImportToolbox("http://myserver/arcgis/services;Geocode")

# Get recordset from server tool's first parameter to use as schema
in_recordset = arcpy.GetParameterValue("GeocodeAddress", 0)