Power Query
Search…
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;
Last modified 3yr ago