WebService Repeating Elements

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
spoilt
Participant
Posts: 7
Joined: Mon Mar 25, 2013 7:17 am

WebService Repeating Elements

Post by spoilt »

I am having a problem while sending a message to webservice having repeating element.

For exemple : Employees ID's is declared as maxoccurs="unbounded"

<EMPLOYEES>
<ID>123</ID>
<ID>121443</ID>
<ID>125553</ID>
</EMPLOYEES>

I am reading ID column as one value 123</ID><ID>121443</ID><ID>125553. (DataType is already marked as "XML") However, the message send to webservice is
123</ID><ID&gt121443</ID&gt<ID&gt125553
encoding < as < and > as >


Client needs the repeating values to be send in the same record [not splitting every value as a row in XMLStage to send message] ?

Can you please help me?
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

You'll need an xmlOutput Stage prior to the web services transformer. ...one that builds this xml that is required going into the web service, where your multiple ID rows become multiple instances. I recently outlined the steps needed for another poster in the past day or two....search for that and you will see the steps.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Post Reply