Marketo Connector Guide > Understanding the property File > Objects and Operators
  

Objects and Operators

The following table provides information on the various operators supported by objects.
Object
Filter Fields
Data Type
Operators
Allowed Values
Lead
Email
String
Equals
Any String
ForeignSysPersonId
String
Equals
Any String
Id
Integer
Equals
Any Integer
LastUpdatedAt
DateTime
Equals
Any DateTime
Activity
ActivityType
String
Equals
Any String
Email
String
Equals
ExcludeActivityType
String
Equals
Any String
ForeignSysPersonId
String
Equals
Any String
Id
Integer1
Equals
Any Integer2
marketoGUID
String
Equals
Any String
OldestCreatedAt
DateTime
Equals
Any DateTime
Opportunity
All Supported Fields
All Date Types
Not Equals,
Equals,
Greater Than and Equals,
Less Than and Equals,
Greater Than
Less Than
All Date Types
OpportunityPersonRole
All Supported Fields
All Date Types
Not Equals,
Equals,
Greater Than and Equals,
Less Than and Equals,
Greater Than
Less Than
All Date Types
1 Integer is replaced by Long in WSDL versions 27 and later.

2 Any Integer is replaced by Any Long in WSDL versions 27 and later.

Note: Boolean is also considered as Integer Data type and hence '0' Indicates "False" & '1'-to-Infinity Indicates "True".
The connector supports a particular set of data types for selected operators.
Operators
Supported Data Types
Not Equals
String, Integer, DateTime, Double, Boolean
Equals
Greater Than and Equals
Integer, DateTime, Double, Boolean
Less Than and Equals
Contains
String
Greater Than
Integer, DateTime, Double, Boolean
Less Than
Note: When you perform an insert (write) and update task operation, the ‘Null’ value will not be accepted by Marketo endpoint. Only non-null values are accepted as updatable values. It is due to technical limitation of marketo connector (which is xml based data).