ArcGIS - Connectors - Microsoft Docs

Access geoenrichment, geocoding, and routing services to add demographics and location information to your data. You can also use ArcGIS to create feature ... Skiptomaincontent Thisbrowserisnolongersupported. UpgradetoMicrosoftEdgetotakeadvantageofthelatestfeatures,securityupdates,andtechnicalsupport. DownloadMicrosoftEdge Moreinfo Tableofcontents Exitfocusmode ReadinEnglish Save Tableofcontents ReadinEnglish Save Edit Twitter LinkedIn Facebook Email Tableofcontents ArcGIS Reference ArcGISconnectsyourautomatedworkflowstoresourcesfromyourArcGISorganization.Accessgeoenrichment,geocoding,androutingservicestoadddemographicsandlocationinformationtoyourdata.YoucanalsouseArcGIStocreatefeaturelayersandfetchdatafromexistingfeaturelayersinyourArcGISorganization. Inthisarticle Thisconnectorisavailableinthefollowingproductsandregions: Service Class Regions LogicApps Standard AllLogicAppsregionsexceptthefollowing:    - AzureChinaregions    - USDepartmentofDefense(DoD) PowerAutomate Premium AllPowerAutomateregionsexceptthefollowing:    - USGovernment(GCCHigh)    - ChinaCloudoperatedby21Vianet    - USDepartmentofDefense(DoD) PowerApps Premium AllPowerAppsregionsexceptthefollowing:    - USGovernment(GCCHigh)    - ChinaCloudoperatedby21Vianet    - USDepartmentofDefense(DoD) Contact Name EsriPowerAutomateSupport URL https://community.esri.com/t5/arcgis-for-power-bi-questions/bd-p/arcgis-for-power-bi-questions Email [email protected] ConnectorMetadata Publisher EsriInc. Website https://www.esri.com/powerbi/ Privacypolicy https://www.esri.com/en-us/privacy/privacy-statements/privacy-statement Categories ITOperations;BusinessIntelligence TheArcGISConnectorhelpsyougainlocationintelligencebyleveraginglocationbasedservicesavailablewithinyourArcGISOnlineorganizationtoenhanceunderstanding,insight,andsupportdata-drivendecision-making.Itprovidesthecapabilitiestogeo-enrichyourbusinessdata,spatiallyenableinformationfromexternaldatasources,andaccesslocation-baseddetailsfromhostedfeatureservices. Prerequisites AnArcGISaccounttoanArcGISOnlineorganizationisrequiredtousethisconnector. HowtogetanArcGISaccount Ifyoudon'thaveanArcGISAccount,youcancreateanArcGISAccount.Publicaccountshaslimitsoncapabilities.Tousemostoftheactionsinthisconnector,youneedanArcGISOrganizationalaccount. Ifyoudon'thaveanArcGISOnlineorganization,youcansignupforatrialorganizationfirst. Ifyourteam/group/organizationalreadyhasanArcGISOnlinesubscription,contactyouradministratororITdepartmenttorequesttobeaddedorinvitedtotheArcGISOnlineorganization. GetstartedwithArcGISconnector Tousemostoftheactions,therolethattheArcGISaccountbelongstoneedscertainprivilege/permission: Action Privilege Geoenrichment Geoenrichment Findaddresscandidate Geocoding Geocodeaddresses Geocoding Pointtopointrouting NetworkAnalysis Getgeometryfromfeaturelayer - Getdatafromfeaturelayer - Createfeaturelayer Publishhostedfeaturelayers Limitations Connectionswilltimeoutafter14daysandmustberefreshedmanuallybyinitiatingasign-intoArcGIS. WhenusingtheGeocodeaddressesorCreatefeaturelayeraction,forlargedatasetstheinputtotheactionwillneedtobebatchedorchunkedintomultipleindividualrequests. Name Limit Geocodeaddresses 150rowsperrequest GetdatafromFeatureLayer 1000rowsperrequestwithoutgeometry GetdatafromFeatureLayer 150rowsperrequestwithgeometry Geometrylookups 1geometryperrequest Pointtopointrouting 150stopsperrequest ThrottlingLimits Name Calls RenewalPeriod APIcallsperconnection10060seconds Actions Createarecordinafeaturelayer Thisactionaddsanewrecordtoafeaturelayer. Createfeaturelayer CreateafeaturelayerinArcGISusingdatafromanexistingsource,suchasaSharePointlist.Afeaturelayerisagroupingofsimilargeographicfeatures,forexample,buildings,parcels,cities,roads,andearthquakeepicenters.Featurescanbepoints,lines,orpolygons(areas).Featurelayersaremostappropriateforvisualizingdataontopofabasemap. Deletearecordfromfeaturelayer ThisactiondeletesoneormanyrecordsfromafeaturelayerusingIDs. Fetchupdates,changes,ordeletionsfromfeaturelayer Fetchtheupdates,changes,ordeletionsthatweremadetoyourselectedfeaturelayer.Thisactionisusedinconjunctionwiththetriggeronyourfeatureservice. Findaddresscandidate Locateasingleaddressusingageocodeserviceresource.Thisresourceprovidesinformationaboutcandidates,includingtheaddress,location,andmatchscore.Theresultofthisoperationisalistofaddresscandidates. Geocodeaddresses Findmultiple(batch)addresses,place-names,andbusinessesandthendisplaythatinformationonamap.Thisdatacanbeaddedtoanexistingdatasetoryoucancreateanewone.ThisdatacanbeusedtocreatenewmapsinallArcGISforMicrosoft365products. Geoenrichment Getfactsaboutalocationorarea.UsingtheGeoEnrichmentservice,youcangetinformationaboutthepeople,places,andbusinessesinaspecificareaorwithinacertaindistanceordrivetimefromalocation. Getdatafromfeaturelayer ConnecttoafeaturelayerinArcGISandpullitsdataandattributesintoyourexistingdatasetorcreateanewone.ThisdatacanbeusedtocreatenewmapsinallArcGISforMicrosoft365products. Getgeometryfromfeaturelayer GetgeometryorboundaryinformationfromafeaturelayerandexportitasEsriJSONortoashapecolumninyourdataset.ThisdatacanbeusedinallArcGISforMicrosoft365products. Pointtopointrouting Createpoint-to-pointroutes.Pointsinaroutecanvisitedintheorderyouspecifyorintheorderthatminimizesoveralltraveltimeordistance.Routesrepresentthequickestorshortestpathalongroadstovisitstopsorpointlocations. Updatearecordinafeaturelayer Thisactionupdatesanexistingrecordinafeaturelayer. Createarecordinafeaturelayer OperationID: CreateItemInFeatureLayer Thisactionaddsanewrecordtoafeaturelayer. Parameters Name Key Required Type Description Layersin contentFilter True string WhenyousigninusingyourArcGISaccount,youcansearchforcontentinyourorganization,yourorganization'sgroups,orpubliccontent. Featurelayer userLayer True string SelectafeaturelayerfromyourArcGIScontent data data True dynamic Returns Name Path Type Description Createoperationsuccessstatus success boolean Createstatus ObjectID objectId number ObjectIDoftherecordcreated GlobalID globalId string GlobalIDoftherecordcreated Createfeaturelayer OperationID: CreateFeatureLayer CreateafeaturelayerinArcGISusingdatafromanexistingsource,suchasaSharePointlist.Afeaturelayerisagroupingofsimilargeographicfeatures,forexample,buildings,parcels,cities,roads,andearthquakeepicenters.Featurescanbepoints,lines,orpolygons(areas).Featurelayersaremostappropriateforvisualizingdataontopofabasemap. Parameters Name Key Required Type Description Title layerTitle True string Titleofthenewfeaturelayer Locationtype locationType string Typeoflocationinformationinthecolumns body body True dynamic Returns Name Path Type Description ServiceitemID serviceItemId string ServiceitemID ServiceURL serviceurl string ServiceURL Servicetype type string Servicetypecreated Locationtype locationType string Locationtypeusedtomatchlocation Deletearecordfromfeaturelayer OperationID: DeleteItemInFeatureLayer ThisactiondeletesoneormanyrecordsfromafeaturelayerusingIDs. Parameters Name Key Required Type Description Layersin contentFilter True string WhenyousigninusingyourArcGISaccount,youcansearchforcontentinyourorganization,yourorganization'sgroups,orpubliccontent. Featurelayer userLayer True string SelectafeaturelayerfromyourArcGIScontent UniqueIDfield idField True string SelectauniqueIDfieldinthefeaturelayer Deleterecords deletedIds string AlistorsinglevalueofIDsusedtoidentifythedeleteditems.TheIDsprovidedmustmatchtheIDsusedinthefeaturelayer.MultipleIDscanbeaddedandseparatedbyacomma. Returns Name Path Type Description arrayofobject Deletestatus success boolean Deleteoperationsuccessstatus ObjectID objectId number ObjectIDoftherecorddeleted GlobalID globalId string GlobalIDofthedeletedrecord Fetchupdates,changes,ordeletionsfromfeaturelayer OperationID: WebhookGet Fetchtheupdates,changes,ordeletionsthatweremadetoyourselectedfeaturelayer.Thisactionisusedinconjunctionwiththetriggeronyourfeatureservice. Parameters Name Key Required Type Description Getchangesfrom changesUrl True string SelecttheChangesURLoptionfromtheDynamiccontentpane. Featurelayer userLayer True string Nameofthefeaturelayerthatwaschanged,updated,ordeleted. FeaturelayerID layerId True number SelecttheFeaturelayerIDoptionfromtheDynamiccontentpane. Returns Theoutputsofthisoperationaredynamic. Findaddresscandidate OperationID: FindAddressCandidates Locateasingleaddressusingageocodeserviceresource.Thisresourceprovidesinformationaboutcandidates,includingtheaddress,location,andmatchscore.Theresultofthisoperationisalistofaddresscandidates. Parameters Name Key Required Type Description Storeresults? forStorage True boolean Specifieswhethertheresultsoftheoperationwillbepersisted. Address address string Address Region region string Region City city string City ZIPorpostalcode postal string ZIPorpostalcode Country country string Selectacountry Matchtype locationType string Specifieswhethertouserooftoporstreetentrancelocationforthegeometryoutput Spatialreferencesystem srs string Selectspatialreferencesystem Returns Name Path Type Description Fulladdress address string Thelocationsofyourdatalistedeitherassinglelineormulti-lineresults Countrycode countryCode string Thecountrywherethelocationsarebased City city string Thecitywherethelocationsarebased Longitude(X) Geometry.x number Longitude(X) Latitude(Y) Geometry.y number Latitude(Y) Geocodeaddresses OperationID: GeocodeAddresses Findmultiple(batch)addresses,place-names,andbusinessesandthendisplaythatinformationonamap.Thisdatacanbeaddedtoanexistingdatasetoryoucancreateanewone.ThisdatacanbeusedtocreatenewmapsinallArcGISforMicrosoft365products. Parameters Name Key Required Type Description Addresses addresses True string Arrayofaddresseswithwellformedfields Returns Name Path Type Description SpatialreferenceID spatialReference.wkid number Well-knownID locations locations arrayofobject Arrayofgeocodedlocations Address locations.address string Fulladdress AddressID locations.attributes.ResultID number ThisvaluecontainstheIDofyourgeocodingrequest.UsethisvalueforspecifyingtheitemtoactoninotheractionssuchasmatchingIdsinalist. Longitude(X) locations.location.x number Latitude(Y) locations.location.y number Geoenrichment OperationID: Geoenrich Getfactsaboutalocationorarea.UsingtheGeoEnrichmentservice,youcangetinformationaboutthepeople,places,andbusinessesinaspecificareaorwithinacertaindistanceordrivetimefromalocation. Parameters Name Key Required Type Description Studyarea studyarea True string Addressorgeometry Country country True string Selectacountrytoseeavailabledatacollections Datacollection datacollection True string Selectadatacollection Variable parameter True string Selectavariablefromthecollection Buffertype areatype string Typeofbufferaroundthelocation query query dynamic Spatialreferencesystem srs string Selectspatialreferencesystem Returns Name Path Type Description Valueofthevariable value number Geoenrichmentvariablevalue Nameofthevariable parameterName string Thenameofthevariablethatisbeinganalyzedduringthegeoenrichmentprocess. Units units string Parameterunits Getdatafromfeaturelayer OperationID: GetFeatureLayerData ConnecttoafeaturelayerinArcGISandpullitsdataandattributesintoyourexistingdatasetorcreateanewone.ThisdatacanbeusedtocreatenewmapsinallArcGISforMicrosoft365products. Parameters Name Key Required Type Description Layersin contentFilter True string WhenyousigninusingyourArcGISaccount,youcansearchforcontentinyourorganization,yourorganization'sgroups,orpubliccontent. Featurelayer userLayer True string SelectafeaturelayerfromyourArcGIScontent Availablefields field string SelectanattributefromtheArcGISfeaturelayer Comparisontype comparison string Searchforvaluesusingacomparisonoperatorsuchas"equalto"or"greaterthan" Outputformat format True string Selectreturnformattype Searchparametervalue parameter string Enteravaluetosearch Startingcount offset number Whenbatching,thisvalueisthestartingpointofthequery Where where string InputaWHEREclausetofilterrecordsinyoursearch Returngeometry returnGeometry boolean Returngeometry Returns Theoutputsofthisoperationaredynamic. Getgeometryfromfeaturelayer OperationID: GetFLBoundaries GetgeometryorboundaryinformationfromafeaturelayerandexportitasEsriJSONortoashapecolumninyourdataset.ThisdatacanbeusedinallArcGISforMicrosoft365products. Parameters Name Key Required Type Description Country searchterm True string Selectacountrytoseeavailabledatacollections Featurelayer layer True string Selectafeaturelayer Field field True string Selectafield Searchparameter parameter True string Enterthesearchparameter Geometryoutputformat f string Geometryoutputformat SecondField field2 string Selectafield Secondsearchparameter parameter2 string Enterthesecondsearchparameter Returns Name Path Type Description Geometryobject data object GeometryobjectasaJSONstring Pointtopointrouting OperationID: GetRoute Createpoint-to-pointroutes.Pointsinaroutecanvisitedintheorderyouspecifyorintheorderthatminimizesoveralltraveltimeordistance.Routesrepresentthequickestorshortestpathalongroadstovisitstopsorpointlocations. Parameters Name Key Required Type Description Routingstops stops True string StopsasLatitude(Y)andLongitude(X),features,orfeatureservice Travelmode travelModeName string Choosethemodeoftransportationfortheanalysis Findbestroute findBestSequence boolean Specifywhethertheserviceshouldreorderstopstofindtheoptimizedroute Preservefirststop preserveFirstStop boolean Indicatewhethertheserviceshouldkeepthefirststopfixedwhenreorderingthestops Returndirections returnDirections boolean Specifywhethertheserviceshouldgeneratedrivingdirectionsforeachroute Returns Name Path Type Description Directions Directions arrayofobject Directiontext Directions.text string Name Name string Nameoftheroute Distanceinkilometers Kilometers number Routedistanceinkilometers Distanceinmiles Miles number Routedistanceinmiles Traveltime TravelTime number Estimatedtraveltimeinminutes Routegeometry Geometry object Geometryobjectoftheroute Updatearecordinafeaturelayer OperationID: UpdateItemInFeatureLayer Thisactionupdatesanexistingrecordinafeaturelayer. Parameters Name Key Required Type Description Layersin contentFilter True string WhenyousigninusingyourArcGISaccount,youcansearchforcontentinyourorganization,yourorganization'sgroups,orpubliccontent. Featurelayer userLayer True string SelectafeaturelayerfromyourArcGIScontent UniqueIDfield idField True string SelectauniqueIDfieldinthefeaturelayer data data True dynamic Returns Name Path Type Description Updateoperationsuccessstatus success boolean Updatestatus ObjectID objectId number ObjectIDoftherecordupdated GlobalID globalId string GlobalIDoftheupdatedrecord Triggers Whenarecordiscreatedinafeaturelayer Thisactiontriggersaflowwhenarecordiscreatedinyourfeaturelayer. Whenarecordisdeletedfromafeaturelayer Thisactiontriggersaflowwhenarecordisdeletedinafeaturelayer. Whenarecordisupdatedinafeaturelayer Thisactiontriggersaflowwhenarecordisupdatedinafeaturelayer. Whenarecordiscreatedinafeaturelayer OperationID: WebhookFLCreated Thisactiontriggersaflowwhenarecordiscreatedinyourfeaturelayer. Parameters Name Key Required Type Description Featurelayer userLayer True string Featurelayersownedbytheuserthathavechangestrackingenabled. Returns Name Path Type Description arrayofobject FeaturelayerID layerId number TheuniquelayerIDforthefeaturelayer. ChangesURL changesUrl string TheURLofthefeatureservicewhereyouarelisteningforchanges. Whenarecordisdeletedfromafeaturelayer OperationID: WebhookFLDeleted Thisactiontriggersaflowwhenarecordisdeletedinafeaturelayer. Parameters Name Key Required Type Description Featurelayer userLayer True string Featurelayersownedbythecurrentuser.Layerslistedherehavethe"trackchanges"optionenabled. Returns Name Path Type Description arrayofobject FeaturelayerID layerId number TheuniquelayerIDforthefeaturelayer. ChangesURL changesUrl string TheURLofthefeatureservicewhereyouarelisteningforchanges. Whenarecordisupdatedinafeaturelayer OperationID: WebhookFLEdited Thisactiontriggersaflowwhenarecordisupdatedinafeaturelayer. Parameters Name Key Required Type Description Featurelayer userLayer True string Featurelayersownedbythecurrentuser.Layerslistedherehavethe"trackchanges"optionenabled. Returns Name Path Type Description arrayofobject FeaturelayerID layerId number TheuniquelayerIDforthefeaturelayer. ChangesURL changesUrl string TheURLofthefeatureservicewhereyouarelisteningforchanges. Inthisarticle