Connecting to Spotify?

[Nick Burns]

Has anyone attempted to connect to your personal Spotify playlist?

I have a client ID on Spotify Developer, but I don't know if that's enough.

I don't have the first clue on what I would need to get a track listing from Spotify.

 

[Pecoflyer]

What has this to do with Power Query?

 

[Nick Burns]

Spotify has a Web API that can generate JSON which Power Query should be able to read. I'd like to connect to my Playlists and look at song running time to best optimize a list.

 

[Nick Burns]

Here's their web api:
https://developer.spotify.com/documentation/web-api/reference/playlists/get-playlists-tracks/

that particular connection has a limit of 100 songs, which means there would need to be able to read the number of tracks in a playlist and then set the offset to get next set if the playlist exceeds 100 songs.

I manually use that web site and cut/paste the output to JSON files, but there should be a way for Power Query to do all that.