Reply
Terry2023
Frequent Visitor
Partially syndicated - Outbound

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"": dateRangeEnd, ""detailedFilter"": { ""page"": ""1  ....... etc
in
Source

 

what do I need for these 2 to reference the parameters ?

 

 

Advanced editor.png

1 ACCEPTED SOLUTION
Terry2023
Frequent Visitor

SOLVED:

 

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

 

let
body = Parameter
in
Source

View solution in original post

4 REPLIES 4
Terry2023
Frequent Visitor

SOLVED:

 

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

 

let
body = Parameter
in
Source

Terry2023
Frequent Visitor

Syndicated - Outbound

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"

Terry2023
Frequent Visitor

Syndicated - Outbound

how to reference 2 parameters for a Source = Json.Document(Web.Contents

 

Terry2023_0-1677622728942.png

 

Terry2023
Frequent Visitor

Syndicated - Outbound

fyi, i tried

= let
dateRangeStart=[dateRangeStart],
dateRangeEnd=[dateRangeEnd],
body = "{ ""dateRangeStart"": dateRangeStart, ""dateRangeEnd"": dateRangeEnd, ""detailedFilter"

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)