Excel Add-In for Salesforce Pardot

Build 21.0.7930

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.


PropertyDescription
ArchivedSpecify whether to get archived or unarchived records.
IncludeMessageSet this property when querying Emails table. If false, the response does not include the html or text body of the email message. Default value is true.
MaxRowsLimits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
MaxThreadsSpecifies the number of concurrent requests.
OtherThese hidden properties are used only in specific use cases.
PagesizeThe maximum number of results to return per page from Salesforce Pardot.
ReadonlyYou can use this property to enforce read-only access to Salesforce Pardot from the provider.
ResponseModeThe Pardot API supports several output formats, each of which returns different levels of detail in the response. Supported output formats include: full - Returns all supported data for the Pardot object and all objects associated with it. simple - Returns all supported data for for the Pardot object. bulk -- Returns basic data for an object. Does not provide object associations and total object count. The default value is bulk.
SupportEnhancedSQLThis property enhances SQL functionality beyond what can be supported through the API directly, by enabling in-memory client-side processing.
TimeoutThe value in seconds until the timeout error is thrown, canceling the operation.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930