xml to soap

Question

I need to take a SQL defined Xml that looks like this...&lt;optiondata&gt;&nbsp;&nbsp;&nbsp; &lt;system.admission_data&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;AdmissionDate&gt;2020-06-15&lt;/AdmissionDate&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;AdmissionTime&gt;07:15 PM &lt;/AdmissionTime&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;ClientName&gt;Doe, John&lt;/ClientName&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;EpisodeNumber&gt;1&lt;/EpisodeNumber&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;Program&gt;3958&lt;/Program&gt;&lt;sex&gt;M&lt;/sex&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;TypeOfAdmission&gt;01&lt;/TypeOfAdmission&gt;&nbsp;&nbsp;&nbsp; &lt;/system.admission_data&gt;&nbsp;&nbsp;&nbsp; &lt;ClientID&gt;123456&lt;/ClientID&gt;&nbsp;&nbsp;&nbsp; &lt;Episode&gt;1&lt;/Episode&gt;&nbsp; &lt;/optiondata&gt;and change it to this...&lt;tem:UpdateAdmission&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tem:SystemCode&gt;Code&lt;/tem:SystemCode&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tem:UserName&gt;Username&lt;/tem:UserName&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tem:Password&gt;Password&lt;/tem:Password&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tem:ClientAdmissionInfo&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tem:AdmissionDate&gt;2020-06-15&lt;/tem:AdmissionDate&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tem:AdmissionTime&gt;07:15 PM&lt;/tem:AdmissionTime&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tem:ClientName&gt;Doe,JOHN&lt;/tem:ClientName&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tem:EpisodeNumber&gt;1&lt;/tem:EpisodeNumber&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tem:Program&gt; 3958&lt;/tem:Program&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tem:Sex&gt;M&lt;/tem:Sex&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tem:TypeOfAdmission&gt;01&lt;/tem:TypeOfAdmission&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/tem:ClientAdmissionInfo&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tem:ClientID&gt;123456&lt;/tem:ClientID&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tem:Episode&gt;1&lt;/tem:Episode&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/tem:UpdateAdmission&gt;

nmrao · Answer

Just trying to understand your use case, please confirm:
optiondata xml is the response of a step and extract data and create request for next with UpdateAdmission&nbsp;

johnnybegood · Answer

I use SQL to create optiondata xml&nbsp; for most my imports however this import requires it push through a webservice using &lt;tem:UpdateAdmission&gt; format soap envelope above.I have the Request defined with header.&nbsp; I have the system code, username and password.&nbsp; I tested the envelope and it imports correctly..however i had to manually change each line.&nbsp; Example&lt;AdmissionDate&gt;&nbsp; &nbsp; to&nbsp; &nbsp; &nbsp;&lt;tem:AdmissionDate&gt;&nbsp;I can't find a way to take the SQL extracted data and drop it into the soap body without manually changing it.&nbsp;

nmrao · Answer

Looks like it is namespace issue. Based on the available data (Unless there is full information), it is difficult to help.

Forum Discussion

xml to soap

optiondata xml is the response of a step and extract data and create request for next with UpdateAdmission

<AdmissionDate> to <tem:AdmissionDate>

Related Content

Reference current Response-SOAP-XML in context.expand

how to get xml joint value and output in groovy

SOAP UI Return XML Dumping with Invalid Characters

XML Checkpoint

ReadyAPI - inserting entire xml body in to SOAP post

Recent Discussions

OpenAPI/Swagger 3.0 Support

Is SoapUI still supported?

How to change the API of a REST test step

How to stop the listener in SoapUI after running a test case with a test step that is a mock?

Error when trying to check WSI compliance