ODBC Driver for PingOne

Build 25.0.9434

Applications

General information on all the applications (regardless of protocol) in the environment.

View-Specific Information

SELECT

Reading data from this entity requires Read Application/applications:read:application permission.

We recommend using the built-in Client Application Developer role.

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.Applications WHERE Id = '8f2c6a33-1f7f-458e-8b58-f92507742293';
SELECT * FROM Administrators.Applications WHERE Id IN ('8f2c6a33-1f7f-458e-8b58-f92507742293', '4441de0a-e4f2-47da-a217-545955eb23a5');

Columns

Name Type References Description
Id [KEY] String The application identifier (UUID).
Name String The name of the application.
Description String The application's description.
IsEnabled Boolean Boolean value indicating whether the application is enabled for authorization to PingOne.
Type String The type of the application. Possible values are: 'WEB_APP', 'NATIVE_APP', 'SINGLE_PAGE_APP', 'SERVICE', 'CUSTOM_APP', 'WORKER', 'PING_ONE_SELF_SERVICE', 'PING_ONE_ADMIN_CONSOLE', 'PING_ONE_PORTAL', 'TEMPLATE_APP' and 'PORTAL_LINK_APP'.
Protocol String The protocol used by the application. Possible values are: 'OPENID_CONNECT', 'SAML' and 'WS-FED'.
EnvironmentId String Information.Environments.Id The identifier (UUID) of the environment in which the application exists.
CreatedAt Datetime The time at which the application was created.
UpdatedAt Datetime The time at which the application was last updated.
LoginPageURL String The application's login page URL.
HomePageURL String The application's home page URL.
IsHiddenFromPortal Boolean Boolean value indicating whether the application is hidden in the application portal.
IconURL String The URL of the application's icon.
AccessControlRolesCriteria String The user role criteria for accessing the application. Possible values are 'ADMIN_USERS_ONLY'. A user is an admin user if they have one or more of the following roles: 'Organization Admin', 'Environment Admin', 'Identity Data Admin' or 'Client Application Developer'.
CORSRestriction String The application's restriction in regards to CORS requests. Possible values are 'ALLOW_NO_ORIGINS' and 'ALLOW_SPECIFIC_ORIGINS'. 'ALLOWS_NO_ORIGINS' rejects all CORS requests. 'ALLOW_SPECIFIC_ORIGINS' rejects all CORS requests except those listed in the 'CORSAllowedOrigins' column.
CORSAllowedOrigins String The origins from which CORS requests to the Authorization and Authentication APIs are allowed. This applies only when 'CORSRestriction' is set to 'ALLOW_SPECIFIC_ORIGINS'.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434