Skip to main content

metadata_schemas

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

Overview

Namemetadata_schemas
TypeResource
Idazure.api_center.metadata_schemas

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}".
namestringThe name of the resource.
assignedToarrayThe assignees.
schemastringThe schema defining the type. Required.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, service_name, metadata_schema_name, subscription_idReturns details of the metadata schema.
listselectresource_group_name, service_name, subscription_id$filterReturns a collection of metadata schemas.
create_or_updateinsertresource_group_name, service_name, metadata_schema_name, subscription_idCreates new or updates existing metadata schema.
create_or_updatereplaceresource_group_name, service_name, metadata_schema_name, subscription_idCreates new or updates existing metadata schema.
deletedeleteresource_group_name, service_name, metadata_schema_name, subscription_idDeletes specified metadata schema.
headexecresource_group_name, service_name, metadata_schema_name, subscription_idChecks if specified metadata schema exists.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
metadata_schema_namestringThe name of the metadata schema. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
service_namestringThe name of Azure API Center service. Required.
subscription_idstring
$filterstringOData filter parameter. Default value is None.

SELECT examples

Returns details of the metadata schema.

SELECT
id,
name,
assignedTo,
schema,
systemData,
type
FROM azure.api_center.metadata_schemas
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND service_name = '{{ service_name }}' -- required
AND metadata_schema_name = '{{ metadata_schema_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Creates new or updates existing metadata schema.

INSERT INTO azure.api_center.metadata_schemas (
properties,
resource_group_name,
service_name,
metadata_schema_name,
subscription_id
)
SELECT
'{{ properties }}',
'{{ resource_group_name }}',
'{{ service_name }}',
'{{ metadata_schema_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

REPLACE examples

Creates new or updates existing metadata schema.

REPLACE azure.api_center.metadata_schemas
SET
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND service_name = '{{ service_name }}' --required
AND metadata_schema_name = '{{ metadata_schema_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

DELETE examples

Deletes specified metadata schema.

DELETE FROM azure.api_center.metadata_schemas
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND service_name = '{{ service_name }}' --required
AND metadata_schema_name = '{{ metadata_schema_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

Checks if specified metadata schema exists.

EXEC azure.api_center.metadata_schemas.head 
@resource_group_name='{{ resource_group_name }}' --required,
@service_name='{{ service_name }}' --required,
@metadata_schema_name='{{ metadata_schema_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
;