xmloutput for a webservice

[pandujoy]

Hi All,

I am getting multiple outputs to a webservice...So inorder to handle that i am using a xmloutput stage before the wsdl output.

When i am trying to test my service i am not getting the fields which i prefer.

Design:-

With in the xml output i checked on aggregate rows
I specified a key field

Not sure y i am not getting the desired result.

I am getting the following result :-

<soapenv:Envelope xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Header/>
<soapenv:Body>
<p668:newOperation1Response xmlns:p668="http://NewService1.sample.isd.ibm.com/soapoverhttp/">
<newOperation1Return xsi:nil="true"/>
</p668:newOperation1Response>
</soapenv:Body>
</soapenv:Envelope>

I have to get :-

<soapenv:Envelope xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Header/>
<soapenv:Body>
<p281:verifyIndividualResponse xmlns:p281="http://verify_Individual.VerifyIndividual.isd.ibm.com/soapoverhttp/">
<IndividualReturn>
<IndividualOutVar2>
<label_nm xsi:nil="true"/>
<city_cd xsi:nil="true"/>
<state_cd_Ref xsi:nil="true"/>
<zip xsi:nil="true"/>
<return_code>00</return_code>
</IndividualOutVar2>
</IndividualReturn>
</p281:IndividualResponse>
</soapenv:Body>
</soapenv:Envelope>

Can anyone help me out.....

[eostic]

You have a lot of work to do, learning the XMLOutput Stage and exactly how it builds xml documents. Start by sending your output link from that Stage to a flat file...use a single column on the output link (call it something like mySOAPbody and make it varchar with a long length), and then in the sequential stage use "None" for quote characters and delimiters and develop your solution that way......

Once you have the perfect output you can start pointing it to the WSTransformer...

Ernie

[pandujoy]

I have tried that...and i am getting the desired output to my flatfile.
Ther problem is only when i am using the option "aggregate" in the service....If i put single row it works fine....

[eostic]

....I am assuming in your first post that "what you are getting" and "what you want" are solely from the output of the XMLOutput Stage. ....they aren't even close, which means that the xpaths aren't right, or something else is strange. ...and if, in fact, it's something only when you check "aggregate," then still, indeed, you need to do more debugging with a flat file, checking that your payload from XMLOutput is exactly what you want.

On that subject, Aggegrate will be impacted by the column that you select on the input link at the "key" (the repetition element). Try making it "lower" (one of the deepest columns/elements in your hierarchy). That's where many aggregate problems lie.

Ernie