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↓

Order on Spotify app↓↓↓