UserLinkedAccounts
The linked (external) accounts of the user.
View-Specific Information
SELECT
Reading data from this entity requires Read User Linked Accounts/dir:read:userLinkedAccounts permission.We recommend using the built-in Identity Data Admin role.
To execute SELECT statements on this entity, the UserId column must be specified in the criteria as shown in the examples below:
SELECT * FROM Administrators.UserLinkedAccounts WHERE UserId = 'f45bb04b-d7ee-4f84-ab83-7fe3919405ae';
SELECT * FROM Administrators.UserLinkedAccounts WHERE UserId IN ('f45bb04b-d7ee-4f84-ab83-7fe3919405ae', '4cbf5435-6c39-49f9-8c8f-cee7c1cd8a6b');
The connector uses the PingOne Platform API to process WHERE clause conditions built with the following columns and operators.
- UserId supports the following operators: =, IN.
All other filters are processed client-side within the connector.
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The linked account identifier (UUID). | |
| UserId | String | Users.Id | The identifier (UUID) of the user associated with the linked account. |
| IdentityProviderId | String | IdentityProviders.Id | The identifier (UUID) of the identity provider associated with the linked account. |
| ExternalId | String | The user identifier as defined in the external system (identity provider). |