使用Microsoft Graph SDK时GetConfig配置查询字段报错问题

问题背景 #

我正在开发调用Microsoft Graph SDK的API，用于获取租户的Teams列表。以下代码可正常运行，返回Teams的所有字段：

_clientSecretCredential = new ClientSecretCredential("TenantId", "ClientId", "Secret");
_appClient = new GraphServiceClient(_clientSecretCredential,
// 使用默认范围，会请求应用注册中配置的权限范围
new[] { "https://graph.microsoft.com/.default" });
TeamCollectionResponse _rsp = new TeamCollectionResponse();

return await _appClient.Teams.GetAsync();

但当我尝试通过配置仅获取指定字段时，Graph返回OData错误，相关代码如下：

_clientSecretCredential = new ClientSecretCredential("TenantId", "ClientId", "Secret");
_appClient = new GraphServiceClient(_clientSecretCredential,
// 使用默认范围，会请求应用注册中配置的权限范围
new[] { "https://graph.microsoft.com/.default" });
TeamCollectionResponse _rsp = new TeamCollectionResponse();

return await _appClient.Teams.GetAsync((config) =>
{
    // 仅请求特定属性
    config.QueryParameters.Select = new[] { "displayName", "id" };
    // 最多获取2条结果
    config.QueryParameters.Top = 2;
    // 按显示名称排序
    config.QueryParameters.Orderby = new[] { "displayName" };
});

错误信息 #

Microsoft.Graph.Models.ODataErrors.ODataError: Exception of type 'Microsoft.Graph.Models.ODataErrors.ODataError' was thrown.
at Microsoft.Kiota.Http.HttpClientLibrary.HttpClientRequestAdapter.ThrowIfFailedResponse(HttpResponseMessage response, Dictionary2 errorMapping, Activity activityForAttributes) at Microsoft.Kiota.Http.HttpClientLibrary.HttpClientRequestAdapter.SendAsync[ModelType](RequestInformation requestInfo, ParsableFactory1 factory, Dictionary2 errorMapping, CancellationToken cancellationToken) at Microsoft.Kiota.Http.HttpClientLibrary.HttpClientRequestAdapter.SendAsync[ModelType](RequestInformation requestInfo, ParsableFactory1 factory, Dictionary2 errorMapping, CancellationToken cancellationToken) at Microsoft.Graph.Teams.TeamsRequestBuilder.GetAsync(Action1 requestConfiguration, CancellationToken cancellationToken)
at SmartUCC.API.Controllers.TeamsController.GetAllTeams(String tenantId) in C:\Users\rupena\Documents\VerizonTeams\API\SmartUCC.API\SmartUCC.API\SmartUCC.API\Controllers\TeamsController.cs:line 80
at lambda_method6(Closure, Object)
at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)

问题原因与解决方案 #

原因 #

Microsoft Graph的Teams列表接口不支持$select查询参数，即使官方文档存在相关示例，但实际调用时该接口不允许指定返回字段，使用Select配置会触发OData错误。

解决方案 #

1. 移除Select配置，保留其他查询参数
   直接去掉config.QueryParameters.Select的配置，Top和Orderby参数可以正常使用：

   return await _appClient.Teams.GetAsync((config) =>
   {
       config.QueryParameters.Top = 2;
       config.QueryParameters.Orderby = new[] { "displayName" };
   });
   

2. 本地筛选所需字段
   如果仅需要特定字段，可在获取完整结果后在本地进行数据过滤：

   var allTeams = await _appClient.Teams.GetAsync((config) =>
   {
       config.QueryParameters.Top = 2;
       config.QueryParameters.Orderby = new[] { "displayName" };
   });
   
   // 本地提取需要的字段
   var filteredTeams = allTeams.Value.Select(t => new 
   { 
       Id = t.Id, 
       DisplayName = t.DisplayName 
   }).ToList();
   return filteredTeams;
   

补充说明 #

部分Microsoft Graph接口存在文档与实际行为不一致的情况，Teams列表接口就是典型案例。通过客户端凭据流调用时，该接口强制返回所有默认字段，无法通过$select进行字段过滤，只能在客户端自行处理数据。

内容的提问来源于stack exchange，提问作者TechTurtle