views:

47

answers:

0

Hi guys

In a Proxy Service If for example the input is:


[Employee]
    [Name]Test[/Name]
    [ID]ID[/ID]
    [Address]test add[/Address]
    [Email]test@test[/Email]
    [Department]Testh[/Department]
    [Department]Test 2[/Department]
    [Department]Test 3[/Department]
    [Department]Test 4[/Department]
[/Employee]

If there's multiple Departments given, i need to go through them all via For-Each loop and insert Name,ID,Address ,Email and Department(1 only) into database for as as many Departments given , so for the above input there will be 4 inserts of Name,ID,Address,Email and Department in the table.

From the Flow Control I am using "For Each" to iterate through the Department node via :

./*[1]//*:Department

and store the result in $Dep variable, and then continues to do a Service callout. but when a service call out is done to insert the data into a table, Instead of passing just one Department for every iteration it tries to pass all the given department elements at once during each iteration! I don't know how to proceed from here so any help/hints would be appreciated.