FINS Salesforce Marketing System API - Implementation Template
Data mappings
This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables.
| Module | Description |
|---|---|
| subscribers-create-subscriber | CIM format to Salesforce create subscriber request mapping |
| subscribers-create-individual | CIM format to Salesforce create Individual request mapping |
| subscribers-update-subscriber | CIM format to Salesforce update data extension request mapping |
subscribers-create-subscriber
CIM format to Salesforce create subscriber request mapping
Source:
./src/main/resources/dwl/subscribers-create-subscriber.dwl
Mapping Tables
Maps CIM format to Salesforce Marketing Individual subscriber mapping
| Salesforce subscriber | CIM | Description |
|---|---|---|
| CreatedDate | todays date time | The created date to now |
| EmailAddress | emailAddress | The email address of the subscriber |
| ModifiedDate | todays date time | The modified date to "yyyy-MM-dd'T'HH:mm:ssz" |
| SubscriberKey | emailAddress | The email address of the subscriber |
subscribers-create-individual
CIM format to Salesforce create Individual request mapping
Source:
./src/main/resources/dwl/subscribers-create-individual.dwl
Mapping Tables
Maps CIM format to Salesforce data extension Object
| Salesforce data extension Object | CIM | Description |
|---|---|---|
| concreteClassType | DataExtensionObject | Hardcoded as DataExtensionObject |
| name | Individual | Hardcoded as Individual |
| properties.property.name | EmailAddress | Hardcoded as email address |
| properties.property.value | emailAddress | The subscriber email |
| properties.property.name | GlobalPartyId | Hardcoded as GlobalPartyId |
| properties.property.value | externalId | The External Identifier of MDM |
| properties.property.name | SubscriberId | Hardcoded as SubscriberId |
| properties.property.value | Id | Identifier to update the Subscriber |
| properties.property.name | FirstName | Hardcoded as FirstName |
| properties.property.value | firstName | The FirstName of the Individual |
| properties.property.name | LastName | Hardcoded as LastName |
| properties.property.value | lastName | The LastName of the Individual |
| properties.property.name | PersonName | Hardcoded as PersonName |
| properties.property.value | personName | The Full name of the Individual |
| properties.property.name | CreatedDate | Hardcoded as CreatedDate |
| properties.property.value | todays date | Hardcoded today datetime to "yyyy-MM-dd HH:mm:dd" |
| properties.property.name | CreatedBy | Hardcoded as CreatedBy |
| properties.property.value | app.name | The application name |
| properties.property.name | UpdatedDate | Hardcoded as UpdatedDate |
| properties.property.value | todays date | Hardcoded today datetime to "yyyy-MM-dd HH:mm:dd" |
| properties.property.name | UpdatedBy | Hardcoded as UpdatedBy |
| properties.property.value | app.name | The application name |
subscribers-update-subscriber
CIM format to Salesforce update data extension request mapping
Source:
./src/main/resources/dwl/subscribers-update-subscriber.dwl
Mapping Tables
Maps CIM format to Salesforce data extension Object
| Salesforce data extension Object | CIM | Description |
|---|---|---|
| concreteClassType | DataExtensionObject | Hardcoded as DataExtensionObject |
| name | Individual | Hardcoded as Individual |
| properties.property.name | EmailAddress | Hardcoded as email address |
| properties.property.value | emailAddress | The Individual subscriber email |
| properties.property.name | GlobalPartyId | Hardcoded as GlobalPartyId |
| properties.property.value | externalId | The External Identifier of MDM |
| properties.property.name | SubscriberId | Hardcoded as SubscriberId |
| properties.property.value | id | Identifier obtained from the results of Subscriber creation. |
| properties.property.name | FirstName | Hardcoded as FirstName |
| properties.property.value | firstName | The FirstName of the Individual |
| properties.property.name | LastName | Hardcoded as LastName |
| properties.property.value | lastName | The LastName of the Individual |
| properties.property.name | PersonName | Hardcoded as PersonName |
| properties.property.value | personName | The Full name of the Individual |
| properties.property.name | CreatedDate | Hardcoded as CreatedDate |
| properties.property.value | todays date | Hardcoded today datetime to "yyyy-MM-dd HH:mm:dd" |
| properties.property.name | CreatedBy | Hardcoded as CreatedBy |
| properties.property.value | app.name | The application name |
| properties.property.name | UpdatedDate | Hardcoded as UpdatedDate |
| properties.property.value | todays date | Hardcoded today datetime to "yyyy-MM-dd HH:mm:dd" |
| properties.property.name | UpdatedBy | Hardcoded as UpdatedBy |
| properties.property.value | app.name | The application name |