Geocode using ArcGIS Geocoding service in SQL

Question

I would like to geocode addresses in a SQL table using a ArcGIS geocoding service.  The service is located here: http://gis.hennepin.us/arcgis/rest/services/Locators/HC_COMPOSITE/GeocodeServer

I found a great example of what I am trying to do here:

https://alastaira.wordpress.com/2012/05/04/geocoding-in-sql-server-with-the-bing-maps-locations-api/

but this example is using Bing maps and XML.  I would like to use ArcGIS service and JSON.  Any help would be greatly appreciated.  Thanks

ChrisSmith7 · Answer

You should really have a look at PowerShell (Microsoft PowerShell) - you can interface with the geocoding API through PowerShell, and then call a SQL stored proc to update your records with the geocoded values.