Data Type Compatibility for Field Mapping

Mike Jones
Mike Jones
  • Updated

Use the table below to find the data type compatibility between data types when mapping fields in your pipelines. The header represents the source (from) and the row represents the destination (to). 


From (column) / To (Row) Boolean String Integer Double Datetime Date Polymorphic Reference FileLink Id Object Picklist Reference Textarea Url
Boolean ✅ ✅ ❌ ❌ ❌ ❌ ❌ ❌ ❌ ❌ ❌ ❌ ❌ ❌
String ✅ ✅ ✅ ✅ ✅ ✅ ❌ ✅ ✅ ✅ ✅ ✅ ✅ ✅
Integer ✅ ✅ ✅ ✅ ✅ ✅ ❌ ❌ ❌ ✅ ❌ ❌ ❌ ❌
Double ❌ ✅ ✅ ✅ ✅ ✅ ❌ ❌ ❌ ✅ ❌ ❌ ❌ ❌
Datetime ❌ ✅ ❌ ❌ ✅ ✅ ❌ ❌ ❌ ✅ ❌ ❌ ❌ ❌
Date ❌ ✅ ❌ ❌ ✅ ✅ ❌ ❌ ❌ ✅ ❌ ❌ ❌ ❌
Polymorphic Reference ❌ ✅ ❌ ❌ ❌ ❌ ✅ ❌ ❌ ✅ ❌ ❌ ❌ ❌
FileLink ❌ ✅ ❌ ❌ ❌ ❌ ❌ ✅ ❌ ✅ ❌ ❌ ❌ ❌
Id ❌ ✅ ❌ ❌ ❌ ❌ ❌ ❌ ✅ ✅ ❌ ❌ ❌ ❌
Object ❌ ✅ ✅ ❌ ❌ ❌ ❌ ❌ ❌ ✅ ✅ ✅ ✅ ✅
Picklist ❌ ✅ ❌ ❌ ❌ ❌ ❌ ❌ ❌ ✅ ✅ ❌ ❌ ❌
Reference ❌ ✅ ❌ ❌ ❌ ❌ ❌ ❌ ❌ ✅ ❌ ✅ ❌ ❌
TextArea ❌ ✅ ❌ ❌ ❌ ❌ ❌ ❌ ❌ ✅ ❌ ❌ ✅ ❌
Url ❌ ✅ ❌ ❌ ❌ ❌ ❌ ❌ ❌ ✅ ❌ ❌ ❌ ✅
Share this

Was this article helpful?

2 out of 2 found this helpful