ListItems
Represents all items within SharePoint lists, including standard columns applicable across different lists. Useful for bulk data extraction and reporting.
View-Specific Information
To retrieve records from the ListItems view, you must specify the List column. This identifies the Microsoft SharePoint list from which items should be fetched.
Sample Query
The following query retrieves all items from the list named List1:
SELECT * FROM CData.REST.ListItems WHERE List = 'List1';
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. |