Marketo Limitations
- This query applies only to
List
andActivity_type
entities. For others, provide the filter type.Select * from Marketo_Table
- Does not support joins except between
Lead
andLead_List
entities. The join query betweenLead
andLead_List
for a List_Id is as follows:Select Lead.* from Lead Inner Join Lead_List On Lead.ID = Lead_List.Lead_ID And Lead_List.List_ID = <List ID>