ADO.NET Provider for Salesforce Pardot

Build 21.0.8137

Folders

Retrieve folders or organize and nest your content and marketing assets in a way that makes sense for your team.

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 '=', '<', '<=', '>', '>='.
  • ParentFolderId supports '=', '<', '<=', '>', '>='.

For example, the following queries are processed server side:

SELECT * FROM Folders WHERE Id = 50
SELECT * FROM Folders WHERE ParentFolderId = 2

Columns

Name Type References Description
Id [KEY] Integer Pardot ID of this file.
Name String Name of the folder.
ParentFolderId Integer ID of the folder containing this folder. This value is null when the folder is a root folder and doesn't have a parent.
Path String The names of each folder from the root folder separated with forward slashes.
UsePermissions Boolean True if the folder is configured to use permissions.
CreatedAt Datetime The timestamp of when this object was created.
UpdatedAt Datetime The timestamp of when this object was last updated.
CreatedById Integer ID of the individual who created this object.
UpdatedById Integer ID of the individual who last updated this object.

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