Create Pending Status Files in Responsys SFTP Location
The mapping details for Create Pending Status Files in Responsys SFTP Location are as shown in the table below:
OCI Stream
Responsys SFTP Pending File
DVM Mapping
Comments
Element Name
Parent Element
Type
Element Name
Parent Element
Type
DVM
Source Column
Target Column
 
messageId
 
Field
messageId
 
Field
 
 
 
 
origin
 
Field
origin
 
Field
 
 
 
 
accountId
 
Field
accountId
 
Field
 
 
 
 
notificationType
 
Field
notificationType
 
Field
 
 
 
 
cisDivision
 
Field
cisDivision
 
Field
 
 
 
 
contactId
 
Field
contactId
 
Field
 
 
 
 
personId
 
Field
personId
 
Field
 
 
 
 
language
 
Field
language
 
Field
 
 
 
 
lastName
 
Field
lastName
 
Field
 
 
 
 
firstName
 
Field
firstName
 
Field
 
 
 
 
deliveryChannel
 
Field
deliveryChannel
 
Field
 
 
 
 
deliveryValue
 
Field
deliveryValue
 
Field
 
 
 
 
notificationTemplate
 
Field
notificationTemplate
 
Field
 
 
 
 
deliveryInstance
 
Field
deliveryInstance
 
Field
 
 
 
 
CCId
 
Field
CCId
 
Field
 
 
 
 
notifPreferenceId
 
Field
notifPreferenceId
 
Field
 
 
 
 
optOutAllowed
 
Field
optOutAllowed
 
Field
 
 
 
 
custContactNeeded
 
Field
d
 
Field
 
 
 
 
subscriptionType
 
Field
subscriptionType
 
Field
 
 
 
 
notifEventInstanceId
 
Field
Id
 
Field
 
 
 
 
sourceMessageId
 
Field
sourceMessageId
 
Field
 
 
 
 
timezone
 
Field
timezone
 
 
 
 
 
Timezone is not convered based on the DVM (OUTL-BRT-NOTIFHUB_Timezones) and other integration will already do the conversion. The Json message from OCI stream already has the converted timezone for example this field will have EST as time zone but note USEstern (CCB type timezone)
emailSubject
 
Field
emailSubject
 
Field
OUTL-BRT-NOTIFHUB_NotifMetaData
 
EmailSubject
 
eventCapturedDate
Time
 
Field
eventCapturedDateTime
 
Field
 
 
 
This is the UTC Timezone datetime when the message was dropped in TargetNotificationStream
 
data
List
 
data
List
 
 
 
 
key
 
Field
 
key
Field
 
 
 
 
value
 
Field
 
value
Field