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.