api_issues

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

Overview

Name	api_issues
Type	Resource
Id	azure.api_management.api_issues

Fields

vw_api_issues

Name	Datatype	Description
description	text	field from the properties object
apiId	text	field from the properties object
api_id	text	field from the properties object
created_date	text	field from the properties object
issueId	text	field from the properties object
resourceGroupName	text	field from the properties object
serviceName	text	field from the properties object
state	text	field from the properties object
subscriptionId	text	field from the properties object
title	text	field from the properties object
user_id	text	field from the properties object

api_issues

Name	Datatype	Description
properties	object	Issue contract Properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	apiId, issueId, resourceGroupName, serviceName, subscriptionId	Gets the details of the Issue for an API specified by its identifier.
list_by_service	SELECT	apiId, resourceGroupName, serviceName, subscriptionId	Lists all issues associated with the specified API.
create_or_update	INSERT	apiId, issueId, resourceGroupName, serviceName, subscriptionId	Creates a new Issue for an API or updates an existing one.
delete	DELETE	If-Match, apiId, issueId, resourceGroupName, serviceName, subscriptionId	Deletes the specified Issue from an API.
update	UPDATE	If-Match, apiId, issueId, resourceGroupName, serviceName, subscriptionId	Updates an existing issue for an API.

SELECT examples

Lists all issues associated with the specified API.

vw_api_issues

SELECT
description,
apiId,
api_id,
created_date,
issueId,
resourceGroupName,
serviceName,
state,
subscriptionId,
title,
user_id
FROM azure.api_management.vw_api_issues
WHERE apiId = '{{ apiId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}';

api_issues

SELECT
properties
FROM azure.api_management.api_issues
WHERE apiId = '{{ apiId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: title
          value: string
        - name: description
          value: string
        - name: userId
          value: string
        - name: createdDate
          value: string
        - name: state
          value: string
        - name: apiId
          value: string

UPDATE example

Updates a api_issues resource.

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

DELETE example

Deletes the specified api_issues resource.

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