Field Mapping Formats
Introduction
The following formats are defined for use by both campaign and product attributes.
Field Mapping Format Definitions
Type | Description |
---|---|
TEXT | Freeform text. Several fields will be converted to upper case in Synergy, including demographic fields. - Max length: 1000 - Regex: ^[0-9a-zA-Z \:&()+\\#.,\-'_]{0,1000}$ |
INTLTEXT | INTERNATIONAL TEXT - Freeform text supported extended character sets. |
NUMBER | Integer |
DATE | Date in format MM-DD-YYYY, where DD = 1 to 31, MM = 1 to 12 |
TIME | Time in format HH:MM:SS with a 24 hour clock (no am, pm). |
BOOLEAN | Any of “TRUE”, “FALSE”, “true”, “false”, “1”, “0”. Internal note: This is listed as YES/NO in the Synergy attribute setup screen |
CURRENCY | A floating point number with 2 decimal places |
FLOAT | A decimal number. Internal note: this is listed as DECIMAL in the Synergy attribute setup screen |
CHOICE | An attribute defined as CHOICE has a predefined list of values that can be selected from. NOTE: When creating a submission the selected choice value must be sent as TEXT Read more about choice attributes. |
ENCRYPTED | Sensitive data that has been encrypted. You will not be able to decrypt this data. |
Updated almost 5 years ago