vw_api_operations

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

Overview

Name	vw_api_operations
Type	View
Id	azure.api_management.vw_api_operations

Fields

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

SQL Definition

Sqlite3

SELECT
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.method') as "method",
JSON_EXTRACT(properties, '$.urlTemplate') as "url_template",
JSON_EXTRACT(properties, '$.templateParameters') as "template_parameters",
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.request') as "request",
JSON_EXTRACT(properties, '$.responses') as "responses",
JSON_EXTRACT(properties, '$.policies') as "policies",
subscriptionId,
resourceGroupName,
serviceName,
apiId,
operationId
FROM azure.api_management.api_operations
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serviceName = 'replace-me' AND apiId = 'replace-me';

Postgres

SELECT
json_extract_path_text(properties, '$.displayName') as "display_name",
json_extract_path_text(properties, '$.method') as "method",
json_extract_path_text(properties, '$.urlTemplate') as "url_template",
json_extract_path_text(properties, '$.templateParameters') as "template_parameters",
json_extract_path_text(properties, '$.description') as "description",
json_extract_path_text(properties, '$.request') as "request",
json_extract_path_text(properties, '$.responses') as "responses",
json_extract_path_text(properties, '$.policies') as "policies",
subscriptionId,
resourceGroupName,
serviceName,
apiId,
operationId
FROM azure.api_management.api_operations
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serviceName = 'replace-me' AND apiId = 'replace-me';