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

Joined
Aug 23, 2022
Messages
53
Thanked
35
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"}],