fix(microsoft-excel): decide SharePoint site discovery consent model

未关闭
#7,197 1 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看

维护者通常 1 天内回复

@Zoymusk 已经在做这个了。

开始于 2026年9月19日。

评估

难度
5/5
预计耗时
一周以上
新手友好度
35/100
Issue 类型
功能
描述清晰度
基本清楚
活跃度
活跃
技术栈
typescript

调研方向

Start by tracing the Excel OAuth consent and SharePoint site selector credential-binding paths, then review the focused permission/binding tests and Microsoft Graph site-search requirements. Done means the supported credential model is documented and implemented consistently, unsupported credentials show a clear product-level error, live work-or-school validation is covered, and existing Excel file operations still work.

由索引模型根据 Issue 内容生成。

描述

Summary

Microsoft Excel credentials can now be recognized by the SharePoint site selector, but the existing Excel OAuth consent does not authorize Microsoft Graph site search.

Graph site search requires Sites.Read.All. Sim’s Excel connection currently requests file permissions only, so an ordinary existing Excel credential should be expected to receive a 403. The endpoint also does not support delegated personal Microsoft accounts.

This is a pre-existing consent-model limitation, not a selector transport or credential-binding bug.

Decision needed

Choose and implement one supported model:

  1. Add Sites.Read.All to the standard Excel consent and require existing users to reconnect/reconsent.
  2. Add conditional or incremental consent when SharePoint site discovery is requested.
  3. Require a separate SharePoint credential for site discovery and narrow the Excel selector compatibility accordingly.

The decision should account for least privilege, reconnect UX, existing credentials, and personal-account behavior.

Acceptance criteria

  • The supported Excel/SharePoint credential model is documented.
  • OAuth scopes, reconnect/reconsent behavior, and selector credential binding agree.
  • Unsupported credentials receive a clear product-level error.
  • Focused permission/binding tests and live work-or-school tenant validation are added.
  • Existing Excel file operations continue to work.

Reference

Microsoft Graph site search requires Sites.Read.All and does not support delegated personal Microsoft accounts:

https://learn.microsoft.com/en-us/graph/api/site-search?tabs=http&view=graph-rest-1.0

主要语言
TypeScript
星标
29.8k
派生
3.9k
平均合并
1 小时 44 分钟
30 天内合并 PR
841

环境准备

这个项目没有提供开发容器、Dockerfile 或贡献指南,环境需要你自己搭建:先看它的 README,通用步骤见我们的新手贡献指南。

从这里开始

  1. 先读完整个 Issue,再读项目的贡献指南。
  2. 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
  3. Fork 仓库,在一个分支上完成修改。
  4. 提交 Pull Request,并在描述里引用这个 Issue 编号。

simstudioai/sim 的其他 Issue

查看 simstudioai/sim 的全部 Issue

相似的 Issue

更多 TypeScript Issue

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。