Excel Add-In for Azure Active Directory

Build 24.0.9062

Applications

Retrieves all applications for the authenticated user.

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 id of the application.

addIns String False

The addIns of the application.

api_acceptMappedClaims Bool False

The api_acceptMappedClaims of the application.

api_knownClientApplications String False

The api_knownClientApplications of the application.

api_oauth2PermissionScopes String False

The api_oauth2PermissionScopes of the application.

api_preAuthorizedApplications String False

The api_preAuthorizedApplications of the application.

api_requestedAccessTokenVersion Int False

The api_requestedAccessTokenVersion of the application.

appId String False

The appId of the application.

applicationTemplateId String False

The applicationTemplateId of the application.

appRoles String False

The appRoles of the application.

authenticationBehaviors_removeUnverifiedEmailClaim Bool False

The authenticationBehaviors_removeUnverifiedEmailClaim of the application.

authenticationBehaviors_requireClientServicePrincipal Bool False

The authenticationBehaviors_requireClientServicePrincipal of the application.

certification_certificationDetailsUrl String False

The certification_certificationDetailsUrl of the application.

certification_certificationExpirationDateTime Datetime False

The certification_certificationExpirationDateTime of the application.

certification_isCertifiedByMicrosoft Bool False

The certification_isCertifiedByMicrosoft of the application.

certification_isPublisherAttested Bool False

The certification_isPublisherAttested of the application.

certification_lastCertificationDateTime Datetime False

The certification_lastCertificationDateTime of the application.

createdDateTime Datetime False

The createdDateTime of the application.

defaultRedirectUri String False

The defaultRedirectUri of the application.

description String False

The description of the application.

disabledByMicrosoftStatus String False

The disabledByMicrosoftStatus of the application.

displayName String False

The displayName of the application.

groupMembershipClaims String False

The groupMembershipClaims of the application.

identifierUris String False

The identifierUris of the application.

info_logoUrl String False

The info_logoUrl of the application.

info_marketingUrl String False

The info_marketingUrl of the application.

info_privacyStatementUrl String False

The info_privacyStatementUrl of the application.

info_supportUrl String False

The info_supportUrl of the application.

info_termsOfServiceUrl String False

The info_termsOfServiceUrl of the application.

isDeviceOnlyAuthSupported Bool False

The isDeviceOnlyAuthSupported of the application.

isFallbackPublicClient Bool False

The isFallbackPublicClient of the application.

keyCredentials String False

The keyCredentials of the application.

logo String False

The logo of the application.

notes String False

The notes of the application.

oauth2RequirePostResponse Bool False

The oauth2RequirePostResponse of the application.

optionalClaims_accessToken String False

The optionalClaims_accessToken of the application.

optionalClaims_idToken String False

The optionalClaims_idToken of the application.

optionalClaims_saml2Token String False

The optionalClaims_saml2Token of the application.

parentalControlSettings_countriesBlockedForMinors String False

The parentalControlSettings_countriesBlockedForMinors of the application.

parentalControlSettings_legalAgeGroupRule String False

The parentalControlSettings_legalAgeGroupRule of the application.

passwordCredentials String False

The passwordCredentials of the application.

publicClient_redirectUris String False

The publicClient_redirectUris of the application.

publisherDomain String False

The publisherDomain of the application.

requiredResourceAccess String False

The requiredResourceAccess of the application.

samlMetadataUrl String False

The samlMetadataUrl of the application.

serviceManagementReference String False

The serviceManagementReference of the application.

servicePrincipalLockConfiguration_isEnabled Bool False

The servicePrincipalLockConfiguration_isEnabled of the application.

servicePrincipalLockConfiguration_allProperties Bool False

The servicePrincipalLockConfiguration_allProperties of the application.

servicePrincipalLockConfiguration_credentialsWithUsageVerify Bool False

The servicePrincipalLockConfiguration_credentialsWithUsageVerify of the application.

servicePrincipalLockConfiguration_credentialsWithUsageSign Bool False

The servicePrincipalLockConfiguration_credentialsWithUsageSign of the application.

servicePrincipalLockConfiguration_tokenEncryptionKeyId Bool False

The servicePrincipalLockConfiguration_tokenEncryptionKeyId of the application.

signInAudience String False

The signInAudience of the application.

spa_redirectUris String False

The spa_redirectUris of the application.

tags String False

The tags of the application.

tokenEncryptionKeyId String False

The tokenEncryptionKeyId of the application.

verifiedPublisher_addedDateTime Datetime False

The verifiedPublisher_addedDateTime of the application.

verifiedPublisher_displayName String False

The verifiedPublisher_displayName of the application.

verifiedPublisher_verifiedPublisherId String False

The verifiedPublisher_verifiedPublisherId of the application.

web_homePageUrl String False

The web_homePageUrl of the application.

web_implicitGrantSettings_enableAccessTokenIssuance Bool False

The web_implicitGrantSettings_enableAccessTokenIssuance of the application.

web_implicitGrantSettings_enableIdTokenIssuance Bool False

The web_implicitGrantSettings_enableIdTokenIssuance of the application.

web_logoutUrl String False

The web_logoutUrl of the application.

web_redirectUris String False

The web_redirectUris of the application.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062