The resources in the environment.

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 Resource/resources:read:resource permission.

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

• Id supports the following operators: =, IN.

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

For example, the following queries are processed server-side:

SELECT * FROM Administrators.Resources WHERE Id = '0978e1d6-cdd5-4115-a5e0-90fe93064e40';
SELECT * FROM Administrators.Resources WHERE Id IN ('0978e1d6-cdd5-4115-a5e0-90fe93064e40', '7b9a9ba5-459a-45df-a6db-cbc3cab0e53d');

INSERT

Creating data in this table requires Create Resource/resources:create:resource permission.

Refer to the query example below:

INSERT INTO Administrators.Resources (Name, Description, Type, Audience, TokenDuration, TokenIntrospectionEndpointMethod) VALUES ('My Resource', 'My Resource', 'OPENID_CONNECT', 'https://test.com/', 3600, 'CLIENT_SECRET_BASIC')

UPDATE

Updating data in this table requires Update Resource/resources:update:resource permission.

Refer to the query example below:

UPDATE Administrators.Resources SET Name = 'Test Resource', Description = 'Test Resource', Type = 'PING_ONE_API', Audience = 'https://testing.com/', TokenDuration = 1800, TokenIntrospectionEndpointMethod = 'CLIENT_SECRET_POST' WHERE Id = '0978e1d6-cdd5-4115-a5e0-90fe93064e40'

DELETE

Deleting data from this table requires Delete Resource/resources:delete:resource permission.

Refer to the query example below:

DELETE FROM Administrators.Resources WHERE Id = '0978e1d6-cdd5-4115-a5e0-90fe93064e40'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The resource identifier (UUID).
Name	String	False		The name of the resource.
Description	String	False		The resource's description.
Type	String	False		The type of resource. Possible values are: 'OPENID_CONNECT', 'PING_ONE_API', and 'CUSTOM'.
Audience	String	False		The intended audience for the resource.
TokenDuration	Integer	False		The number of seconds that the access token is valid.
TokenIntrospectionEndpointMethod	String	False		The authentication methods supported by the token endpoint. Possible values are: 'NONE', 'CLIENT_SECRET_BASIC', 'CLIENT_SECRET_POST', 'CLIENT_SECRET_JWT', and 'PRIVATE_KEY_JWT'. Applies only to custom resources.
EnableTokenPermissionClaims	Boolean	True		Boolean value indicating whether to enable application permission claims in the access token.
CreatedAt	Datetime	True		The time at which the resource was created.
UpdatedAt	Datetime	True		The time at which the resource was last updated.
EnvironmentId	String	True	Information.Environments.Id	The identifier (UUID) of the environment in which the resource exists.