3 hours ago
3
Overview
In the previous parts of this series, we explored various SAP CPI pallet functions and learned how message payloads can be transformed and processed within an integration flow. Building on that foundation, this hands-on exercise focuses on consuming OData services using the OData Adapter and the Request-Reply pallet function in SAP Cloud Platform Integration (SAP CPI).
OData (Open Data Protocol) is a widely adopted standard for exposing and consuming data through RESTful APIs. Many SAP applications, including SAP S/4HANA and SuccessFactors, expose business data through OData services, making it an essential technology for integration developers.
OData Adapter & Request Reply
The OData Adapter allows SAP CPI to connect and interact with OData services using a configuration-driven approach. The Request-Reply step enables synchronous processing by sending a request to a receiver system and waiting for the corresponding response.
In this exercise, we will use the publicly available Northwind OData Service to understand how SAP CPI interacts with OData endpoints. We will first validate the service using Postman, explore the available entities, and then configure an OData Receiver Adapter within an integration flow. Finally, we will retrieve data from the service using the Request-Reply pattern and verify the response.
https://services.odata.org/V2/Northwind/Northwind.svc
Before configuring the integration flow, let’s test the service using Postman.
First let us test in POSTMAN what is response of above ODATA URL
We got the response containing all entity inside that OData API
New Training Announcement
Fee Payment and Enrollment Ends – 5th June 2026
Course Start Date – June 13 2026, 7:30 AM IST GMT+5.5 (9 PM CST on June 12 for USA Participants)
Course End Date – July 12 2026, 7:30 AM IST GMT+5.5 (9 PM CST on July 12 for USA Participants)
Each Class Duration ~ 2.5 hours
Course Days – 13, 14, 20, 21, 27, 28 June, 4, 5, 11 & 12 July 2026 IST Dates
Recordings of all classes will be provided – Lifetime access of these recording links
Day wise course break up – SAPUI5 & Fiori Master Class
https://services.odata.org/V2/Northwind/Northwind.svc/Orders
Now try the above URL to get all the fields of entity Orders
Now, let us again construct URL with specific OrderID=10248
https://services.odata.org/V2/Northwind/Northwind.svc/Orders(10248)\
In Response field of OrderID=10248 is fetched above
Now let us try the same using OData Adapter & Request Reply Pallet function in SAP CPI
Before we proceed with our tutorial, we would like to give you an opportunity to join our ZAPYard’s learning community where we have more than 35 groups and more than 1850 real SAP Consultants interacting with each other daily. Only SAP topics and not BS. Else, they will be banned from the community without warning. 👇👇👇👇
If you want to be part of ZAPYard’s Discussion Community, please feel free to check the below Link. We Ask, Answer, Help and Learn Together. There are more than 35 groups from different topics like Generative AI, SAP Joule, CAPM, BTP, RAP, BPT, Fiori, iRPA, CAI, CPI, PI/PO, ABAP on HANA, SAPUI5, SAP Build, SAP Adobe Forms, ChatBots, SAC etc. Join any group of your interest and interact with our Community.
Join ZAPYard’s WhatsApp Community – Ask, Answer, Propose & Defend SAP Topics
Step-1:
HTTPS Adapter:
Step-2:
Connect Request Reply pallet function with NorthWind receiver with OData Adapter
OData Adapter Configuration:
Connection Tab:
Address: https://services.odata.org/V2/Northwind/Northwind.svc/
Proxy Type: Internet
Authentication: None
Processing Tab:
Select Button- > 1: Connect to System
2: Select Entity & Define Operation
3: Configure Filter & Sorting
Deploy this flow and test from POSTMAN using GET request
Actual Response:
So, we have fetched response with same OData URL below in XML format
https://services.odata.org/V2/Northwind/Northwind.svc/Orders(10248)\
Quick Assignment – You need to check the below query in Adapter level and analyze the response
The OData Adapter significantly simplifies the process of integrating with OData-compliant applications by providing a configuration-driven approach instead of requiring custom development. The concepts covered in this exercise form the foundation for integrating SAP and non-SAP applications that expose business data through OData services.
In the next part of this series, we will continue exploring additional adapters and integration patterns available in SAP CPI to build more advanced integration scenarios.
If you found this article helpful, we’d love to hear from you! Share your thoughts, questions, or experiences in the comments below—your feedback is always welcome and helps us craft even more valuable content for your. Stay tuned for the next part in the series, where we’ll continue exploring essential tools and techniques to level up your SAP development skills.
Please follow our LinkedIn Page, LinkedIn Group , Facebook Page, Facebook Group, Twitter & Instagram.
Do not forget to SUBSCRIBE to our YouTube Channel for Free Courses and Unconventional Interesting Videos.
English (US) · 