Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tRest Client Query Parameter

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.

Labels (4)
11 Replies
Anonymous
Not applicable
Author

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?

Anonymous
Not applicable
Author

Hi there,

 

How did you write your URL to take in the parameters' values?