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 | Query Activities for a Marketo organization. |
Activities_AddToList | Query Add To List Activities for a Marketo organization. |
Activities_AddToSFDCCampaign | Query Add To SFDC Campaign Activities for a Marketo organization. |
Activities_ChangeDataValue | Query Change Data Value Activities for a Marketo organization. |
Activities_ChangeOwner | Query Change Owner Activities for a Marketo organization. |
Activities_ChangeRevenueStage | Query Change Revenue Stage Activities for a Marketo organization. |
Activities_ChangeScore | Query Change Score Activities for a Marketo organization. |
Activities_ChangeStatusInProgression | Query Change Status In Progression Activities for a Marketo organization. |
Activities_ChangeStatusInSFDCCampaign | Query Change Status In SFDC Campaign Activities for a Marketo organization. |
Activities_ClickEmail | Query Click Email Activities for a Marketo organization. |
Activities_ClickLink | Query Click Link Activities for a Marketo organization. |
Activities_ConvertLead | Query Convert Lead Activities for a Marketo organization. |
Activities_CreateTask | Query Create Task Activities for a Marketo organization. |
Activities_EmailBouncedSoft | Query Email Bounced Soft Activities for a Marketo organization. |
Activities_EmailDelivered | Query Email Delivered Activities for a Marketo organization. |
Activities_InterestingMoments | Query Interesting Moments Activities for a Marketo organization. |
Activities_MergeLeads | Query Merge Leads Activities for a Marketo organization. |
Activities_NewLeads | Query New Lead Activities for a Marketo organization. |
Activities_OpenEmail | Query Open Email Activities for a Marketo organization. |
Activities_RemoveFromFlow | Query Remove from Flow Activities for a Marketo organization. |
Activities_RemoveFromList | Query Remove from List Activities for a Marketo organization. |
Activities_RemoveFromSFDCCampaign | Query Remove from SFDC Campaign Activities for a Marketo organization. |
Activities_SendAlert | Query Send Alert Activities for a Marketo organization. |
Activities_SendEmail | Query Send Email Activities for a Marketo organization. |
Activities_SFDCActivity | Query SFDC Activity Activities for a Marketo organization. |
Activities_SFDCMergeLeads | Query SFDC Merge Leads Activities for a Marketo organization. |
Activities_VisitWebpage | Query Visit Webpage Activities for a Marketo organization. |
Campaigns | Query Campaigns for a Marketo organization. |
Channels | Query Channels for a Marketo organization. |
Opportunities | Query Opportunities for a Marketo organization. |
OpportunityPersonRoles | Query Opportunity Person Roles for a Marketo organization. |
Tags | Query Tags for a Marketo organization. |