Forum Discussion

SRS11's avatar
SRS11
Frequent Visitor
5 years ago
Solved

REST API and 1000ft

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)

  • 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.

2 Replies

  • 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.