XML Help.. adding a root to the root?

• oogibah

  SSC Eights!

  Points: 827

  More actions

  November 6, 2019 at 2:38 pm

  #3695445

  I have a XML output that gets output into a file for BizTalk to send to another company, and I'm trying to format the Root clause the way they want but its a bit bizzare and I'm having trouble

  This is how they want it formatted:

  <GIAS xmlns="GIAS_PolicyEquipment_New">
  <ROOT xmlns="" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <Certdata>
  
  ...
  
  ...
  
  </GIAS>

  if I try to use WITH XMLNAMESPACE it just put its after the <ROOT xmlns:xsi="HTTP://...>

  like this

  <GIAS xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:GIAS="xmlns=GIAS_PolicyEquipment_New">
  <Certdata>

  I've tried to specify the root but unfortunately I'm pretty bad with HTML, this is simply a select statement not an insert was wondering if I could get some assistance here.

   

  Thanks!

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  November 7, 2019 at 3:10 pm

  #3695943

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.