ArcGIS

ArcGIS connects your automated workflows to resources from your ArcGIS organization. Access geoenrichment, geocoding, and routing services to add demographics and location information to your data. You can also use ArcGIS to create feature layers and fetch data from existing feature layers in your ArcGIS organization.

This connector is available in the following products and regions:

Service	Class	Regions
Logic Apps	Standard	All Logic Apps regions except the following:      -   Azure China regions      -   US Department of Defense (DoD)
Power Automate	Premium	All Power Automate regions except the following:      -   US Government (GCC High)      -   China Cloud operated by 21Vianet      -   US Department of Defense (DoD)
Power Apps	Premium	All Power Apps regions except the following:      -   US Government (GCC High)      -   China Cloud operated by 21Vianet      -   US Department of Defense (DoD)

Contact
Name	Esri Power Automate Support
URL	https://community.esri.com/t5/arcgis-for-power-bi-questions/bd-p/arcgis-for-power-bi-questions
Email	powerautomate@esri.com

Connector Metadata
Publisher	Esri Inc.
Website	https://www.esri.com/powerbi/
Privacy policy	https://www.esri.com/en-us/privacy/privacy-statements/privacy-statement
Categories	IT Operations; Business Intelligence

The ArcGIS Connector helps you gain location intelligence by leveraging location based services available within your ArcGIS Online organization to enhance understanding, insight, and support data-driven decision-making. It provides the capabilities to geo-enrich your business data, spatially enable information from external data sources, and access location-based details from hosted feature services.

Prerequisites

• An ArcGIS account to an ArcGIS Online organization is required to use this connector.

How to get an ArcGIS account

If you don't have an ArcGIS Account, you can create an ArcGIS Account. Public accounts has limits on capabilities. To use most of the actions in this connector, you need an ArcGIS Organizational account.

If you don't have an ArcGIS Online organization, you can sign up for a trial organization first.

If your team / group / organization already has an ArcGIS Online subscription, contact your administrator or IT department to request to be added or invited to the ArcGIS Online organization.

Get started with ArcGIS connector

To use most of the actions, the role that the ArcGIS account belongs to needs certain privilege / permission:

Action	Privilege
Geoenrichment	Geoenrichment
Find address candidate	Geocoding
Geocode addresses	Geocoding
Point to point routing	Network Analysis
Get geometry from feature layer	-
Get data from feature layer	-
Create feature layer	Publish hosted feature layers

Limitations

1. Connections will time out after 90 days and must be refreshed manually by initiating a sign-in to ArcGIS.

2. When using the Geocode addresses or Create feature layer action, for large datasets the input to the action will need to be batched or chunked into multiple individual requests.

   Name	Limit
   Geocode addresses	150 rows per request
   Get data from Feature Layer	1000 rows per request without geometry
   Get data from Feature Layer	150 rows per request with geometry
   Geometry lookups	1 geometry per request
   Point to point routing	150 stops per request

Throttling Limits

Name	Calls	Renewal Period
API calls per connection	100	60 seconds

Actions

