Announcements

Help Wizard

Step 1

NEXT STEP

The order of songs in the playlist obtained through the API is incorrect.

The order of songs in the playlist obtained through the API is incorrect.

Plan

Free

Country

JAPAN

Device

dell laptop

Operating System

Windows 11

 

 

I want to retrieve music data from the playlist "Showa Pop" with the playlist ID "37i9dQZF1DX2QCBqV8Ylrq" and playlist URL "https://open.spotify.com/playlist/37i9dQZF1DX2QCBqV8Ylrq?si=39418b36e0844509" using Spotify's API.

 

When I used the API to retrieve the data, the order of the songs returned in the HTML request was different from the order displayed in the Spotify app.

I have confirmed that there are song restrictions depending on the country, and both the Spotify app and the Spotify developer settings are set to Japan.

I would like to know how to solve this problem. I am using VBA to make the requests, and the request is being sent as follows:

PlayList_Url = "https://api.spotify.com/v1/playlists/" & PlayList_Id
Call httpreq.Open("GET", PlayList_Url, False)
Call httpreq.setRequestHeader("Accept", "application/json")
Call httpreq.setRequestHeader("Accept-Language", "ja")
Call httpreq.setRequestHeader("Content-Type", "application/json")
Call httpreq.setRequestHeader("Authorization", "Bearer " & access_token)
Call httpreq.send

 

Order on HTML request↓

APIで帰ってくる結果.png

Order on Spotify app↓↓↓

spotifyアプリ上の並び.png

Reply
0 Replies

Suggested posts