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. |
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 |
Name of the column or URL or String literal containing the query parameters and their values to extract.
Required? | Data Type | Example Value |
---|---|---|
Yes | String literal or column reference (URL) | http://www.example.com?q1=hello&q2=goodbye |