Integration Cloud 6.1.0 | Recipes | SAP C4C Employee to Marketo Sales Person Data Sync
 
SAP C4C Employee to Marketo Sales Person Data Sync
This section describes the recipe for the data sync between SAP Cloud for Customer Employee business object and Marketo Sales Person business object.
SAP Cloud for Customer (C4C) is a cloud solution to manage customer sales, customer service, and marketing activities efficiently and is one of the key SAP solutions to manage customer relationships.
Marketo provides software platforms and technologies designed for marketing departments such as account-based marketing, which includes email, mobile, social, digital ads, web management, and analytics.
Business Use Case
The business purpose of this integration is to extract the SAP Cloud for Customer Employee records and upsert them in Marketo as the records for Salesperson.
Custom Fields
When the Employee object gets synced in Marketo, it needs to be created or updated with the custom fields mentioned below.
On SAP C4C
Comments
MKTOEmployeeID
The custom field needs to be created for Employee records in SAP C4C to hold the Marketo Sales Person records id.
Product Compatibility
The recipe is tested for SAP Cloud for Customer product version 1908.04.0006. Hence the recipe is compatible to run for the tested and older versions of the product.
SAP C4C Employee to Marketo Sales Person Sync Flow
This integration "SAPC4CToMarketoSalesPersonDataSync" is designed to run for initial as well as ongoing sync. As part of initial sync, all the employee records present in SAP C4C will be synced to Marketo. On the other hand, as part of ongoing sync, the newly created or updated Employee records will be synced to Marketo for the provided date range. Once the record is successfully created in Marketo, it syncs back the Marketo Salesperson ID in the corresponding SAP C4C Employee record (Custom Field: MKTOEmployeeID).
The following diagram represents creating a Salesperson in Marketo from an Employee in SAP C4C:
Operations Used
This recipe has a sub flow to handle the obsolete contact record in SAP C4C, that is, updateDeletedSAPC4CContactsToMkto.
Operation Name
Application
Description
querySAPC4CEmployees
SAP C4C
Queries SAP C4C Employee.
upsertMarketoSalesPerson
Marketo
Upserts Employee in Marketo as SalesPerson records.
patchSAPC4CMultipleContact
SAP C4C
Once records are successfully created in Marketo, it updates Marketo SalesPerson ID in the corresponding SAP C4C employee record in the MKTOEmployeeID custom field.
1. querySAPC4CEmployees
Input Filter parameter
Sl.No
Condition
Filter to query records from SAP
1
IsInitialSync = True
No filter required.
2
IsInitialSync = False
ChangedOn ge datetimeoffset'%fromDateString%'
Note:
Pagination is taken care in the recipe where it fetches 100 records per API Call.
2. upsertMarketoSalesPerson
Field Mapping
SAP - EMPLOYEE
MKTO - SALES PERSON
EmployeeID
Standard
externalSalesPersonID
Standard
Email
Standard
email
Standard
FaxNumber
Standard
fax
Standard
FirstName
Standard
firstName
Standard
LastName
Standard
lastName
Standard
MobilePhoneNumber
Standard
mobilePhone
Standard
OfficePhoneNumber
Standard
phone
Standard
JobName
Standard
title
Standard
3. patchMultipleEmployee
Once Employee records are successfully created in Marketo as SalesPerson records, then update Marketo SalesPerson ID to the corresponding SAP C4C employee record in the MKTOEmployeeID custom field.
MKTO - SALES PERSON
SAP - EMPLOYEE
ID
Standard
MKTOEmployeeID
CustomField
CountryCode
Standard
CountryCode
Standard
FirstName
Standard
FirstName
Standard
LastName
Standard
LastName
Standard
ObjectID
Standard
ObjectID
Standard
Usage Notes
*In order to add new standard or custom fields to the integration, copy the required field and add it to empList_NullMKTOID list and empList_WithMKTOID list while making the upsert API call to Marketo.
*In order to change or remove standard or custom fields from the integration, remove the required field mapping and change or remove the field from empList_NullMKTOID list and empList_WithMKTOID list while making the upsert API call to Marketo.