Applescript equivalent to VBA XMLHTTP object?

Question

Level 1

0 points

Applescript equivalent to VBA XMLHTTP object?

Having no luck after hours of research on this. Is there an Applescript equivalent to the VBA XMLHTTP object?

We have an Excel form that can pass data to a web service. We basically take the XML, wrap it in a SOAP envelope and send it using the xmlhttp object. Unfortunately, the xmlhttp object does not appear to exist for the mac version of Excel. If there is no equivalent to the xmlhttp object, is there an alternate way of making this work in applescript?

Thanks in advance

Posted on Aug 5, 2009 7:19 PM

Reply

Answer 1

Aug 5, 2009 7:58 PM in response to Kennedy27

Open the "URL Access" dictionary.

Reply

Answer 2

Camelot

Level 9

54,339 points

Aug 5, 2009 10:27 PM in response to Kennedy27

Apple have some substantial documentation of using SOAP with AppleScript.

http://developer.apple.com/documentation/AppleScript/Conceptual/soapXMLRPC/chapt er1/soapXMLRPC_intro.html

Reply

Answer 3

Kennedy27 Author

Level 1

0 points

Aug 6, 2009 8:19 AM in response to Kennedy27

Thanks guys. We were able to solve the problem through Query Tables in VBA rather than resorting to Applescript.

For anyone interested in the solution:

Sub URL GetQuery()

With ActiveSheet.QueryTables.Add(Connection:= _
"URL; http://mywebservice.com/mywebserviceproc",
Destination:=Range("a1"))

.PostText = SoapString
.BackgroundQuery = True
.TablesOnlyFromHTML = True
.Refresh BackgroundQuery:=False
.SaveData = True
End With
End Sub

Lets you post to a web service without using the xmlhttp object

Message was edited by: Kennedy27

Reply