Easy lookup of user IDs

💬 Feature Requests
1

Could user ID be added to the information that is shown about users at Settings > Users?

Though one's own ID is readily exposed at current_user.id, Admins currently don't have a way to discern user IDs. Settings > Users > User details seems like a natural place for this, and of course also in the "Download as csv" export.

Our need for this is kind of an edge case (migrating data and connecting it to users), however I imagine there are other scenarios where access to IDs could be useful.

(For context, we're on Business/Cloud)

Thanks!

1 Like
2

You can list all the Retool users through the REST API exposed by Retool.

Check this out:
List all users

This is the form of data you will get from the endpoint, which also contains the ID for each user

{
  "success": true,
  "data": [
    {
      "id": "string",
      "legacy_id": 0,
      "email": "user@example.com",
      "active": true,
      "created_at": "2019-02-08T11:45:48.899Z",
      "last_active": "2019-02-08T11:45:48.899Z",
      "first_name": "string",
      "last_name": "string",
      "metadata": {},
      "is_admin": true,
      "user_type": "default"
    }
  ],
  "total_count": 0,
  "next_token": "string",
  "has_more": true
}

As for showing it on the Retool settings page, this is something the Retool team can add in their UI.

3

@ali-sajjad-rizavi note that @Schteevynn specified they are on the business cloud plan. You cannot access Retool users as a business plan account.

image

4

@OLR I am also on business cloud plan, and able to see the Retool API page, where we have to create a token to access the API.

5

@ali-sajjad-rizavi What are the permissions set on your API key?

6

The critical detail here is the difference between creating a token and being able to use it…

Even though we can create an access token as a Business user, it's not very useful (see pic), the returned message says it all :pensive:

I was on office hours with Retool staff and they agreed that user IDs should be more easily discovered – and not exclusively to Enterprise via API – so they asked me to create this Feature Request.

Screenshot 2025-03-19 at 7.05.36 PM
Screenshot 2025-03-19 at 7.05.36 PM1142×166 13.6 KB

1 Like
7

To clarify, there are just three sets of API endpoints that are available on a Business plan:

I did talk to @Schteevynn, though, and generally agree that it makes sense to expose user IDs via the UI for any org admin. I've passed that feedback on to the team and will provide an update here as soon as there is news to share. :+1:

3 Likes
8

Even something as simple as the way we can grab Permission Group ID would be cool:

Screenshot 2025-03-24 at 1.38.06 PM

I have implemented your workaround suggestion – a page-load query that logs current_user.id/email/fullName/groups to a table in our DB. This is decent, albeit only for users who load the page going forward; there is of course no retroactive discovery of IDs with this method.

Side note, @Darren I'm so glad you mentioned that User Invite API is actually available to Business Tier … I did not know that, and since learning that, have already implemented. Had been wanting to be able to invite users from within an app, and now, can do exactly that.

2 Likes