- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 ?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
SOLVED:
replaced entire Body string as a parametre rather than inserting multiple parameters into the string
let
body = Parameter
in
Source
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
SOLVED:
replaced entire Body string as a parametre rather than inserting multiple parameters into the string
let
body = Parameter
in
Source
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
how to reference 2 parameters for a Source = Json.Document(Web.Contents
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
fyi, i tried
= let
dateRangeStart=[dateRangeStart],
dateRangeEnd=[dateRangeEnd],
body = "{ ""dateRangeStart"": dateRangeStart, ""dateRangeEnd"": dateRangeEnd, ""detailedFilter"
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
09-13-2024 06:06 AM | |||
09-19-2024 05:40 AM | |||
05-10-2024 10:41 AM | |||
07-07-2024 02:50 PM | |||
08-02-2024 01:59 PM |
User | Count |
---|---|
127 | |
84 | |
59 | |
59 | |
44 |
User | Count |
---|---|
180 | |
119 | |
82 | |
70 | |
54 |