Add attachment	Add an attachment to record in a feature layer.
Create a record in a feature layer	This action adds a new record to a feature layer.
Create feature layer	Create a feature layer in ArcGIS using data from an existing source, such as a SharePoint list. A feature layer is a grouping of similar geographic features, for example, buildings, parcels, cities, roads, and earthquake epicenters. Features can be points, lines, or polygons (areas). Feature layers are most appropriate for visualizing data on top of a basemap.
Delete a record from feature layer	This action deletes one or many records from a feature layer using IDs.
Delete attachment	Delete an attachment from a record in your feature layer.
Fetch updates, changes, or deletions from feature layer	Fetch the updates, changes, or deletions that were made to your selected feature layer. This action is used in conjunction with the trigger on your feature service.
Find address candidate	Locate a single address using a geocode service resource. This resource provides information about candidates, including the address, location, and match score. The result of this operation is a list of address candidates.
Geocode addresses	Find multiple (batch) addresses, place-names, and businesses and then display that information on a map. This data can be added to an existing dataset or you can create a new one. This data can be used to create new maps in all ArcGIS for Microsoft 365 products.
Geoenrichment	Get facts about a location or area. Using the GeoEnrichment service, you can get information about the people, places, and businesses in a specific area or within a certain distance or drive time from a location.
Geoenrichment (deprecated) [DEPRECATED]	This action has been deprecated. Please use Geoenrichment instead. Get facts about a location or area. Using the GeoEnrichment service, you can get information about the people, places, and businesses in a specific area or within a certain distance or drive time from a location. (deprecated)
Get attachment	Get an attachment from a record in your feature layer.
Get attachment from URL	Get an attachment from a record in your feature layer by using the attachment URL.
Get data from feature layer	Connect to a feature layer in ArcGIS and pull its data and attributes into your existing dataset or create a new one. This data can be used to create new maps in all ArcGIS for Microsoft 365 products.
Get geometry from feature layer	Get geometry or boundary information from a feature layer and export it as Esri JSON or to a shape column in your dataset. This data can be used in all ArcGIS for Microsoft 365 products.
Point to point routing	Create point-to-point routes. Points in a route can visited in the order you specify or in the order that minimizes overall travel time or distance. Routes represent the quickest or shortest path along roads to visit stops or point locations.
Query attachment	Search for an attachment associated with a record in a feature layer.
Update a record in a feature layer	This action updates an existing record in a feature layer.

Add attachment

Operation ID:

AddAttachment

Add an attachment to record in a feature layer.

Parameters

Name	Key	Required	Type	Description
Layers in	contentFilter	True	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	True	string	Select a feature layer from your ArcGIS content
Record ID	objectId	True	number	Object ID of the record associated with the attachment
Attachment name	attachmentName	True	string	Name of the file that will be attached
File content	data	True	binary	File content from another action such as 'Get file content' (OneDrive, Share Point)
Keywords	keywords		string	Keywords used to identify the attachment

Returns

Name	Path	Type	Description
Object ID	objectId	number
Global ID	globalId	string
Success	success	boolean

Create a record in a feature layer

Operation ID:

CreateItemInFeatureLayer

This action adds a new record to a feature layer.

Parameters

Name	Key	Required	Type	Description
Layers in	contentFilter	True	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	True	string	Select a feature layer from your ArcGIS content
data	data	True	dynamic

Returns

Name	Path	Type	Description
Create operation success status	success	boolean	Create status
Object ID	objectId	number	Object ID of the record created
Global ID	globalId	string	Global ID of the record created

Create feature layer

Operation ID:

CreateFeatureLayer

Create a feature layer in ArcGIS using data from an existing source, such as a SharePoint list. A feature layer is a grouping of similar geographic features, for example, buildings, parcels, cities, roads, and earthquake epicenters. Features can be points, lines, or polygons (areas). Feature layers are most appropriate for visualizing data on top of a basemap.

Parameters

Name	Key	Required	Type	Description
Title	layerTitle	True	string	Title of the new feature layer
Location type	locationType		string	Type of location information in the columns
body	body	True	dynamic

Returns

Name	Path	Type	Description
Service item ID	serviceItemId	string	Service item ID
Service URL	serviceurl	string	Service URL
Service type	type	string	Service type created
Location type	locationType	string	Location type used to match location

Delete a record from feature layer

Operation ID:

DeleteItemInFeatureLayer

This action deletes one or many records from a feature layer using IDs.

Parameters

Name	Key	Required	Type	Description
Layers in	contentFilter	True	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	True	string	Select a feature layer from your ArcGIS content
Unique ID field	idField	True	string	Select an unique ID field in the feature layer
Delete records	deletedIds		string	A list or single value of IDs used to identify the deleted items. The IDs provided must match the IDs used in the feature layer. Multiple IDs can be added and separated by a comma.

Returns

Name	Path	Type	Description
		array of object
Delete status	success	boolean	Delete operation success status
Object ID	objectId	number	Object ID of the record deleted
Global ID	globalId	string	Global ID of the deleted record

Delete attachment

Operation ID:

DeleteAttachment

Delete an attachment from a record in your feature layer.

Parameters

Name	Key	Required	Type	Description
Layers in	contentFilter	True	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	True	string	Select a feature layer from your ArcGIS content
Record ID	objectid	True	number	Object ID of the record associated with the attachment.
Attachment ID	attachmentId	True	number	The ID of the attachment in a record from your feature layer.

