List SharePoint List Items
sharepoint_list_list_itemsRetrieve items and field values from a SharePoint list, using optional OData filters on indexed columns to return only matching records.
Instructions
List items and field values in a SharePoint list. Optional filters work best on indexed columns. Requires delegated Sites.Read.All. Chinese intents / 中文意图: 查看SharePoint列表项, 读取SharePoint清单数据, 查询列表记录, 筛选SharePoint列表.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top | No | Number of list items to return, from 1 to 100. | |
| filter | No | Optional OData filter, for example fields/Status eq 'Open'. Prefer indexed columns. | |
| listId | Yes | SharePoint list ID from sharepoint_list_lists. | |
| siteId | Yes | SharePoint site ID. | |
| fieldNames | No | Optional SharePoint internal column names to return. Omit to return all available fields. |