ODBC Driver for Microsoft SharePoint

Build 23.0.8839

Attachments

Reads attachments for the specified item on the specified list.

Table Specific Information

Select

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

Columns

Name Type References Description
Id [KEY] String The Id of the attachment on the item.
Updated Datetime The updated date of the attachment to the item.
FileName String The FileName of the attachment to the item.
ServerRelativePath_DecodedUrl String The ServerRelativePath DecodedUrl of the attachment to the item.
FileNameAsPath_DecodedUrl String The FileNameAsPath DecodedUrl of the attachment to the item.
ServerRelativeUrl String The ServerRelativeUrl of the attachment to the item.
List String The internal name of the list to retrieve attachments from.
ItemID String The Id of the item on the list to retrieve attachments from.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839