Power Query
Search…
published
Introduction
Accessing Data
Action
Binary
Binary Formats
Combiner
Comparer
Cube
Date
Date Time
Date Time Zone
Diagnostics
Duration
Error
Expression
Function
Lines
List
Logical
Metadata
Number
Record
Replacer
Splitter
Table
Text
Time
Type
Uri
Uri.BuildQueryString
Uri.Combine
Uri.EscapeDataString
Uri.Parts
Values
Powered By
GitBook
Uri.Parts
Uri.Parts
Returns the parts of the input absolute URI as a record.
function (
absoluteUri
as text) as record
Description
Returns the parts of the input
absoluteUri
as a record, containing values such as Scheme, Host, Port, Path, Query, Fragment, UserName and Password.
Category
Uri
Examples
Find the parts of the absolute URI "www.adventure-works.com".
1
Uri.Parts("www.adventure-works.com")
Copied!
[ Scheme = "http", Host = "www.adventure-works.com", Port = 80, Path = "/", Query = [], Fragment = "", UserName = "", Password = "" ]
Decode a percent-encoded string.
1
let
2
UriUnescapeDataString = (data as text) as text => Uri.Parts("http://contoso?a=" & data)[Query][a]
3
in
4
UriUnescapeDataString("%2Bmoney%24")
Copied!
"+moneyquot;
Previous
Uri.EscapeDataString
Next
Values
Last modified
3yr ago
Copy link
Contents
Uri.Parts
Description
Category
Examples