Skip to main content

evidences

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

Overview

Nameevidences
TypeResource
Idazure_extras.app_compliance_automation.evidences

Fields

NameDatatypeDescription
control_idtextfield from the properties object
evidenceNametextfield from the properties object
evidence_typetextfield from the properties object
extra_datatextfield from the properties object
file_pathtextfield from the properties object
provisioning_statetextfield from the properties object
reportNametextfield from the properties object
responsibility_idtextfield from the properties object

Methods

NameAccessible byRequired ParamsDescription
getSELECTevidenceName, reportNameGet the evidence metadata
list_by_reportSELECTreportNameReturns a paginated list of evidences for a specified report.
create_or_updateINSERTevidenceName, reportName, data__propertiesCreate or Update an evidence a specified report
deleteDELETEevidenceName, reportNameDelete an existent evidence from a specified report
downloadEXECevidenceName, reportNameDownload evidence file.

SELECT examples

Returns a paginated list of evidences for a specified report.

SELECT
control_id,
evidenceName,
evidence_type,
extra_data,
file_path,
provisioning_state,
reportName,
responsibility_id
FROM azure_extras.app_compliance_automation.vw_evidences
WHERE reportName = '{{ reportName }}';

INSERT example

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

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

DELETE example

Deletes the specified evidences resource.

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