JDBC Driver for Microsoft SharePoint

Build 22.0.8462

Attachments

Read 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 on the item.
FileName String The FileName of the attachment on the item.
ServerRelativePath_DecodedUrl String The ServerRelativePath DecodedUrl of the attachment on the item.
FileNameAsPath_DecodedUrl String The FileNameAsPath DecodedUrl of the attachment on the item.
ServerRelativeUrl String The ServerRelativeUrl of the attachment on 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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462