ADO.NET Provider for Salesforce Pardot

Build 21.0.8137

LayoutTemplates

Retrieve and modify layout templates.

Table Specific Information

Select

The provider 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 provider.

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

For example, the following queries are processed server side:

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

Insert

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

INSERT INTO LayoutTemplates (Name,IsIncludeDefaultCss,LayoutContent,FolderId) VALUES ('name','true','content', 33621)

Update

Updating LayoutTemplates:

Update LayoutTemplates set Name='newName' where Id=24143

Delete

Remove all layout templates or a layout template by specifying the Id of the template.

DELETE FROM LayoutTemplates 

DELETE FROM LayoutTemplates WHERE Id = 10003

GetDeleted

To retrieve layout templates that are in the recycle bin in Pardot the following operation is supported:

GETDELETED FROM LayoutTemplates 

Columns

Name Type ReadOnly References Description
Id [KEY] Integer True

ID of this object.

Name String False

Name of the object for identification in Pardot. Uses the name of the file being uploaded if not specified on create.

LayoutContent String False

HTML content of this layout template encoded as JSON string.

FormContent String False

HTML content encoded as JSON string that controls form display logic. Uses default values if not provided.

SiteSearchContent String False

HTML content encoded as JSON string that controls the site search content.

IsIncludeDefaultCss Boolean False

True if not supplying custom CSS styling.

FolderId Integer False

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

IsDeleted Boolean True

True if the object is in the recycle bin in Pardot.

CreatedAt Datetime True

The timestamp of when this object was created.

UpdatedAt Datetime True

The timestamp of when this object was last updated.

CreatedById Integer True

ID of the individual who created this object.

UpdatedById Integer True

ID of the individual who last updated this object.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137