Skip to main content

vw_authorization_servers

Creates, updates, deletes, gets or lists a vw_authorization_servers resource.

Overview​

Namevw_authorization_servers
TypeView
Idazure.api_management.vw_authorization_servers

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.useInTestConsole') as "use_in_test_console",
JSON_EXTRACT(properties, '$.useInApiDocumentation') as "use_in_api_documentation",
JSON_EXTRACT(properties, '$.clientRegistrationEndpoint') as "client_registration_endpoint",
JSON_EXTRACT(properties, '$.authorizationEndpoint') as "authorization_endpoint",
JSON_EXTRACT(properties, '$.grantTypes') as "grant_types",
JSON_EXTRACT(properties, '$.clientId') as "client_id",
JSON_EXTRACT(properties, '$.clientSecret') as "client_secret",
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.authorizationMethods') as "authorization_methods",
JSON_EXTRACT(properties, '$.clientAuthenticationMethod') as "client_authentication_method",
JSON_EXTRACT(properties, '$.tokenBodyParameters') as "token_body_parameters",
JSON_EXTRACT(properties, '$.tokenEndpoint') as "token_endpoint",
JSON_EXTRACT(properties, '$.supportState') as "support_state",
JSON_EXTRACT(properties, '$.defaultScope') as "default_scope",
JSON_EXTRACT(properties, '$.bearerTokenSendingMethods') as "bearer_token_sending_methods",
JSON_EXTRACT(properties, '$.resourceOwnerUsername') as "resource_owner_username",
JSON_EXTRACT(properties, '$.resourceOwnerPassword') as "resource_owner_password",
subscriptionId,
resourceGroupName,
serviceName,
authsid
FROM azure.api_management.authorization_servers
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serviceName = 'replace-me';