I've been asked to set up a SOAP/XML API to send data directly into a client's system. Its all kind of new to me so here's the thing.
I've been given the web service details so I don't envisage too many problems with that, but I'm having trouble creating the XML as it contains a SOAP header and I've not come accross this before.
Does anyone know how to write a SQL query to produce an XML result like the one provided below? (I've got all the fields they require in a table, I just need to know how to do the XML)
<?xml version="1.0" encoding="UTF-8"?>
-<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://www.w3.org/2003/05/soap-envelope" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
-<SOAP-ENV:Body>
-<CreateProposal xmlns="http://www.anchor.co.uk/">
<userName>uname</userName>
<password>pass</password>
<account>SWP Users</account>
<proposal>
<Title>Mr</Title>
<Forename>Test</Forename>
<Surname>Test</Surname>
<DOB>1980-08-04T10:44:41</DOB>
<MaritalStatus></MaritalStatus>
<MobilePhoneNumber>0123456789</MobilePhoneNumber>
<PostCode>AB1 2CD</PostCode>
</proposal>
<allowZeroPrincipal>0</allowZeroPrincipal>
</CreateProposal>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
I'd be most grateful if someone could point me in the right direction. You know, the annoying thing is that I'm leaving this job next week so if they'd left it for a few more days, it would have been someone else's headache. Doh!
---------------------------------------------------------------------------------
http://www.mannyroadend.co.uk A Bury FC supporters website and forum
SOAP dodger
Posted - 11/30/2012 : 10:32:57
