I have used SQL adapter in my orchestration to insert value in database tables and return some values from database tables.
For that purpose we have used SQL adapter of Type Request-Response which return xml schema having number of repeating child nodes in it.
I want break this XML schema so that each child node can be used separately.
Already i have used Atomic Scope shape and Loop shape to break message. In the Expression box of Scope firstly XML is loaded. & then by using SelectNode() given a Xpath of Root node having Repeating Child nodes in it.
Finally it’s output is given to File but i am unable get any output.
How To get output in File Format? How to exactly break messge coming as response of SQL adapter?