api_issue_comments

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

Overview

Name	api_issue_comments
Type	Resource
Id	azure.api_management.api_issue_comments

Fields

vw_api_issue_comments

Name	Datatype	Description
apiId	text	field from the properties object
commentId	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
subscriptionId	text	field from the properties object
text	text	field from the properties object
user_id	text	field from the properties object

api_issue_comments

Name	Datatype	Description
properties	object	Issue Comment contract Properties.

Methods

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

SELECT examples

Lists all comments for the Issue associated with the specified API.

vw_api_issue_comments

SELECT
apiId,
commentId,
created_date,
issueId,
resourceGroupName,
serviceName,
subscriptionId,
text,
user_id
FROM azure.api_management.vw_api_issue_comments
WHERE apiId = '{{ apiId }}'
AND issueId = '{{ issueId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}';

api_issue_comments

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

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: text
          value: string
        - name: createdDate
          value: string
        - name: userId
          value: string

DELETE example

Deletes the specified api_issue_comments resource.

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