Skip to main content

Salesforce data type support and correspondence

Salesforce data type

Striim type

base64

java.lang.Object

boolean

String

byte

Byte

date

org.joda.time.LocalDate

dateTime

org.joda.time.DateTime

double

Double

int

Long

string

String

time

String

Salesforce sObject field to Striim type mapping

sObject field

Striim type

address

java.lang.String (see discussion below)

anyType

String

calculated

String

combobox

String

currency

Double

DataCategoryGroupReference

String

email

String

encryptedstring

String

ID

String

JunctionIdList

String

location

String (see discussion below)

masterrecord

String

multipicklist

String

percent

Double

phone

String

picklist

String

reference

String

textarea

String

url

String

The address and location fields are compound types. The lava.lang.String data field contains a JSON representation of the sObject values and the WAEvent metadata map. The following is the WAEvent for a location:

data: ["a067F00000B52obQAB","a067F00000B52ob","{latitude=1.0, longitude=1.0}"]
metadata: {"LastModifiedDate":"2018-09-11T05:45:43.000+0000","IsDeleted":false,
  "CustomObject":true,"OperationName":"INSERT","SystemModstamp":"2018-09-11T05:45:43.000+0000",
  "TableName":"compoundobject__c","OwnerId":"0057F000001oImoQAE","CreatedById":"0057F000001oImoQAE",
  "location__Latitude__s":1.0,"CreatedDate":"2018-09-11T05:45:43.000+0000",
  "location__Longitude__s":1.0,"attributes":{"type":"compoundobject__c",
  "url":"/services/data/v34.0/sobjects/compoundobject__c/a067F00000B52obQAB"},
  "LastModifiedById":"0057F000001oImoQAE"}