Returns

Name	Path	Type	Description
		array of object
Object ID	objectId	number
Global ID	globalId	string
Success	success	boolean

Fetch updates, changes, or deletions from feature layer

Operation ID:

WebhookGet

Fetch the updates, changes, or deletions that were made to your selected feature layer. This action is used in conjunction with the trigger on your feature service.

Parameters

Name	Key	Required	Type	Description
Get changes from	changesUrl	True	string	Select the Changes URL option from the Dynamic content pane.
Feature layer	userLayer	True	string	Name of the feature layer that was changed, updated, or deleted.
Feature layer ID	layerId	True	number	Select the Feature layer ID option from the Dynamic content pane.

Returns

The outputs of this operation are dynamic.

Find address candidate

Operation ID:

FindAddressCandidates

Locate a single address using a geocode service resource. This resource provides information about candidates, including the address, location, and match score. The result of this operation is a list of address candidates.

Parameters

Name	Key	Required	Type	Description
Store results?	forStorage	True	boolean	Specifies whether the results of the operation will be persisted.
Address	address		string	Address
Region	region		string	Region
City	city		string	City
ZIP or postal code	postal		string	ZIP or postal code
Country	country		string	Select a country
Match type	locationType		string	Specifies whether to use rooftop or street entrance location for the geometry output
Spatial reference system	srs		string	Select spatial reference system

Returns

Name	Path	Type	Description
Full address	address	string	The locations of your data listed either as single line or multi-line results
Country code	countryCode	string	The country where the locations are based
City	city	string	The city where the locations are based
Longitude (X)	Geometry.x	number	Longitude (X)
Latitude (Y)	Geometry.y	number	Latitude (Y)

Geocode addresses

Operation ID:

GeocodeAddresses

Find multiple (batch) addresses, place-names, and businesses and then display that information on a map. This data can be added to an existing dataset or you can create a new one. This data can be used to create new maps in all ArcGIS for Microsoft 365 products.

Parameters

Name	Key	Required	Type	Description
Addresses	addresses	True	string	Array of addresses with well formed fields

Returns

Name	Path	Type	Description
Spatial reference ID	spatialReference.wkid	number	Well-known ID
locations	locations	array of object	Array of geocoded locations
Address	locations.address	string	Full address
Address ID	locations.attributes.ResultID	number	This value contains the ID of your geocoding request. Use this value for specifying the item to act on in other actions such as matching Ids in a list.
Longitude (X)	locations.location.x	number
Latitude (Y)	locations.location.y	number

Geoenrichment

Operation ID:

Geoenrich_V2

Get facts about a location or area. Using the GeoEnrichment service, you can get information about the people, places, and businesses in a specific area or within a certain distance or drive time from a location.

Parameters

Name	Key	Required	Type	Description
Country	country	True	string	Select a country to see available data collections
Data collection	datacollection	True	string	Select a data collection
Variable	parameter	True	string	Select a variable from the collection
Buffer type	buffertype	True	string	Type of buffer around the location
body	body	True	dynamic

Returns

Name	Path	Type	Description
Value of the variable	value	number	Geoenrichment variable value
Name of the variable	parameterName	string	The name of the variable that is being analyzed during the geoenrichment process.
Units	units	string	Parameter units

Geoenrichment (deprecated) [DEPRECATED]

Operation ID:

Geoenrich

This action has been deprecated. Please use Geoenrichment instead.

Get facts about a location or area. Using the GeoEnrichment service, you can get information about the people, places, and businesses in a specific area or within a certain distance or drive time from a location. (deprecated)

Parameters

Name	Key	Required	Type	Description
Study area	studyarea	True	string	Address or geometry
Country	country	True	string	Select a country to see available data collections
Data collection	datacollection	True	string	Select a data collection
Variable	parameter	True	string	Select a variable from the collection
Buffer type	areatype		string	Type of buffer around the location
query	query		dynamic
Spatial reference system	srs		string	Select spatial reference system

Returns

