Connect to any REST API from Alteryx without writing any code

Introduction

Alteryx is a self-service data analytics platform that can help you to prepare/clean, blend, enrich and analyze data at scale. For a data analytics platform like Alteryx, the first step in your workflow is getting the data from different data sources. With the API economy at an all-time high, one can find themselves having their data accessible only via REST API. Unfortunately, connecting to REST API can be a bit tricky, requiring you to invest time and coding to connect to it. With Progress DataDirect Autonomous REST Connector for ODBC, you will be able to connect to any REST API from Alteryx without writing code. Point the Autonomous REST Connector towards the endpoint, set your Authentication and you will be able to access the data in the REST API by running SQL queries from Alteryx. 

In this tutorial, we will walk you through on how you can connect to a REST API from Alteryx, to be specific AlphaVantage API, which provides you with real-time and historical stock data.

Download and Install Autonomous REST ODBC Connector

  1. Download and install the Autonomous REST Connector for ODBC. We recommend you download the 64-bit version.

  2. Install the connector by running the setup executable file on your machine.

  3. After you have finished installation, you should find the Autonomous REST connector at the below default path, unless you have chosen to install it at a different location.

Configure Autonomous REST Connector for ODBC

  1. Before we configure the REST connector, copy the configuration below and save it as AlphaVantage.rest


     
  2. Now, go to the Alphavantage website and get your API key.
  3. Open ODBC Administrator (64-bit) and click on Add. Choose the driver DataDirect Autonomous REST Connector.


    ODBC Administrator - Choose Autonomous REST Driver

  4. Enter a datasource name and for REST config file, browse and locate the AlphaVantage.rest file as shown below.


    Configure REST Connector

  5. Go to Authentication tab, set the below:
    1. Authentication Method: UrlParameter
    2. Auth Param: apikey
    3. Security Token: <Alphavantage API Key>

    4. REST Connector - Security Configuration
  6. Click on Test Connect and you should be able to connect to the API.

     

Importing REST API data in Alteryx

  1. In Alteryx, drag Input Data in to the workflow. In the configuration, go to the Data sources tab and choose Generic ODBC and click on ODBC.
  2. Choose the AlphaVantage ODBC Connection in the window as shown below.


    Choose DSN in Alteryx

  3. Choose a table, for this tutorial you can choose Timeseries5min which has stock data for MSF in a 5 minute interval.


    CHoose Table

  4. Once you have the data, you can build your rest of workflow to clean, transform, enrich the data, and create your reports.
Build Workflow

Learn more

You can customize Autonomous REST Connector to your needs and the possibilities are endless. Learn more about Autonomous REST Connector and the different ways to configure from this GitHub repository.

               

We hope this tutorial helped you to connect to a REST API from Alteryx with the help of Progress DataDirect Autonomous REST Connector. Feel free to contact us if you have any questions.

ODBC TUTORIAL

Connect to any REST API from Alteryx without writing any code

View all Tutorials

Connect any application to any data source anywhere

A product specialist will be glad to get in
touch with you