FlowService for SAP C4C Employee to Marketo SalesPerson data sync in webMethods.io New Flow Editor

Summary:

This article describes the step-by-step process of creating a FlowService in webMethods.io New Flow Editor for the data sync between SAP Cloud for Customer “Employee” business object and Marketo “Sales Person” business object.

Prerequisites:

  • User needs to have a working SAP Cloud for Customer account, to log into the SAP CRM tenant
  • User needs to have a working Marketo account, to log into the Marketo tenant
  • Access permission for SAP C4C APIs and Marketo APIs
  • Working webMethods.io tenant

Contents:

Creating FlowService in webMethods.io New Flow Editor for the data sync between SAP Cloud for Customer “Employee” business object and Marketo “Sales Person” business object.

Steps to create flowservice for SAP C4C Employee to Marketo Sales Person data sync in webMethods.io:

    1. Login to webMethods.io integration

    2. Click on Project and navigate to FlowServices

                  

    3. Create a flowservice

    4. Add Try-Catch control with getLastError and Exit flow with reason in case of failure

                  

    5. Define Input fields

                    

    6. Add SAP C4C connector and select Add Custom Operation

        Select pre-defined operation if existing already

                    

    7. Configure Account for SAP C4C connector using basic authentication

                      

    8. Set Metadata Caching to true while configuring account

                      

    9. Select the account configured and continue to create the custom operation

                      

                      

                       

    10. Select the custom operation "querySAPC4Cemployees" created and the SAP C4C account configured

                        

    11. Add the Repeat control to loop over the Employees list

                           

                       

    12. Add the If-Else control to filter the Employees list based on the filter parameter and map the list of Employees to upsert into Marketo as Sales                Person

                             

    13. Add the Marketo connector

                              

    14. Add the custom operation or select pre-defined operation of the Marketo connector and configure account using OAuth access token

                                 

                                  

    15. Select the Marketo operation "upsertMarketoSalesPerson" created and the account configured

                                  

    16. Add Do-Until control for the pagination of the Employee list queried from SAP C4C and iterate to upsert the Sales Person list into Marketo,                    default count is 100 records per iteration

                                   

    17. Once the flowservice is created, click on the Run button to execute it with the required inputs and check it is executed successfully.