ArcGIS esri JSON to Alteryx SpatialObj conversion

Hello,

I'm trying to see if there is a way in Alteryx to convert a ArcGIS ESRI JSON REST API response to an Alteryx SpatialObj data type so we can see the shape like points or polygons. I'm able to download the response however not sure how to parse this and convert the geometries into polygons. Attached a workflow with sample JSON response that I'm trying to convert to a spatial object within Alteryx. Or is the only way to use GDAL/org2ogr tools with Run Command tool to pass the response to a GeoJSON and then parse it? Any insights are appreciated.

Thank you in advance!

-VS

sample_arcJSON.yxmd

Output

Parse

Connectors

Spatial Analysis

Accepted answers

TravisR

This should fix it to handle multiple shapes.

sample_arcJSON_final.yxmd

All comments

TravisR

As you're probably aware, under the hood an Alteryx 'SpatialObject' is just GeoJson.

Esri supports GeoJson format for their API - https://doc.arcgis.com/en/arcgis-online/reference/geojson.htm

I would just change your API call to receive the data in geojson and then go from there. You may need to do a small amount of pruning/parsing the GeoJson response from their API but after that it's just a matter of using a select tool to change the data type from a string to SpatialObject.

VidyaS

Thank you Travis. Yes, that was my first thought to change the output format to geojson, however, in the current implementation of this REST API call that output method is not supported unfortunately and I'm only able to get Esri JSON response. My apologies, I should have mentioned this before.

Quick Links

This months top contributors

FláviaB 262

JORGE4900 235

caltang 177

DanM 167

IraWatt 157