Salesforce Datatype | Transformation Datatype | Description |
|---|---|---|
AnyType | String | Polymorphic data type that returns string, picklist, reference, boolean, currency, integer, double, percent, ID, date, datetime, URL, or email data. |
Base64 | String | Base64 encoded binary data. |
Boolean | Integer | Boolean (true/false) values. |
Combobox | String | Enumerated values. |
Currency | Decimal | Currency values. |
DataCategoryGroupReference | String | Types of category groups and unique category names. |
Date | Date/Time | Date values. |
DateTime | Date/Time | Date and time values. |
Double | Decimal | Double values. |
Email | String | Email addresses. |
Encrypted String | String | Encrypted text fields contain any combination of letters, numbers, or symbols stored in encrypted form. |
ID | String | Primary key field for a Salesforce object. |
Int | Integer | Fields of this type contain numbers with no fraction portion. |
JunctionIdList | String | A string array of referenced ID values that represents the many-to-many relationship of an underlying junction entity. Query and manipulate the string array to query and manipulate the underlying junction entities in a single API call. Note: This field type is available from V34.0 API and above. |
Location | Decimal | A compound data type that contains latitude and longitude values (Double) for geolocation field. |
Master record | String | ID of the merged record. |
Multipicklist | String | Multiple-selection picklists, which provide a set of enumerated values that you can select multiple values from. |
Percent | Decimal | Percentage values. |
Phone | String | Phone numbers. |
Picklist | String | Single-selection picklists, which provide a set of enumerated values that you can select one value from. |
Reference | String | Cross-references to another Salesforce object. |
String | String | Character strings. |
Textarea | String | String that appears as a multiple-line text field. |
Time | Date/Time | Time values. |
URL | String | URL values. |