SugarCRM SOAP: Difference between revisions
Jump to navigation
Jump to search
Jkuehlthau (talk | contribs) |
Jkuehlthau (talk | contribs) |
||
Line 6: | Line 6: | ||
=Mapping= | =Mapping= | ||
==Field Types== | ==Field Types== | ||
===Multi-select Dropdowns=== | ===Multi-select Dropdowns=== | ||
Data in Multiselect Dropdowns is stored as a comma separated string with carats around each value: | Data in Multiselect Dropdowns is stored as a comma separated string with carats around each value: | ||
Line 45: | Line 31: | ||
End Function | End Function | ||
</syntaxhighlight> | </syntaxhighlight> | ||
==VBScript== | ==VBScript== |
Revision as of 19:10, 8 April 2015
SugarCRM SOAP Origin
Note that the tab in Starfish is labelled simply "SugarCRM".
Sample Origin Filters
Mapping
Field Types
Multi-select Dropdowns
Data in Multiselect Dropdowns is stored as a comma separated string with carats around each value: ^Atari^,^Automobiles^,^Baseball^,^Fine_Art^,^Running_Walking^
Sample Function:
Function ScriptedField dim cat cat = "@@ORG:Categories@@" dim res If InStr(cat,"Board Invitee") Then res = res & "^Board_Invitee^," End If If InStr(cat,"Priority Contact") Then res = res & "^Priority_Contact^," End If If InStr(cat,"Dividend Contact") Then res = res & "^Dividend_Contact^," End If If Right(res,1) = "," Then res = Left(res,Len(res)-1) End If ScriptedField=res End Function
VBScript
Smart Lookup
When filtering in a smart lookup, the filter must use double-double quotes:
strSugarID = SmartLookup("Accounts","id","[{""import_source_id"":""84b1c05c-1043-05c8-ced8-53a2ed18427b""}]")
A more complex filter:
res = SmartLookup("Users", "id", "[{""$and"":[{""last_name"":""@@ORG:IENSalesRep_Last@@""},{""first_name"":""@@ORG:IENSalesRep_First@@""}]}]")
Sugar Specific
Warnings
SmartLookups and Origin Filters against the User Module fail.
SQL Statements to Purge Data From Sugar
delete from accounts; delete from accounts_audit; delete from accounts_contacts; delete from accounts_cstm; delete from accounts_opportunities; delete from activities; delete from activities_users; delete from bugs; delete from bugs_cstm; delete from calls; delete from calls_contacts; delete from calls_users; delete from cases; delete from cases_audit; delete from contacts; delete from contacts_audit; delete from contacts_cstm; delete from contacts_users; delete from emails; delete from emails_text; delete from emails_beans; delete from email_addr_bean_rel where bean_module <> 'Users'; delete from email_addresses where id in (select email_address_id from email_addr_bean_rel where bean_module <> 'Users'); delete from job_queue; delete from meetings; delete from meetings_contacts; delete from meetings_leads; delete from meetings_users; delete from notes; delete from opportunities; delete from opportunities_contacts; delete from opportunities_cstm; delete from opportunities_audit; delete from outbound_email; delete from products; delete from tasks;