MS Dynamics Field Data Types supported with Marketo via Native Sync

AmritTandon
Marketo Employee
Marketo Employee

Below are the MSD field types and how they sync over to Marketo via native sync

 

MSD Data Types MSD Field Type Marketo Data Type Comment
Single Line of Text Simple String  
Single Line of Text Calculated String  
Option Set Simple String  
Option Set Calculated Boolean  
MultiSelect Option Set Simple String As Dropdown
Two Options Simple Boolean  
Two Options Calculated Boolean  
Image   X Not supported
Whole Number Simple Integer  
Whole Number Calculated Integer  
Whole Number Rollup Integer  
Floating Point Number   Float  
Decimal Simple Float  
Decimal Calculated Float  
Decimal Rollup Float The field changes wont sync into Marketo. Hence, should not be used
Currency Simple Currency  
Currency Calculated Currency  
Currency Rollup Currency The field changes wont sync into Marketo. Hence, should not be used
Multiple Lines of Text   Text  
Date and Time Simple DateTime or Date Depends on the format selected in MSD
Date and Time Calculated DateTime or Date Depends on the format selected in MSD
Date and Time Rollup DateTime or Date Depends on the format selected in MSD. The field changes wont sync into Marketo. Hence, should not be used
Lookup   String MSD GUID would sync over for the field

 

Hope this is helpful. Let me know your thoughts 🙂

1950
1
1 Comment
AmritTandon
Marketo Employee

Rollup fields are unsupported as events in child objects do not generate change events in the rolled up field and hence, changes do not come through.