Attachments

Retrieves attachments associated with a specific list item in a SharePoint list. Helps manage and track attached files related to SharePoint items.

Table Specific Information

Note: List and ItemId are required to return Attachments.

List can be fetched from the Lists view(Title column).

SELECT * FROM Attachments WHERE List = 'TestApp' AND ItemID = 1


Name	Type	References	Description
Id [KEY]	String		A unique identifier for the attachment associated with the list item. Useful for referencing attachments in automation and API calls.
Updated	Datetime		The date and time when the attachment was last modified. Helps track recent updates to file attachments.
FileName	String		The name of the attached file, including its extension. Useful for identifying and managing attachments.
FileExtension	String		The file extension of the attachment.
ServerRelativePath_DecodedUrl	String		The decoded server-relative path of the attachment. Helps in constructing URLs for accessing attachments within SharePoint.
FileNameAsPath_DecodedUrl	String		The decoded file path representation of the attachment’s name. Useful for programmatically referencing attachments.
ServerRelativeUrl	String		The server-relative URL of the attachment. Provides a direct path to the file within SharePoint for internal linking.
ItemURL	String		A browsable link to the attachment.
List	String	Lists.Title	The internal name of the SharePoint list that contains the attachment. Useful for identifying the source list when retrieving attachments.
ItemID	Int		The unique identifier of the list item to which the attachment belongs. Helps in linking attachments to specific records.