RecordSet (arcpy)

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 feature class 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 a JSON representation of the geometry as a string. Tip: The returned string can be converted to a dictionary using Python's 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)