cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

how do i implement an odata api for an cds view entity with parameters in integration suite

ojone
Discoverer
1,101

Hi community

I'm quite new to the SAP Integration Suite and even newer to CDS Views.

What I've done:

I created a CDS View Entity with parameters. That works.

I created an OData-Service with SADL for this CDS View Entity. It works too. So I can call the service via SAP Gateway Client and pass the parameters.

Here the url is like /sap/opu/odata/sap/Ztest/Ztest(p_par='1')/Set

Now, we want to publish an API via SAP Integration Suite that consume the odata service. Of course we have already implement odata services for cds views without parameters and that works fine. But with parameters everything seems to be different. 

If I try to make a request from Postman I tried different URLs. For example:

https://.../gw/odata/SAP/Test;v=1/ZtestType(p_par = '1')/Set           => Requested entity could not be found

https://.../gw/odata/SAP/Test;v=1/ZtestTypeSet(p_par = '1')            => Invalid key predicate: 'p_par='
https://.../gw/odata/SAP/Test;v=1/ZtestTypeSet$filter=p_par EQ '1' => Requested entity could not be found
I'm not sure what I have to in the OData API and how I have to call the service from Posstman.
 
Can someone help me or has someone done something similar?
 
Best Regards
Robin
PS: I  asked google to find something regarding Integration Suite and OData for CDS Views with parameters and found ... nothing 😞

Accepted Solutions (0)

Answers (1)

Answers (1)

ojone
Discoverer
0 Likes

The third call is right one but you have to take care of upper-/lowercase. In this case it is not EQ but eq.