1. Grow
  2. Connecting to Data Sources
  3. CRMs

Sugar CRM

Article last updated:

SugarCRM delivers the straightforward simplicity, mobility, and social aspects of a consumer app with the business process optimization of a conventional CRM. This article will give you an overview of the SugarCRM/Grow integration.

We are no longer actively supporting this integration. If you have previously authenticated this data source, it will still appear in the list of your data sources. We will not be improving this integration further.

Connecting to SugarCRM

  1. Click on the Data tab at the top left of the global navigation. Then click on Connections in the Data Library section.
  2. Click on the blue Connect button.
  3. Search for Sugar CRM, and select Connect.
  4. Next, you will be asked to enter the following information:
    • Consumer Key
    • Consumer Secret
    • Unique URL: This will be the main part of the URL found in the browser URL bar. (e.g., https://yourcompany.sugarondemand.com/).
    • Username
    • Password
  5. Click Connect and you will be able to start building metrics with your SugarCRM data!

Endpoints

Below is a list of the endpoints offered through the SugarCRM/Grow integration, along with the field data that each endpoint returns.

  • Accounts: ID, Name, Date Entered, Date Modified, Modified User ID, Modified By Name, Modified User Link Full Name, Modified User Link ID, Modified User Link ACL Fields, Modified User Link ACL Hash, Created By, Created By Name, Created By Link Full Name, Created By Link ID, Created By Link ACL Fields, Created By Link ACL Hash, Description, Deleted, facebook, Twitter, Googleplus, Account Type, Industry, Annual Revenue, Phone Fax, Billing Address Street, Billing Address Street 2, Billing Address Street 3, Billing Address Street 4, Billing Address City, Billing Address State, Billing Address Postalcode, Billing Address Country, Rating, Phone Office, Phone Alternate, Website, Ownership, Employees, Ticker Symbol, Shipping Address Street, Shipping Address Street 2, Shipping Address Street 3, Shipping Address Street 4, Shipping Address City, Shipping Address State, Shipping Address Postalcode, Shipping Address Country, Parent ID, SIC Code, DUNS Num, Parent Name, Member Of Name, Member Of ID, Member Of ACL Fields, Member Of ACL Hash, Campaign ID, Campaign Name, Campaign Accounts Name, Campaign Accounts ID, Campaign Accounts ACL Fields, Campaign Accounts ACl Hash, Following, My Favorite, Tag, Locked Fields, Assigned User ID, Assigned User Name, Assigned User Link Full Name, Assigned User Link ID, Assigned User Link ACL Fields, Assigned User Link ACL Hash, Team Count, Team Count Link Team Count, Team Count Link ID, Team Count Link ACL Fields, Team Count Link ACL Hash, Team Name ID, Team Name Name, Team Name Name 2, Team Name Primary, Team Name Selected, Email, Email 1, Email 2, Invalid Email, Email Opt Out, Email Addresses Non Primary, Type Of Office C, Distribution Purpose C, Territory C, Region C, Last Activity C Module, Email Email Address, Email Primary Address, Email Reply To Address, Email Invalid Email, Email Opt Out, Email Email Address, Email Primary Address, Email Reply To Address, Email Invalid Email, Email Opt Out, Modified User Link ACL Fields PWD Last Changed Write, Modified User Link ACL Fields PWD Last Changed Create, Modified User Link ACL Fields Last Login Write, Modified User Link ACL Fields Last Login Create, Modified User Link ACL Delete
  • Activities: ID, Name, Date Entered, Date Modified, Modified User ID, Modified By Name, Modified User Link Full Name, Modified User Link ID, Modified User Link ACL Fields PWD Last Changed Write, Modified User Link ACL Fields PWD Last Changed Create, Modified User Link ACL Fields Last Login Write, Modified User Link ACL Fields Last Login Create, Modified User Link ACL Delete, Modified User Link ACL Hash, Created By, Created By Name, Created By Link Full Name, Created By Link ID, Created By Link ACL Fields PWD Last Changed Write, Created By Link ACL Fields PWD Last Changed Create, Created By Link ACL Fields Last Login Write, Created By Link ACL Fields Last Login Create, Created By Link ACL Delete, Created By Link ACL Hash, Description, Deleted, Parent ID, Parent Type, Activity Type, Data Object Name, Data Object Type, Data Object Module, Data Object ID, Comment Count, Last Comment Name, Last Comment Deleted, Last Comment Data, Following, My Favorite, Locked Fields, Display Parent Type, Display Parent ID, Module, Preview Enabled, Preview Disabled Reason
  • Campaigns: my_favorite, following, id, name, date_entered, date_modified, modified_user_id, modified_by_name, created_by, created_by_name, doc_owner, user_favorites, description, deleted, assigned_user_id, assigned_user_name, team_count, team_name.0.id, team_name.0.name, team_name.0.name_2, team_name.0.primary, team_name.1.id, team_name.1.name, team_name.1.name_2, team_name.1.primary, tracker_key, tracker_count, refer_url, tracker_text, start_date, end_date, status, impressions, currency_id, base_rate, budget, expected_cost, actual_cost, expected_revenue, campaign_type, objective, content, frequency, Module
  • Contacts: ID, Name, Date Entered, Date Modified, Modified User ID, Modified By Name, Modified User Link Full Name, Modified User Link ID, Modified User Link ACL Fields, Modified User Link ACL Hash, Created By, Created By Name, Created By Link Full Name, Created By Link ID, Created By Link ACL Fields, Created By Link ACL Hash, Description, Deleted, Salutation, First Name, Last Name, Full Name, Title, facebook, Twitter, Googleplus, Department, Do Not Call, Phone Home, Phone Mobile, Phone Work, Phone Other, Phone Fax, Primary Address Street, Primary Address Street 2, Primary Address Street 3, Primary Address City, Primary Address State, Primary Address Postalcode, Primary Address Country, ALT Address Street, ALT Address Street 2, ALT Address Street 3, ALT Address City, ALT Address State, ALT Address Postalcode, ALT Address Country, Assistant, Assistant Phone, Picture, Email And Name 1, Lead Source, Account Name, Accounts Name, Accounts ID, Accounts ACL Fields, Accounts ACL Hash, Account ID, DNB Principal ID, Opportunity Role Fields, Opportunities ID, Opportunity Role ID, Opportunity Role, Reports To ID, Report To Name, Reports To Link Name, Reports To Link ID, Reports To Link ACL Fields, Reports To Link ACl Hash, Birthdate, Portal Name, Portal Active, Portal Password, Portal Password 1, Portal App, Preferred Language, Campaign ID, Campaign Name, Campaign Contacts Name, Campaign Contacts ID, Campaign Contacts ACL Fields, Campaign Contacts ACL Hash, C Accept Status Fields, Calls ID, M Accept Status Fields, Meetings ID, Accept Status ID, Accept Status Name, Accept Status Calls, Accept Status Meetings, Sync Contact, MKTO Sync, MKTO ID, MKTO Lead Score, Following, My Favorite, Tag, Locked Fields, Assigned User ID, Assigned User Name, Assigned User Link Full Name, Assigned User Link ID, Assigned User Link ACL Fields, Assigned User Link ACL Hash, Team Count, Team Count Link Team Count, Team Count Link ID, Team Count Link ACL Fields, Team Count Link ACL Hash, Team Name ID, Team Name Name, Team Name Name 2, Team Name Primary, Team Name Selected, Email Email Address, Email Primary Address, Email Reply To Address, Email Invalid Email, Email Opt Out, Email 1, Email 2, Invalid Email, Email Opt Out, Email Addresses Non Primary, Module, Email
  • Cases: id, name, date_entered, date_modified, modified_user_id, modified_by_name, modified_user_link.full_name, modified_user_link.id, modified_user_link._acl.fields, modified_user_link._acl._hash, created_by, created_by_name, created_by_link.full_name, created_by_link.id, created_by_link._acl.fields, created_by_link._acl._hash, description, deleted, case_number, type, status, priority, resolution, system_id, work_log, account_name, accounts.name, accounts.id, accounts._acl.fields, accounts._acl._hash, account_id, source, portal_viewable, following, my_favorite, tag, locked_fields, assigned_user_id, assigned_user_name, assigned_user_link.full_name, assigned_user_link.id, assigned_user_link._acl.fields, assigned_user_link._acl._hash, team_count, team_count_link.team_count, team_count_link.id, team_count_link._acl.fields, team_count_link._acl._hash, team_name.0.id, team_name.0.name, team_name.0.name_2, team_name.0.primary, team_name.0.selected, _module
  • Leads: ID, Name, Date Entered, Date Modified, Modified User ID, Modified By Name, Modified User Link Full Name, Modified Use Link ID, Modified User Link ACL Fields, Modified User Link ACL Hash, Created By, Created By Name, Created By Link Full Name, Created By Link ID, Created By Link ACL Fields, Created By Link ACL Hash, Description, Deleted, Salutation, First Name, Last Name, Full Name, Title, Facebook, Twitter, Googleplus, Department, Do Not Call, Phone Home, Phone Mobile, Phone Work, Phone Other, Phone Fax, Primary Address Street, Primary Address Street 2, Primary Address Street 3, Primary Address City, Primary Address State, Primary Address Postalcode, Primary Address Country, ALT Address Street, ALT Address Street 2, ALT Address Street 3, ALT Address City, ALT Address State, ALT Address Postalcode, ALT Address Country, Assistant, Assistant Phone, Picture Converted, Referred By, Lead Source, Lead Source Description, Status, Status Description, Reports To ID, Report To Name, DNB Principal ID, Account Name, Account To Lead, Accounts Name, Accounts ID, Accounts ACL Fields, Accounts ACL Hash, Account Description, Contact ID, Contact Name, Contacts Name, Contacts ID, Contacts ACL Fields, Contacts ACL Hash, Account ID, Opportunity ID, Opportunity Name, Opportunity Amount, Campaign ID, Campaign Name, Campaign Leads Name, Campaign Leads ID, Campaign Leads ACL Fields, Campaign Leads ACL Hash, C Accept Status Fields, Calls ID, M Accept Status Fields, Meetings ID, Accept Status ID, Accept Status Name, Accept Status Calls, Accept Status Meetings, Web To Lead Email 1 Email Address, Web To Lead Email 1 Primary Address, Web To Lead Email 1 Reply To Address, Web To Lead Email 1 Invalid Email, Web To Lead Email 1 Opt Out, Web To Lead Email 2 Email Address, Web To Lead Email 2 Primary Address, Web To Lead Email 2 Reply To Address, Web To Lead Email 2 Invalid Email, Web To Lead Email 2 Opt Out, Web To Lead Email Opt Out, Web To Lead Invalid Email, Birthdate, Portal Name, Portal App, Website, Preferred Language, MKTO Sync, MKTO ID, MKTO Lead Score, Following, My Favorite, Tag, Locked Fields, Assigned User ID, Assigned User Name, Assigned User Link Full Name, Assigned User Link ID, Assigned User Link ACL Fields, Assigned User Link ACL Hash, Team Count, Team Count Link Team Count, Team Count, Link ID, Team Count Link ACL Fields, Team Count Link ACL Hash, Team Name ID, Team Name Name, Team Name Name 2, Team Name Primary, Team Name Selected, Email Email Address, Email Primary Address, Email Reply To Address, Email Invalid Email, Email Opt Out, Email 1, Email 2, Invalid Email, Email Opt Out, Email Addresses Non Primary, Territory C, Legacy Lead Source C, Module, Web To Lead Email 1, Web To Lead Email 2, Email
  • Opportunities: ID, Name, Date Entered, Date Modified, Modified User ID, Modified By Name, Modified User Link Full Name, Modified User Link ID, Modified User Link ACL Fields, Modified User Link ACL Hash, Created By, Created By Name, Created By Link Full Name, Created By Link ID, Created By Link ACL Fields, Created By Link ACL Hash, Description, Deleted, Opportunity Type, Account Name, Accounts Name, Accounts ID, Accounts ACL Fields, Accounts ACL Hash, Account ID, Campaign ID, Campaign Name, Campaign Opportunities Name, Campaign Opportunities ID, Campaign Opportunities ACL Fields, Campaign Opportunities ACL Hash, Lead Source, Amount, Amount US Dollar, Date Closed, Date Closed Timestamp, Next Step, Sales Stage, Sales Status, Probability, Best Case, Worst Case, Commit Stage, Total Revenue Line Items, Closed Revenue Line Items, Included Revenue Line Items, Contact Role, MKTO Sync, MKTO ID, Following, My Favorite, Tag, Locked Fields, Assigned User ID, Assigned User Name, Assigned User Link Full Name, Assigned User Link ID, Assigned User Link ACL Fields, Assigned User Link ACL Hash, Team Count, Team Count Link Team Count, Team Count Link ID, Team Count Link ACL fields, Team Count Link ACL Hash, Team Name ID, Team Name Name, Team Name Name 2, Team Name Primary, Team Name Selected, Currency ID, Base Fate, Currency Name, Currencies Name, Currencies ID, Currencies ACL Fields, Currencies ACL Hash, Currencies Symbol, Currency Symbol, Modified User Link ACL Fields PWD Last Changed Write, Modified User Link ACL Fields PWD Last Changed Create, Modified User Link ACL Fields Last Login Write, Modified User Link ACL Fields Last Login Create, Modified User Link ACL Delete
  • Tasks: ID, Name, Date Entered, Date Modified, Modified User ID, Modified By Name, Modified User Link Full Name, Modified User Link ID, Modified User Link ACL Fields, Modified User Link ACL Hash, Created By, Created By Name, Created By Link Full Name, Created By Link ID, Created By Link ACL Fields, Created By Link ACL Hash, Description, Deleted, Status, Date Due Flag, Date Due, Time Due, Date Start Flag, Date Start, Parent Type, Parent Name, Parent ACL Fields, Parent ACL Hash, Parent ID, Parent Type, Parent Name, Parent ID, Contact ID, Contact Name, Contacts Name, Contacts ID, Contacts ACL Fields, Contacts ACL Hash, Contact Phone, Contact Email, Priority, Following, My Favorite, Tag, Locked Fields, Assigned User ID, Assigned User Name, Assigned User Link Full Name, Assigned User Link ID, Assigned User Link ACL Fields, Assigned User Link ACL Hash, Team Count, Team Count Link Team Count, Team Count Link ID, Team Count Link ACL Fields, Team Count, Link ACL Hash, Team Name ID, Team Name Name, Team Name Name 2, Team Name Primary, Team Name Selected, Location C, Module, Parent
  • Users: ID, User Name, User Hash, System Generated Password, PWD Last Changed, Authenticate ID, Sugar Login, Picture, First Name, Last Name, Full Name, Name, Is Admin, External Auth Only, Receive Notifications, Description, Date Entered, Date Modified, Last Login, Modified User ID, Modified By Name, Created By, Created By Name, Created By Link Full Name, Created By Link ID, Created By Link ACL Fields, Created By Link ACL Hash, Title, Department, Phone Home, Phone Mobile, Phone Work, Phone Other, Phone Fax, Status, Address Street, Address City, Address State, Address Country, Address Postalcode, User Type, Default Team, Team Count, Team Count Link Team Count, Team Count Link ID, Team Count Link ACL Fields, Team Count Link ACL Hash, Team Name ID, Team Name Name, Team Name Name 2, Team Name Primary, Team Name Selected, Deleted, Portal Only, Show On Employees, Employee Status, Messenger ID, Messenger Type, Reports To ID, Reports To Name, Reports To Link Name, Reports To Link ID, Reports To Link ACL Fields, Reports To Link ACL Hash, Email 1, Email Email Address, Email Primary Address, Email Reply To Address, Email Invalid Email, Email Opt Out, Email Link Type, Is Group, C Accept Status Fields, Calls ID, M Accept Status Fields, Meetings ID, Accept Status ID, Accept Status Name, Accept Status Calls, Accept Status Meetings, Preferred Language, ACL Role Set ID, My Favorite, ACL Delete, ACL Fields PWD Last Changed Write, ACL Fields PWD Last Changed Create, ACL Fields Last Login Write, ACL Fields Last Login Create, Module, Created By Link ACL Fields PWD Last Changed Write, Created By Link ACL Fields PWD Last Changed Create, Created By Link ACL Fields Last Login Write, Created By Link ACL Fields Last Login Create, Created By Link ACL Delete
Was this article helpful?