Loading
Extend Salesforce with Clicks, Not Code
OData 2.0 Type Mapping

OData 2.0 Type Mapping

Understand how the OData 2.0 adapter for Salesforce Connect maps OData types to Salesforce metadata field types.

Required Editions

Available in: both Salesforce Classic and Lightning Experience (not for high-data-volume external objects)

Available in: Developer Edition

Available for an extra cost in: Enterprise, Performance, and Unlimited Editions

Salesforce Connect supports only the following types when syncing metadata and converting values between Salesforce and an external system.

OData 2.0 Primitive Types

OData 2.0 Type Salesforce Metadata Field Type
Binary TextArea
Boolean Checkbox
Byte Number
DateTime DateTime
DateTimeOffset DateTime
Decimal Number
Double Number
Guid Text
Int16 Number
Int32 Number
Int64 Number
SByte Number
Single Number
String

Depends on the declared maximum length of the OData string column.

  • OData declared maximum length: not declared
    • Salesforce field type: Text
    • Salesforce field length attribute: 128 characters
  • OData declared maximum length: 255 or fewer characters
    • Salesforce field type: Text
    • Salesforce field length attribute: Same as declared
  • OData declared maximum length: More than 255 characters
    • Salesforce field type: LongTextArea
    • Salesforce field length attribute: Same as declared
Time Text
Tip
Tip A binary value from an external system is represented in Salesforce as a base64-encoded string. You can convert it to a value of type Blob by using the EncodingUtil.base64Decode(inputString) Apex method.

OData 2.0 Complex Types

Salesforce Connect supports OData complex types as follows.

 
Loading
Salesforce Help | Article