Map Salesforce External Object Field to DynamoDB Attributes

This table lists Amazon DynamoDB attribute types supported for field types of external objects in Salesforce.

Following is the mapping strategy of Amazon DynamoDB attribute types to some of the common field types of external objects in Salesforce:

• An attribute of string type that represents a date or dateTime is stored in ISO 8601 format.
• An attribute of string type that represents a time is stored in a format used by TIMEVALUE() or TEXT() function.
• An attribute of number type that represents currency is stored as a numeric value using the currency symbol configured for the Salesforce org.
• An attribute of string type that represents a picklist is rendered as Salesforce defined enumeration values. For picklist (multi-select), it is stored as comma-separated values of the selected choices.
• An attribute of number type that represents a percent is stored as a numeric value of percent type.
• An attribute of string type that represents a phone, URL, textarea, or email is stored as the corresponding Salesforce field type.

External object fields cannot be mapped to these attributes types:

• Scalar Types: Binary, Null
• Document Types: Map, List
• Sets of number, string, or binary values

Note When you manually create fields for an external object, make sure the mapped attributes are of a compatible type.