IdentityProviderAttributeMappings
The attribute mappings configured for the identity provider.
View-Specific Information
SELECT
Reading data from this entity requires Read Identity Provider/identityProviders:read:identityProvider permission.We recommend using the built-in Client Application Developer role.
To execute SELECT statements on this entity, the IdentityProviderId column must be specified in the criteria as shown in the examples below:
SELECT * FROM Administrators.IdentityProviderAttributeMappings WHERE IdentityProviderId = 'e3fc0e64-5686-4003-b81b-a79508f77e5a';
SELECT * FROM Administrators.IdentityProviderAttributeMappings WHERE IdentityProviderId IN ('e3fc0e64-5686-4003-b81b-a79508f77e5a', 'ada05412-75a9-4faa-b9d6-345537b50f1e');
The connector uses the PingOne Platform API to process WHERE clause conditions built with the following columns and operators.
- IdentityProviderId supports the following operators: =, IN.
All other filters are processed client-side within the connector.
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The attribute mapping identifier (UUID). | |
| AttributeName | String | The name of the user attribute for the mapping. | |
| AttributeValue | String | A placeholder referring to the attribute (or attributes) from the provider. For example, username=${samlAssertion.subject}. | |
| Type | String | The type of the attribute mapping. Possible values are: 'CORE'(this attribute is required by the schema and cannot be removed; the 'Name' and 'Update' properties cannot be changed) and 'CUSTOM'(user-created attributes). | |
| SyncType | String | Indicates whether to update the user attribute in the directory with the non-empty mapped value from the identity provider. Possible values are: 'EMPTY_ONLY'(only update the user attribute if it has an empty value) and 'ALWAYS'(always update the user attribute value). | |
| CreatedAt | Datetime | The time at which the attribute mapping was created. | |
| UpdatedAt | Datetime | The time at which the attribute mapping was last updated. | |
| IdentityProviderId | String | IdentityProviders.Id | The identifier (UUID) of the identity provider to which these attribute mappings belong. |