I'm looking for some help regarding my trance book (Discogs API, SQL, programming)

Aug 23, 2022
122 Posts
113 Thanked
I've made some significant progress on my own with the help of SyncWith. However, I cannot make API calls to get tracklists (artist + track name + track length) out of releases. So, let's say I want to get the artist name + track name + track length for the following release. How can I do that, and how can I automate this process for multiple thousands of links/releases?

The API release link already contains the artist name, the track names, and the track lengths, but how can I extract only these data into a spreadsheet?

Artist name (based on the example release above):
"artists": [{"name": "The Source Experience",
Track names (based on the example release above):
"type_": "track", "title": "The Source Experience", "duration": "7:30"},
"type_": "track", "title": "Kamikaze", "duration": "6:32"},
"type_": "track", "title": "Release The Pressure", "duration": "7:50"},
"type_": "track", "title": "Mental Rider", "duration": "6:23"},
"type_": "track", "title": "Elektra", "duration": "11:03"}],