ListItems
Represents all items within SharePoint lists, including standard columns applicable across different lists. Useful for bulk data extraction and reporting.
Columns
| Name | Type | References | Description |
| ID [KEY] | Int | A unique numeric identifier assigned to the list item. Useful for referencing specific items in workflows and API queries. | |
| Title | String | The title or name of the list item. Helps in quickly identifying and organizing items within the list. | |
| Attachments | Bool | Indicates whether the list item has one or more attachments. Useful for managing related documents or files. | |
| Description | String | A detailed description of the list item. Helps provide additional context or metadata for the item. | |
| List [KEY] | String |
Lists.Title | The display name of the SharePoint list containing the item. Useful for identifying the source list when retrieving items. |
| ContentTypeID | String | The identifier for the content type associated with the item. Helps enforce metadata structures and define item types. | |
| FileSystemObjectType | Int | Indicates the type of object in the file system. Possible values: '-1' (Invalid), '0' (File), '1' (Folder), '2' (Web). Useful for distinguishing between files, folders, and site components. | |
| GUID | String | A globally unique identifier (GUID) assigned to the item. Ensures distinct identification across SharePoint environments. | |
| Version | String | The version number of the item, indicating its revision history. Useful for tracking changes and rollback purposes. | |
| CreatedBy | Int |
Users.Id | The unique identifier of the user who created the item. Useful for tracking authorship and permissions. |
| ModifiedBy | Int |
Users.Id | The unique identifier of the last user who edited the item. Helps monitor recent changes and user contributions. |
| Created | Datetime | The date and time when the item was originally created. Useful for tracking item lifecycle and auditing changes. | |
| Modified | Datetime | The date and time when the item was last modified. Helps identify recent updates and maintain version history. |