Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
PriyankaChak
Active Contributor

Introduction:


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

Scenario:



  1. 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.

  2. 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.

  3. The response will be sent back to the calling system. In my case, Postman.


Prerequisite Setup:



  1. Set up Integration Suite. This is necessary to create Integration flow in Cloud Integration. 

  2. 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.                         

  3. Create a trial account in Salesforce (https://developer.salesforce.com)


Setup in Salesforce:



  1. 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 Security Token in Salesforce


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


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 Field in Salesforce


   Help Link: Custom field in Salesforce

 

Design Solution in Cloud Integration:


 


Integration Flow


 

Step 1:


Configure sender channel as below.


HTTPS Sender Channel



Step 2:


Call Local Integration Process via Process Call.

Step 2.a:


Convert JSON message to XML.


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 Modifier



Step 2.c:


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


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 Salesforce Adapter Processing tab



Step 2.d:


Configure the Content Modifier step as shown below.


Content Modifier Exchange Property



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 Generator



Message Mapping


Use Groovy Script to get value of property AccountId.


Groovy Script



Step 2.f:


Use Request Reply step to send data to Salesforce.


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 Request/Response


The record is created in Salesforce.


New Case in Salesforce



Test Case 2: Update the case in Salesforce



Postman request/Reply


The record is updated in Salesforce.


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

35 Comments
Labels in this area