View Source

Extracts the query parameters of a URL into an Object. The Object keys are the parameter's names, and its values are the parameter's values. Input values must be of URL or String type.

This function is part of a set of functions for processing URL data.

See DOMAIN Function.
See SUBDOMAIN Function.
See SUFFIX Function.
For more information, see Structure of a URL.

URL literal examples:

derive type:single value: URLPARAMS('http://example.com?color=blue&shape=square' ) as: 'myURLParams'

Output: Generates the myURLParams column containing the following Object:

{"color": "blue","shape": "square"}

Column reference example:

derive type:single value: URLPARAMS(myURLs) as: 'myURLParams'

Output: Generates the new myURLParams column containing the query parameters extracted from the URLs in the myURLs column.

derive type:single value: URLPARAMS(column_url)

Argument	Required?	Data Type	Description
column_url	Y	string	Name of column or String or URL literal containing the parameters and their values to extract

column_url

Name of the column or URL or String literal containing the query parameters and their values to extract.

Missing input values generate missing results.
Multiple columns and wildcards are not supported.

Required?	Data Type	Example Value
Yes	String literal or column reference (URL)	`http://www.example.com?q1=hello&q2=goodbye`

column_url

Example - Domain, Subdomain, Host, and Suffix functions