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.
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.