Oracle Utilities OCI Stream Responsys Notif Send
The mapping details for Oracle Utilities OCI Stream Responsys Notif Send are as shown in the table below:
OCI Target Notification Stream
"Responsys
//rest/api/v1.3/campaigns/{notifcationTemplate}/sms
//rest/api/v1.3/campaigns/{notifcationTemplate}/email "
DVM
Comments
Element Name
Parent Element
Type
Element Name
Parent Element
Type
 
 
messageId
 
Field
 
 
 
 
 
origin
 
Field
 
 
 
 
 
accountId
 
Field
optionalData/value (optionalData/key = INT_ACCOUNT_ID')
mergeTriggerRecordData/mergeTriggerRecords
 
 
 
notificationType
 
Field
optionalData/value (optionalData/key = INT_NOTIFTYPE')
mergeTriggerRecordData/mergeTriggerRecords
 
 
 
cisDivision
 
Field
 
mergeTriggerRecordData/mergeTriggerRecords
 
 
 
contactId
 
Field
optionalData/value (optionalData/key = INT_CONTACT_ID')
mergeTriggerRecordData/mergeTriggerRecords
 
 
 
personId
 
Field
optionalData/value (optionalData/key = INT_PERSON_ID')
mergeTriggerRecordData/mergeTriggerRecords
 
 
 
language
 
Field
 
mergeTriggerRecordData/mergeTriggerRecords
 
 
 
firstName
 
Field
optionalData/value (optionalData/key = INT_FIRST_NAME')
mergeTriggerRecordData/mergeTriggerRecords
 
 
 
lastName
 
Field
optionalData/value (optionalData/key = 'INT_LAST_NAME')
mergeTriggerRecordData/mergeTriggerRecords
 
 
 
deliveryChannel
 
Field
 
 
 
OUTL-BRT-NOTIFHUB_
DeliveryChannel
This lookup is used to determine if the SMS or Email campaign API needs to be invoked.
deliveryValue
 
Field
fieldValues
mergeTriggerRecordData/mergeTriggerRecords
 
 
 
notificationTemplate
 
Field
 
 
 
 
This value is used to populate the campaign name in the API URL.
deliveryInstance
 
Field
 
 
 
 
This value is used to determine the Responsys instance to invoke. RESP1,RESP2,RESP3 corresponding to three Responsys instance connections that is provided out of the box.
CCId
 
Field
optionalData/value (optionalData/key = 'INT_CC_ID')
 
 
 
 
notifPreferenceId
 
Field
optionalData/value (optionalData/key = 'INT_NOTIF_PREF_ID')
 
 
 
 
optOutAllowed
 
Field
optionalData/value (optionalData/key = 'INT_OPTOUT_ALLOWED')
 
 
 
 
custContactNeeded
 
Field
optionalData/value (optionalData/key = 'INT_CUST_CONTACT_NEEDED')
 
 
 
 
subscriptionType
 
Field
optionalData/value (optionalData/key = 'INT_SUB_TYPE')
 
 
 
 
notifEventInstanceId
 
Field
optionalData/value (optionalData/key = 'INT_NOTIF_EVNT_ID')
 
 
 
 
sourceMessageId
 
Field
optionalData/value (optionalData/key = 'INT_SOURCE_MSG_ID')
 
 
 
 
eventCapturedDTTM
 
Field
 
 
 
 
Time in UTC timezone when the message was dropped in Target Stream.
 
 
 
fieldValues
mergeTriggerRecordData/mergeTriggerRecords
 
 
Mapped to fieldName CUSTOMER_ID as contatination of messageId |CCId|notificationType|personId
 
 
 
fieldNames
mergeTriggerRecordData
 
 
“Multiple fieldNames nodes with each mapped as following:
EMAIL_ADDRESS_ if the campaign type is email
MOBILE_NUMBER_ if the campaign type is sms
CUSTOMER_ID_ “
data
 
List
 
 
 
 
 
key
data
Field
optionalData/key
 
 
 
 
value
data
Field
optionalData/value
 
 
 
 
 
 
 
matchColumnName1
mergeTriggerRecordData/mergeRule
 
 
EMAIL_ADDRESS_ for Email MOBILE_NUMBER_ for SMS. These values are hard coded in the flow.
 
 
 
matchColumnName2
mergeTriggerRecordData/mergeRule
 
 
null
 
 
 
insertOnNoMatch
mergeTriggerRecordData/mergeRule
 
 
True. Same for Email and SMS
 
 
 
defaultPermissionStatus
mergeTriggerRecordData/mergeRule
 
 
This is the same value sent for Email and SMS.
 
Property name: resp.email.permission
 
 
 
rejectRecordIfChannelEmpty
mergeTriggerRecordData/mergeRule
 
OUTL-BRT-NOTIFHUB_ConfigProps
Property name: resp.reject.channel.empty
 
 
 
optoutValue
mergeTriggerRecordData/mergeRule
 
OUTL-BRT-NOTIFHUB_ConfigProps
Metadata value to indicate optoutValue.
 
Property name: resp.optout.value
 
 
 
optinValue
mergeTriggerRecordData/mergeRule
 
OUTL-BRT-NOTIFHUB_ConfigProps
Metadata value to indicate optinValue.
 
Property name: resp.optin.value
 
 
 
updateOnMatch
mergeTriggerRecordData/mergeRule
 
OUTL-BRT-NOTIFHUB_ConfigProps
Property name:resp.update.on.match
 
 
 
htmlValue
mergeTriggerRecordData/mergeRule
 
 
“H” Same for both Email and SMS.
 
 
 
textValue
mergeTriggerRecordData/mergeRule
 
 
“T” value is passed
 
 
 
matchOperator
mergeTriggerRecordData/mergeRule
 
OUTL-BRT-NOTIFHUB_ConfigProps
Same for both SMS and Email. Property name: resp.match.operator