Query Attachments in Sage Business Cloud Accounting.

Table Specific Information

Query the available Attachments

Select

The driver uses the Sage Accounting API to process search criteria that refer to AttachmentContextTypeId,AttachmentContextId,LegacyAttachmentContextType,LegacyAttachmentContextId,UpdatedOrCreatedSince,DeletedSince columns. The driver processes other filters client-side within the driver.

• AttachmentContextTypeId supports the '=' operator.
• AttachmentContextId supports the '=' operator.
• LegacyAttachmentContextType supports the '=' operator.
• LegacyAttachmentContextId supports the '=' operator.
• UpdatedOrCreatedSince supports the '=' operator.
• DeletedSince supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM Attachments WHERE AttachmentContextTypeId='PURCHASE_CREDIT_NOTE'
SELECT * FROM Attachments WHERE AttachmentContextId='abc'
SELECT * FROM Attachments WHERE LegacyAttachmentContextType='abc'
SELECT * FROM Attachments WHERE LegacyAttachmentContextId='abc'
SELECT * FROM Attachments WHERE UpdatedOrCreatedSince='2018-12-15'
SELECT * FROM Attachments WHERE DeletedSince='2018-12-15'

Update

Updates are performed based on Id.

UPDATE Attachments SET FileExtension='abc' WHERE Id='123'

Delete

You must specify the Id of the Attachments to delete it.

DELETE FROM Attachments WHERE id ='123' 

Columns