JDBC Driver for HubSpot

Build 22.0.8462

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'.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462