Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to pass a Column value from a table in a tRestClient as Query Parameter?
This way I could get a different response based on each input row from the source.
Thank you JR and RHall for your responses.
Yes,I could now get the response from TRestClient as multiple records and could pass multiple values using tJava from the table result.
Column "string" contains more than one record and I had to convert that as a Document type and set the loop element appropriately to get the result.
But , I'm still not getting the output as expected to load into a table as I have nested/recursive loop and multiple loop XML structure like below:
<A_LIST>
<M_LIST>
<B>
<ID><![CDATA[828282]]></ID>
<URL><![CDATA[xxxx]]></URL>
</B>
<B>
<ID><![CDATA[14141]></ID>
<URL><![CDATA[xxxxxxx]]></URL>
</B>
</B_LIST>
<C_LIST>
<C>
<ID><![CDATA[989898]]></ID>
<URL><![CDATA[xxxx]]></URL>
</C>
<C>
<ID><![CDATA[181818]></ID>
<URL><![CDATA[xxxxxxx]]></URL>
</C>
</M_LIST>
<M_LIST>
.
.
</M_LIST>
<A_LIST>
I got to know that tXML Map currently doesn't support nested/recursive loop and I had to use tHMap instead.
Any pointers on how to define the loop element in tHMap and process the XML data to table?
Hi there,
How did you write your URL to take in the parameters' values?