Power Query my own account

[NickBurns]

Plan

Premium

Country

USA

Device

N/A

Operating System

Windows 10 / Office 365

My Question or Issue

I would like to use Excel's Power Query to inspect my own account (playlists, favorites, albums, etc)

What do I need to do to do this?

[Peter_Schorn]

You can do this using the web API. See https://developer.spotify.com/documentation/web-api/

[NickBurns]

Thanks - I'm just not sure how the process works; how do I get a key and which URL would I use?

[Peter_Schorn]

Read the documentation. It tells you how the process works. To start, you need to authorize your app. See https://developer.spotify.com/documentation/general/guides/authorization-guide/. All of the available endpoints are documented at https://developer.spotify.com/documentation/web-api/reference/.

[NickBurns]

Sigh - still at a loss at how these calls and APIs will work in Power Query, realistically looking for some hand-holding here.

I have an app. I have a client ID and the secret client code.

I'm trying to follow a Power Query use for the twitter API from here:

Get data from Twitter API with Power Query 

But not sure what to put on line 14 (code at link)

Though I'm pretty sure I need put 

https://api.spotify.com/v1/me/playlists

in line 28 of the code to get my playlists.

Thanks for any further insight.

[Peter_Schorn]

You cannot replace a single line in code written for the Twitter API and expect it to work with the Spotify API.

Power Query has nothing to do with the Spotify web API, so this is the wrong forum in which to ask this question.

If you've never used the Spotify API before, then you should start by forgetting about Power Query and write a simple script instead that implements authorization process and then makes a request to the playlists endpoint. Can you do that?