Removing <?xml version = "1.0" encoding = "
Posted: Wed Mar 10, 2010 10:14 pm
Hi All,
I am having a small problem with XML, which after reading all the posts, I am still not able to solve. the problem description is as follows: -
I am having data where I need to send a message on MQ. The data is being read from tables then transformed and then it is converted to XML and then sent to MQ. Now in data if a Client has more then 1 account then a single message should be generated where all the accounts will come in one message for only that Client No. Finally this message payload has to be added to a Wrapper called as CCP Trigger.
I was able to manage the first part using trigger column property, but int this case the Wrapper also repeats for each account number, due to which the XML is not well formed. So I used a way to create a payload in one XML stage and then sent the output as a single row using output as Root and then this value was fed to another XML stage as an input where I added this incoming payload to a wrapper "/defns:".
Now the message is getting opened in Internet Explorer but the tag is repeating in between the XML message for each XML stage.
This causes the XML to be rejected by MQ in Tibco. I want to have only single occurrence of "<?xml version = "1.0" encoding = "UTF-8"?>" tag and remove all in between tags.
I am not able to do it even after trying many settings. Can anyone help me with this.
@Ernie: I've read many of your posts but could not find anything matching this. May be I've not searched enough.
I am having a small problem with XML, which after reading all the posts, I am still not able to solve. the problem description is as follows: -
I am having data where I need to send a message on MQ. The data is being read from tables then transformed and then it is converted to XML and then sent to MQ. Now in data if a Client has more then 1 account then a single message should be generated where all the accounts will come in one message for only that Client No. Finally this message payload has to be added to a Wrapper called as CCP Trigger.
I was able to manage the first part using trigger column property, but int this case the Wrapper also repeats for each account number, due to which the XML is not well formed. So I used a way to create a payload in one XML stage and then sent the output as a single row using output as Root and then this value was fed to another XML stage as an input where I added this incoming payload to a wrapper "/defns:".
Now the message is getting opened in Internet Explorer but the tag
Code: Select all
<?xml version = "1.0" encoding = "UTF-8"?>
This causes the XML to be rejected by MQ in Tibco. I want to have only single occurrence of "<?xml version = "1.0" encoding = "UTF-8"?>" tag and remove all in between tags.
I am not able to do it even after trying many settings. Can anyone help me with this.
@Ernie: I've read many of your posts but could not find anything matching this. May be I've not searched enough.