Searching and retrieving information from a website

jleon14

Hello everyone,

I need your help because I want to do something that I dont know if it can be done with Alteryx. I want to be able to search and retrieve specific information from a website to go into my workflow. I have a list of various address and I want to retrieve their coordinates. And i wanted to know if through Alteryx there is any tool that I can use so that I enter into the workflow all of these addresses and it inputs these addresses into a website that gives coordinates and outputs the results (which would be the coordinates) into the workflow. 

I feel that this can be done, but through all of the videos, tutorials and experimenting that I have done, I cannot seem to figure it out. 

If anyone has done something similar before or thinks they know if this can be done, I would greatly appreciate your help!!

Thank you!!!

jrgo

Hi @jleon14,

This is primarily going to be dependent to the website you're utilizing and if they offer an API that Alteryx can submit a query to and have it return a result. Below is an example of an approach that uses Google Maps to send an address and parse out the returned HTML to get my coordinates. This is to serve mainly as an example and I don't recommend using this to process large amounts of addresses without reviewing Googles TOS to ensure you don't violate any of their usage agreements.

 

Alternatively, if you subscribe to Alteryx spatial data add-on, it does include an address parser that'll return you coordinates and also the CASS (postal service) standardized address.

Hope this helps!

Jimmy

jleon14.yxmd