Entity by ID 'XXXXXXXXX' not found. occur when use $expand with include Odata service

[felix0315]

Hi Experts,

I create a odata project with one entity and include another odata service, create association between my own entity and include model reference's entity, create association set and navigation properties.as picture below

this link works fine:

/sap/opu/odata/SAP/ZDMS_002_SRV/HeaderSet(Dokar='ZSR',Doknr='10000000902')/versions

however, with this link, I get error "Entity by ID 'N2B8F050322926B2CA65BA5A590DE8B14' not found"

/sap/opu/odata/SAP/ZDMS_002_SRV/HeaderSet(Dokar='ZSR',Doknr='10000000902')?$expand=versions

how to fix it?

Or include Odata service doesn't support $expand parameter?

best regards,

felix

[Andre_Fischer · Accepted solution]

Hi Felix,

it is not supported.

Best Regards,

Andre

[felix0315 · Accepted solution]

Hi Andre,

thank you, and I have read your works, you are amazing. thank you.

[samson_moses · Accepted solution]

Hi Felix / Andre,

My requirement is exactly the same, where I have nested entities/associations in my included service( REF_SERVICE). I don't want to rebuild the whole logical connections again in my parent service(PAR_SERVICE) and hence thought of including the reference service.

Any reason why this is not supported for now. The objective of including a service is to avoid redundancy.

In such cases what should be our design approach ?

Appreciate your help & explanation.

Regards,

Samson.

[former_member185414 · Accepted solution]

Maybe you can look at developing OData V4 services. I understand this limitation goes away with the creation of service groups which allow component services to have cross service navigations much like the microservice architecture concept.