AnsweredAssumed Answered

Making multiple SQL calls for child level XML elements

Question asked by RanjiniElamkulammana2391 on Sep 6, 2016
Latest reply on Sep 14, 2016 by Srinivas Chandrakanth Vangari

Given the following XML structure

 

<root_parent>

<field1/>

<field2/>

<child>

       <cf1/>

        <cf2/>

</child>

<child>

       <cf1/>

        <cf2/>

</child>

<root_parent>

 

How can I make multiple SQL calls for the <child> level elements using a DB connector? One per each child? As DB connector Select only takes parameters from incoming documents, how is this done? If the parameter is a child level element will it automatically loop? or do I only get one SELECT per DOCUMENT irrespective of children?

Outcomes