How to consume the open OData service in SAP CPI?

[suresh_98]

Introduction:

This blog article will teach you how to consume OData service in i-Flow. You will also learn about OData adapter configuration & the utilization of Content Modifier in our i-Flow.

https://services.odata.org/v3/northwind/northwind.svc

In this i-Flow I'm using the above free OData service

Create an i-Flow with the name OData

Open & click on edit the i-Flow.

As Start event should have an incoming message use Timer event instead of Start Event

 

Now, add a content modifier & write the below XML code in Message Body

<RequestBody>

<OrderNumber>10253</OrderNumber>

</RequestBody>

In order to fetch the details of that particular Order Number I’m using the above XML code

Now add another Content Modifier & create a variable as shown below

Now add a Request reply to consume the OData service

Now connect your request reply with Receiver by using the OData V2 as message protocol

 

Now configure OData adapter as below

In the connection tab give the free OData service url in Address and keep the remaining as default

In processing tab configure as shown below

In order to choose Resource path, click on Select & select the path that we have created in Content Modifier

After selecting it will take you to another screen as below. So, don’t change anything in Step-1 keep it AS-IS

Now click on Step-2 and select the Operation as Query as we are fetching the Order Details.

In Entity, search for Orders and select it. Also, check all the checkboxes against all fields

After this click on Step-3. Now, give the filter conditions as below

After step-3 click on Finish. It will automatically generate a query as below based on our filter conditions.

Leave the remaining fields as empty as they are not mandatory

Now save and deploy the i-Flow. Always, change the Log level from info to Trace to see all the Message Processing steps

Once you i-Flow gets started you can see the below payload at the End Step

Conclusion:

This is the process to consume the OData service in i-Flow based on our requirement.

Please feel free to post a query in the comments section if you have any inquiries. I’d like to ask everyone to provide feedback and to like this blog article if you found it helpful. To discover more about CPI, kindly follow me for similar technical articles.

 

Thanks & Regards,

Suresh