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.
Marketo Adapter 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. |