vw_api_diagnostics

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

Overview

Name	vw_api_diagnostics
Type	View
Id	azure.api_management.vw_api_diagnostics

Fields

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

SQL Definition

Sqlite3

SELECT
JSON_EXTRACT(properties, '$.alwaysLog') as "always_log",
JSON_EXTRACT(properties, '$.loggerId') as "logger_id",
JSON_EXTRACT(properties, '$.sampling') as "sampling",
JSON_EXTRACT(properties, '$.frontend') as "frontend",
JSON_EXTRACT(properties, '$.backend') as "backend",
JSON_EXTRACT(properties, '$.logClientIp') as "log_client_ip",
JSON_EXTRACT(properties, '$.httpCorrelationProtocol') as "http_correlation_protocol",
JSON_EXTRACT(properties, '$.verbosity') as "verbosity",
JSON_EXTRACT(properties, '$.operationNameFormat') as "operation_name_format",
JSON_EXTRACT(properties, '$.metrics') as "metrics",
subscriptionId,
resourceGroupName,
serviceName,
apiId,
diagnosticId
FROM azure.api_management.api_diagnostics
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serviceName = 'replace-me' AND apiId = 'replace-me';

Postgres

SELECT
json_extract_path_text(properties, '$.alwaysLog') as "always_log",
json_extract_path_text(properties, '$.loggerId') as "logger_id",
json_extract_path_text(properties, '$.sampling') as "sampling",
json_extract_path_text(properties, '$.frontend') as "frontend",
json_extract_path_text(properties, '$.backend') as "backend",
json_extract_path_text(properties, '$.logClientIp') as "log_client_ip",
json_extract_path_text(properties, '$.httpCorrelationProtocol') as "http_correlation_protocol",
json_extract_path_text(properties, '$.verbosity') as "verbosity",
json_extract_path_text(properties, '$.operationNameFormat') as "operation_name_format",
json_extract_path_text(properties, '$.metrics') as "metrics",
subscriptionId,
resourceGroupName,
serviceName,
apiId,
diagnosticId
FROM azure.api_management.api_diagnostics
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serviceName = 'replace-me' AND apiId = 'replace-me';