get_items
Query SharePoint list items with filtering, sorting, and pagination options to retrieve specific data from lists.
Instructions
Query items in a list. Supports OData $filter, $select, $orderby, $top, $skip, $expand.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| listName | Yes | ||
| filter | No | OData filter, e.g. "Status eq 'Active' and DueDate lt '2025-01-01'" | |
| select | No | Field internal names to return. | |
| orderBy | No | e.g. 'Title asc' or 'Modified desc' | |
| top | No | Max items to return (default: 100). | |
| skip | No | Skip N items (for paging). | |
| expand | No | Navigation properties to expand, e.g. ['Author', 'AssignedTo'] |