SSIS Components for Microsoft SharePoint

Build 24.0.9060

Attachments

Reads attachments to the specified item to 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 to 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

Lists.Title

The internal name of the list to retrieve attachments from.
ItemID Int The Id of the item in the list to retrieve attachments from.

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