RE: Witango-Talk: OT: SOAP request from MS-SQL

Peter Dobbs Tue, 07 Feb 2006 13:04:41 -0800

This isn't really the list of choice for a MS SQL development question. If you want to do this using Witango as an interface in front of the database then you would use an <@URL> tag to hit the location of the web service. Here is a sample of how to do it using Witango:

<@ASSIGN NAME="XMLPackage" VALUE='

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xs="http://www.w3.org/2001/XMLSchema">

<SOAP-ENV:Header></SOAP-ENV:Header>

<SOAP-ENV:Body>

<pns:bell_CASOGetFulfillment xmlns:pns="urn:bell_CASOFulfillment">

<pns:wsdlClientId></pns:wsdlClientId>

</pns:bell_CASOGetFulfillment>

</SOAP-ENV:Body>

</SOAP-ENV:Envelope>

' SCOPE="local">

<@ASSIGN NAME="XMLPackage" VALUE='<@OMIT STR="@@local$XMLPackage" CHARS="<@CHAR code='9'><@CHAR code='13'><@CHAR code='10'>" encoding=none>' SCOPE="local">

<@ASSIGN NAME="location" VALUE="PLACE THE ADDRESS OF THE WEB SERVICE HERE" SCOPE="local">

<@ASSIGN NAME="userAgent" VALUE='WITANGO LOOKING FOR WHATS ON THE TRUCK... <@VERSION> <@PLATFORM><@CRLF>Content-Id: soap-envelope<@CRLF>Content-Type: text/xml<@CRLF>Host: 2F2F<@CRLF>Content-Length: <@LENGTH STR="<@VAR XMLPackage scope=local>"><@CRLF>' SCOPE="local">

<@ASSIGN NAME="packageResponse" VALUE='<@URL LOCATION="<@VAR location scope=local>" USERAGENT="@@local$userAgent" POSTARGS="<@VAR xmlPackage scope=local>">' SCOPE="local">

<@ASSIGN NAME="faultFound" VALUE='<@LOCATE STR="@@local$packageResponse" FINDSTR="soap:Fault">' SCOPE="local">

<@IF "@@local$faultFound > 0">

<@ASSIGN NAME="packageFailed" VALUE="1" SCOPE="local">

</@IF>

<!-- HEY THERE HERE I AM!!!!!

<@VAR local$packageResponse encoding=none>

-->

Assign the response to a DOM

<@ASSIGN NAME="packageDOM" SCOPE="local" VALUE="<@DOM VALUE='@@local$packageResponse'>">

Then just parse the DOM as you would normally do. If you don't understand how to do this, the Witango documentation is quite good otherwise just ask the list, there are a lot of smart cookies that can help you.

Just a little tip, you don't need the WSDL file in order to communicate to a SOAP web service, you just need a sample of the complete request and response XML packages and verify that you have the right information for the HTTP header. HTTP header information just goes into the USERAGENT element of the <@URL> tag.

Peter

From: Dave Machin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 07, 2006 11:52 AM
To: [email protected]
Cc: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: OT: SOAP request from MS-SQL

I would totally appreciate some on- or off-list help on this. We're having trouble figuring out how to approach the problem.

Is there anything you could send me?

----- Original Message -----

From: Troy Sosamon

To: [email protected]

Sent: Monday, February 06, 2006 7:56 PM

Subject: RE: Witango-Talk: OT: SOAP request from MS-SQL

I have done it using VB.

It is pretty easy.

Troy

From: Dave Machin [mailto:[EMAIL PROTECTED]
Sent: Monday, February 06, 2006 11:59 AM
To: [email protected]
Subject: Witango-Talk: OT: SOAP request from MS-SQL

Has anyone used MS-SQL to issue SOAP requests? In other words, MS-SQL is the client and needs to issue a request?
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: OT: SOAP request from MS-SQL

Reply via email to