How to get a list of users?

Current plan level (Free, Team, Business, or Enterprise: Retool | Retool Pricing):
Monthly/Annual (if Team or Business): business annual
Version of Retool (if self-hosted): hosted

Question / Description:
I have used the audit log download to get a history of queries but the exported logs only contain user_id and no other information about who performed the action.

Is there a way to get user_id and names out of the hosted retool? I have been looking all over Retool to find a way. The closest I have found is the ajax response on the audit page but that doesn't help me with older entries no longer preserved by Retool (no results for a given user).

Thanks,
Mike

2 Likes

Answering my own question, I found the ajax endpoint "user" returns yourself.. and all the users on the system and that appears to be what is used to display the actors on the audit page.

Didn't expect it there, but at least I have them now. It'd be nice to be able to query internal retool stuff on the hosted version like the self-hosted instances can.

Thanks,
Mike

Hi @Mike_Johnson! Welcome to the community. :slightly_smiling_face:

Having access to the primary database is definitely one of the primary benefits of running self-hosted instance! The nature of the cloud product makes it a little challenging to do this in a secure and scalable manner, unfortunately.

Regardless, I'm glad you were able to pull the information that you needed!