cancel
Showing results for 
Search instead for 
Did you mean: 

How to Retrieve few records using sender odata adapter in CPI

itsravi
Explorer
0 Kudos
2,005

HI all

I am new to using of sender ODATA adapter in CPI,

we have scenario as

Odata--cpi--webservice

The main reason we are using the sender odata adapter is as the sender system data is coming in JSON format

The example URL we are trying to access is like

https://test.com/sap/XXX/abc/entityset

In the sender side we using the ODATA adapter in cpi, Here my question is as the source systems contains millions of records , here i have two cases to handle for which i am trying to build two different integration flows

1)case one ::: we need only to retrieve only top 100 records form the sender odata service ,can someone please help me with inputs how i do this

I have tried providing a condition in custom query options tab with (FILEDNAME&$TOP=100) but it did not work (please find the image attached )

2)How can we retrieve the huge volume of records form the source odata in cpi without integration flow getting failed . please find the screenshot attached ..

image.pngimage2.png

Thanks Ravi 😉

View Entire Topic
0 Kudos

Hello Ravi,

You can refer the blog here for the ways to handle large data using pagination.

Regards,

Narayana Raju

itsravi
Explorer
0 Kudos

Hi narayana_raju

Thanks for the reply but coming to the first part of the question , in the source url they are passing one filed value which we need to capture and use this value to dynamically query the odata url end point

for example

https://test.com/sap/XXX/abc/entityset?$filter=id eq123

In the above example we have capture the id value 123 and need to use this value during the odata query

for example :$select=Uom&$filter=id eq 123.

This value 123 we need to dynamical fetch from the source url and pass to the odata query


Thanks

ravi

itsravi
Explorer
0 Kudos

Hi narayana_raju

Thanks for the reply but coming to the first part of the question , in the source url they are passing one filed value which we need to capture and use this value to dynamically query the odata url end point

for example

https://test.com/sap/XXX/abc/entityset?$filter=id eq123

In the above example we have capture the id value 123 and need to use this value during the odata query

for example :$select=Uom&$filter=id eq 123.

This value 123 we need to dynamical fetch from the source url and pass to the odata query


Thanks

ravi