How Can I Download ServiceNow Attachments?

Question

I included the SYS_ATTACHMENT table in my connection schema, but it only includes the file metadata, such as the name, type, and size. It does not include download link.

How can I access or download the actual attachment files?

Environment

Connector: ServiceNow

Answer

To access attachment file data, use the SYS_ATTACHMENT_DOC table, which stores the raw contents of each attachment. To combine file metadata with file contents, join the SYS_ATTACHMENT_DOC and SYS_ATTACHMENT tables using the sys_attachment key. This gives you records that include both the attachment details and the underlying file data.