ColdFusion and SugarCRM Intergration
If you would like to integrate your ColdFusion site with SugarCRM, please see the new ColdSugar project at RIAForge. This is a simple CFC that allows for complete integration with a SugarCRM account. You can get any kind of data and perform updates as well. I wish I could say there was something sexy about this code, but their API was relatively simple to work with.
Some sample code:
<cfset coldsugar = createObject("component", "sugarcrm").init("http://eval.sugarondemand.com/xxx/soap.php?wsdl", "admin", "foo", true)>
<cfdump var="#coldsugar.getList('Opportunities')#" label="Opportunities">
<cfset q = "opportunities.name LIKE 'TI%'">
<cfdump var="#coldsugar.getList(type='Opportunities',query=q)#" label="query=#q#">
<cfdump var="#coldsugar.getList(type='Opportunities',orderby='amount_usdollar')#" label="sort by amount_usdollar">
<cfdump var="#coldsugar.getList(type='Opportunities',deleted=true)#" label="deleted">
<cfdump var="#coldsugar.getList(type='Opportunities',fields='name,amount_usdollar')#" label="Just name and amount_usdollar">
<cfdump var="#coldsugar.getList('Contacts')#" label="Contacts">
<cfdump var="#coldsugar.getList('Accounts')#" label="Accounts">
<cfdump var="#coldsugar.getList('Documents')#" label="Documents">
<cfdump var="#coldsugar.getList('Calls')#" label="Calls">
<cfdump var="#coldsugar.getList('Meetings')#" label="Meetings">
<cfdump var="#coldsugar.getList('Tasks')#" label="Tasks">
<cfdump var="#coldsugar.getList('Notes')#" label="Notes">
<cfdump var="#coldsugar.getFields('Emails')#" label="Email Fields">
<cfset emails = coldsugar.getList('Emails')>
<cfdump var="#emails#" label="Emails">
<cfset email = coldsugar.get('Emails', emails.id[1])>
<cfdump var="#email#" label="Emails">
<cfset email.status = 'replied'>
<cfset r = coldsugar.save('Emails',email)>
<p>
Result of save is #r#
</p>
<cfset coldsugar.logout()>
<p>
Done with tests.
</p>
</cfoutput>