Skip to main content

workspace_apis

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

Overview

Nameworkspace_apis
TypeResource
Idazure.api_management.workspace_apis

Fields

NameDatatypeDescription
descriptiontextfield from the properties object
apiIdtextfield from the properties object
api_revisiontextfield from the properties object
api_revision_descriptiontextfield from the properties object
api_versiontextfield from the properties object
api_version_descriptiontextfield from the properties object
api_version_settextfield from the properties object
api_version_set_idtextfield from the properties object
authentication_settingstextfield from the properties object
contacttextfield from the properties object
display_nametextfield from the properties object
is_currenttextfield from the properties object
is_onlinetextfield from the properties object
licensetextfield from the properties object
pathtextfield from the properties object
protocolstextfield from the properties object
provisioning_statetextfield from the properties object
resourceGroupNametextfield from the properties object
serviceNametextfield from the properties object
service_urltextfield from the properties object
source_api_idtextfield from the properties object
subscriptionIdtextfield from the properties object
subscription_key_parameter_namestextfield from the properties object
subscription_requiredtextfield from the properties object
terms_of_service_urltextfield from the properties object
typetextfield from the properties object
workspaceIdtextfield from the properties object

Methods

NameAccessible byRequired ParamsDescription
getSELECTapiId, resourceGroupName, serviceName, subscriptionId, workspaceIdGets the details of the API specified by its identifier.
list_by_serviceSELECTresourceGroupName, serviceName, subscriptionId, workspaceIdLists all APIs of the workspace in an API Management service instance.
create_or_updateINSERTapiId, resourceGroupName, serviceName, subscriptionId, workspaceIdCreates new or updates existing specified API of the workspace in an API Management service instance.
deleteDELETEIf-Match, apiId, resourceGroupName, serviceName, subscriptionId, workspaceIdDeletes the specified API of the workspace in an API Management service instance.
updateUPDATEIf-Match, apiId, resourceGroupName, serviceName, subscriptionId, workspaceIdUpdates the specified API of the workspace in an API Management service instance.

SELECT examples

Lists all APIs of the workspace in an API Management service instance.

SELECT
description,
apiId,
api_revision,
api_revision_description,
api_version,
api_version_description,
api_version_set,
api_version_set_id,
authentication_settings,
contact,
display_name,
is_current,
is_online,
license,
path,
protocols,
provisioning_state,
resourceGroupName,
serviceName,
service_url,
source_api_id,
subscriptionId,
subscription_key_parameter_names,
subscription_required,
terms_of_service_url,
type,
workspaceId
FROM azure.api_management.vw_workspace_apis
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceId = '{{ workspaceId }}';

INSERT example

Use the following StackQL query and manifest file to create a new workspace_apis resource.

/*+ create */
INSERT INTO azure.api_management.workspace_apis (
apiId,
resourceGroupName,
serviceName,
subscriptionId,
workspaceId,
properties
)
SELECT
'{{ apiId }}',
'{{ resourceGroupName }}',
'{{ serviceName }}',
'{{ subscriptionId }}',
'{{ workspaceId }}',
'{{ properties }}'
;

UPDATE example

Updates a workspace_apis resource.

/*+ update */
UPDATE azure.api_management.workspace_apis
SET
properties = '{{ properties }}'
WHERE
If-Match = '{{ If-Match }}'
AND apiId = '{{ apiId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceId = '{{ workspaceId }}';

DELETE example

Deletes the specified workspace_apis resource.

/*+ delete */
DELETE FROM azure.api_management.workspace_apis
WHERE If-Match = '{{ If-Match }}'
AND apiId = '{{ apiId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceId = '{{ workspaceId }}';