URL_AUTHORITY
Description
URL_AUTHORITY
is a row function that returns the authority portion of a URL string. The authority portion of a URL is the part that has the information on how to locate and connect to the server.Syntax
Return Value
Returns the authority portion of a URL as a
TEXT
value, or NULL
if the input string is not a valid URL. For example, in the string
http://www.workday.com/company/contact.html
, the authority portion is www.workday.com
. In the string
http://user:password@mycompany.com:8012/mypage.html
, the authority portion is user:password@mycompany.com:8012
.In the string
mailto:username@mycompany.com?subject=Topic
, the authority portion is NULL
.Input Parameters
- URL_string
- Required. A field or expression that returns aTEXTvalue in URI (uniform resource identifier) format of:.protocol:authority[/path][?query][#fragment]
- The authority portion of the URL contains the host information, which can be specified as a domain name (www.workday.com), a host name (localhost), or an IP address (127.0.0.1). The host information can be preceeded by optional user information terminated with @ (for example,username:password@workday.com), and followed by an optional port number preceded by a colon (for example,localhost:8001).
Examples
Return the authority portion of URL string values in the
referrer
field:URL_AUTHORITY([referrer])
Return the authority portion of a literal URL string:
returns
user:password@mycompany.com:8012
.