如何将auth响应转换为对象数组

Question

我正试图使用auth函数获得用户的响应，我必须使用xlsx填充库创建一个excel表，并且我能够将其转换为对象数组，因为限制是1000，所以有多个对象数组。我不知道如何解决这个问题。在这个问题中，我只是使用auth获取结果，并尝试将结果放入一个对象数组中。我也试图使用对象传递到excel表中，但它给了excel表最后1000个查询的响应

const admin = require("firebase-admin");
const momentTz = require("moment-timezone");
const XlsxPopulate = require("xlsx-populate");
momentTz.suppressDeprecationWarnings = true;
const {
alphabetsArray
} = require("./constant");
var start = momentTz().subtract(4, "days").startOf("day").format();
var start = momentTz(start).valueOf();
const end = momentTz().subtract(1, "days").endOf("day").format();
const  listAllUsers = async(nextPageToken) =>{
const [workbook] = await Promise.all([
XlsxPopulate.fromBlankAsync()
]);
const reportSheet = workbook.addSheet("Signup Report");
workbook.deleteSheet("Sheet1");
reportSheet.row(1).style("bold", true);
[
"Date",
"TIME",
"Phone Number"
].forEach((field, index) => {
reportSheet.cell(`${alphabetsArray[index]}1`).value(field);
});
let count = 0
// List batch of users, 1000 at a time.

const data = [];
admin
.auth()
.listUsers(1000, nextPageToken)
.then (async  (listUsersResult) => {
listUsersResult.users.forEach((userRecord) =>{
const time = userRecord.metadata.creationTime;
const timestamp = momentTz(time).valueOf();
//   console.log(timestamp)

if (timestamp >= 1585704530967 ) {
console.log(time);
let column = count+2;
count++;
data.push(userRecord.toJSON())
reportSheet.cell(`A${column}`).value(time);
reportSheet.cell(`C${column}`).value(userRecord.phoneNumber);
}
});
console.log(JSON.stringify(data))//this is the array of the object and i am getting after 1000 response 
if (listUsersResult.pageToken) {
// List next batch of users.
listAllUsers(listUsersResult.pageToken);
await workbook.toFileAsync("./SignUp.xlsx");
}
})
// .catch(function (error) {
//   console.log("Error listing users:", error);
// });
// const datas = []
//   datas.push(data)
//   console.log(datas)
return ;
}
// Start listing users from the beginning, 1000 at a time.
listAllUsers();

and the output i am getting is like this 
[]
[]
[]
[]
[]
i want to convert this into a single array of response

Answer 1

您有一个竞赛条件。当您执行console.log(JSON.stringify(data))时，listUserQuery正在进行中(并且处于异步模式(，并且在打印数组时还没有答案。因此，数组为空。

试试这个(我不确定这个最佳解决方案，我不是nodeJS开发人员(

admin
.auth()
.listUsers(1000, nextPageToken)
.then (async  (listUsersResult) => {
listUsersResult.users.forEach((userRecord) =>{
const time = userRecord.metadata.creationTime;
const timestamp = momentTz(time).valueOf();
//   console.log(timestamp)

if (timestamp >= 1585704530967 ) {
console.log(time);
let column = count+2;
count++;
data.push(userRecord.toJSON())
reportSheet.cell(`A${column}`).value(time);
reportSheet.cell(`C${column}`).value(userRecord.phoneNumber);
}
}
console.log(JSON.stringify(data))//this is the array of the object and i am getting after 1000 response 
if (listUsersResult.pageToken) {
// List next batch of users.
listAllUsers(listUsersResult.pageToken);
await workbook.toFileAsync("./SignUp.xlsx");
}
);