Attachments
Manages attachments for SharePoint list items, allowing retrieval and deletion. Essential for users who frequently handle file attachments within SharePoint.
Table Specific Information
Select
The List and ItemId columns are required to return Attachments.
Sample Query
The following query retrieves attachments from the list named MyAttachmentList for the item with ItemId = 4:
SELECT * FROM Attachments WHERE List = 'MyAttachmentList' AND ItemId = 4;
Insert
Call the AddAttachment stored procedure to add new attachments to a list item.
Columns
| Name | Type | ReadOnly | Description |
| Url [KEY] | String | True |
The URL path to the attachment file. Useful for accessing or downloading the attachment. |
| List | String | True |
The internal name of the SharePoint list containing the attachment. Helps identify the source list for the attachment. |
| ListDisplayName | String | True |
The display name of the SharePoint list containing the attachment. Useful for user-friendly identification of the list. |
| ItemID | String | True |
The unique identifier of the item in the list to which the attachment is linked. Helps track associated files. |
| Name | String | True |
The name of the attachment file. Useful for displaying file names and managing attachments. |