Bring Web Data into Alteryx with the InterWorks Connector


Bring Web Data into Alteryx with the InterWorks Connector

by Michael Treadwell
// is the best tool for scraping structured data off the web. Alteryx is the best tool for self-service data analysis. It doesn’t take long to realize that we should put the two together. > Alteryx” src=”/wp-content/uploads/sites/default/files/blog-content/AlteryxImportioPatrick.jpg” /></p>
<p>Using the API, the InterWorks connector allows you to read structured data from the web and bring it directly into your Alteryx workflow.</p>
<p><strong>Note:</strong> If you want to achieve similar results with Tableau, my colleague <a href=Robert Rouse built a handy web connector of his own


To install the InterWorks macro, unzip the attached folder to the location on your computer where you want the macros to be permanently saved. I suggest: DocumentsMy Alteryx MacrosInterWorks Macros Then, run the installer wizard Install.yxwz and choose Install. Once you restart Alteryx, the macros will now be available on your toolbar just like any other tool:

Alteryx - InterWorks Macros

You will also need to set up a free account at Once you’ve signed up, the account page will show your API Key: API Key

Automatically Extract Web Data provides easy access to web data through their Magic API. On the homepage, enter any URL and the Magic API will attempt to extract structured data. As an example, try using the InterWorks People page Extraction Page will return a structured table of the InterWorks employee directory. To do the same thing in Alteryx, use the InterWorks connector, enter your API Key, select Magic API in the tool configuration and enter the URL. The tool will the return the JSON data extracted from the webpage right into your Alteryx module:

JSON dat in Alteryx Module

Using the Connector API in Alteryx

The Magic API works wonders, but sometimes it is unable to find exactly what you are looking for. In this case, you may need to train an extractor or connector. An extractor allows you to build a custom tool to scrape data from similarly structured web pages. A connector is an extractor with a macro attached. This will allow you to record actions such as using page searches before extracting data. Building a connector is easy; but for this example, we will use one that has already been created.

Robert Rouse, in another blog, has provided a connector that allows us to pull data from a formatted Wikipedia table:

Wikipedia colors

To use this connector in Alteryx, enter your API key, the connector ID and the input variable:

How to use the connector in Alteryx

Try It Out

We’re excited to bring together the simple data scraping capabilities with our favorite data analytics tools. InterWorks is always looking for feedback and ways that we can improve our tools to better help our clients. Create a connector, try out the macro and tell us what you think!

KeepWatch by InterWorks

Whether you need support for one platform or many, our technical experts have you covered.

More About the Author

Michael Treadwell

Data Lead
Introducing the Snowflake Data Cloud: Data Science When you think of data science (for the purposes of this blog, this will encompass all machine learning and AI activities), you may ...
The Migratory Patterns of the Common Alteryx Workflow Prior to Alteryx Server version 2018.4, migrating workflows was a three-step process: Deny the problem exists Procrastinate Acquiesce ...

See more from this author →

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK


Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Geschäftsführer: Mel Stephenson

Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072


Love our blog? You should see our emails. Sign up for our newsletter!