UrlMappings
Retrieve the available url mappings in HubSpot.
Table Specific Information
URL mappings represent any number of redirects you have specified in your HubSpot content optimization system.
SELECT
When selecting URL mappings, they can only be filtered by the Id, CreatedAt, DeletedAt, Destination, IsOnlyAfterNotFound, RoutePrefix, and UpdatedAt. DeletedAt, CreatedAt, and UpdatedAt can be used with the > and < comparisons to form a range. For example:
SELECT * FROM UrlMappings WHERE DeletedAt >= '1/1/2014' AND DeletedAt <= '10/1/2014' SELECT * FROM UrlMappings WHERE Id = '123456789'
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | The id of the url mapping. | |
| CreatedAt | Datetime | When the url mapping was created. | |
| DeletedAt | Datetime | When the url mapping was deleted. | |
| Destination | String | The URL to redirect to. | |
| IsMatchFullUrl | Boolean | If true, the 'route_prefix' should match on the entire URL including the domain. | |
| IsMatchQueryString | Boolean | If true, the 'route_prefix' should match on the entire URL path including the query string. | |
| IsOnlyAfterNotFound | Boolean | If True, the URL mapping will only be applied if a live page matching the URL is not found. If False, the URL mapping will take precedence over any existing page. | |
| Precedence | Integer | If a URL matches more than one mapping, the one with the lower precedence applies. | |
| RoutePrefix | String | The incoming URL to match. | |
| UpdatedAt | Datetime | When the url mapping was last updated. | |
| ExtraUrlParameters | String | An input only property for specifying additional parameters when selecting data from HubSpot. Specify the parameters as name=value pairs in a comma separated list. For instance, 'param1=value1,param2=value2,param3=value3'. |