vw_api_collections

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

Overview

Name	vw_api_collections
Type	View
Id	azure.security.vw_api_collections

Fields

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

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
type as type,
systemData as system_data,
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.discoveredVia') as "discovered_via",
JSON_EXTRACT(properties, '$.baseUrl') as "base_url",
JSON_EXTRACT(properties, '$.numberOfApiEndpoints') as "number_of_api_endpoints",
JSON_EXTRACT(properties, '$.numberOfInactiveApiEndpoints') as "number_of_inactive_api_endpoints",
JSON_EXTRACT(properties, '$.numberOfUnauthenticatedApiEndpoints') as "number_of_unauthenticated_api_endpoints",
JSON_EXTRACT(properties, '$.numberOfExternalApiEndpoints') as "number_of_external_api_endpoints",
JSON_EXTRACT(properties, '$.numberOfApiEndpointsWithSensitiveDataExposed') as "number_of_api_endpoints_with_sensitive_data_exposed",
JSON_EXTRACT(properties, '$.sensitivityLabel') as "sensitivity_label",
subscriptionId,
resourceGroupName,
serviceName,
apiId
FROM azure.security.api_collections
WHERE subscriptionId = 'replace-me';

Postgres

SELECT
id as id,
name as name,
type as type,
systemData as system_data,
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.displayName') as "display_name",
json_extract_path_text(properties, '$.discoveredVia') as "discovered_via",
json_extract_path_text(properties, '$.baseUrl') as "base_url",
json_extract_path_text(properties, '$.numberOfApiEndpoints') as "number_of_api_endpoints",
json_extract_path_text(properties, '$.numberOfInactiveApiEndpoints') as "number_of_inactive_api_endpoints",
json_extract_path_text(properties, '$.numberOfUnauthenticatedApiEndpoints') as "number_of_unauthenticated_api_endpoints",
json_extract_path_text(properties, '$.numberOfExternalApiEndpoints') as "number_of_external_api_endpoints",
json_extract_path_text(properties, '$.numberOfApiEndpointsWithSensitiveDataExposed') as "number_of_api_endpoints_with_sensitive_data_exposed",
json_extract_path_text(properties, '$.sensitivityLabel') as "sensitivity_label",
subscriptionId,
resourceGroupName,
serviceName,
apiId
FROM azure.security.api_collections
WHERE subscriptionId = 'replace-me';