What is API?
API stands for "Application Programming Interface." It is a set of rules and protocols that allows different software applications to communicate with each other. APIs define the methods and data formats that applications can use to request and exchange information.
To collect data from API, we need to enter an Endpoint in an text input tool in Alteryx. Take this website (https://thronesapi.com/) as an example, if we want to collect the name of characters, the endpoint we need is "https://thronesapi.com/api/v2/Characters"
We then need to use Download Tool to configure the connection to the API. After that, use the Json parse tool to download the data we want and used text to column to separate the number and the letter in Json_Name column.
Use cross tab to transform the rows to columns in JSON_Name2 field. And now we have a table with the all the characters name.
