Google Apps Script & Google Analytics API: Can't read PropertyIDs from Google Spreadsheet columns -

-

i'm trying use code in script editor read queries google spreadsheet columns people not know google apps scripts can use when want change queries start-date, end-date, metrics, dimensions, etc...the codes can read start-date, end-date, metrics, dimensions, , filters successfully. however, think doesn't recognize accountid, webpropertyid, , profileid sheet named "report configuration." got error "response code: 404. message: not found". me on this? below code got @eudardo:

var log_sheet_name = 'unsampled report logs'; var ss = spreadsheetapp.getactive(); var ui = spreadsheetapp.getui(); var sheet = ss.getsheetbyname('report configuration'); var startdaterange = sheet.getrange(10,5);  var startdate = startdaterange.getvalue(); var enddaterange = sheet.getrange(10,6);  var enddate = enddaterange.getvalue(); var metricsrange = sheet.getrange(10,8);  var metrics = metricsrange.getvalue(); var dimensionsrange = sheet.getrange(10,9);  var dimensions = dimensionsrange.getvalue(); var filtersrange = sheet.getrange(10,11);  var filters = filtersrange.getvalue();  function insertreport() {   var resource = {         'title': 'medium sale',         'start-date': startdate,         'end-date': enddate,         'metrics': metrics,         'dimensions': dimensions,         'filters': filters,       };    var ss = spreadsheetapp.getactive();    var sheet = ss.getsheetbyname('report configuration');    var accountid = sheet.getrange(10,18).getvalue();    var webpropertyid = sheet.getrange(10,19).getvalue();    var profileid = sheet.getrange(10,20).getvalue();    try {     var request = analytics.management.unsampledreports.insert(resource, accountid, webpropertyid, profileid);    } catch (error) {     ui.alert('error performing unsampled report query', error.message, ui.buttonset.ok);     return;   }    var sheet = ss.getsheetbyname(log_sheet_name);    if (!sheet) {     sheet = ss.insertsheet(log_sheet_name);     sheet.appendrow(['user', 'account', 'web property', 'view', 'title', 'inserted time', 'updated time', 'status', 'id', 'file']);     sheet.getrange(1, 1, 1, 10).setfontweight('bold');   }   sheet.appendrow([     session.geteffectiveuser().getemail(),     request.accountid,     request.webpropertyid,     request.profileid,     request.title,     request.created,     request.updated,     request.status,     request.id   ]);  }  // scans log_sheet_name , tries update report pending function updateallreports() {   var sheet = ss.getsheetbyname(log_sheet_name);   var lastrow = sheet.getlastrow();    var datarange = sheet.getrange(2,1, lastrow, 10);    var data = datarange.getvalues();    (var i=0; i<data.length; i++) {     // if data pending let's try update it's status. it's complete     // may take 24h process unsampled reprot     if (data[i][0] == session.geteffectiveuser().getemail() && data[i][7] == 'pending') {       try {       var request = analytics.management.unsampledreports.get(data[i][1], data[i][2], data[i][3], data[i][8]);       } catch (error) {         ui.alert('error performing unsampled report query', error.message, ui.buttonset.ok);         return;       }        data[i] = [         session.geteffectiveuser().getemail(),         request.accountid,         request.webpropertyid,         request.profileid,         request.title,         request.created,         request.updated,         request.status,         request.id,         request.status == 'completed' ? driveapp.getfilebyid(request.drivedownloaddetails.documentid).geturl() : ''       ];         // if data complete let's import new sheet       if (request.status == 'completed') {         importreportfromdrive(request.title, request.drivedownloaddetails.documentid);       }     }   }    // write once spreadsheet faster   datarange.setvalues(data);  }  function importreportfromdrive(title, fileid) {   var file = driveapp.getfilebyid(fileid);   var csvstring = file.getblob().getdataasstring();   var data = utilities.parsecsv(csvstring);    // find suitable name new sheet   var i=1;   var sheetname = title;   while (ss.getsheetbyname(sheetname)) {     sheetname = title + ' ('+ i++ +')';   }    var sheet = ss.insertsheet(sheetname);   var range = sheet.getrange(1, 1, data.length, data[0].length);   range.setvalues(data); }

never mind. figured out why. it's because of mis-use of getrange(). it's supposed getrange(row,column), referenced getrange(column,row). silly me! :)


Comments

Post a Comment

Popular posts from this blog

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th...
Read more

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de...
Read more