Datastage calling peoplesoft web service
Posted: Mon Oct 03, 2016 12:33 pm
Hi,
We are invoking peoplesoft web service from datastage and the output is in one field in the form of an XML. Lets say for exmple the output of peoplesoft web service is like this
>col11
col2
col3
col4
XML is there in col3 and i am trying to make this as a key column to propogate and create an XML file out of it. when i am taking col3 alone in the output and trying to see an output .. I could the output in this way
<col1>a</col1>b<col2><col2/><col3></Col3><col4>1</col4>
where as i want to see
<col3> abc123</col3> as an output....
Please let me know in case if you need more details and do help me to fix this issue.. There is one more issue along with this ie.. instead of < and > ... i am getting < and &rt.
We are invoking peoplesoft web service from datastage and the output is in one field in the form of an XML. Lets say for exmple the output of peoplesoft web service is like this
>col11
col2
col3
col4
XML is there in col3 and i am trying to make this as a key column to propogate and create an XML file out of it. when i am taking col3 alone in the output and trying to see an output .. I could the output in this way
<col1>a</col1>b<col2><col2/><col3></Col3><col4>1</col4>
where as i want to see
<col3> abc123</col3> as an output....
Please let me know in case if you need more details and do help me to fix this issue.. There is one more issue along with this ie.. instead of < and > ... i am getting < and &rt.