JDBC Driver for Salesforce Pardot

Build 22.0.8462

CustomRedirects

Track links on your website or third-party site with Pardot custom redirects.

Table Specific Information

Select

The driver will use the Salesforce Pardot API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.

  • Id supports '=', '<', '<=', '>', '>='.
  • IsDeleted supports '='.

For example, the following queries are processed server side:

SELECT * FROM CustomRedirects WHERE Id = 40
SELECT * FROM CustomRedirects WHERE IsDeleted = 'true'

Insert

The following attributes are required when performing an insert: Name, CampaignId, DestinationUrl.

INSERT INTO CustomRedirects (Name,CampaignId,DestinationUrl) VALUES ('name','1','https://example.com/content.html')

Update

Update CustomRedirects attributes.

UPDATE CustomRedirects SET Name = 'newName', FolderId = '527425' WHERE Id = 24143

Delete

Remove all CustomRedirects objects or one by specifying the Id of the CustomRedirect.

DELETE FROM CustomRedirects WHERE Id = 10003

GetDeleted

To retrieve custom redirects that are in the recycle bin in Pardot the following operation is supported:

GETDELETED FROM CustomRedirects 

Columns

Name Type ReadOnly References Description
Id [KEY] Int64 True

Pardot ID for this campaign.

Name String False

Name of the object for identification in Pardot.

CampaignId Int64 False

Pardot Campaign related to this object.

DestinationUrl String False

A fully qualified URL. The visitor who clicks the custom redirect is directed to this location.

FolderId Int64 False

ID of the folder containing this object. Uses the asset type's uncategorized folder if not specified on create.

TrackerDomainId Int64 False

ID of the tracker domain to use in the URL for this object. Uses the primary tracker domain for the account if not specified on create.

VanityUrl String True

Fully qualified vanity URL. Includes tracker domain and vanityUrlPath.

VanityUrlPath String False

Vanity URL path (excluding protocol and host). Must be unique for each tracker domain.

GASource String False

Google Analytics Campaign source.

GAMedium String False

Google Analytics Campaign medium.

GATerm String False

Google Analytics Campaign keyword.

GAContent String False

Google Analytics Campaign content.

GACampaign String False

Google Analytics Campaign ID.

SalesforceId String True

ID of the Salesforce object representing this object.

TrackedUrl String True

Fully qualified tracked URL. Does not include Vanity URL.

BitlyIsPersonalized String True

True if a custom Bitly URL was set.

BitlyShortUrl String True

If set, a fully qualified Bitly URL.

IsDeleted Boolean True

True if the object is in the Pardot recycle bin.

CreatedAt Datetime True

The object creation timestamp.

UpdatedAt Datetime True

The timestamp of the last update of the object.

CreatedById Int64 True

ID of the individual who created this object.

UpdatedById Int64 True

ID of the individual who last updated this object.

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