REST API and 1000ft

[SRS11]

My client a 10kft user wants me to bring data into Power Bi and I am struggling to get the query to work properly. The fields in the output go to default views and not as I specify, am I missing something. I have tried and searched many times over and now need some help....
See query for Power Bi below.
The body section may as well not be there.

let
url = "https://api.10000ft.com/api/v1/reports/rows?auth=api-key-here",

body = "{
""view"": ""utilization"",
""time_frame"": {
""from"": ""2020-04-01"",
""to"": ""2021-04-14""
},
""group_by"": ""user-id"",
""today"": ""2021-04-15"",
""calc_incurred"": ""confirmed-unconfirmed""
}",

Source = Json.Document(Web.Contents(url,
[
Headers = [#"Content-Type"="application/x-www-form-urlencoded"],
Content=Text.ToBinary(body)
]
)
),
#"Converted to Table" = Record.ToTable(Source)

[lbendlin · Accepted solution]

Your query asks 10kft for a list of reports.  I think you will want to read their API documentation again, and then amend the query to indicate which report you want to pull.

[v-yingjl · Accepted solution]

Hi @SRS11 ,

Seems like you are using Reports API, you can refer this document about 100kft Reports API:

https://github.com/10Kft/10kft-api/blob/master/sections/reports.md 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

Your query asks 10kft for a list of reports.  I think you will want to read their API documentation again, and then amend the query to indicate which report you want to pull.