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.
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. |