JDBC Driver for Azure Active Directory

Build 24.0.9175

Applications

Contains details of all registered applications within the organization for the authenticated user, including app-specific configurations.

Table Specific Information

Select

You can query Applications by specifying an Id or selecting all: 

SELECT * FROM Applications WHERE Id = '037c5534-1059-4c71-9f1c-a9b887e34b03'

Select a certain column from the entity and filter by that column: 

SELECT Id FROM Applications WHERE Id LIKE '%037c5534-1059-4c71-9f1c-a9b887e34b03%'

Insert

Specify a displayName in order to create a new Application, the displayName should be the name of the new Application: 

INSERT INTO Applications (displayName) VALUES ('TestApp')

Update

To update a Applications record you need to specify the Id in WHERE clause. 

UPDATE Applications SET displayName = 'Test' WHERE Id = '037c5534-1059-4c71-9f1c-a9b887e34b03'

Delete

To delete an Application record, you need to specify the Id in WHERE clause. 

DELETE FROM Applications WHERE Id = '480a2785-1c18-49ac-9a80-9dfc1b40e1f2'

Columns

Name Type ReadOnly Description
id [KEY] String False

The unique identifier of the application, used as the primary key.

addIns String False

A list of add-ins associated with the application, detailing additional functionalities.

api_acceptMappedClaims Bool False

Indicates whether the application accepts mapped claims in tokens.

api_knownClientApplications String False

A list of known client applications that this API trusts.

api_oauth2PermissionScopes String False

The OAuth2 permission scopes defined for the API of the application.

api_preAuthorizedApplications String False

Applications pre-authorized to call this application's API.

api_requestedAccessTokenVersion Int False

The version of access tokens requested by the application API.

appId String False

The globally unique application ID assigned to the application.

applicationTemplateId String False

The ID of the application template used during creation.

appRoles String False

Roles defined for the application that can be assigned to users or groups.

authenticationBehaviors_removeUnverifiedEmailClaim Bool False

Specifies if unverified email claims should be removed during authentication.

authenticationBehaviors_requireClientServicePrincipal Bool False

Indicates if a client service principal is required for authentication.

certification_certificationDetailsUrl String False

The URL providing details about the application's certification.

certification_certificationExpirationDateTime Datetime False

The date and time when the application's certification expires.

certification_isCertifiedByMicrosoft Bool False

Specifies if the application is certified by Microsoft.

certification_isPublisherAttested Bool False

Indicates if the application's publisher attested to its certification.

certification_lastCertificationDateTime Datetime False

The date and time of the application's last certification.

createdDateTime Datetime False

The date and time the application was created.

defaultRedirectUri String False

The default redirect URI used in the application's authentication flows.

description String False

A brief description of the application's purpose or functionality.

disabledByMicrosoftStatus String False

Indicates if the application is disabled by Microsoft and the reason for it.

displayName String False

The friendly name of the application, displayed in portals.

groupMembershipClaims String False

The claims related to group memberships that the application can receive.

identifierUris String False

The URIs that identify the application within its tenant.

info_logoUrl String False

The URL of the application's logo image.

info_marketingUrl String False

The URL of the application's marketing or promotional page.

info_privacyStatementUrl String False

The URL of the application's privacy policy.

info_supportUrl String False

The URL for the application's support page.

info_termsOfServiceUrl String False

The URL of the application's terms of service.

isDeviceOnlyAuthSupported Bool False

Indicates if the application supports authentication for devices only.

isFallbackPublicClient Bool False

Specifies if the application can fallback to public client behavior.

keyCredentials String False

The list of key credentials associated with the application for authentication.

logo String False

The binary data of the application's logo.

notes String False

Additional notes or metadata about the application.

oauth2RequirePostResponse Bool False

Indicates if the application requires a POST response for OAuth2 authorization.

optionalClaims_accessToken String False

Optional claims included in the application's access tokens.

optionalClaims_idToken String False

Optional claims included in the application's ID tokens.

optionalClaims_saml2Token String False

Optional claims included in the application's security assertion markup language 2.0 (SAML2) tokens.

parentalControlSettings_countriesBlockedForMinors String False

Countries where the application is blocked for minors, based on parental control settings.

parentalControlSettings_legalAgeGroupRule String False

Rules for age group restrictions applied to the application.

passwordCredentials String False

The list of password credentials associated with the application.

publicClient_redirectUris String False

Redirect URIs defined for public client flows of the application.

publisherDomain String False

The verified domain of the application publisher.

requiredResourceAccess String False

Resources and permissions the application requires for operation.

samlMetadataUrl String False

The metadata URL for security assertion markup language (SAML) integration with the application.

serviceManagementReference String False

A reference for managing the application's service configuration.

servicePrincipalLockConfiguration_isEnabled Bool False

Indicates if the service principal lock configuration is enabled.

servicePrincipalLockConfiguration_allProperties Bool False

Specifies if all properties of the service principal are locked.

servicePrincipalLockConfiguration_credentialsWithUsageVerify Bool False

Locks credentials used for verifying tokens in the application.

servicePrincipalLockConfiguration_credentialsWithUsageSign Bool False

Locks credentials used for signing tokens in the application.

servicePrincipalLockConfiguration_tokenEncryptionKeyId Bool False

Locks the token encryption key ID for the application.

signInAudience String False

Defines the audience that can sign in to the application.

spa_redirectUris String False

Redirect URIs defined for single-page applications.

tags String False

Custom tags associated with the application for organization.

tokenEncryptionKeyId String False

The ID of the token encryption key used by the application.

verifiedPublisher_addedDateTime Datetime False

The date and time when the publisher was verified.

verifiedPublisher_displayName String False

The display name of the verified publisher.

verifiedPublisher_verifiedPublisherId String False

The ID of the verified publisher of the application.

web_homePageUrl String False

The URL of the application's web homepage.

web_implicitGrantSettings_enableAccessTokenIssuance Bool False

Specifies if implicit grant access tokens are enabled for web applications.

web_implicitGrantSettings_enableIdTokenIssuance Bool False

Specifies if implicit grant ID tokens are enabled for web applications.

web_logoutUrl String False

The URL for logout redirection in the application.

web_redirectUris String False

Redirect URIs defined for web applications.

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