Get list of Retool users

💬 App Building
1

How can I fetch the list of Retool users so I can use it on an app? I want to fetch the user name and its email address.

2

Hi @fernando_monoline,

For enterprise customers, via API. Docs are here.

Otherwise, you can build a list of users by setting a query to run on load and capturing the users when they login.

here is a snippet I have used:

INSERT INTO app_users (retool_id, email, full_name)
VALUES ({{ current_user.id }}, {{ current_user.email }}, {{ current_user.fullName }})
ON CONFLICT (retool_id) 
DO UPDATE 
SET email = EXCLUDED.email,
    full_name = EXCLUDED.full_name;
1 Like