Views
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
Salesforce Pardot Adapter Views
| Name | Description |
| Account | Use the account resource to learn about the current user's Pardot account. |
| Campaigns | Retrieve and modify campaigns. |
| CustomFields | Retrieve custom fields metadata. |
| DynamicContentVariations | Retrieve a collection of Dynamic Content Variations |
| Emails | Query emails to learn how prospects responded to the emails. |
| EmailSuppressionList | A Lists used as suppression lists for the list email. |
| Folders | Retrieve folders or organize and nest your content and marketing assets in a way that makes sense for your team. |
| Forms | Retrieve forms. |
| LifecycleHistories | Use lifecycle history resources to learn how a prospect is moving through their sales journey, from visitor to won opportunity. |
| ListEmail | A list email is a single email sent to a recipient list. |
| ListEmailRecipients | RecipientLists used by an email |
| Opportunities | Retrieve a collection of opportunities |
| ProspectAccounts | Retrieve and modify prospect accounts. |
| ReplyToOptions | Query the replyTo options of email templates. |
| SenderOptions | Query the sender options of email templates. |
| TrackerDomains | Query the available tracker domains. |
| Users | Query the available users. |
| VisitorActivities | Retrieve visitor activities. |
| Visitors | Retrieve visitors. |
| VisitorsPageViews | Retrieve visitors page views. |
| Visits | Retrieve visits. |