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. |