google-apps-script - Appscript 使用 Reports API 从 Google 工作区提取数据时遇到问题
问题描述
以下代码使用 Reports API 从 Google 工作区将数据提取到 Google 工作表。但是它只给了我最后 2 天的数据,不知道为什么,脚本中没有设置限制。
该代码是以下问题的参考:
如何使用 Appscript 从 Admin SDK >> Reports API 将已删除、存档、暂停的用户数据提取到 Google 工作表
功能列表用户(){
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.');
}
}
解决方案
您的代码包含每页结果最大值的限制:
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.');
}
}
}