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 | Retrieve account info. |
| CustomRedirects | Retrieve and modify custom redirects. |
| DynamicContents | Retrieve dynamic contents. |
| EmailClicks | Retrieve email clicks. |
| Emails | Retrieve emails. |
| EmailStats | Retrieve email stats. |
| EmailTemplates | Retrieve email templates. |
| Forms | Retrieve forms. |
| LifecycleHistories | Retrieve lifecycle histories. |
| LifecycleStages | Retrieve lifecycle stages. |
| OneToOneEmails | Retrieve one to one emails. |
| TagObjects | Retrieve tag objects. |
| Tags | Retrieve tags. |
| Users | Retrieve users. |
| VisitorActivities | Retrieve visitor activities. |
| Visitors | Retrieve visitors. |
| VisitorsPageViews | Retrieve visitors page views. |
| Visits | Retrieve visits. |