powerquery - 如何修复 Power Query 中的 Clockify 连接错误？

Question

我正在尝试从电源查询访问时钟，这是为了获取运营团队的时间记录并了解每个项目专用的时间，我具有以下功能：

    let
     url="https://api.clockify.me/api/workspaces/5e99b479a2686b699ed36/reports/summary/",
        content ="{
          ""startDate"": ""2020-01-01T00:00:00.000Z"",
          ""endDate"": ""2021-12-31T23:59:59.999Z"",
          ""me"": ""false"", 
          ""userGroupIds"": [],
          ""userIds"": [],
          ""projectIds"": [],
          ""clientIds"": [],
          ""taskIds"": [],
          ""tagIds"": [],
          ""billable"": ""BOTH"", 
          ""includeTimeEntries"": ""true"",
          ""zoomLevel"": ""week"", 
          ""description"": """",
          ""archived"": ""Active"", 
          ""roundingOn"": ""false"",
          ""groupingOn"": ""false"" 
    "/* ,
          ""groupedByDate"": ""false"",
          ""page"":0,
          ""count"":9999,
          ""sortDetailedBy"": ""timeAsc"" (Options: "description", "descriptionAsc", "userName", "userNameAsc", "duration", "durationAsc", "time", "timeAsc")
     */
           &" }",      
        Source = Json.Document(
                        Web.Contents(url,    [Headers=    [ #"X-Api-Key"="ZTIwMzBkZTUtMTk1NGUtNGQ3MmY2YmM5ZTZk"
                                                            ,ContentType="application/json"
                                                            ,#"Content-Type"="application/json"
                                                           ]
                                             ,Content=Text.ToBinary(content)
                                             ] 
                                     )
                                 )
in
Source

但是在加载以下功能电源查询时，它给了我消息：

它也给我这个错误

有人知道我该如何解决吗？

标签： powerqueryclockify