Netweaver Gateway: Getting multiple output tables simultaneously

[Former Member]

Hi all,

There is an RFC in CRM System which has certain import parameters and returns two output tables. For this RFC  Data Model has been created in Gateway Development System. So now when trying to consume this REST Service, I need to specify the output table name in the URL of the REST Service in REST Client. Therefore, in order to get both the output tables the SAP database gets hit twice.

Is there any way by which both the output tables can be retrieved at once.

Thanks!

Amrisha

[Former Member]

Hi all,

There is an RFC in CRM System which has certain import parameters and returns two output tables. For this RFC  Data Model has been created in Gateway Development System. So now when trying to consume this REST Service, I need to specify the output table name in the URL of the REST Service in REST Client. Therefore, in order to get both the output tables the SAP database gets hit twice.

Is there any way by which both the output tables can be retrieved at once.

Thanks!

Amrisha

[Former Member]

Hi Amrisha,

This could be achieved using the READ Operation.

You can perform the READ operation for the entity set or the collection with the key input values. This would provide you with the URLs for the specific tables. Using these URLs you can retrieve the individual table data.

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/f6/152975ec4d411aa192a0de339ffd91/content.htm

Thanks,

Jiten

[Former Member]

Hi Amrisha,

Data of multiple output tables could be retrieved in one RFC call using the option $expand and by implementing methods GET_EXPANDED_ENTITY and GET_EXPANDED_ENTITYSET.

Please refer the following thread for more info.

https://scn.sap.com/thread/3367787

Thanks,

Jiten

[Former Member]

Thanks Jiten.

Using using GET_EXPANDED_ENTITY and GET_EXPANDED_ENTITYSET methods I am able to get multiple output tables in one

go.