SOAP and Applescript?

[mattjones99]

Hello,

I'd like to write an applescript to be able to add messages from Apple's Mail application into Sugar. This would certainly make it a sweeter application. :-) Sugar's SOAP interface seems like a great way to facilitate this connection. But, I can't even login using the SOAP interface.

Here is my applescript:

my create_session("username", "password")

on create_session(in_user_name, in_password)
tell application "http://iMacG5.local/sugarsuite/soap.php"
set mn to "create_session"
set sa to "http://iMacG5.local/sugarsuite/soap.php/create_session"
set mns to "http://www.sugarcrm.com/sugarcrm"
set params to {}
set paramOrder to {}
set params to params & {user_namein_user_name as string)}
set paramOrder to paramOrder & "user_name"
set params to params & {|password|in_password as string)}
set paramOrder to paramOrder & "password"
set params to params & {record orderaramOrder}
return call soap {method name:mn, parametersarams, SOAPAction:sa, method namespace uri:mns}
end tell
end create_session

And here are the errors from sugarcrm.log
Tue May 3 16:11:22 2005,803 [17137] FATAL User - SECURITY: failed login by matt
Tue May 3 16:11:22 2005,804 [17137] FATAL soap_contacts - SECURITY: failed attempted login for matt using SOAP api

Help, advice, suggestions? I am certain that the correct username and password are in the actual script.

As a side note, if anybody else is interested in using SOAP with Applescript, there is a really cool tool in the Develepor tools. Running the command /Developer/Tools/WSMakeStubs -url "http://imacg5.local/sugarsuite/soap.php?wsdl" -x applescript will stub out all the SOAP functions for you in applescript.

[rcourtna]

Hi, did you ever get this working? If so, I'd be very interested in your applescript.

Ryan

[mattjones99]

Ryan,

Sorry, I got busy before I had time to work on it.

If anybody else is interested in working on it, the key is that the password has to be an md5 hash of the password. I haven't figured out a way to create an md5 hash in applescript.

Peace,

Matt

[martinb]

If anybody else is interested in working on it, the key is that the password has to be an md5 hash of the password. I haven't figured out a way to create an md5 hash in applescript.

The hash is what's stored in the db - just grab it from the user_hash field in the users table:

SELECT *
FROM `users`
LIMIT 0 , 30

[clint]

Have you checked out this quick start guide for the Sugar SOAP API's?

http://www.sugarforge.org/frs/downlo...P_Overview.rtf

Regards,

[Shoe]

I saw this at http://ruk.ca/code/PlazesAdium.txt and modified it a little

set passwordPlain to "mypassword"

try
	do shell script "/sbin/md5 -qs " & passwordPlain
on error errMsg number errNo
	error errMsg number errNo
	return "failed"
end try

set passwordMD5 to result

display dialog passwordMD5

That should allow you to get the md5 from applescript.

-Shoe