Technical Articles

Priyanka Chakraborti

May 21, 2021 4 minute read

SAP Cloud Integration with Salesforce – Part 1

Introduction:

In this blog post, I will explain how to use Salesforce Adapter in Cloud Integration for a case replication scenario.

Scenario:

External system will send details related to the logged ticket in JSON format. This is mimicked using Postman. The message will contain requester’s email, account no of the organisation and other details related to the raised ticket.
Cloud Integration flow will receive the details and send it to Salesforce either to create a new case or update an existing case. Ticket no. will be used as an External ID in Salesforce for the ‘upsert’ function.
The response will be sent back to the calling system. In my case, Postman.

Prerequisite Setup:

Set up Integration Suite. This is necessary to create Integration flow in Cloud Integration.
Download and install Salesforce Adapter in Cloud Integration. Help Link: Salesforce Adapter. Go to Integration Package in CI -> Artifacts tab -> Add -> Integration Adapter. After successful deployment, it will show up in the Overview/Manage Integration Content, shown as below.
Create a trial account in Salesforce (https://developer.salesforce.com)

Setup in Salesforce:

After creating a trial account in Salesforce, go to Settings -> Reset My Security Token. It will send a new token to the registered email. I will use this token in Cloud Integration flow later along with my login credentials for Salesforce connectivity.

Reset%20Security%20Token%20in%20Salesforce

Reset Security Token in Salesforce

2. Create a Connected App in Salesforce. It will create a Consumer Key and a Secret. Connected%20App%20in%20Salesforce

Connected App in Salesforce

Help Link: Connected App in Salesforce

3. Create a custom field in Salesforce for Case object which will be used as External ID.

Custom%20Field%20in%20Salesforce

Custom Field in Salesforce

Help Link: Custom field in Salesforce

Design Solution in Cloud Integration:

Integration%20Flow

Integration Flow

Step 1:

Configure sender channel as below.

HTTPS%20Sender%20Channel

HTTPS Sender Channel

Step 2:

Call Local Integration Process via Process Call.

Step 2.a:

Convert JSON message to XML.

JSON%20to%20XML%20Converter

JSON to XML Converter

Step 2.b:

Set below properties in Content Modifier.

AccountNo will be used to get the Account ID in the next step.

queryId from Input message will be used as External ID.

Content%20Modifier

Content Modifier

Step 2.c:

Use Request Reply step to fetch Account ID using account number.

Receiver%20Salesforce%20Adapter%20Connection%20tab

Receiver Salesforce Adapter Connection tab

Basic Credential: Create User Credential in Manage Security Material. Login credentials will be used as user and password.
Security Token Alias: Create Secure Parameter in Manage Security Material to save Salesforce security token.
OAuth Credential: Create User Credential in Manage Security Material. Consumer key and consumer secret will be used as user and password, respectively.

Receiver%20Salesforce%20Adapter%20Processing%20tab

Receiver Salesforce Adapter Processing tab

Step 2.d:

Configure the Content Modifier step as shown below.

Content%20Modifier%20Exchange%20Property

Content Modifier Exchange Property

Content%20Modifier%20Message%20Body

Content Modifier Message Body

Step 2.e:

Use Message Mapping to map the input fields to desired sObject XSD structure. The XSD structure for sObject can be downloaded from Eclipse plugin – Salesforce Adapter Workbench.

XSD%20Generator

XSD Generator

Message%20Mapping

Message Mapping

Use Groovy Script to get value of property AccountId.

Groovy%20Script

Groovy Script

Step 2.f:

Use Request Reply step to send data to Salesforce.

Receiver%20Salesforce%20Adapter

Receiver Salesforce Adapter

Step 2.g:

Convert received XML payload back to JSON.

Test Execution:

Test Case 1: Create a new case in Salesforce

Trigger message using Postman tool to the cloud integration flow endpoint.

Postman%20Request/Response

Postman Request/Response

The record is created in Salesforce.

New%20Case%20in%20Salesforce

New Case in Salesforce

Test Case 2: Update the case in Salesforce

Postman%20request/Reply

Postman request/Reply

The record is updated in Salesforce.

Updated%20Case%20in%20Salesforce

Updated Case in Salesforce

Please note the data used in executing these scenarios is test data/ fake data only.

Behind the Scene:

While configuring the salesforce adapter, only the generic login URL of Salesforce is used. The actual execution happens in two steps. Both of these steps are handled by adapter level internally.

Step1: A call is made to https://login.salesforce.com/services/oauth2/token into Salesforce using login credentials, security token and client credentials. In response, salesforce returns an access token and instance URL.

Step 2: The next call is made to the instance URL along with a specific path (based on sObject) using the access token. That’s it!

Thank you for reading this blog post. Please feel free to share your feedback or thoughts or ask questions in the Q&A tag below.

https://answers.sap.com/tags/67837800100800006801

Regards,

Priyanka Chakraborti

Next – SAP Cloud Integration with Salesforce – Part 2

27 Comments

You must be Logged on to comment or reply to a post.

Anish Shah

May 21, 2021 at 5:11 pm

Excellent blog with step by step explanation, much helpful.

Priyanka Chakraborti

Blog Post Author

May 21, 2021 at 6:22 pm

Thanks 🙂

Syambabu Allu

May 22, 2021 at 8:17 am

Hi Priyanka,

Thanks for sharing in detailed blog on integration with salesforce adapter.

Thank you,

Syam

Priyanka Chakraborti

Blog Post Author

May 22, 2021 at 4:07 pm

Welcome 🙂

Allen Chew

May 22, 2021 at 3:25 pm

Very well presented. Like it 🙂

Priyanka Chakraborti

Blog Post Author

May 22, 2021 at 4:06 pm

Thanks 🙂

Meduturu Mastan Vali

May 23, 2021 at 5:49 am

Hi Priyanka,

Nice Blog 🙂

Can you provide steps to genarate XSD or attach the XSD you used in this blog.

Thank you

Priyanka Chakraborti

Blog Post Author

May 23, 2021 at 7:08 am

Hi Mastan,

To download the XSD, you need to add Eclipse plugin for Salesforce Adapter Workbench.

Help Link: Salesforce Adapter. It provides the path link for downloading the plugin from SAP Software Download Center. In the downloaded zip file, you will also get the documentation to use it for XSD generation.

Meduturu Mastan Vali

May 23, 2021 at 12:49 pm

Thank you Priyanka, it solved my problem

But when i deployed the artifact getting below error and also attached modeling

Error Details

[CONTENT][CONTENT_DEPLOY][GenerationFailed] : Validation failed: 1. Request Reply 1 is not supported for the adapter 2. Request Reply 2 is not supported for the adapter

Priyanka Chakraborti

Blog Post Author

May 23, 2021 at 1:51 pm

Hi Mastan,

Try to re-deploy the Iflow again. I also faced the same issue. After 2nd try, it successfully deployed.

Vasudevan Dharanipathy

October 15, 2021 at 3:58 am

Hi Mastan,

Could you provide steps to generate XSD or attach the XSD which you used.

Thank you.

Meduturu Mastan Vali

May 24, 2021 at 3:00 am

Hi Priyanka,

thank you, redeployment worked 🙂

Priyanka Chakraborti

Blog Post Author

May 24, 2021 at 3:27 am

Welcome 🙂

Priyansh Shah

July 19, 2021 at 10:05 am

Hello Priyanka,

Hope you are doing well and safe.

I just read your article. Honestly speaking, I learnt a lot from it. Design solution in cloud makes good impact on me.Thanks for sharing.

By the way, I just wanted to divert your attention here by presenting the The Ultimate Guide to Salesforce Integration With Third-Party Apps.

I hope once you read it, you will have a different approach towards salesforce integration.

Cheers

Have a nice day

Priyansh

Priyanka Chakraborti

Blog Post Author

July 26, 2021 at 3:11 pm

Thanks.

Souymodip Chakraborty

September 22, 2021 at 6:20 pm

Informative blog!

Priyanka Chakraborti

Blog Post Author

September 22, 2021 at 6:36 pm

Thanks

Vasudevan Dharanipathy

October 15, 2021 at 3:57 am

Hi Priyanka,

Excellent blog with step by step. Could you provide steps to generate XSD or attach the XSD which you used

Thanks.

Priyanka Chakraborti

Blog Post Author

October 16, 2021 at 6:46 am

Hi Vasudevan,

To download the XSD, you need to add Eclipse plugin for Salesforce Adapter Workbench.

Help Link: Salesforce Adapter. It provides the path link for downloading the plugin from SAP Software Download Centre. In the downloaded zip file, you will also get the documentation to use it for XSD generation.

Regards,

Priyanka

Vimal Pillai

January 4, 2022 at 3:02 pm

Hi Priyanka,

Brilliant blog.. Covers all the details for Sales force ticketing integration.

Keep blogging!!!!

Regards

Vimal

Priyanka Chakraborti

Blog Post Author

January 4, 2022 at 3:33 pm

Thanks Vimal 😊

Lucas Erni

April 8, 2022 at 9:42 am

Hi Priyanka

Thanks for the blogpost. Sadly I got the following Problem while configuring the adapter:

We created the user credentials in CPI
CPI Token is configured as a secure parameter
oAuth configured according to the official documentation, user = client id and password = client secret. Is this correct?

Currently we get the following error in the CPI:

org.apache.camel.CamelException: <?xml version="1.0" encoding="UTF-8" standalone="no"?> <array> <error>invalid_grant</error> <error_description>authentication failure</error_description> </array>

In Postman the request is working but as granttype we have set password instead of cliient_credentials.

Regards

Lucas

Priyanka Chakraborti

Blog Post Author

April 8, 2022 at 10:47 am

In OAuth Credential, you have to use consumer key and consumer secret that gets generated during creation of connected app ( step 2 of Setup in Salesforce).

Praneeth Modali

May 3, 2022 at 12:25 am

Hi Priyanka

I am beginner with CPI and Open connectors. Is there an article which explains Salesforce integration with 3rd party applications without installing the adapter. I do not have Admin in downloading the package and the eclipse setup .

I tried to import the .esa file and deploy but it do not give me the ability to edit iflow

Vijayakumar Konna

February 6, 2023 at 5:58 am

Hi Priyanka,

Excellent Blog, Thanks for sharing it.

I have question handle multiple External ID's on Upsert query. How to Handel this in CPI -Rojo SFDC adapter.

For example :Upsert

salesforce Object : Contract,Contract_Product__c

External ID: ContractNumber,Name

Sidharth Mehta

May 2, 2023 at 12:54 pm

Thanks Priyanka for this blog, and it really helped us alot.

In our scenario we have sender as SFDC, which post data based on CPI REST service /endpoint url.

Also, we have Oauth authentication from SFDC to CPI, and we have created Service keys from BTP Cockpit and it's working fine in postman.

In SFDC, they require - Tokem url , Client id, Client secret & Authentication url. But in Service key we don't receive Authentication url and it's mandatory for SFDC.

could you please help what we need to proivde?

Rodrigo de Oliveira Alarcon

May 18, 2023 at 7:26 pm

Não consegui baixar o Salesforce Adapter, existe algum outro local para baixá-lo?

Technical Articles

SAP Cloud Integration with Salesforce – Part 1

Introduction:

Scenario:

Prerequisite Setup:

Setup in Salesforce:

Design Solution in Cloud Integration:

Step 1:

Step 2:

Step 2.a:

Step 2.b:

Step 2.c:

Step 2.d:

Step 2.e:

Step 2.f:

Step 2.g:

Test Execution:

Test Case 1: Create a new case in Salesforce

Test Case 2: Update the case in Salesforce

Behind the Scene:

Assigned Tags