Skip to main content

vw_identity_providers

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

Overview​

Namevw_identity_providers
TypeView
Idazure.api_management.vw_identity_providers

Fields​

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

SQL Definition​

SELECT
JSON_EXTRACT(properties, '$.clientId') as "client_id",
JSON_EXTRACT(properties, '$.clientSecret') as "client_secret",
JSON_EXTRACT(properties, '$.type') as "type",
JSON_EXTRACT(properties, '$.signinTenant') as "signin_tenant",
JSON_EXTRACT(properties, '$.allowedTenants') as "allowed_tenants",
JSON_EXTRACT(properties, '$.authority') as "authority",
JSON_EXTRACT(properties, '$.signupPolicyName') as "signup_policy_name",
JSON_EXTRACT(properties, '$.signinPolicyName') as "signin_policy_name",
JSON_EXTRACT(properties, '$.profileEditingPolicyName') as "profile_editing_policy_name",
JSON_EXTRACT(properties, '$.passwordResetPolicyName') as "password_reset_policy_name",
JSON_EXTRACT(properties, '$.clientLibrary') as "client_library",
subscriptionId,
resourceGroupName,
serviceName,
identityProviderName
FROM azure.api_management.identity_providers
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serviceName = 'replace-me';