Appscript使用Reports API从Google工作区提取数据时出现问题

Question

以下代码使用Reports API将数据从Google工作区拉入Google工作表。然而，它只给了我最后两天的数据，不确定为什么，脚本中没有设置限制。

该代码是以下问题的参考：

如何从Admin SDK将已删除、存档、暂停的用户数据拉到Google工作表>gt；使用Appscript 报告API

函数列表用户((｛

var sheet = SpreadsheetApp.getActive().getActiveSheet();
var values = [];
var userKey = 'all';
var applicationName = 'admin';
var optionalArgs = {
maxResults: 100
};
var response = AdminReports.Activities.list(userKey, applicationName, optionalArgs);
var activities = response.items;
if (activities && activities.length > 0) {
Logger.log('REPORTS:');
for (i = 0; i < activities.length; i++) {
var activity = activities[i];
//ONLY GET DATA IF ACTION IS EITHER "SUSPEND_USER", "DELETE_USER", or "ARCHIVE_USER"
if(activity.events[0].name == "SUSPEND_USER" || activity.events[0].name == "DELETE_USER" || activity.events[0].name == "ARCHIVE_USER"){
Logger.log('%s: %s (%s)', activity.id.time, activity.events[0].parameters[0].value,
activity.events[0].name);
//RETRIEVES THE TIMESTAMP, USER'S EMAIL, & THE EVENT NAME THAT WAS PERFORMED TO THE USER
values = [[activity.id.time, activity.events[0].parameters[0].value,activity.events[0].name]]; 
//SET THE DATA TO SHEET
var lrow = sheet.getLastRow()+1;
sheet.getRange("A"+lrow+":C"+lrow).setValues(values); 
}
}
} else {
Logger.log('No reports found.');
}

}

Answer 1

您的代码包含每页结果的最大值限制：

var optionalArgs = {
maxResults: 100
};

根据文档，将该值设置为1000而不是100，或将其删除-maxResults的默认值为1000

如果要检索1000个以上的结果，则需要从响应中检索nextPageToken，并将其作为pageToken传递给optionalArgs以进行下一个请求。

您可以在循环中获取请求，直到获得所有结果。

代码修改：

function listUsers() {
var sheet = SpreadsheetApp.getActive().getActiveSheet();
var userKey = 'all';
var applicationName = 'admin';
var optionalArgs = {
maxResults: 1000
};
var response = AdminReports.Activities.list(userKey, applicationName, optionalArgs);
var activities = response.items;
if (activities && activities.length > 0) {
Logger.log('REPORTS:');
for (i = 0; i < activities.length; i++) {
var activity = activities[i];
//ONLY GET DATA IF ACTION IS EITHER "SUSPEND_USER", "DELETE_USER", or "ARCHIVE_USER"
if (activity.events[0].name == "SUSPEND_USER" || activity.events[0].name == "DELETE_USER" || activity.events[0].name == "ARCHIVE_USER") {
Logger.log('%s: %s (%s)', activity.id.time, activity.events[0].parameters[0].value,
activity.events[0].name);
//RETRIEVES THE TIMESTAMP, USER'S EMAIL, & THE EVENT NAME THAT WAS PERFORMED TO THE USER
values = [
[activity.id.time, activity.events[0].parameters[0].value, activity.events[0].name]
];
//SET THE DATA TO SHEET
var lrow = sheet.getLastRow() + 1;
sheet.getRange("A" + lrow + ":C" + lrow).setValues(values);
}
}
} else {
Logger.log('No reports found.');
}

//////// ADD THE FOLLOWING TO YOUR EXISTING CODE:

while (response.nextPageToken) {
var optionalArgs = {
maxResults: 1000,
pageToken: response.nextPageToken
}
var response = AdminReports.Activities.list(userKey, applicationName, optionalArgs);
var activities = response.items;
if (activities && activities.length > 0) {
Logger.log('REPORTS:');
for (i = 0; i < activities.length; i++) {
var activity = activities[i];
//ONLY GET DATA IF ACTION IS EITHER "SUSPEND_USER", "DELETE_USER", or "ARCHIVE_USER"
if (activity.events[0].name == "SUSPEND_USER" || activity.events[0].name == "DELETE_USER" || activity.events[0].name == "ARCHIVE_USER") {
Logger.log('%s: %s (%s)', activity.id.time, activity.events[0].parameters[0].value,
activity.events[0].name);
//RETRIEVES THE TIMESTAMP, USER'S EMAIL, & THE EVENT NAME THAT WAS PERFORMED TO THE USER
values = [
[activity.id.time, activity.events[0].parameters[0].value, activity.events[0].name]
];
//SET THE DATA TO SHEET
var lrow = sheet.getLastRow() + 1;
sheet.getRange("A" + lrow + ":C" + lrow).setValues(values);
}
}
} else {
Logger.log('No reports found.');
}
}
}