List users with access to current App for using in an Select component?

  1. My goal: Have a Select component with list all users that has access to the APP.

  2. Issue: I have low knowledge about JS and ReTool.
    Is there something similar to {{current_user.ID}} and {{current_user.fullname}} listing all users with access to App or belonging to a given group.

    I have setup API with ChatGPT
    https:///api/v2/permissions/accessList/app/{{appID}}
    Response:
    {
    "success": false,
    "message": "API access is only available for enterprise customers"
    }

  3. Steps I've taken: used Google, ReTool Doc.

  4. Additional info: Self-hosted, 3.114.3

Hey there @Thore,

Unfortunately, Retool’s users endpoint is gated for enterprise accounts only (although I don’t know if that changes for self-hosted to be honest) , as such there is no actual way to get a list of your current account users, together with the other endpoints such as permissions.

There are workarounds when it comes to attributes (keeping a db table that mirrors your current users and tables), but because you’re not able to access permissions programatically, you would end up with a very manual workaround.