Introduction
The Skyvva integration platform’s adapter for SAP Business ByDesign includes an operation patch feature, enabling seamless updates of records in SAP Business ByDesign from Salesforce. This feature simplifies the synchronization and accuracy of data between the two systems, streamlining workflows and eliminating the need for manual data entry. By leveraging the operation patch capability, businesses can efficiently update records in SAP Business ByDesign using the latest information from Salesforce, improving efficiency and data consistency.
To Update record in sap business by design using OData, we need to using sap business by design adapter with operation Update and we need to know the ObjectID which will use in PATH Parameter.
How to using Sap Business Bydesign adapter with operation Patch?
Pre-required
- Create Integration
- Create Connection Destination in Sap bydesign.
- Create Metadata and Repository
- Generate Message Type of Material
- Create Request Interface 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: Outbound Interface.
- Create Outbound Interface and linked with message type. See the picture below.
- Do mapping
Step 6: Create Sap Business Bydesign adapter and Linked with request Interface.
Click New button and fill the required fill such as Name, Type: SAP Business By Design, Direction: Outbound, Status: Active, Protocol: Rest, Authentication Type: Basic, Operation: PATCH, API Service Endpoint URL : The URL OData material , Request format : application/json, response format: application/json and put the connection destination.
Noted: We need to use (‘ {!ObjectID}‘) in URL PATH Parameter for put the value dynamic from fields of salesforce record.
- Linked adapter with outbound Interface.
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
- Go to monitor to see the result