It’s best practice to limit the overall API calls needed for a solution, so the first thing the workflow does is create a unique list of the songs. The second API is where it gets interesting as it contains Spotify’s features. The first API has basic track information, such as the Artist, URL for the image, name, etc. This is where it gets fun! I used these endpoints from Spotify: To then call the macro, I created this simple workflow: The workflow above takes a single date, downloads the csv field by dynamically changing the date in the URL, and then returns the fields I need – namely the rank, number of views and (most importantly) the Spotify ID. To avoid manually downloading all 1,160 csv files I ended up using, I created a batch macro in Alteryx! This link will download the daily most popular songs in a csv format.
I went about this with a batch macro in Alteryx. I then used the Spotify API to get features about each song. To do this, I first extracted the top 200 songs from the Spotify Charts back until the start of 2017. What I wanted to create a chart that analysed how the features behind the most popular songs changed over time. In case you’re asking, what is dashboard week? Dashboard week is a week where, during each day, all the data schoolers create a dashboard and post about it! Monday’s challenge was creating a dashboard using the Spotify API. Welcome to my first of five dashboard week blogs!
0 kommentar(er)
