In this blog I'll be walking through how I used Alteryx to connect to Stardew Valley data, a popular farm simulation game. The free API can be found at: https://www.stardewvalleywiki.net/developers. My end goal is to get data on the villagers in the game.
Step one: Connecting to the API
After finding the open API, I put in the base URL as a text input and the endpoint I want.
Then I used a formula tool to make the URL I need for the villager information specifically. For this API I don't need an API key, but if I did I would add it to the end of my formula.
Next, I connected and configured a download tool before running and caching it, in order to limit the amount of times I'm calling on the API.
The output being "HTTP/1.1 200 OK" means that my download was successful.
Step Two: Parsing the Data
Next was a series of select tools and JSON parse tools until I reached my desired output, the selecting being used to manage the view of the data, unnest for "{}" and flatten for "[]".
Step Three: Cleaning
After, I used dynamic rename tools, a data cleansing tool, select, and formula tool to clean up the data until I was satisfied with the desired output.
And now I have base information on the Stardew Valley characters. Thank you for joining me on this journey!