Forum Discussion

johnnybegood's avatar
johnnybegood
New Contributor
8 days ago

xml to soap

I need to take a SQL defined Xml that looks like this... <optiondata>     <system.admission_data>       <AdmissionDate>2020-06-15</AdmissionDate>       <AdmissionTime>07:15 PM </AdmissionTi...
SOAP
nmrao's avatar
nmrao
Champion Level 3
7 days ago

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 
  • johnnybegood's avatar
    johnnybegood
    New Contributor
    7 days ago

    I use SQL to create optiondata xml  for most my imports however this import requires it push through a webservice using <tem:UpdateAdmission> format soap envelope above.

    I have the Request defined with header.  I have the system code, username and password.  I tested the envelope and it imports correctly..

    however i had to manually change each line.  Example

    <AdmissionDate>    to     <tem:AdmissionDate> 

    I can't find a way to take the SQL extracted data and drop it into the soap body without manually changing it.