Name	Path	Type	Description
Value of the variable	value	number	Geoenrichment variable value
Name of the variable	parameterName	string	The name of the variable that is being analyzed during the geoenrichment process.
Units	units	string	Parameter units

Get attachment

Operation ID:

GetAttachment

Get an attachment from a record in your feature layer.

Parameters

Name	Key	Required	Type	Description
Layers in	contentFilter	True	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	True	string	Select a feature layer from your ArcGIS content
Object ID	objectid	True	number	Object ID of the record associated with the attachment
Attachment	attachmentId	True	number	Select attachment name or enter the attachment ID

Returns

The content of the attachment.

Attachment contents

binary

Get attachment from URL

Operation ID:

GetAttachmentFromUrl

Get an attachment from a record in your feature layer by using the attachment URL.

Parameters

Name	Key	Required	Type	Description
Attachment Url	attachmentUrl	True	string	The URL associated with the attachment in a record in your feature layer.

Returns

The content of the attachment.

Attachment contents

binary

Get data from feature layer

Operation ID:

GetFeatureLayerData

Connect to a feature layer in ArcGIS and pull its data and attributes into your existing dataset or create a new one. This data can be used to create new maps in all ArcGIS for Microsoft 365 products.

Parameters

Name	Key	Required	Type	Description
Layers in	contentFilter	True	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	True	string	Select a feature layer from your ArcGIS content
Available fields	field		string	Select an attribute from the ArcGIS feature layer
Comparison type	comparison		string	Search for values using a comparison operator such as "equal to" or "greater than"
Output format	format	True	string	Select return format type
Search parameter value	parameter		string	Enter a value to search
Starting count	offset		number	When batching, this value is the starting point of the query
Where	where		string	Input a WHERE clause to filter records in your search
Return geometry	returnGeometry		boolean	Return geometry

Returns

The outputs of this operation are dynamic.

Get geometry from feature layer

Operation ID:

GetFLBoundaries

Get geometry or boundary information from a feature layer and export it as Esri JSON or to a shape column in your dataset. This data can be used in all ArcGIS for Microsoft 365 products.

Parameters

Name	Key	Required	Type	Description
Country	searchterm	True	string	Select a country to see available data collections
Feature layer	layer	True	string	Select a feature layer
Field	field	True	string	Select a field
Search parameter	parameter	True	string	Enter the search parameter
Geometry output format	f		string	Geometry output format
Second Field	field2		string	Select a field
Second search parameter	parameter2		string	Enter the second search parameter

Returns

Name	Path	Type	Description
Geometry object	data	object	Geometry object as a JSON string

Point to point routing

Operation ID:

GetRoute

Create point-to-point routes. Points in a route can visited in the order you specify or in the order that minimizes overall travel time or distance. Routes represent the quickest or shortest path along roads to visit stops or point locations.

Parameters

Name	Key	Required	Type	Description
Routing stops	stops	True	string	Stops as Latitude (Y) and Longitude (X), features, or feature service
Travel mode	travelModeName		string	Choose the mode of transportation for the analysis
Find best route	findBestSequence		boolean	Specify whether the service should reorder stops to find the optimized route
Preserve first stop	preserveFirstStop		boolean	Indicate whether the service should keep the first stop fixed when reordering the stops
Return directions	returnDirections		boolean	Specify whether the service should generate driving directions for each route

Returns

Name	Path	Type	Description
Directions	Directions	array of object
Direction text	Directions.text	string
Name	Name	string	Name of the route
Distance in kilometers	Kilometers	number	Route distance in kilometers
Distance in miles	Miles	number	Route distance in miles
Travel time	TravelTime	number	Estimated travel time in minutes
Route geometry	Geometry	object	Geometry object of the route

Query attachment

Operation ID:

QueryAttachment

Search for an attachment associated with a record in a feature layer.

Parameters

Name	Key	Required	Type	Description
Layers in	contentFilter	True	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	True	string	Select a feature layer from your ArcGIS content
Record ID	objectId	True	number	Object ID of the record associated with the attachment
Keywords	keywords		string	Keywords used to identify the attachment

Returns

Name	Path	Type	Description
		array of object
Attachment Object ID	id	number
Attachment Global ID	globalId	string
Attachment name	name	string
Content-type	contentType	string
Attachment size	size	number
Keywords	keywords	string
Attachment URL	url	string

