Read a permission matrix
get_permission_matrixRetrieves a permission matrix from a SharePoint Excel worksheet, converting it into structured JSON records for automated QA workflows.
Instructions
Read a worksheet as structured records, using the header row as keys. Note that maxRows/offset/filter/columns are applied AFTER the full sheet is fetched: they bound what you receive, not what is transferred. If the result is truncated, narrow it with filter or columns first, and only page with offset as a fallback.
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "get_permission_matrix"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| link | No | SharePoint sharing link (…/:x:/s/Site/TOKEN?e=code) or a direct document URL. Omit if supplying driveId and itemId. | |
| sheet | No | Worksheet name. Defaults to the first sheet. | |
| filter | No | Server-side row filter, applied before maxRows. | |
| itemId | No | Item ID from resolve_link. Use with driveId. | |
| offset | No | Records to skip. Default 0. | |
| columns | No | Return only these columns. Greatly reduces payload on wide matrices. | |
| driveId | No | Drive ID from resolve_link. Use with itemId. | |
| maxRows | No | Maximum records to return. Default 500. | |
| headerRow | No | 1-indexed header row. Default 1. |