ODBC guide

Read attachments for an incident


Retrieve all file attachments linked to a specific incident. Attachments are stored in the sys_attachment table.

This example is commonly used before downloading or deleting attachments.

-- List attachments linked to an incident
SELECT *
FROM get_table_rows
WITH(
	TableName='sys_attachment',
	Query='table_name=incident^table_sys_id=<<INCIDENT_SYS_ID>>'
)