How to get user details from uid without using API

[Fsherin]

Hi,
I am using nodebb in the project.
It is using the nodebb apis to read and write.
But in one of the requirements, we need to get the userid or username from the uid. There is an api for that, but we need this data for a spark job and calling this api per user will be a bigger number. So its not scalable.
Is there any way to map the uid to the username ?

[baris]

Sure on mongodb you can run this.

> db.objects.find({ _key: { $in: ["user:1", "user:2", "user:3", "user:4"] } }, { _id: 0, uid: 1, username: 1 }).pretty();

[baris]

NodeBB has a method in the user module to get usernames, if you can call nodebb functions you can use that.

const usernames = await User.getUsernamesByUids([1,2,3,4]);

[Fsherin]

No, we can't call the functions, is there any way like able to query from a database ?

[baris]

Sure on mongodb you can run this.

> db.objects.find({ _key: { $in: ["user:1", "user:2", "user:3", "user:4"] } }, { _id: 0, uid: 1, username: 1 }).pretty();

[Fsherin]

Thanks, this works !!