Skip to main content

webhooks

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

Overview

Namewebhooks
TypeResource
Idazure_extras.app_compliance_automation.webhooks

Fields

NameDatatypeDescription
content_typetextfield from the properties object
delivery_statustextfield from the properties object
enable_ssl_verificationtextfield from the properties object
eventstextfield from the properties object
payload_urltextfield from the properties object
provisioning_statetextfield from the properties object
reportNametextfield from the properties object
send_all_eventstextfield from the properties object
statustextfield from the properties object
tenant_idtextfield from the properties object
update_webhook_keytextfield from the properties object
webhookNametextfield from the properties object
webhook_idtextfield from the properties object
webhook_keytextfield from the properties object
webhook_key_enabledtextfield from the properties object

Methods

NameAccessible byRequired ParamsDescription
getSELECTreportName, webhookNameGet the AppComplianceAutomation webhook and its properties.
listSELECTreportNameGet the AppComplianceAutomation webhook list.
create_or_updateINSERTreportName, webhookName, data__propertiesCreate a new AppComplianceAutomation webhook or update an exiting AppComplianceAutomation webhook.
deleteDELETEreportName, webhookNameDelete an AppComplianceAutomation webhook.
updateUPDATEreportName, webhookNameUpdate an exiting AppComplianceAutomation webhook.

SELECT examples

Get the AppComplianceAutomation webhook list.

SELECT
content_type,
delivery_status,
enable_ssl_verification,
events,
payload_url,
provisioning_state,
reportName,
send_all_events,
status,
tenant_id,
update_webhook_key,
webhookName,
webhook_id,
webhook_key,
webhook_key_enabled
FROM azure_extras.app_compliance_automation.vw_webhooks
WHERE reportName = '{{ reportName }}';

INSERT example

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

/*+ create */
INSERT INTO azure_extras.app_compliance_automation.webhooks (
reportName,
webhookName,
data__properties,
properties
)
SELECT
'{{ reportName }}',
'{{ webhookName }}',
'{{ data__properties }}',
'{{ properties }}'
;

UPDATE example

Updates a webhooks resource.

/*+ update */
UPDATE azure_extras.app_compliance_automation.webhooks
SET
properties = '{{ properties }}'
WHERE
reportName = '{{ reportName }}'
AND webhookName = '{{ webhookName }}';

DELETE example

Deletes the specified webhooks resource.

/*+ delete */
DELETE FROM azure_extras.app_compliance_automation.webhooks
WHERE reportName = '{{ reportName }}'
AND webhookName = '{{ webhookName }}';