user_app
Represents a user's connected application or integration in Rolebase. Tracks application settings, preferences, and authentication details for third-party services like Google Calendar and Microsoft 365.
Fields
| Field | Type | Description |
|---|---|---|
id | uuid | Unique identifier for the app connection (auto-generated) |
userId | uuid | Reference to the user |
type | Text | Type of application: GoogleCalendar or Office365 |
config | JSON | Public application configuration |
Application Types
The type field accepts the following values:
- GoogleCalendar — Google Calendar integration
- Office365 — Microsoft 365 Calendar integration
Relationships
Object Relationships
user— The user this app connection belongs to
Query Examples
List User Apps
query GetUserApps {
user_app {
id
type
config
userId
}
}
Permissions
App connection access is restricted to the owning user:
- Users can view their own app connections (limited to
config,id,type, anduserIdfields)
Each user can have multiple app connections, but there is a unique constraint
on the (userId, type) pair, meaning one connection per app type per user.
The secretConfig, tmpData, and createdAt fields exist in the database
but are not exposed via the API.