Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
google script to pull in discography data for a particular user
function getThatData() {
var user = 'USERNAME';
var url = '' + user + '/collection/folders/0/releases'; //I probably did this right but ran it w the user hardcoded
var sheet = SpreadsheetApp.getActiveSheet();
var response = UrlFetchApp.fetch(url); // get feed
var json = response.getContentText(); //
var data = JSON.parse(response);
var counter = data.pagination.items;
for (var i = 0; i<= counter; i++) {
var stats = [];
stats.push(data.releases[i].instance_id);//works a
stats.push(data.releases[i].date_added);//works b
stats.push(data.releases[i].basic_information.labels[0].name); //works c
stats.push(data.releases[i].basic_information.labels[0].catno); // work d
stats.push(data.releases[i].basic_information.labels[0].resource_url); // works e
stats.push(data.releases[i].basic_information.labels[0].entity_type_name); //workd f
stats.push(data.releases[i].basic_information.formats[0].descriptions[0]); //stringify array?
stats.push(data.releases[i].basic_information.formats[0].name);//works h
stats.push(data.releases[i].basic_information.title); //works i
stats.push(data.releases[i].basic_information.artists[0].name); //works j
stats.push(data.releases[i].basic_information.resource_url); //k
stats.push(data.releases[i].basic_information.year); //l
stats.push(data.releases[i]; // m
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment