Nested Lookup using ReST API

Hi,

I have a ReST API connector, which I have bound to a table grid control to show the data. However, the results from the API (only one column) is a id and I need to look up the name using another API. How can this be achieved? Is there a way to do nested API calls? Any help would be much appreciated. Thanks.

@psomasamudram

There are 2 scenarios -

Scenario #1 - Output of Api 1 can be used as is for input to Api 2

In this case, Bind a Connector 1 to a variable/datastore. use that variable reference as input to your Api 2 that you can bind to a tablegrid control.

Scenario #2 - Output of Api 1 needs some manipulation for using it as is for input to Api 2

In this case, Bind a Connector 1 to a variable/datastore and use transform response where you can write JS code to update the output as required by the api 2 input, then Bind the Tablegrid control with Api 2 with above Variable/Datastore control as input.

Hope this Helps!