Introduction
Skyvva, with its SAP Business ByDesign adapter, offers a seamless integration solution between Salesforce and SAP Business ByDesign. In this tutorial, we will focus on utilizing the operation get feature to retrieve records from SAP Business ByDesign, enabling their insertion or updating in Salesforce. By leveraging this feature, users can efficiently fetch data from SAP Business ByDesign and ensure its accurate synchronization with Salesforce, streamlining the integration process between the two systems.
To GET record in sap business by design using OData, we need to using sap business by design adapter with operation GET and we need to know the ObjectID which will use in PATH Parameter.
How to get specific record from sap business bydesign ?
Pre-required
- Create Integration
- Create Connection Destination in Sap bydesign.
- Create Metadata and Repository
- Generate Message Type of Material
- Create Request Response Interfaces and linked with message Type
- Create Sap Business Bydesign adapter and Linked with request Interface.
Step 1 : Create Integration
- Here’s Integration
Step2: Create Connection Destination of SAP Business Bydesign.
- Go to Integration detail-> Click Sap Control board.
- Destination: New, fill name, choose type: Sap Business ByDesign and click continue button.
- Fill Host URL which is the OData API of sap business bydeisgn, fill Username and password which have permission to access the service that to get API OData fill your path of the sap API of By design see the example below.
- Click Ping SAP Connection to make sure that the SAP Credential is correct.
Step3: Create Metadata and Repository
- Here’s the Metadata.
- Here’s the Repository
Step4 : Generate Material Message Type.
- Go to SAP control board -> Ping connection SAP Business Bydesign -> click Metadata. Choose the Metadata and Repository which created in step3 and click Import Sap Metadata button.
- Select the Application: SAP Business ByDesign, Select the connection Destination , Select Type Rest Template and click retrive button.
- Find the Entity that we want to do, in this case We choose Material Collection for Create, Update, Get and Delete. Then click Generate Message Type.
- Here’s the message type that we generate.
Due to we have generated already in case create record in sap by design, so we can use the template existed.
In case Update Material we need to have ObjectID so we can use in mapping by add field Object ID in the node Path _Paramater as the dynamic value.
- To add fields in PATH Parameter, we need to go PATH Parameter and click detail
- Create field ObjectID. See the picture below.
Fill the MsgType Field Entry Name and Istructure then click Save.
Step 5: Create Integration, Outbound Interface.
- Create Outbound Interface and linked with message type. See the picture below.
- Do mapping
- Create Inbound Interface
Due to we have Inbound Interface in case 1 so we can using this interface .
- Here’s Inbound Inteface.
- Create Response Interface.
- Do mapping
Linked the Response with Interface.
- Go to Request Interface.
Linked the Response with Interface.
- Go to Request Interface.
Step 6: Create SAP Business Bydesign using operation GET.
- Linked this adapter with Outbound Interface see the picture below.
Step 6: Callout by manual Process button on Integration.
- Go to integration, Click Interface tap, select request Interface and click manually processing see the picture below. Click next button.
- Select Account and click Execute SOQL
- We can do SOQL with the fields that we want. Then select Record and click Ok
Noted: In case Update Material we have update the Description so when we are using the operation get it will get the new value from sap business by design system to salesforce.
- Go to monitor to see the result
- Click Account to see the new value description.
- Here’s the result.
We can see the account is modified Description because we using the account to update record in case update record so when we get the record from sap business by design it will get the latest value in sap business by design.