Update a record in a feature layer

Operation ID:

UpdateItemInFeatureLayer

This action updates an existing record in a feature layer.

Parameters

Name	Key	Required	Type	Description
Layers in	contentFilter	True	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	True	string	Select a feature layer from your ArcGIS content
Unique ID field	idField	True	string	Select an unique ID field in the feature layer
data	data	True	dynamic

Returns

Name	Path	Type	Description
Update operation success status	success	boolean	Update status
Object ID	objectId	number	Object ID of the record updated
Global ID	globalId	string	Global ID of the updated record

Triggers

When a record is created in a feature layer	This action triggers a flow when a record is created in your feature layer.
When a record is deleted from a feature layer	This action triggers a flow when a record is deleted in a feature layer.
When a record is updated in a feature layer	This action triggers a flow when a record is updated in a feature layer.
When an attachment is created	This action triggers a flow when an attachment is created in a record in your feature layer.
When an attachment is deleted	This action triggers a flow when an attachment is deleted in your feature layer.
When an attachment is updated	This action triggers a flow when an attachment is updated in your feature layer.

When a record is created in a feature layer

Operation ID:

WebhookFLCreated

This action triggers a flow when a record is created in your feature layer.

Parameters

Name	Key	Required	Type	Description
Feature layer	userLayer	True	string	Feature layers owned by the user that have changes tracking enabled.

Returns

Name	Path	Type	Description
		array of object
Feature layer ID	layerId	number	The unique layer ID for the feature layer.
Changes URL	changesUrl	string	The URL of the feature service where you are listening for changes.

When a record is deleted from a feature layer

Operation ID:

WebhookFLDeleted

This action triggers a flow when a record is deleted in a feature layer.

Parameters

Name	Key	Required	Type	Description
Feature layer	userLayer	True	string	Feature layers owned by the current user. Layers listed here have the "track changes" option enabled.

Returns

Name	Path	Type	Description
		array of object
Feature layer ID	layerId	number	The unique layer ID for the feature layer.
Changes URL	changesUrl	string	The URL of the feature service where you are listening for changes.

When a record is updated in a feature layer

Operation ID:

WebhookFLEdited

This action triggers a flow when a record is updated in a feature layer.

Parameters

Name	Key	Required	Type	Description
Feature layer	userLayer	True	string	Feature layers owned by the current user. Layers listed here have the "track changes" option enabled.

Returns

Name	Path	Type	Description
		array of object
Feature layer ID	layerId	number	The unique layer ID for the feature layer.
Changes URL	changesUrl	string	The URL of the feature service where you are listening for changes.

When an attachment is created

Operation ID:

WebhookAttachmentCreated

This action triggers a flow when an attachment is created in a record in your feature layer.

Parameters

Name	Key	Required	Type	Description
Feature layer	userLayer	True	string	Feature layers owned by the user that have changes tracking enabled.

Returns

Name	Path	Type	Description
		array of object
Feature layer ID	layerId	number	The unique layer ID for the feature layer.
Changes URL	changesUrl	string	The URL of the feature service where you are listening for changes.

When an attachment is deleted

Operation ID:

WebhookAttachmentDeleted

This action triggers a flow when an attachment is deleted in your feature layer.

Parameters

Name	Key	Required	Type	Description
Feature layer	userLayer	True	string	Feature layers owned by the user that have changes tracking enabled.

Returns

Name	Path	Type	Description
		array of object
Feature layer ID	layerId	number	The unique layer ID for the feature layer.
Changes URL	changesUrl	string	The URL of the feature service where you are listening for changes.

When an attachment is updated

Operation ID:

WebhookAttachmentUpdated

This action triggers a flow when an attachment is updated in your feature layer.

Parameters

Name	Key	Required	Type	Description
Feature layer	userLayer	True	string	Feature layers owned by the user that have changes tracking enabled.

Returns

Name	Path	Type	Description
		array of object
Feature layer ID	layerId	number	The unique layer ID for the feature layer.
Changes URL	changesUrl	string	The URL of the feature service where you are listening for changes.

Definitions

binary

This is the basic data type 'binary'.