Forum Discussion

Terry2023's avatar
Terry2023
Frequent Visitor
3 years ago
Solved

How to reference a parameter in a new query

assistance with the follwoing would be appreciated.   I have created a date parameter which I wish to reference in the query   let body = "{ ""dateRangeStart"": dateRangeStart, ""dateRangeEnd"":...
  • Terry2023's avatar
    Terry2023
    3 years ago

    SOLVED:

     

    replaced entire Body string as a parametre rather than inserting multiple parameters into the string

     

    let
    body = Parameter
    in
    Source

Terry2023's avatar
Terry2023
Frequent Visitor
3 years ago

how to substitute 2 parametres?

 

let
dateRangeStart=dateRangeStart,
dateRangeEnd=dateRangeEnd,
body = "{ ""dateRangeStart"": ""2022-01-01T00:00:00.000"", ""dateRangeEnd"": ""2022-12-01T23:59:59.000"", ""detailedFilter"": { ""page"": ""1"", ""pageSize"": ""500"" } }", Source = Json.Document(Web.Contents("https://reports.api.clockufy.me/v1/workspaces/WORKSPACEID/reports/detailed", [ Headers = [#"Content-Type"="application/json"], Content=Text.ToBinary(body) ])),
timeentries = Source[timeentries],
#"Converted to Table" = Table.FromList(timeentries, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"_id", "description", "userId", "timeInterval" })
in
#"Expanded Column1"