topic Re: Netweaver Gateway: Getting multiple output tables simultaneously in Application Development and Automation Discussions

Netweaver Gateway: Getting multiple output tables simultaneously

Former Member — Fri, 23 Aug 2013 10:06:14 GMT

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

Re: Netweaver Gateway: Getting multiple output tables simultaneously

Former Member — Wed, 18 Sep 2013 00:10:19 GMT

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

Re: Netweaver Gateway: Getting multiple output tables simultaneously

Former Member — Wed, 18 Sep 2013 12:16:29 GMT

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

Re: Netweaver Gateway: Getting multiple output tables simultaneously

Former Member — Thu, 10 Oct 2013 05:53:23 GMT

Thanks Jiten.

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

go.