hi all
i have an orchestration in which i am getting records from the sql which has all the records,
now i am using xpath to go through node by node so that i can insert one by one row as it is my need,
now when i loop through the nodes i have following in my xmldocument at a time
<userDetails xmlns=”http://SqlRowLooping“>
<userID>1</userID>
<fName>niladri</fName>
<lName>Roy</lName>
<department>hr</department>
</userDetails>
now i have new schema created for above xml which has same namespace as shown in xml onroot node userDetails
and elements like above,now if i’ve construct shape as i want to map this schema with updategram,
so i am mapping this singleNode schema with updategram schema,so in map input msg is singleNode and output msg
is updategram msg,but when this shape executes the out msg has blank attributes,it means in after shape it has
<ns0:Get_Emp xmlns:ns0=”http://SqlRowLooping“>
<ns0:sync>
<ns0:after>
<ns0:HRDepartment FName=”” LName=”” Department=”” />
</ns0:after>
</ns0:sync>
</ns0:Get_Emp>
so it is inserting blank rows instead of the data present in xml
but when i debug the map and see output xml it has perfect updategram generated with sample data
plz help….