RCG Loyalty Management Cloud System 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 |
|---|---|
| fulFillmentLocationRequest | |
| getOrderByIdResponse | Maps the Order and Order Product data from Loyalty Management Cloud to CIM |
| getOrdersQueryRequest | |
| getOrdersResponse | Maps the Order and Order Product data from Loyalty Management Cloud to CIM |
| orderLineItemRequest | Maps the CIM request to Order Product for Loyalty Management Cloud |
| orderProductTax | |
| postOrdersRequest | Maps the CIM request to Order for Loyalty Management Cloud |
| productPriceAdjustmentRequest | |
| storeRequest | |
| postCustomerRequest | Maps the CIM request to Customer Data for Loyalty Management Cloud |
| postLoyaltyProgramMemberRequest | Maps the CIM request to Loyalty Program Member data for Loyalty Management Cloud |
| postLoyaltyMemberTierRequest | Maps the CIM request to Loyalty Member Tier data for Loyalty Management Cloud |
| postCommSubscriptionConsentRequest | Maps the CIM request to Communication Subscription Consent data for Loyalty Management Cloud |
| getCustomersResponse | Maps the Customer Data from Loyalty Management Cloud to CIM |
| getCustomerByIdResponse | Maps the Customer Data from Loyalty Management Cloud to CIM |
fulFillmentLocationRequest
Source:
./src/main/resources/dwl/fulFillmentLocationRequest.dwl
Variables
var s
Maps CIM format to Salesforce fulFillmentLocation__c Object
Mapping Tables
Maps CIM format to Salesforce fulFillmentLocation__c Object
| Salesforce fulFillmentLocation__c | CIM | Description |
|---|---|---|
| activeFromDate__c | payload.fulFillmentLocation.activeFromDate | Active From Date of the fulFillmentLocation |
| name | payload.fulFillmentLocation.name | Name of the fulFillmentLocation |
| addressLine1__c | payload.fulFillmentLocation.addressLine1 | Address of the fulFillmentLocation |
| cityName__c | payload.fulFillmentLocation.cityName | City of the fulFillmentLocation |
| postalCodeText__c | payload.fulFillmentLocation.postalCodeText | Postal Code of the fulFillmentLocation |
| stateProvinceName__c | payload.fulFillmentLocation.stateProvinceName | State or Province name of the fulFillmentLocation |
| countryName__c | payload.fulFillmentLocation.countryName | Country name of the fulFillmentLocation |
| fulFillmentLocationType__c | payload.fulFillmentLocation.fulFillmentLocationType | Type of fulFillmentLocation information |
| contactPointType__c | payload.fulFillmentLocation.contactPointType[0] | Contact Point of the fulFillmentLocation |
| orderId__c | payload.id | Order information which fulFillmentLocation receive |
getOrderByIdResponse
Maps the Order and Order Product data from Loyalty Management Cloud to CIM
Source:
./src/main/resources/dwl/getOrderByIdResponse.dwl
Mapping Tables
Maps the Order and Order Product data from Loyalty Management Cloud to CIM
| CIM field | Loyalty Management Cloud field | Description | |
|---|---|---|---|
| id | Id | Order identifier in Loyalty Management Cloud | |
| name | Description | Order description | |
| description | Description | Order description | |
| orderNumber | OrderNumber | Order number in Loyalty Management Cloud | |
| requestedStartDate | EffectiveDate | Order date | |
| salesOrderType | Type | Order type | |
| salesOrderStatus | Status | Order status | |
| orderCurrency | |||
| orderLineItems.id | Id | Order Product identifier in Loyalty Management Cloud | |
| orderLineItems.description | Description | Order Product description | |
| orderLineItems.orderedQuantity | Quantity | Order Product quantity | |
| orderLineItems.unitPriceAmount | UnitPrice | Order Product unit price | |
| orderLineItems.totalPriceAmount | TotalPrice | Order Product total price | |
| orderLineItems.quantityOrderedUOM | |||
| orderLineItems.orderProductNumber | OrderItemNumber | Order Product number in Loyalty Management Cloud | |
| store.id | Id | Store identifier in Loyalty Management Cloud | |
| store.activeFromDate | activeFromDate__c | Store active from date | |
| store.name | Name | Store name | |
| store.addressLine1 | addressLine1__c | Store address | |
| store.cityName | cityName__c | Store city | |
| store.postalCodeText | postalCodeText__c | Store postal code | |
| store.stateProvinceName | stateProvinceName__c | Store state province name | |
| store.countryName | countryName__c | Store country | |
| store.storeType | storeType__c | Store type | |
| store.contactPointType | contactPointType__c | Store contact point type | |
| orderProductTax.id | Id | Order product identifier in Loyalty Management Cloud | |
| orderProductTax.country | country__c | Product country | |
| orderProductTax.name | Name | Product name | |
| orderProductTax.taxRatePercent | taxRatePercent__c | Product tax rate percent | |
| orderProductTax.taxClass | taxClass__c | taxClass__c | Product tax class |
| orderProductTax.taxCode | taxCode__c | taxCode__c | Product tax code |
| orderProductTax.salesOrderTaxAmount | salesOrderTaxAmount__c | Product sales order tax amount | |
| orderProductTax.taxAmount | taxAmount__c | Product tax amount | |
| orderProductTax.description | description__c | Product description | |
| fulFillmentLocation.id | Id | Fulfillment location identifier in Loyalty Management Cloud | |
| fulFillmentLocation.activeFromDate | activeFromDate__c | Fulfillment location active from date | |
| fulFillmentLocation.name | Name | Fulfillment location name | |
| fulFillmentLocation.addressLine1 | addressLine1__c | Fulfillment location address | |
| fulFillmentLocation.cityName | cityName__c | Fulfillment location city | |
| fulFillmentLocation.postalCodeText | postalCodeText__c | Fulfillment location postal code | |
| fulFillmentLocation.stateProvinceName | stateProvinceName__c | Fulfillment location state province name | |
| fulFillmentLocation.countryName | countryName__c | Fulfillment location country | |
| fulFillmentLocation.storeType | storeType__c | Fulfillment location store type | |
| fulFillmentLocation.contactPointType | contactPointType__c | Fulfillment location contact point type | |
| productPriceAdjustment.id | Id | Product price adjustment identifier in Loyalty Management Cloud | |
| productPriceAdjustment.description | description__c | Product price adjustment description | |
| productPriceAdjustment.adjustment | adjustment__c | Product price adjustment | |
| productPriceAdjustment.price | price__c | Product price adjustment price | |
| productPriceAdjustment.priceAdjustmentType | priceAdjustmentType__c | Product price adjustment type | |
| productPriceAdjustment.reason.reasonCodeType | reasonCodeType__c | Product price adjustment reason code type | |
| orderCustomer.id | Id | Order customer identifier | |
| orderCustomer.partyRoleType | Defaulted to 'Party' | ||
| orderCustomer.customerStatus | Defaulted to 'ACTIVE' | ||
| orderCustomer.party.id | id | Order customer identifier | |
| orderCustomer.party.personName | Name | Order customer name | |
| orderCustomer.party.firstName | FirstName | Order customer first name | |
| orderCustomer.party.lastName | LastName | Order customer last name | |
| orderCustomer.party.partyType | Defaulted to 'Individual' | ||
| orderCustomer.party.contactPoints.id | |||
| orderCustomer.party.contactPoints.telephoneNumber | Phone | Order customer contact point telephone number | |
| orderCustomer.party.contactPoints.activeFromDate | Active from date | ||
| orderCustomer.party.contactPoints.contactPointType | ContactPointPhone | ||
| orderCustomer.party.contactPoints.id | |||
| orderCustomer.party.contactPoints.activeFromDate | Active from date | ||
| orderCustomer.party.contactPoints.addressLine1 | BillingStreet | Order customer contact point address | |
| orderCustomer.party.contactPoints.cityName | BillingCity | Order customer contact point city | |
| orderCustomer.party.contactPoints.postalCodeText | BillingPostalCode | Order customer contact point postal code | |
| orderCustomer.party.contactPoints.stateProvinceName | BillingState | Order customer contact point billing state | |
| orderCustomer.party.contactPoints.countryName | BillingCountry | Order customer contact point billing country | |
| orderCustomer.party.contactPoints.contactPointType | ContactPointAddress | ||
| orderCustomer.party.contactPoints.id | |||
| orderCustomer.party.contactPoints.activeFromDate | Active from date | ||
| orderCustomer.party.contactPoints.emailAddress | PersonEmail | Order customer contact point email | |
| orderCustomer.party.contactPoints.contactPointType | ContactPointEmail | ||
| externalId.id | |||
| externalId.externalId | Global_SalesOrder_Id__c | Global sales order identifier | |
| externalId.externalIdType | Defaulted to 'MDM' | ||
| externalId.status | Defaulted to 'VALID' | ||
| grandTotalAmount | OrderTotalAmount__c | Order total amount | |
| totalProductAmount | TotalAmount | Total product amount | |
| totalDeliveryFeeAmount | Shipping__c | Shipping | |
| totalTaxAmount | Total_Tax__c | Total tax |
getOrdersQueryRequest
Source:
./src/main/resources/dwl/getOrdersQueryRequest.dwl
getOrdersResponse
Maps the Order and Order Product data from Loyalty Management Cloud to CIM
Source:
./src/main/resources/dwl/getOrdersResponse.dwl
Mapping Tables
Maps the Order and Order Product data from Loyalty Management Cloud to CIM
| CIM field | Loyalty Management Cloud field | Description | |
|---|---|---|---|
| id | Id | Order identifier in Loyalty Management Cloud | |
| name | Description | Order description | |
| description | Description | Order description | |
| orderNumber | OrderNumber | Order number in Loyalty Management Cloud | |
| requestedStartDate | EffectiveDate | Order date | |
| salesOrderType | Type | Order type | |
| salesOrderStatus | Status | Order status | |
| orderCurrency | |||
| orderLineItems.id | Id | Order Product identifier in Loyalty Management Cloud | |
| orderLineItems.description | Description | Order Product description | |
| orderLineItems.orderedQuantity | Quantity | Order Product quantity | |
| orderLineItems.unitPriceAmount | UnitPrice | Order Product unit price | |
| orderLineItems.totalPriceAmount | TotalPrice | Order Product total price | |
| orderLineItems.quantityOrderedUOM | |||
| orderLineItems.orderProductNumber | OrderItemNumber | Order Product number in Loyalty Management Cloud | |
| store.id | Id | Store identifier in Loyalty Management Cloud | |
| store.activeFromDate | activeFromDate__c | Store active from date | |
| store.name | Name | Store name | |
| store.addressLine1 | addressLine1__c | Store address | |
| store.cityName | cityName__c | Store city | |
| store.postalCodeText | postalCodeText__c | Store postal code | |
| store.stateProvinceName | stateProvinceName__c | Store state province name | |
| store.countryName | countryName__c | Store country | |
| store.storeType | storeType__c | Store type | |
| store.contactPointType | contactPointType__c | Store contact point type | |
| orderProductTax.id | Id | Order product identifier in Loyalty Management Cloud | |
| orderProductTax.country | country__c | Product country | |
| orderProductTax.name | Name | Product name | |
| orderProductTax.taxRatePercent | taxRatePercent__c | Product tax rate percent | |
| orderProductTax.taxClass | taxClass__c | taxClass__c | Product tax class |
| orderProductTax.taxCode | taxCode__c | taxCode__c | Product tax code |
| orderProductTax.salesOrderTaxAmount | salesOrderTaxAmount__c | Product sales order tax amount | |
| orderProductTax.taxAmount | taxAmount__c | Product tax amount | |
| orderProductTax.description | description__c | Product description | |
| fulFillmentLocation.id | Id | Fulfillment location identifier in Loyalty Management Cloud | |
| fulFillmentLocation.activeFromDate | activeFromDate__c | Fulfillment location active from date | |
| fulFillmentLocation.name | Name | Fulfillment location name | |
| fulFillmentLocation.addressLine1 | addressLine1__c | Fulfillment location address | |
| fulFillmentLocation.cityName | cityName__c | Fulfillment location city | |
| fulFillmentLocation.postalCodeText | postalCodeText__c | Fulfillment location postal code | |
| fulFillmentLocation.stateProvinceName | stateProvinceName__c | Fulfillment location state province name | |
| fulFillmentLocation.countryName | countryName__c | Fulfillment location country | |
| fulFillmentLocation.storeType | storeType__c | Fulfillment location store type | |
| fulFillmentLocation.contactPointType | contactPointType__c | Fulfillment location contact point type | |
| productPriceAdjustment.id | Id | Product price adjustment identifier in Loyalty Management Cloud | |
| productPriceAdjustment.description | description__c | Product price adjustment description | |
| productPriceAdjustment.adjustment | adjustment__c | Product price adjustment | |
| productPriceAdjustment.price | price__c | Product price adjustment price | |
| productPriceAdjustment.priceAdjustmentType | priceAdjustmentType__c | Product price adjustment type | |
| productPriceAdjustment.reason.reasonCodeType | reasonCodeType__c | Product price adjustment reason code type | |
| orderCustomer.id | Id | Order customer identifier | |
| orderCustomer.partyRoleType | Defaulted to 'Party' | ||
| orderCustomer.customerStatus | Defaulted to 'ACTIVE' | ||
| orderCustomer.party.id | id | Order customer identifier | |
| orderCustomer.party.personName | Name | Order customer name | |
| orderCustomer.party.firstName | FirstName | Order customer first name | |
| orderCustomer.party.lastName | LastName | Order customer last name | |
| orderCustomer.party.partyType | Defaulted to 'Individual' | ||
| orderCustomer.party.contactPoints.id | |||
| orderCustomer.party.contactPoints.telephoneNumber | Phone | Order customer contact point telephone number | |
| orderCustomer.party.contactPoints.activeFromDate | Active from date | ||
| orderCustomer.party.contactPoints.contactPointType | ContactPointPhone | ||
| orderCustomer.party.contactPoints.id | |||
| orderCustomer.party.contactPoints.activeFromDate | Active from date | ||
| orderCustomer.party.contactPoints.addressLine1 | BillingStreet | Order customer contact point address | |
| orderCustomer.party.contactPoints.cityName | BillingCity | Order customer contact point city | |
| orderCustomer.party.contactPoints.postalCodeText | BillingPostalCode | Order customer contact point postal code | |
| orderCustomer.party.contactPoints.stateProvinceName | BillingState | Order customer contact point billing state | |
| orderCustomer.party.contactPoints.countryName | BillingCountry | Order customer contact point billing country | |
| orderCustomer.party.contactPoints.contactPointType | ContactPointAddress | ||
| orderCustomer.party.contactPoints.id | |||
| orderCustomer.party.contactPoints.activeFromDate | Active from date | ||
| orderCustomer.party.contactPoints.emailAddress | PersonEmail | Order customer contact point email | |
| orderCustomer.party.contactPoints.contactPointType | ContactPointEmail | ||
| externalId.id | |||
| externalId.externalId | Global_SalesOrder_Id__c | Global sales order identifier | |
| externalId.externalIdType | Defaulted to 'MDM' | ||
| externalId.status | Defaulted to 'VALID' | ||
| grandTotalAmount | OrderTotalAmount__c | Order total amount | |
| totalProductAmount | TotalAmount | Total product amount | |
| totalDeliveryFeeAmount | Shipping__c | Shipping | |
| totalTaxAmount | Total_Tax__c | Total tax |
orderLineItemRequest
Maps the CIM request to Order Product for Loyalty Management Cloud
Source:
./src/main/resources/dwl/orderLineItemRequest.dwl
Mapping Tables
Maps the CIM request to Order Product for Loyalty Management Cloud
| Loyalty Management Cloud field | CIM field | Description |
|---|---|---|
| id | Id | Order Product identifier in Loyalty Management Cloud |
| OrderId | id | Order identifier in Loyalty Management Cloud |
| Product2Id | Product identifier in Loyalty Management Cloud | |
| PricebookEntryId | PricebookEntry identifier in Loyalty Management Cloud | |
| Description | description | Order Product description |
| UnitPrice | unitPriceAmount | Order Product unit price |
| Quantity | orderedQuantity | Order Product quantity |
orderProductTax
Source:
./src/main/resources/dwl/orderProductTax.dwl
Variables
var s
Maps CIM format to Salesforce orderProductTax__c Object
Mapping Tables
Maps CIM format to Salesforce orderProductTax__c Object
| Salesforce orderProductTax__c | CIM | Description |
|---|---|---|
| description__c | payload.orderProductTax.description | Order product tax description |
| taxAmount__c | payload.orderProductTax.taxAmount | Order product tax amount |
| salesOrderTaxAmount__c | payload.orderProductTax.salesOrderTaxAmount | salesOrderTaxAmount |
| taxCode__c | payload.orderProductTax.taxCode | Order taxCode |
| taxClass__c | payload.orderProductTax.taxClass | Order taxClass |
| taxRatePercent__c | payload.orderProductTax.taxRatePercent | Order taxRatePercent |
| name | payload.orderProductTax.reasonCodeType | Order product tax name |
| country__c | payload.orderProductTax.country | Order product tax country |
| orderId__c | payload.id | Order id |
postOrdersRequest
Maps the CIM request to Order for Loyalty Management Cloud
Source:
./src/main/resources/dwl/postOrdersRequest.dwl
Variables
var s
Maps the CIM request to Order for Loyalty Management Cloud
Mapping Tables
Maps the CIM request to Order for Loyalty Management Cloud
| Loyalty Management Cloud field | CIM field | Description |
|---|---|---|
| id | id | Order identifier in Loyalty Management Cloud |
| Global_SalesOrder_Id__c | externalId | Global Order identifier in Loyalty Management Cloud |
| AccountId | accountId | Account identifier in Loyalty Management Cloud |
| EffectiveDate | requestedStartDate | Order date |
| Pricebook2Id | Pricebook identifier in Loyalty Management Cloud | |
| Type | salesOrderType | Sales Order type |
| Status | salesOrderStatus | Sales Order status |
| Description | description | Order description |
productPriceAdjustmentRequest
Source:
./src/main/resources/dwl/productPriceAdjustmentRequest.dwl
Variables
var s
Maps CIM format to Salesforce productPriceAdjustment__cc Object
Mapping Tables
Maps CIM format to Salesforce productPriceAdjustment__cc Object
| Salesforce productPriceAdjustment__c | CIM | Description |
|---|---|---|
| description__c | payload.productPriceAdjustment.description | Product Price Adjustment description |
| adjustment__c | payload.productPriceAdjustment.adjustment | Product Price Adjustment |
| price__c | payload.productPriceAdjustment.price | Product Price Adjustment Price |
| priceAdjustmentType__c | payload.productPriceAdjustment.priceAdjustmentType | Product Price Adjustment type |
| reasonCodeType__c | payload.productPriceAdjustment.reasonCodeType | Product Price Adjustment reason code |
| orderId__c | payload.id | Order price adjustment |
storeRequest
Source:
./src/main/resources/dwl/storeRequest.dwl
Variables
var s
Maps CIM format to Salesforce Store__c Object
Mapping Tables
Maps CIM format to Salesforce Store__c Object
| Salesforce Store__c | CIM | Description |
|---|---|---|
| activeFromDate__c | payload.store.activeFromDate | Active From Date of the store |
| name | payload.store.name | Name of the store |
| addressLine1__c | payload.store.addressLine1 | Address of the store |
| cityName__c | payload.store.cityName | City of the store |
| postalCodeText__c | payload.store.postalCodeText | Postal Code of the store |
| stateProvinceName__c | payload.store.stateProvinceName | State or Province name of the store |
| countryName__c | payload.store.countryName | Country name of the store |
| storeType__c | payload.store.storeType | Type of Store information |
| contactPointType__c | payload.store.contactPointType[0] | Contact Point of the store |
| orderId__c | payload.id | Order information which store receive |
postCustomerRequest
Maps the CIM request to Customer Data for Loyalty Management Cloud
Source:
./src/main/resources/dwl/postCustomerRequest.dwl
Mapping Tables
Maps the CIM request to Customer Data for Loyalty Management Cloud
| Loyalty Management Cloud field | CIM field | Description |
|---|---|---|
| id | id | Account identifier in Loyalty Management Cloud |
| RecordTypeId | recordTypeId | Record Type identifier |
| FirstName | firstName | Customer FirstName |
| LastName | lastName | Customer LastName |
| Phone | contactPoints.telephoneNumber | ContactPoint Telephone Number |
| PersonEmail | contactPoints.emailAddress | ContactPoint Email Address |
| BillingStreet | contactPoints.addressLine1 | ContactPoint Billing Address Line1 |
| BillingCity | contactPoints.cityName | ContactPoint Billing City Name |
| BillingPostalCode | contactPoints.postalCodeText | ContactPoint Billing Postal Code Text |
| BillingState | contactPoints.stateProvinceName | ContactPoint Billing State Province Name |
| BillingCountry | contactPoints.countryName | ContactPoint Billing Country Name |
| ShippingStreet | contactPoints.addressLine1 | ContactPoint Shipping Address Line1 |
| ShippingCity | contactPoints.cityName | ContactPoint Shipping City Name |
| ShippingPostalCode | contactPoints.postalCodeText | ContactPoint Shipping Postal Code Text |
| ShippingState | contactPoints.stateProvinceName | ContactPoint Shipping State Province Name |
| ShippingCountry | contactPoints.countryName | ContactPoint Shipping Country Name |
| Global_Customer_Id__c | externalId | External identifier |
postLoyaltyProgramMemberRequest
Maps the CIM request to Loyalty Program Member data for Loyalty Management Cloud
Source:
./src/main/resources/dwl/postLoyaltyProgramMemberRequest.dwl
Mapping Tables
Maps the CIM request to Loyalty Program Member data for Loyalty Management Cloud
| Loyalty Management Cloud field | CIM field | Description |
|---|---|---|
| id | id | Loyalty Program Member identifier in Loyalty Management Cloud |
| MemberType | Default value 'Individual' | |
| ProgramId | Program identifier | |
| ContactId | Contact identifier | |
| MembershipNumber | Membership Number | |
| EnrollmentDate | Enrollment Date | |
| MemberStatus | Default value 'Active' |
postLoyaltyMemberTierRequest
Maps the CIM request to Loyalty Member Tier data for Loyalty Management Cloud
Source:
./src/main/resources/dwl/postLoyaltyMemberTierRequest.dwl
Mapping Tables
Maps the CIM request to Loyalty Member Tier data for Loyalty Management Cloud
| Loyalty Management Cloud field | CIM field | Description |
|---|---|---|
| id | id | Loyalty Member Tier identifier in Loyalty Management Cloud |
| LoyaltyMemberId | Loyalty Program Member identifier | |
| LoyaltyTierGroupId | Loyalty Tier Group identifier | |
| LoyaltyTierId | Loyalty Tier identifier | |
| Name | name | Loyalty Member Tier name |
| EffectiveDate | Effective date | |
| Display__c | display | Display |
| ImageURL__c | imageURL | Image URL |
postCommSubscriptionConsentRequest
Maps the CIM request to Communication Subscription Consent data for Loyalty Management Cloud
Source:
./src/main/resources/dwl/postCommSubscriptionConsentRequest.dwl
Mapping Tables
Maps the CIM request to Communication Subscription Consent data for Loyalty Management Cloud
| Loyalty Management Cloud field | CIM field | Description |
|---|---|---|
| id | id | Communication Subscription Consent identifier in Loyalty Management Cloud |
| Name | name | Consent name |
| ConsentGiverId | id | Account identifier |
| ContactPointId | contactPointDetails.contactPointEmailId | ContactPointDetails identifier |
| CommSubscriptionChannelTypeId | Communication Subscription Channel Type identifier | |
| PrivacyConsentStatus | consentStatus | Consent Status |
| EffectiveFromDate | Effective From Date |
getCustomersResponse
Maps the Customer Data from Loyalty Management Cloud to CIM
Source:
./src/main/resources/dwl/getCustomersResponse.dwl
Variables
var s
Maps the Customer Data from Loyalty Management Cloud to CIM
Mapping Tables
Maps the Customer Data from Loyalty Management Cloud to CIM
| CIM field | Loyalty Management Cloud field | Description |
|---|---|---|
| id | id | Account identifier in Loyalty Management Cloud |
| partyRoleType | Default value 'Customer' | |
| party.id | Account identifier in Loyalty Management Cloud | |
| party.personName | Name | Account name (concatenation of firstName + lastName) |
| party.firstName | firstName | Customer firstName |
| party.lastName | lastName | Customer lastName |
| party.partyType | Default value 'Individual' | |
| party.contactPoints.contactPointType | Default value ContactPointAddress | |
| party.contactPoints.activeFromDate | CreatedDate | Created Date |
| party.contactPoints.addressLine1 | BillingStreet | Billing Street |
| party.contactPoints.cityName | BillingCity | Billing City |
| party.contactPoints.postalCodeText | BillingPostalCode | Billing Postal Code |
| party.contactPoints.stateProvinceName | BillingState | Billing State |
| party.contactPoints.countryName | BillingCountry | Billing Country |
| party.contactPoints.contactPointType | Default value ContactPointEmail | |
| party.contactPoints.activeFromDate | CreatedDate | Created Date |
| party.contactPoints.emailAddress | PersonEmail | Person Email |
| party.contactPoints.contactPointType | Default value ContactPointPhone | |
| party.contactPoints.activeFromDate | CreatedDate | Created Date |
| party.contactPoints.telephoneNumber | Phone | Phone |
| party.loyaltyProgramMember.accountId | id | Account identifier |
| party.loyaltyProgramMember.storeId | Store identifier | |
| party.loyaltyProgramMember.loyaltyProgramId | ProgramId | Loyalty Program identifier |
| party.loyaltyMemberTier.name | Name | Loyalty Member Tier name |
| party.loyaltyMemberTier.display | Display__c | Display |
| party.loyaltyMemberTier.imageURL | ImageURL__c | ImageURL |
| party.communicationSubscriptionConsent.name | Name | Communication Subscription Consent name |
| party.communicationSubscriptionConsent.consentStatus | PrivacyConsentStatus | Communication Subscription Consent status |
| party.communicationSubscriptionConsent.ownerId | ConsentGiverId | Communication Subscription Consent giver identifier |
| party.externalIds.externalId | Global_Customer_Id__c | Global Customer identifier |
| party.externalIds.externalIdType | Default value 'MDM' | |
| party.externalIds.statusLastChangedDate | LastModifiedDate | Last modified date |
| party.auditInfo.createdDate | CreatedDate | Created date |
| party.auditInfo.createdBy | CreatedById | Created by id |
| party.auditInfo.updatedDate | LastModifiedDate | Last modified date |
| party.auditInfo.updatedBy | LastModifiedById | Last modified by id |
| party.auditInfo.isDeleted | Default value 'false' | |
| party.customerStatus | Default value 'ACTIVE' |
getCustomerByIdResponse
Maps the Customer Data from Loyalty Management Cloud to CIM
Source:
./src/main/resources/dwl/getCustomerByIdResponse.dwl
Mapping Tables
Maps the Customer Data from Loyalty Management Cloud to CIM
| CIM field | Loyalty Management Cloud field | Description |
|---|---|---|
| id | id | Account identifier in Loyalty Management Cloud |
| partyRoleType | Default value 'Customer' | |
| party.id | Account identifier in Loyalty Management Cloud | |
| party.personName | Name | Account name (concatenation of firstName + lastName) |
| party.firstName | firstName | Customer firstName |
| party.lastName | lastName | Customer lastName |
| party.partyType | Default value 'Individual' | |
| party.contactPoints.contactPointType | Default value ContactPointAddress | |
| party.contactPoints.activeFromDate | CreatedDate | Created Date |
| party.contactPoints.addressLine1 | BillingStreet | Billing Street |
| party.contactPoints.cityName | BillingCity | Billing City |
| party.contactPoints.postalCodeText | BillingPostalCode | Billing Postal Code |
| party.contactPoints.stateProvinceName | BillingState | Billing State |
| party.contactPoints.countryName | BillingCountry | Billing Country |
| party.contactPoints.contactPointType | Default value ContactPointEmail | |
| party.contactPoints.activeFromDate | CreatedDate | Created Date |
| party.contactPoints.emailAddress | PersonEmail | Person Email |
| party.contactPoints.contactPointType | Default value ContactPointPhone | |
| party.contactPoints.activeFromDate | CreatedDate | Created Date |
| party.contactPoints.telephoneNumber | Phone | Phone |
| party.loyaltyProgramMember.accountId | id | Account identifier |
| party.loyaltyProgramMember.storeId | Store identifier | |
| party.loyaltyProgramMember.loyaltyProgramId | ProgramId | Loyalty Program identifier |
| party.loyaltyMemberTier.name | Name | Loyalty Member Tier name |
| party.loyaltyMemberTier.display | Display__c | Display |
| party.loyaltyMemberTier.imageURL | ImageURL__c | ImageURL |
| party.communicationSubscriptionConsent.name | Name | Communication Subscription Consent name |
| party.communicationSubscriptionConsent.consentStatus | PrivacyConsentStatus | Communication Subscription Consent status |
| party.communicationSubscriptionConsent.ownerId | ConsentGiverId | Communication Subscription Consent giver identifier |
| party.externalIds.externalId | Global_Customer_Id__c | Global Customer identifier |
| party.externalIds.externalIdType | Default value 'MDM' | |
| party.externalIds.statusLastChangedDate | LastModifiedDate | Last modified date |
| party.auditInfo.createdDate | CreatedDate | Created date |
| party.auditInfo.createdBy | CreatedById | Created by id |
| party.auditInfo.updatedDate | LastModifiedDate | Last modified date |
| party.auditInfo.updatedBy | LastModifiedById | Last modified by id |
| party.auditInfo.isDeleted | Default value 'false' | |
| party.customerStatus | Default value 'ACTIVE' |