Multiple Entityset

[Former Member]

Hello Experts,

I need help in below scenario.

Scenario: Two Entity sets to be filled in one call. I am consuming OData service in Excel where I want to put each entityset in each sheet.

Ex. SalesHeaderSet and SalesItemsSet are two entity set and based on customer I want to fetch all related orders and fill these two entity sets which ultimately populate my respective sheets in excel.

I tried GET_EXPAND method but using it I am able to fetch details but these details are not getting populated in Excel. In excel I got only one entity set data as my URI is passing only one entity set. (" sap/opu/odata/sap/ZSL_EMP_DEMO1212_SRV/SalesOrder?$expand=SalesOrderItems " which is giving me data of SalesOrder entityset in excel.

Something Similar: If you consume "http://services.odata.org/V3/Northwind/Northwind.svc/" in your excel sheet then you will get all entitysets in different sheets. Similar way I want to build my OData Service.

Can somebody help?

Regards,

Sid

[yevgen_trukhin]

Hi,

To consume several Odata entities in one call, you have the following options:

1) use $batch request with GET requests for specific entities

2) if data model allows, perform $expand to read multiple hierarchically linked entities

Br Yevgen