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.
CData JDBC Driver for Marketo Views
| Name | Description |
| Activities | Returns a list of activities from after a datetime given by the nextPageToken parameter. |
| ActivityBulkExports | Returns a list of activity export jobs that were created in the past 7 days. |
| ActivityTypes | Get activity types for a Marketo Organization |
| ActivityTypesAttributes | Get activity types attributes for a Marketo Organization |
| Campaigns | Query Campaigns for a Marketo organization. |
| ChannelProgressionStatuses | Query ProgressionStatuses of Channels for a Marketo organization. |
| Channels | Query Channels for a Marketo organization. |
| DailyErrorStatistics | Gets a list of users and the count of each error type they have encountered in the current day |
| DailyUsageStatistics | Gets a list of users and the number of calls they have consumed in the current day |
| EmailCCFields | Query Emails CC Fields for a Marketo organization. |
| Files | Query Files for a Marketo organization. |
| LandingPageContentSection | Get section of a landing page content for a Marketo organization. |
| LandingPageTemplateContent | Query the LandingPageTemplateContent for a Marketo organization. |
| LeadBulkExports | Returns a list of lead export jobs that were created in the past 7 days. |
| LeadChanges | Returns a list of Data Value Changes and New Lead activities after a given datetime. |
| LeadChangesAttributes | Returns a list of Data Value Changes and New Lead activities after a given datetime. |
| LeadChangesFields | Returns a list of Data Value Changes and New Lead activities after a given datetime. |
| LeadLists | Query static list membership for one lead. |
| LeadPartitions | Query Lead Partitions for a Marketo organization. |
| LeadPrograms | Query program membership for one lead. |
| Lists | Query Lists for a Marketo organization. |
| PreviewEmail | View a preview of an email. |
| ProgramMembersBulkExports | Returns a list of program members export jobs that were created in the past 7 days. |
| Segmentations | Query segmentations for a Marketo organization. |
| Segments | Query segments for a Marketo organization. |
| SmartListRuleFilters | Query SmartLists rule filters |
| SnippetContent | Query the content of the specific snippet for a Marketo Organization |
| Tags | Query Tags for a Marketo organization. |
| ThankYouList | Query Thank you list for the forms |
| WeeklyErrorStatistics | Gets a list of users and the count of each error type they have encountered in the past 7 days |
| WeeklyUsageStatistics | Gets a list of users and the number of calls they have consumed in a week |