ArcGIS Rest API connection

[bman213]

Hi everybody,

I am new to the API world within Alteryx, and I was wondering if anybody could outline how exactly you would go about pulling data from an ArcGIS rest API url and display this data within Alteryx so that I can further edit it?

Any help would be greatly appreciated!

[markcurry]

Hi @bman213 I've attached a workflow I've used that downloads Irish Covid stats, you'll see the different parameters used in the Query in the Download tool in the 'Payload' tab. 

I hope that helps you,

Mark

[BrandonB]

Here is the services directory which is from the API documentation on the ArcGIS webpage: https://developers.arcgis.com/rest/services-reference/get-started-with-the-services-directory.htm 

I haven't personally connected to ArcGIS yet, but it looks like you first need to generate a token from this endpoint: https://developers.arcgis.com/rest/services-reference/generate-token.htm 

Essentially this is passing a username and password with a few other parameters into a download tool that is doing a POST request to https://<host>:<port>/<site>/tokens/generateToken (your information in here of course) and returning back a token. Normally you would then pass this token as a header into another download tool along with a new URL of the resource that you are trying to pull from. 

[BrandonB]

Thanks for sharing @markcurry. I am thinking that the token must only be required for private resources then because I don't see one leveraged in your example. 

[markcurry]

@BrandonB My workflow was based on a post I found in the community, and I looked for that post but couldn't find it.  If I find it I'll include it.  Thanks for you links, they could come in handy.

[Hollingsworth]

At the 2021 Inspire this year, I demonstrated a macro that I wrote to consume ESRI REST endpoints.

The post where I mention them is here. Please scroll down in the post to find where I post two correction macros that you will need.

Good luck!