The attribute mappings configured for the application.

Table-Specific Information

We recommend using the built-in Client Application Developer role to read and write data for this table.

SELECT

Reading data from this table requires Read Attribute/resources:read:attribute permission.

To execute SELECT statements on this table, the ResourceId column must be specified in the criteria as shown in the examples below:

SELECT * FROM Administrators.ResourceAttributeMappings WHERE ResourceId = '0978e1d6-cdd5-4115-a5e0-90fe93064e40';
SELECT * FROM Administrators.ResourceAttributeMappings WHERE ResourceId IN ('0978e1d6-cdd5-4115-a5e0-90fe93064e40', '7b9a9ba5-459a-45df-a6db-cbc3cab0e53d');
SELECT * FROM Administrators.ResourceAttributeMappings WHERE ResourceId = '0978e1d6-cdd5-4115-a5e0-90fe93064e40' AND Id = 'fe72c71a-a65a-4be7-ba14-107ed2aaebf4';

The connector uses the PingOne Platform API to process WHERE clause conditions built with the following columns and operators.

• ResourceId supports the following operators: =, IN.
• Id supports the following operators: =, IN.

All other filters are processed client-side within the connector.

INSERT

Creating data in this table requires Create Attribute/resources:create:attribute permission.

Refer to the query example below:

INSERT INTO ResourceAttributeMappings (ResourceId, AttributeName, AttributeValue, IncludeInIDToken, IncludeInUserInfo) VALUES ('0978e1d6-cdd5-4115-a5e0-90fe93064e40', 'User Email', '${user.email}', true, true)

UPDATE

Updating data in this table requires Update Attribute/resources:update:attribute permission.

Refer to the query example below:

UPDATE Administrators.ResourceAttributeMappings SET IncludeInIDToken = false, IncludeInUserInfo = true WHERE ResourceId = '0978e1d6-cdd5-4115-a5e0-90fe93064e40' AND Id = 'fe72c71a-a65a-4be7-ba14-107ed2aaebf4'

DELETE

Deleting data from this table requires Delete Attribute/resources:delete:attribute permission.

Refer to the query example below:

DELETE FROM Administrators.ResourceAttributeMappings WHERE ResourceId = '0978e1d6-cdd5-4115-a5e0-90fe93064e40' AND Id = 'fe72c71a-a65a-4be7-ba14-107ed2aaebf4'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The attribute mapping identifier (UUID).
AttributeName	String	False		The name of the attribute.
AttributeValue	String	False		The string constants or expression for mapping the attribute name against a specific source. The expression format is: ${SOURCE.ATTRIBUTE}. The only supported source is user (for example, ${user.id}).
Type	String	True		The mapping type of the attribute. Possible values are: 'CORE', 'CUSTOM', and 'PREDEFINED'.
ResourceId	String	False	Resources.Id	The identifier (UUID) of the application to which the attribute mapping belongs.
IncludeInIDToken	Boolean	False		Boolean value indicating whether the attribute mapping should be available in the ID Token. This applies only for the attribute mappings of the 'OpenId Connect' resource.
IncludeInUserInfo	Boolean	False		Boolean value indicating whether the attribute mapping should be available through the '/as/userinfo' endpoint. This applies only for the attribute mappings of the 'OpenId Connect' resource.