ExternalUser
All external users for the organization. External users are people who interact with Linear through integrated services (Slack, Jira, GitHub, etc.) without having a Linear account.
Table-Specific Information
SELECT
Retrieve Linear ExternalUser records:SELECT * FROM ExternalUser LIMIT 1
Columns
| Name | Type | Description |
| id [KEY] | String | The unique identifier of the entity. |
| createdAt | Datetime | The time at which the entity was created. |
| updatedAt | Datetime | The last time at which the entity was meaningfully updated. This is the same as the creation time if the entity hasn't been updated after creation. |
| archivedAt | Datetime | The time at which the entity was archived. Null if the entity has not been archived. |
| name | String | The external user's full name. |
| displayName | String | The external user's display name. Unique within each workspace. Can match the display name of an actual user. |
| String | The external user's email address. | |
| avatarUrl | String | A URL to the external user's avatar image. Null if no avatar is available from the external service. |
| lastSeen | Datetime | The last time the external user was seen interacting with Linear through their external service. Defaults to the creation time and is updated on subsequent interactions. |