HCI ODATA endpoint URL not fetching response from multiple entities of C4C standard ODATA service

[former_member323756]

Hello Experts,

User->OData(GET)->CPI/HCI->OData(GET)->C4C

We need to create and expose an OData service from HCI/CPI which will consumes a receiver standard OData service from C4C. End user needs to Query ODATA url from HCI and fetch selected few fields (not all) from the 2 mentioned entities of C4C odata service based on the values of field AccountID.

The receiver standard service url is :

https://<c4chost>/sap/c4c/odata/v1/c4codataapi/CorporateAccountCollection

where CorporateAccount entity is a parent to CorporateAccountHasContactPerson entity and has a navigation set to it.

The URL to extract from standard service is:

https://C4Csystemhost/sap/c4c/odata/v1/c4codataap/CorporateAccountCollection?$filter=AccountID eq '123456789'&$expand=CorporateAccountHasContactPerson

My iFlow is able to create similar query in receiver ODATA channel and extract the chosen fields as result from the C4C ODATA api .For this I passed the filter AccountID as a Header in content modifier step and reading this set header in receiver channel to be added to query. So this was kind of unit testing in HCI.

Now coming to ODATA Artifact created,as of now I am able to achieve a working URL of the format:

https://HCItenantaccount-iflmap.hcisbt.eu1.hana.ondemand.com/gw/odata/SAP/ODATAEXPOSED;v=1/CorporateAccountSet(AccountID='7500001885') which can extract the desired fields from endservice using Postman but only from 1 entity at a time.

And the problem that I see is that in my source edmx I am not able to achieve the navigation from parent entity to child and hence the xsd to be used in Responce Mapping allows only one operation to be selected and isnt showing it as hierarchy.

How should I move forward to extract the responce from both entities as one? Kindly share your inputs and please let me know if you need more information on something.

Regards,

Shikha