UrlMappings
Lists all URL mappings configured within HubSpot, useful for managing redirects and vanity URLs.
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 unique identifier assigned to the URL mapping. | |
| CreatedAt | Datetime | Timestamp indicating when the URL mapping was initially created. | |
| DeletedAt | Datetime | Timestamp indicating when the URL mapping was deleted, if applicable. | |
| Destination | String | The destination URL to which incoming requests matching the mapping will be redirected. | |
| IsMatchFullUrl | Boolean | Boolean indicating whether the 'RoutePrefix' attribute must match the entire incoming URL, including the domain name. | |
| IsMatchQueryString | Boolean | Boolean indicating whether the 'RoutePrefix' attribute must match the URL path and its query string parameters. | |
| IsOnlyAfterNotFound | Boolean | Boolean specifying whether the URL mapping should apply only if no live page is found at the incoming URL. | |
| Precedence | Integer | Numeric value determining the priority of the URL mapping. Lower numbers indicate higher priority when multiple mappings match. | |
| RoutePrefix | String | The specific incoming URL pattern to match for triggering the redirection. | |
| UpdatedAt | Datetime | Timestamp indicating the last time the URL mapping was modified. | |
| ExtraUrlParameters | String | Optional input-only parameter for passing extra query parameters when retrieving URL mapping data. Format parameters as name=value pairs separated by commas (for example: 'param1=value1, param2=value2, param3=value3'). |