SSIS Components for Microsoft SharePoint

Build 24.0.9175

ListItems

This view represents general SharePoint items containing standard columns across various SharePoint lists.

Columns

Name Type References Description
ID [KEY] Int Unique identifier for the list item.
Title String Title of the list item.
Attachments Bool Indicates if the item has attachments.
Description String Detailed description of the item.
List [KEY] String

Lists.Title

The display name of the list to retrieve items from.
ContentTypeID String Identifier for the content type of the item.
FileSystemObjectType Int Indicates the type of object in the file system, such as: '-1': Invalid, '0': File, '1': Folder, '2': Web.
GUID String Globally unique identifier for the item.
Version String The version string of the item indicates its version history.
CreatedBy Int

Users.Id

Identifier for the author of the item.
ModifiedBy Int

Users.Id

Identifier for the last editor of the item.
Created Datetime Date and time when the item was created.
Modified Datetime Date and time when the item was last modified.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175