Accelerator Salesforce Global Party 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 |
|---|---|
| CommonTools | This module provides utility functions and mappings for Customer transformations |
| CustomerTools | This module provides utility functions and mappings for Customer transformations |
| retrieve-externalids-response | ExternalIds Query Mapping for Salesforce Global Data System |
| customers-search-response | Salesforce Account to CIM Customer format mapping response |
| map-contactpoints-for-customer | Salesforce Customer Contact Points to CIM Customer format mapping |
| retrieve-customer-by-id-response | Salesforce Account to CIM Customer format mapping |
| update-household-customer | Salesforce Household Account update mapping |
| update-individual-customer | Salesforce Person Account update mapping |
| update-organization-customer | Salesforce Organization Account update mapping |
| lookup-households-response | Salesforce Look up Household mapping |
| retrieve-household-by-id-response-to-cim | Salesforce Retrieve Household mapping |
| retrieve-individual-by-id-response-to-cim | Salesforce Retrieve Individual mapping |
| search-individuals-response | Salesforce Person Account to CIM Customer format mapping |
| retrieve-organization-by-id-response-to-cim | Salesforce Retrieve Organization mapping |
| search-organizations-response | Salesforce Organization Account to CIM Customer format mapping |
| retrieve-search-parties-response-to-cim | Salesforce Lookup Account to Party CIM mapping |
| retrieve-search-partyroles-response-to-cim | Salesforce Look up Account to PartyRole CIM mapping |
CommonTools
This module provides utility functions and mappings for Customer transformations
Source:
./src/main/resources/dwl/common/CommonTools.dwl
Functions
fun getFormattedDateTime (toFormat)
Formats the date-time to the type accepted by CIM
fun getGlobalId (externalIdsArr)
This function filters ExternalIds with ExternalId Type as MDM and returns the first one
return Global ExternalID
fun getCustomerStatus (status)
Function to return appropriate Status that matches to status in Salesforce
param
statusStatus as in MDM
return status equivalent in Salesforce
fun generateMDMIDObj (refId)
Function to generate externalID obj with externalID as RefId & externalIdType as MDM
return generated MDM externalID object
fun generateSFDCIDObj (refId)
Function to generate externalID obj with externalID as RefId & externalIdType as SFDC External ID Type configured
return generated SFDC externalID object
fun generateSFDCIDObj (refId, externalIdType)
Function to generate externalID obj with externalID as RefId & externalIdType as externalIdType
return generated externalID object
fun filterObjectsByTypeAndId (objects: Array<Any>, objectType: String, objectId: String)
Function to filter objectType and objectID from an Array or records
return array of externalIDs mapped in CIM
fun isCompositeRequestSuccess (response)
Function to check if all the sub-requests of a Composite Request are successful
return true if all the sub-requests response status starts with "2"
fun getManagedExternalIdObj (externalIdObj, objectId, objectType)
Function to return the ManagedExternalID object with mapped values from externalId object, object ID and object type as input parameters.
return Sobject of Managed_External_Id__c type
fun appendObjectTypeAndIdToExternalIds (externalIdsArr, objectType, objectId)
Function to append objectType property to externalIds.
return Sobject of Managed_External_Id__c type
fun getManagedExternalIdsMap (externalIds)
Function to return the ManagedExternalID map. This function takes externalIDs array as input parameters This uses the function getManagedExternalIdObj
return Map of Managed_External_Id__c
fun getManagedExternalIdsMap (externalIds, objectId, objectType)
Function to return the ManagedExternalID map. This function takes externalIDs array as input parameters This uses the function getManagedExternalIdObj
return Map of Managed_External_Id__c
fun getExternalIdsMapForParty (partyExternalIds, partyType, objectId)
Function to return ExternalIDs for Party. This function takes party and objectId as parameters. It generates the externalIdType of MDM and SALESFORCE_CORE and adds if any externalIds on the party object. Appends the objectType and objectId to the result array. This will be used to generate the ManagedExternalIdsMap.
return array of ExternalIDsMap
fun getExternalIdsMapForIndividualContactPoints (contactPoints, objectId)
Function to return ExternalIDs for PartyRole. This function takes partyRole and objectId as parameters. It generates the externalIdType of MDM and SALESFORCE_CORE and adds if any externalIds on the partyRole object. Appends the objectType and objectId to the result array. This will be used to generate the ManagedExternalIdsMap.
return array of ExternalIDsMap
fun getExternalIdsMapForOrganizationContactPoints (contactPoints, objectId)
Function to return ExternalIDs for PartyRole. This function takes partyRole and objectId as parameters. It generates the externalIdType of MDM and SALESFORCE_CORE and adds if any externalIds on the partyRole object. Appends the objectType and objectId to the result array. This will be used to generate the ManagedExternalIdsMap.
return array of ExternalIDsMap
fun getExternalIdsWithObjectTypeToUpdate (existingExtIdsArr, currExtIdsArr)
Function to return ExternalIDs Array to update. This function takes existing externalIds array in global system and input externalIds array as parameters. It generates the list of externalId objects that requires update.
return array of ExternalID objects
fun getExternalIdsWithObjectTypeToCreate (existingExtIdsArr, currExtIdsArr)
Function to return ExternalIDs Array to create. This function takes existing externalIds array in global system and input externalIds array as parameters. It generates the list of externalId objects that needs to be created.
return array of ExternalID objects
fun getpartyType (recordType)
This function takes recordType as parameter and returns partyType
return partyType
fun isOrgAccount (isPersonAccount)
Function to confirm if the is organization account by checking if its not person account.
param
isPersonAccountflag to confirm person account or not
return flag to confirm the account is organization account or not
CustomerTools
This module provides utility functions and mappings for Customer transformations
Source:
./src/main/resources/dwl/common/CustomerTools.dwl
Functions
fun getFormattedDateTime (toFormat)
Formats the date-time to the type accepted by CIM
fun getGlobalId (externalIdsArr)
This function filters ExternalIds with ExternalId Type as MDM and returns the first one
return Global ExternalID
fun updateIndividualAddressArr (contactPoints)
This function sets default value for isUsedForBilling and isUsedForShipping flag in the ContactPointAddress array and returns the updated array
fun getMailingAddressArr (contactPoints)
This function filters addresses with isUsedForBilling flag as false
fun getIndividualMailingAddress (contactPoints)
This function gets the MailingAddress from Addresses array
fun getIndividualBillingAddress (contactPoints)
Filter Address with isUsedForBilling as true and return the first record
fun getIndividualShippingAddress (contactPoints)
Filter Address with isUsedForShipping as true and return the first record
fun updateIndividualPhonesArr (contactPoints)
This function sets default value for isSMSCapable flag in the ContactPointPhone array and returns the updated array
fun getPhonesArr (contactPoints)
This function filters phone numbers with isSMSCapable flag as false
fun getIndividualPhoneInfo (contactPoints)
This function gets the Phone Info from Phones array
fun getMobilePhoneInfo (contactPoints)
Filter Phone Numbers with isSMSCapable as true and return the first record
fun getEmailAddressArr (contactPoints)
This function gets the EmailAddress from ContactPoint Array
fun getPrimaryEmailAddress (contactPoints)
This function returns the Primary EmailAddress
fun getCustomerStatus (status)
Function to return appropriate Status that matches to status in Salesforce
param
statusStatus as in MDM
return status equivalent in Salesforce
fun updateOrganizationAddressArr (contactPoints)
This function sets default value for isUsedForBilling and isUsedForShipping flag in the ContactPointAddress array and returns the updated array
fun getOrgBillingAddressArr (contactPoints)
This function filters addresses with isUsedForBilling as true or both isUsedForBilling and isUsedForShipping flags as false
fun getOrgBillingAddress (contactPoints)
This function gets the BillingAddress from Addresses array
fun getOrgShippingAddress (contactPoints)
Filter Address with isUsedForShipping as true and return the first record
fun updateOrganizationPhonesArr (contactPoints)
This function sets default value for isFaxCapable flag in the ContactPointPhone array and returns the updated array
fun getOrgPhonesArr (contactPoints)
This function filters phone numbers with isFaxCapable flag as false
fun getOrgPhoneInfo (contactPoints)
This function gets the Phone Info from Phones array
fun getFaxPhoneInfo (contactPoints)
Filter Phone Numbers with isFaxCapable as true and return the first one record
retrieve-externalids-response
ExternalIds Query Mapping for Salesforce Global Data System
Source:
./src/main/resources/dwl/common/retrieve-externalids-response.dwl
Mapping Tables
| ExternalIds CIM | SFDC Global Data | Description |
|---|---|---|
| id | Id | The id of the entry in SFDC Global Data System |
| externalId | External_Id__c | A unique identifier assigned to the customer in another system |
| externalIdType | External_Id_Type__c | Identifies the system that owns or otherwise recognizes this unique identifier |
| objectType | Object_Type__c | Identifies base type of the object the external identifier references |
| status | Status__c | Indicates whether this identifier is currently valid or not |
| statusLastChangedDate | Status_Last_Changed__c | Date and time of the last change in status |
customers-search-response
Salesforce Account to CIM Customer format mapping response
Source:
./src/main/resources/dwl/customers/customers-search-response.dwl
Mapping Tables
| CIM | Salesforce Customer Account | Description |
|---|---|---|
| partyRoleType | Customer | Hardcoded partyRoleType to customer |
| id | Id | The customer Id |
| party.id | Id | The customer Id |
| party.salutation | Salutation | The customer salutation |
| party.personName | FirstName and LastName | The customer personal name (concatenate FistName + LastName) |
| party.firstName | FirstName | The customer first name |
| party.lastName | LastName | The customer Last name |
| party.birthDate | PersonBirthdate | The customer birth date |
| party.name | Name | The customer name if partyType is Organization |
| party.partyType | RecordType.Name | The Record type stored in Global Data System |
| party.contactPoints.contactPointType | ContactPointAddress | Hardcoded customer contact type to ContactPointAddress |
| party.contactPoints.addressLine1 | BillingStreet | The customers mailing address |
| party.contactPoints.cityName | BillingCity | The customers mailing city |
| party.contactPoints.postalCodeText | BillingPostalCode | The customer mailing postal code |
| party.contactPoints.stateProvinceName | BillingState | The customer state province name |
| party.contactPoints.countryName | BillingCountry | The customer country name |
| party.contactPoints.geoLatitude | BillingLatitude | The customer geo-latitude code |
| party.contactPoints.geoLongitude | BillingLongitude | The customer geo-longitude code |
| party.contactPoints.geoAccuracy | BillingGeocodeAccuracy | The customer geo-code accurate location |
| party.contactPoints.contactPointType | ContactPointAddress | Hardcoded customer contact type to ContactPointAddress |
| party.contactPoints.addressLine1 | ShippingStreet | The customers mailing address |
| party.contactPoints.cityName | ShippingCity | The customers mailing city |
| party.contactPoints.postalCodeText | ShippingPostalCode | The customer mailing postal code |
| party.contactPoints.stateProvinceName | ShippingState | The customer state province name |
| party.contactPoints.countryName | ShippingCountry | The customer country name |
| party.contactPoints.geoLatitude | ShippingLatitude | The customer geo-latitude code |
| party.contactPoints.geoLongitude | ShippingLongitude | The customer geo-longitude code |
| party.contactPoints.geoAccuracy | ShippingGeocodeAccuracy | The customer geo-code accurate location |
| party.contactPoints.contactPointType | ContactPointAddress | Hardcoded customer contact type to ContactPointAddress |
| party.contactPoints.addressLine1 | PersonMailingStreet | The customers mailing address |
| party.contactPoints.cityName | PersonMailingCity | The customers mailing city |
| party.contactPoints.postalCodeText | PersonMailingPostalCode | The customer mailing postal code |
| party.contactPoints.stateProvinceName | PersonMailingState | The customer state province name |
| party.contactPoints.countryName | PersonMailingCountry | The customer country name |
| party.contactPoints.geoLatitude | PersonMailingLatitude | The customer geo-latitude code |
| party.contactPoints.geoLongitude | PersonMailingLongitude | The customer geo-longitude code |
| party.contactPoints.geoAccuracy | PersonMailingGeocodeAccuracy | The customer geo-code accurate location |
| party.contactPoints.contactPointType | ContactPointEmail | Hardcoded customer contact type to ContactPointEmail |
| party.contactPoints.emailAddress | PersonEmail | The customer contact email address |
| party.contactPoints.contactPointType | ContactPointPhone | Hardcoded customer contact type to ContactPointPhone |
| party.contactPoints.telephoneNumber | Phone | The customer phone number |
| party.contactPoints.contactPointType | ContactPointPhone | Hardcoded customer contact type to ContactPointPhone |
| party.contactPoints.telephoneNumber | Fax | The customer fax number |
| party.contactPoints.contactPointType | ContactPointPhone | Hardcoded customer contact type to ContactPointPhone |
| party.contactPoints.telephoneNumber | PersonMobilePhone | The customer personal phone number |
| externalIds.id | id | Id field is hardcoded as null |
| externalIds.externalId | Id | The customer Id stored in Global Data System |
| externalIds.externalIdType | MDM | The customer externalId type is hardcoded as MDM |
| externalIds.statusLastChangedDate | LastModifiedDate | Last modified date to "yyyy-MM-dd'T'HH:mm:ssz" |
| externalIds.status | VALID | The customer status is hardcoded as VALID |
| auditInfo.createdDate | CreatedDate | The customer created date to "yyyy-MM-dd'T'HH:mm:ssz" |
| auditInfo.createdBy | CreatedBy.Name | The last created by user name |
| auditInfo.updatedDate | LastModifiedDate | The last updated date to "yyyy-MM-dd'T'HH:mm:ssz" |
| auditInfo.updatedBy | LastModifiedBy.Name | The last modified user name |
| auditInfo.isDeleted | IsDeleted | returns true if user deleted else false |
| customerNumber | AccountNumber | The customer Account Number |
| customerStatus | Customer_Status__c | The customer status with default Active |
map-contactpoints-for-customer
Salesforce Customer Contact Points to CIM Customer format mapping
Source:
./src/main/resources/dwl/customers/map-contactpoints-for-customer.dwl
Mapping Tables
| ContactPoints CIM | Salesforce Person Account | Description |
|---|---|---|
| contactPointType | ContactPointAddress | Hardcoded customer contact type to ContactPointAddress |
| addressLine1 | BillingStreet | The customers mailing address |
| cityName | BillingCity | The customers mailing city |
| postalCodeText | BillingPostalCode | The customer mailing postal code |
| stateProvinceName | BillingState | The customer state province name |
| countryName | BillingCountry | The customer country name |
| geoLatitude | BillingLatitude | The customer geo-latitude code |
| geoLongitude | BillingLongitude | The customer geo-longitude code |
| geoAccuracy | BillingGeocodeAccuracy | The customer geo-code accurate location |
| contactPointType | ContactPointAddress | Hardcoded customer contact type to ContactPointAddress |
| addressLine1 | ShippingStreet | The customers mailing address |
| cityName | ShippingCity | The customers mailing city |
| postalCodeText | ShippingPostalCode | The customer mailing postal code |
| stateProvinceName | ShippingState | The customer state province name |
| countryName | ShippingCountry | The customer country name |
| geoLatitude | ShippingLatitude | The customer geo-latitude code |
| geoLongitude | ShippingLongitude | The customer geo-longitude code |
| geoAccuracy | ShippingGeocodeAccuracy | The customer geo-code accurate location |
| contactPointType | ContactPointAddress | Hardcoded customer contact type to ContactPointAddress |
| addressLine1 | PersonMailingStreet | The customers mailing address |
| cityName | PersonMailingCity | The customers mailing city |
| postalCodeText | PersonMailingPostalCode | The customer mailing postal code |
| stateProvinceName | PersonMailingState | The customer state province name |
| countryName | PersonMailingCountry | The customer country name |
| geoLatitude | PersonMailingLatitude | The customer geo-latitude code |
| geoLongitude | PersonMailingLongitude | The customer geo-longitude code |
| geoAccuracy | PersonMailingGeocodeAccuracy | The customer geo-code accurate location |
| contactPointType | ContactPointEmail | Hardcoded customer contact type to ContactPointEmail |
| emailAddress | PersonEmail | The customer contact email address |
| contactPointType | ContactPointPhone | Hardcoded customer contact type to ContactPointPhone |
| telephoneNumber | Phone | The customer phone number |
| contactPointType | ContactPointPhone | Hardcoded customer contact type to ContactPointPhone |
| telephoneNumber | Fax | The customer fax number |
| contactPointType | ContactPointPhone | Hardcoded customer contact type to ContactPointPhone |
| telephoneNumber | PersonMobilePhone | The customer personal phone number |
retrieve-customer-by-id-response
Salesforce Account to CIM Customer format mapping
Source:
./src/main/resources/dwl/customers/retrieve-customer-by-id-response.dwl
Variables
var isOrgAccount
Validate if the account is organization account
Mapping Tables
| CIM | Salesforce Person Account | Description |
|---|---|---|
| partyRoleType | Customer | Hardcoded partyRoleType to customer |
| id | Id | The customer Id |
| party.id | Id | The customer Id |
| party.salutation | Salutation | The customer salutation |
| party.personName | FirstName and LastName | The customer personal name (concatenate FistName + LastName) |
| party.firstName | FirstName | The customer first name |
| party.lastName | LastName | The customer Last name |
| party.birthDate | PersonBirthdate | The customer birth date |
| party.name | Name | The customer name if partyType is Organization |
| party.partyType | RecordType.Name | The Record type stored in Global Data System |
| externalIds.id | id | Id field is hardcoded as null |
| externalIds.externalId | Id | The external Id stored in Global Data System |
| externalIds.externalIdType | External_Id_Type__c | The external system identifier |
| externalIds.statusLastChangedDate | LastModifiedDate | Last modified date to "yyyy-MM-dd'T'HH:mm:ssz" |
| externalIds.status | VALID | The customer status is hardcoded as VALID |
| auditInfo.createdDate | CreatedDate | The customer created date to "yyyy-MM-dd'T'HH:mm:ssz" |
| auditInfo.createdBy | CreatedBy.Name | The last created by user name |
| auditInfo.updatedDate | LastModifiedDate | The last updated date to "yyyy-MM-dd'T'HH:mm:ssz" |
| auditInfo.updatedBy | LastModifiedBy.Name | The last modified user name |
| auditInfo.isDeleted | IsDeleted | returns true if user deleted else false |
| customerNumber | AccountNumber | The customer Account Number |
| customerStatus | Customer_Status__c | The customer status with default Active |
update-household-customer
Salesforce Household Account update mapping
Source:
./src/main/resources/dwl/customers/update-household-customer.dwl
Mapping Tables
| Salesforce Account | CIM | Description |
|---|---|---|
| Id | Id | The Global Salesforce Id |
| Name | party.name | The Name of the household in Salesforce |
| Global_Party_Id__c | Id | The Global Salesforce Id |
update-individual-customer
Salesforce Person Account update mapping
Source:
./src/main/resources/dwl/customers/update-individual-customer.dwl
Mapping Tables
| Salesforce Person Account | CIM | Description |
|---|---|---|
| Id | Id | The customer Id from the Uriparams |
| Salutation | party.salutation | The salutation of the customer |
| FirstName | party.firstName | The First Name of the customer |
| lastName | party.LastName | The Last Name of the customer |
| PersonBirthDate | party.birthDate | The birth date of the customer |
| AccountNumber | customerNumber | The customer Account Number |
| Global_Customer_Id__c | Id | The customer Id stored in Global Data System |
| Global_Party_Id__c | Id | The customer Id stored in Global Data System |
| Global_BillingAddress_Id__c | Id | The customer Id stored in Global Data System |
| Global_ShipppingAddress_Id__c | Id | The customer Id stored in Global Data System |
| Global_MailingAddress_Id__c | Id | The customer Id stored in Global Data System |
| Global_EmailAddress_Id__c | Id | The customer Id stored in Global Data System |
| Global_PhoneNumber_Id__c | Id | The customer Id stored in Global Data System |
| Global_MobileNumber_Id__c | Id | The customer Id stored in Global Data System |
| Customer__Status__c | customerStatus | Status of customer |
| PersonEmail | emailAddress | Email Address of the customer |
| Phone | phone | TelephoneNumber of the customer |
| BillingStreet | billingAddress.addressLine1 | Address Line1 of ContactPointAddress in MDM that isUsedForBilling flag set to true |
| BillingCity | billingAddress.cityName | City Name of ContactPointAddress in MDM that isUsedForBilling flag set to true |
| BillingPostalCode | billingAddress.postalCodeText | Postal Code Text of ContactPointAddress in MDM that isUsedForBilling flag set to true |
| BillingState | billingAddress.stateProvinceName | State Province Name of ContactPointAddress in MDM that isUsedForBilling flag set to true |
| BillingCountry | billingAddress.countryName | CountryName of ContactPointAddress in MDM that isUsedForBilling flag set to true |
| BillingLatitude | billingAddress.geoLatitude | Geo Latitude of ContactPointAddress in MDM that isUsedForBilling flag set to true |
| BillingLongitude | billingAddress.geoLongitude | Geo Longitude of ContactPointAddress in MDM that isUsedForBilling flag set to true |
| PersonMailingStreet | mailingAddress.addressLine1 | Address Line1 of ContactPointAddress in MDM that has primaryFlag flag set true |
| PersonMailingCity | mailingAddress.cityName | City Name of ContactPointAddress in MDM that that has primaryFlag flag set true |
| PersonMailingPostalCode | mailingAddress.postalCodeText | Postal Code Text of ContactPointAddress in MDM that has primaryFlag flag set true |
| PersonMailingState | mailingAddress.stateProvinceName | State Province Name of ContactPointAddress in MDM that has primaryFlag flag set true |
| PersonMailingCountry | mailingAddress.countryName | Country Name of ContactPointAddress in MDM that has primaryFlag flag set true |
| PersonMailingLatitude | mailingAddress.geoLatitude | Geo Latitude of ContactPointAddress in MDM that has primaryFlag flag set true |
| PersonMailingLongitude | mailingAddress.geoLongitude | Geo Longitude of ContactPointAddress in MDM that has primaryFlag flag set true |
| PersonMobilePhone | telephoneNumber | Telephone Number of ContactPointPhone in MDM that has isSMSCapable flag set true |
update-organization-customer
Salesforce Organization Account update mapping
Source:
./src/main/resources/dwl/customers/update-organization-customer.dwl
Mapping Tables
| Salesforce Organization Account | CIM | Description |
|---|---|---|
| Id | Id | The customer Id from the Uriparams |
| Name | party.name | The customer organization name |
| AccountNumber | customerNumber | The customer Account Number |
| Global_Customer_Id__c | Id | The customer Id stored in Global Data System |
| Global_Party_Id__c | Id | The customer Id stored in Global Data System |
| Global_BillingAddress_Id__c | Id | The customer Id stored in Global Data System |
| Global_ShippingAddress_Id__c | Id | The customer Id stored in Global Data System |
| Global_PhoneNumber_Id__c | Id | The customer Id stored in Global Data System |
| Global_FaxNumber_Id__c | Id | The customer Id stored in Global Data System |
| BillingStreet | party.contactPointAddress.addressLine1 | The billing Address of the customer where isUsedForBilling is set to true for the contact point address |
| BillingCity | party.contactPointAddress.cityName | The billing city of the customer where isUsedForBilling is set to true for the contact point address |
| BillingPostalCode | party.contactPointAddress.postalCodeText | The billing postal code of the customer where isUsedForBilling is set to true for the contact point address |
| BillingState | party.contactPointAddress.stateProvinceName | The customer billing state where isUsedForBilling is set to true for the contact point address |
| BillingCountry | party.contactPointAddress.countryName | The customer billing country where isUsedForBilling is set to true for the contact point address |
| BillingLatitude | party.contactPointAddress.geoLatitude | The customer geo latitude location where isUsedForBilling is set to true for the contact point address |
| BillingLongitude | party.contactPointAddress.geoLongitude | The customer geo longitude location where isUsedForBilling is set to true for the contact point address |
| ShippingStreet | party.contactPointAddress.addressLine1 | The shipping Address of the customer where isUsedForShipping is set to true for the contact point address |
| ShippingCity | party.contactPointAddress.cityName | The shipping city of the customer where isUsedForShipping is set to true for the contact point address |
| ShippingPostalCode | party.contactPointAddress.postalCodeText | The shipping postal code of the customer where isUsedForShipping is set to true for the contact point address |
| ShippingState | party.contactPointAddress.stateProvinceName | The customer shipping state where isUsedForShipping is set to true for the contact point address |
| ShippingCountry | party.contactPointAddress.countryName | The customer shipping country where isUsedForShipping is set to true for the contact point address |
| ShippingLatitude | party.contactPointAddress.geoLatitude | The customer geo latitude location where isUsedForShipping is set to true for the contact point address |
| ShippingLongitude | party.contactPointAddress.geoLongitude | The customer geo longitude location where isUsedForShipping is set to true for the contact point address |
| Fax | party.ContactPointPhone.telephoneNumber | The customer contact phone Number that has isFaxCapable flag set to true |
| Phone | party.ContactPointPhone.telephoneNumber | The customer contact phone Number |
lookup-households-response
Salesforce Look up Household mapping
Source:
./src/main/resources/dwl/households/lookup-households-response.dwl
Mapping Tables
| CIM - Household | Salesforce - Account | Description |
|---|---|---|
| id | Id | The identifier of the household in Salesforce |
| name | Name | The name of the household in Salesforce |
| householdFormedDate | CreatedDate | The name of the household in Salesforce |
| householdDissolvedDate | LastModifiedDate | The name of the household in Salesforce when Status is 'Closed' |
| auditInfo.createdDate | CreatedDate | The customer created date to "yyyy-MM-dd'T'HH:mm:ssz" |
| auditInfo.createdBy | CreatedBy.Name | The last created by user name |
| auditInfo.updatedDate | LastModifiedDate | The last updated date to "yyyy-MM-dd'T'HH:mm:ssz" |
| auditInfo.updatedBy | LastModifiedBy.Name | The last modified user name |
| auditInfo.isDeleted | IsDeleted | returns true if user deleted else false |
| externalIds.id | id | Id field is hardcoded as null |
| externalIds.externalId | Id | The external Id stored in Global Data System |
| externalIds.externalIdType | MDM | The type is hardcoded as MDM |
| externalIds.statusLastChangedDate | LastModifiedDate | Last modified date to "yyyy-MM-dd'T'HH:mm:ssz" |
| externalIds.status | VALID | The externalId status is hardcoded as VALID |
retrieve-household-by-id-response-to-cim
Salesforce Retrieve Household mapping
Source:
./src/main/resources/dwl/households/retrieve-household-by-id-response-to-cim.dwl
Mapping Tables
| CIM - Household | Salesforce - Account | Description |
|---|---|---|
| id | Id | The identifier of the household in Salesforce |
| name | Name | The name of the household in Salesforce |
| householdFormedDate | CreatedDate | The name of the household in Salesforce |
| householdDissolvedDate | LastModifiedDate | The name of the household in Salesforce when Status is 'Closed' |
| auditInfo.createdDate | CreatedDate | The customer created date to "yyyy-MM-dd'T'HH:mm:ssz" |
| auditInfo.createdBy | CreatedBy.Name | The last created by user name |
| auditInfo.updatedDate | LastModifiedDate | The last updated date to "yyyy-MM-dd'T'HH:mm:ssz" |
| auditInfo.updatedBy | LastModifiedBy.Name | The last modified user name |
| auditInfo.isDeleted | IsDeleted | returns true if user deleted else false |
| externalIds.id | id | Id field is hardcoded as null |
| externalIds.externalId | Id | The external Id stored in Global Data System |
| externalIds.externalIdType | External_Id_Type__c | The external system identifier |
| externalIds.statusLastChangedDate | LastModifiedDate | Last modified date to "yyyy-MM-dd'T'HH:mm:ssz" |
| externalIds.status | VALID | The externalId status is hardcoded as VALID |
retrieve-individual-by-id-response-to-cim
Salesforce Retrieve Individual mapping
Source:
./src/main/resources/dwl/individuals/retrieve-individual-by-id-response-to-cim.dwl
Mapping Tables
| CIM | Salesforce Person Account | Description |
|---|---|---|
| id | Id | ID of the customer |
| personName | FirstName and LastName | The customer personal name (concatenate FistName + LastName) |
| firstName | FirstName | The customer first name |
| lastName | LastName | The customer Last name |
| birthDate | PersonBirthdate | The customer birth date |
| partyType | Record Type | The customer party type returned as Individual |
| auditInfo.createdDate | CreatedDate | The customer created date to "yyyy-MM-dd'T'HH:mm:ssz" |
| auditInfo.createdBy | CreatedBy.Name | The last created by user name |
| auditInfo.updatedDate | LastModifiedDate | The last updated date to "yyyy-MM-dd'T'HH:mm:ssz" |
| auditInfo.updatedBy | LastModifiedBy.Name | The last modified user name |
| auditInfo.isDeleted | IsDeleted | returns true if user deleted else false |
| externalIds.id | id | Id field is hardcoded as null |
| externalIds.externalId | Id | The external Id stored in Global Data System |
| externalIds.externalIdType | External_Id_Type__c | The external system identifier |
| externalIds.statusLastChangedDate | LastModifiedDate | Last modified date to "yyyy-MM-dd'T'HH:mm:ssz" |
| externalIds.status | VALID | The externalId status is hardcoded as VALID |
search-individuals-response
Salesforce Person Account to CIM Customer format mapping
Source:
./src/main/resources/dwl/individuals/search-individuals-response.dwl
Mapping Tables
| CIM | Salesforce Person Account | Description |
|---|---|---|
| id | Id | ID of the customer |
| personName | FirstName and LastName | The customer personal name (concatenate FistName + LastName) |
| firstName | FirstName | The customer first name |
| lastName | LastName | The customer Last name |
| partyType | Individual | The customer party type returned as Individual |
| externalIds.id | id | Id field is hardcoded as null |
| externalIds.externalId | Id | The external Id stored in Global Data System |
| externalIds.externalIdType | MDM | The type is hardcoded as MDM |
| externalIds.statusLastChangedDate | LastModifiedDate | Last modified date to "yyyy-MM-dd'T'HH:mm:ssz" |
| externalIds.status | VALID | The externalId status is hardcoded as VALID |
| auditInfo.createdDate | CreatedDate | The customer created date to "yyyy-MM-dd'T'HH:mm:ssz" |
| auditInfo.createdBy | CreatedBy.Name | The last created by user name |
| auditInfo.updatedDate | LastModifiedDate | The last updated date to "yyyy-MM-dd'T'HH:mm:ssz" |
| auditInfo.updatedBy | LastModifiedBy.Name | The last modified user name |
| auditInfo.isDeleted | IsDeleted | returns true if user deleted else false |
retrieve-organization-by-id-response-to-cim
Salesforce Retrieve Organization mapping
Source:
./src/main/resources/dwl/organizations/retrieve-organization-by-id-response-to-cim.dwl
Mapping Tables
| CIM - Organization | Salesforce - Account | Description |
|---|---|---|
| id | id | Party ID of the Customer |
| name | Name | The customer Organization name |
| partyType | Organization | The customer party type returned as Organization |
| externalIds.id | id | id field is hardcoded as null |
| externalIds.externalId | External_Id__c | The party ID |
| externalIds.externalIdType | External_Id_Type__c | The external system type identifier |
| externalIds.statusLastChangedDate | LastModifiedDate | Last modified date to "yyyy-MM-dd'T'HH:mm:ssz" |
| externalIds.status | VALID | The external Id status is hardcoded as VALID |
| auditInfo.createdDate | CreatedDate | The customer created date to "yyyy-MM-dd'T'HH:mm:ssz" |
| auditInfo.createdBy | CreatedBy.Name | The last created by user name |
| auditInfo.updatedDate | LastModifiedDate | The last updated date to "yyyy-MM-dd'T'HH:mm:ssz" |
| auditInfo.updatedBy | LastModifiedBy.Name | The last modified user name |
| auditInfo.isDeleted | IsDeleted | returns true if user deleted else false |
search-organizations-response
Salesforce Organization Account to CIM Customer format mapping
Source:
./src/main/resources/dwl/organizations/search-organizations-response.dwl
Mapping Tables
| CIM | Salesforce Account | Description |
|---|---|---|
| id | id | Party ID of the Customer |
| name | Name | The customer Organization name |
| partyType | Organization | The customer party type returned as Organization |
| externalIds.id | id | id field is hardcoded as null |
| externalIds.externalId | Id | The party ID |
| externalIds.externalIdType | External_Id_Type__c | The external system type identifier |
| externalIds.statusLastChangedDate | LastModifiedDate | Last modified date to "yyyy-MM-dd'T'HH:mm:ssz" |
| externalIds.status | VALID | The external Id status is hardcoded as VALID |
| auditInfo.createdDate | CreatedDate | The customer created date to "yyyy-MM-dd'T'HH:mm:ssz" |
| auditInfo.createdBy | CreatedBy.Name | The last created by user name |
| auditInfo.updatedDate | LastModifiedDate | The last updated date to "yyyy-MM-dd'T'HH:mm:ssz" |
| auditInfo.updatedBy | LastModifiedBy.Name | The last modified user name |
| auditInfo.isDeleted | IsDeleted | returns true if user deleted else false |
retrieve-search-parties-response-to-cim
Salesforce Lookup Account to Party CIM mapping
Source:
./src/main/resources/dwl/parties/retrieve-search-parties-response-to-cim.dwl
Mapping Tables
| CIM - party | Salesforce Global Data | Description |
|---|---|---|
| id | Id | The customer id in Salesforce Global Data System |
| party.id | Global_Party_Id__c | The party identifier stored in Salesforce Global Data System |
| partyType | RecordType.Name | The party type stored in Global Data System |
| externalIds.id | null | id field is hardcoded as null |
| externalIds.externalId | Id | The customer id in Salesforce Global Data System |
| externalIds.externalIdType | MDM | The ExternalIdType is hardcoded as MDM |
| externalIds.statusLastChangedDate | LastModifiedDate | Last modified date to "yyyy-MM-dd'T'HH:mm:ssz" |
| externalIds.status | VALID | The customer status is hardcoded as VALID |
| auditInfo.createdDate | CreatedDate | The customer created date to "yyyy-MM-dd'T'HH:mm:ssz" |
| auditInfo.createdBy | CreatedBy.Name | The last created by user name |
| auditInfo.updatedDate | LastModifiedDate | The last updated date to "yyyy-MM-dd'T'HH:mm:ssz" |
| auditInfo.updatedBy | LastModifiedBy.Name | The last modified user name |
| auditInfo.isDeleted | IsDeleted | returns true if user deleted else false |
retrieve-search-partyroles-response-to-cim
Salesforce Look up Account to PartyRole CIM mapping
Source:
./src/main/resources/dwl/partyroles/retrieve-search-partyroles-response-to-cim.dwl
Mapping Tables
| CIM - partyRole | Salesforce Global Data | Description |
|---|---|---|
| id | Id | The customer id in Salesforce Global Data System |
| partyRoleType | Customer | The party role type hard coded as Customer Global Data System |
| party.id | Id | The customer id in Salesforce Global Data System |
| partyType | RecordType.Name | The party type stored in Salesforce Global Data System |
| globalParty | Global_Party_Id__c | The global party stored in Salesforce Global Data System |
| externalIds.id | null | id field is hardcoded as null |
| externalIds.externalId | Id | The customer id in Salesforce Global Data System |
| externalIds.externalIdType | MDM | The ExternalIdType is hardcoded as MDM |
| externalIds.statusLastChangedDate | LastModifiedDate | Last modified date to "yyyy-MM-dd'T'HH:mm:ssz" |
| externalIds.status | VALID | The customer status is hardcoded as VALID |
| auditInfo.createdDate | CreatedDate | The customer created date to "yyyy-MM-dd'T'HH:mm:ssz" |
| auditInfo.createdBy | CreatedBy.Name | The last created by user name |
| auditInfo.updatedDate | LastModifiedDate | The last updated date to "yyyy-MM-dd'T'HH:mm:ssz" |
| auditInfo.updatedBy | LastModifiedBy.Name | The last modified user name |
| auditInfo.isDeleted | IsDeleted | returns true if user deleted else false |