My request to get an active host report (within a 1 day timeframe) isn’t returning all data. I’m using google script editor to store the data in a worksheet.
I’m not receiving an error message. Has anyone come across this issue before?
function getZoomMinutes() {
// Declaring variables
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[2];
var input = sheet.getRange(“A2”);
var cols = sheet.getRange(“A:C”);
var token = getJWT(apiKey, apiSecret);
var user = 0;
// Date variables
var date = new Date();
date.setDate(date.getDate() - 1);
var day = date.getDate();
var month = date.getMonth() + 1;
var year = date.getFullYear();
// URL required for API call
var url = ‘https://api.zoom.us/v2/report/users?from=’ + year + ‘-’ + month + ‘-’ + day + ‘T00:00:00Z&to=’ + year + ‘-’ + month + ‘-’ + day + ‘T23:59:59Z&type=active&page_size=300’;
// API parameters
var headers = {
‘Authorization’: ‘Bearer’ + token + ’ ’
};
var params = {
headers: headers
};
// Making API call and parsing JSON response
var response = UrlFetchApp.fetch(url, params);
var zoomData = JSON.parse(response);
var numUsers = zoomData.total_records;
// Clearing existing data
cols.clear();
sheet.getRange(“A1”).setValue(“Email”)
sheet.getRange(“B1”).setValue(“Talk Time”)
sheet.getRange(“C1”).setValue(“Date”)
// Looping through records returned and writing to the Google Sheet
for(user = 0; user < numUsers; user++) {
input.offset(user, 0).setValue(zoomData.users[user].email);
input.offset(user, 1).setValue((zoomData.users[user].meeting_minutes/zoomData.users[user].participants)*zoomData.users[user].meetings);
input.offset(user, 2).setValue(month + “/” + day + “/” + year);
user++;
}
} // END GetZoomMinutes FUNCTION