使用Graph API更新SharePoint 365自定义元数据遇400错误求助

问题背景 #

尝试通过Graph API和Visual Basic修改SharePoint 365中的自定义文件元数据时，更新标准字段（如description）能返回200状态码并成功生效，但更新自定义字段时返回400错误，站点无任何更新。

原代码示例 #

Public Sub UpdateFileMeta(ByVal strFileID As String)
    'Dim fileId As String = "<file-id>"
    Dim metadata As New Dictionary(Of String, Object) From {
           {"certificate_x0020_no", "iop"}
    }

    ' Set the endpoint URL for updating file metadata
    Dim endpointUrl As String = "https://graph.microsoft.com/v1.0/sites/" & siteId

    ' Serialize the metadata values to JSON format
    Dim metadataJson As String = JsonConvert.SerializeObject(metadata)

    ' Create a new HTTP client and add the authorization header
    Dim client As New System.Net.Http.HttpClient()
    client.DefaultRequestHeaders.Authorization = New AuthenticationHeaderValue("Bearer", strAccessToken)

    ' Create a new HTTP request with the endpoint URL and HTTP method
    Dim request As New HttpRequestMessage(New HttpMethod("PATCH"), endpointUrl)

    ' Set the request content to the metadata JSON
    request.Content = New StringContent(metadataJson, Encoding.UTF8, "application/json")

    ' Send the request and get the response
    Dim response As HttpResponseMessage = client.SendAsync(request).Result

    ' Print the response status code and content
    Console.WriteLine("Response status code: " & response.StatusCode.ToString())
    Console.WriteLine("Response content: " & response.Content.ReadAsStringAsync().Result)
End Sub

关键信息 #

• 自定义字段显示名为Certificate No，通过Graph Explorer查询到的内部名称为Certificate_x0020_No，代码中使用了全小写的certificate_x0020_no
• 传入的文件标识格式：<tenant.sharepoint.com,<Site ID>,/drives/<drive id>/root:/Certificates+/<sub folder>+/<sub folder>/file name:/
• 自定义字段更新时返回400 Bad Request，标准字段更新正常

解决方案 #

Graph API完全支持更新SharePoint自定义元数据，问题出在以下核心错误点：

1. 字段名称大小写不匹配 #

Graph API对自定义字段的内部名称严格区分大小写，必须完全匹配Graph Explorer返回的精确值（包括大小写）。将代码中的字段名改为Certificate_x0020_No即可解决字段识别问题。

2. 请求端点错误 #

当前代码的端点仅指向SharePoint站点（https://graph.microsoft.com/v1.0/sites/{siteId}），但更新文件元数据必须指向具体的文件对象。正确的端点格式有两种：

• 通过文件ID：

  https://graph.microsoft.com/v1.0/sites/{site-id}/drives/{drive-id}/items/{item-id}
  

• 通过文件路径：

  https://graph.microsoft.com/v1.0/sites/{site-id}/drives/{drive-id}/root:/{folder-path}/{file-name}:/
  

3. 修正后的代码示例 #

Public Sub UpdateFileMeta(ByVal strFileID As String)
    ' 使用Graph Explorer返回的精确自定义字段内部名称
    Dim metadata As New Dictionary(Of String, Object) From {
           {"Certificate_x0020_No", "iop"}
    }

    ' 修正为指向具体文件的端点（替换为实际的siteId、driveId、路径和文件名）
    Dim endpointUrl As String = $"https://graph.microsoft.com/v1.0/sites/{siteId}/drives/{driveId}/root:/Certificates/{subFolder}/{subFolder}/{fileName}:""/"

    Dim metadataJson As String = JsonConvert.SerializeObject(metadata)

    ' 使用Using语句自动释放HttpClient资源
    Using client As New System.Net.Http.HttpClient()
        client.DefaultRequestHeaders.Authorization = New AuthenticationHeaderValue("Bearer", strAccessToken)

        Dim request As New HttpRequestMessage(HttpMethod.Patch, endpointUrl)
        request.Content = New StringContent(metadataJson, Encoding.UTF8, "application/json")

        Dim response As HttpResponseMessage = client.SendAsync(request).Result

        Console.WriteLine("Response status code: " & response.StatusCode.ToString())
        Console.WriteLine("Response content: " & response.Content.ReadAsStringAsync().Result)
    End Using
End Sub

额外排查建议 #

• 先通过Graph Explorer手动测试PATCH请求，确认端点和字段名称正确后再编写代码
• 查看400响应的具体JSON内容（代码中已打印response.Content），里面会包含精准的错误提示（如“字段不存在”），可快速定位问题
• 确保访问令牌拥有足够权限（至少Files.ReadWrite或Sites.ReadWrite.All），且自定义字段已绑定到目标文档库

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