Get data from feature layer

With this action, you can connect to a feature layer in ArcGIS and query its data and attributes to use in subsequent actions. You can use the output data to update existing features layers, create new ones, or create maps in other ArcGIS for Microsoft products. You can also use the advanced parameters of this action to perform proximity searches or output summary statistics. For more information, see the Esri Developer documentation about querying data in a feature layer and calculating out statistics.

Available connectors

The following connectors are available:

• ArcGIS Online (ArcGIS)
• ArcGIS Enterprise
• ArcGIS PaaS

Parameters

The parameters are described in the following table:

Name	Key	Required	Type	Description
Layers in	contentFilter	Yes	string	When you sign in using your ArcGIS account, you can search for content in your organization, your organization's groups, or public content.
Feature layer	userLayer	Yes	string	Select a feature layer from your ArcGIS content.
Output format	format	Yes	string	Select a return format type.
Show statistics	useStatistics	No	boolean	Select to show statistics fields. Use with the Group by fields for statistics and Output statistics parameters.

Additional parameters: Feature layer

The following parameters appear when a layer is provided in the Feature layer parameter:

Name	Key	Type	Description
Query by field	data/field	string	Select a field to query. Use this parameter with the Comparison type and Search value parameters to search records.
Comparison type	data/comparison	string	Select the comparison type. Use this parameter with the Query by field and Search value parameters to search records.
Search value	data/value	string	Enter a value to search. Use this parameter with the Query by field and Comparison type parameters to search records.
Where	where	string	Filter the records using SQL syntax. Use AND or OR operators to refine the results.
Esri Geometry	geometry	string	Use a JSON geometry object as a spatial filter. The structure of the geometry is the same as returned by other ArcGIS actions or ArcGIS REST API.
Spatial relationship	spatialRel	string	Enter spatial relationship applied while performing the query with the geometry.
Buffer distance	distance	number	Enter the buffer distance for the geometry. Only use this parameter if the geometry is specified.
Buffer units	units	string	Select the units for calculating the buffer distance. Only use this parameter if the geometry is specified.
Input spatial reference	inSR	string	The spatial reference of the input geometry. The spatial reference can be specified as either a well-known ID or as a spatial reference JSON object. If the input spatial reference is not specified, the geometry is assumed to be in the spatial reference of the layer.
Output fields	outFields	array of string	Enter the list of fields to be included in the returned result set.
Order by fields	orderByFields	array of string	Enter one or more field names on which the features will be ordered. Use ASC or DESC operators to order the features in ascending or descending order, respectively.
Return geometry	reutrnGeometry	boolean	Return geometry along with the attributes.
Output spatial reference	outSR	string	The spatial reference can be specified as either a well-known ID or as a spatial reference JSON object.
Result offset	resultOffset	number	Query the results by skipping a specified number of records and starting from the next record.
Result record count	resultRecordCount	number	Enter the maximum number of records to return. The default is 150.

Additional parameters: Statistics

The following parameters appear when Yes is specified for the Show statistics parameter:

Name	Key	Type	Description
Group by fields for statistics	groupByFieldsForStatistics	string	One or more field names on which the values will be grouped for calculating the statistics.
Output statistics	outStatistics	string	The definitions for one or more field-based statistics to be calculated.