SugarCRM

SugarCRM ETL connector for data replication

Snapshot

FeaturesDetails

Release Status

Released

Source API Version

V10

Table Selection

Yes

Column Selection

Yes

Edit Integration

Yes

Replication Type Selection

No

Authentication Parameters

None

Replication Type

Key Based Replication, Full Replication

Replication Key

date_modified

Suggested Replication Frequency

24 hours

Tables/APIs Supported

accounts

currencies

meetings

contacts

cases

calendar

emails

calculated_fields_updated_queue

tags

product_catalog

purchases

tasks

calls

notes

purchased_line_items

Integrate SugarCRM with Daton

  1. Sign in to Daton

  2. Select SugarCRM from Integrations page

  3. Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later

  4. In the next step you will be asked to enter sugar CRM site url, sugar CRM username and password

  5. Post successful authentication you will be prompted to choose required tables from the list

  6. Then select all required fields

  7. Submit the integration

Workflow

  1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

  2. Users would be able to edit/pause/re-activate/delete integration anytime

  3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Sugar CRM Data

accounts

Purpose: This API is used to fetch all the accounts for the given credentials

Replication: Key Based Incremental

Replication Key: date_modified

Fields

NameData Type

business_center_id

STRING

campaign_id

STRING

campaign_name

STRING

campaign_accounts

RECORD

next_renewal_date

STRING

widget_next_renewal_date

STRING

hint_account_size

STRING

hint_account_industry

STRING

hint_account_location

STRING

hint_account_industry_tags

STRING

hint_account_founded_year

STRING

hint_account_facebook_handle

STRING

hint_account_logo

STRING

hint_account_pic

STRING

hint_account_naics_code_lbl

STRING

hint_account_fiscal_year_end

STRING

geocode_status

STRING

following

BOOLEAN

my_favorite

BOOLEAN

sync_key

STRING

assigned_user_id

STRING

assigned_user_name

STRING

assigned_user_link

RECORD

team_count

STRING

team_count_link

RECORD

team_name

RECORD

email1

STRING

email2

STRING

invalid_email

STRING

email_opt_out

STRING

email_addresses_non_primary

STRING

is_escalated

BOOLEAN

prosperworks_id_c

STRING

days_since_last_activity_c

NUMERIC

interaction_count_c

NUMERIC

channel_c

STRING

most_recent_opportunity_c

STRING

first_closed_won_opp_c

STRING

type_visibility_c

STRING

custom_type_c

STRING

last_activity_date_c

DATE

first_order_c

STRING

last_order_date_c

STRING

date_converted_c

STRING

days_since_last_order_c

NUMERIC

master_type_c

STRING

_module

STRING

currencies

Purpose: This API is used to fetch the currencies associated with the account

Replication: Full Replication

Replication Key: NA

Fields

NameData Type

id

STRING

name

STRING

symbol

STRING

iso4217

STRING

conversion_rate

NUMERIC

status

STRING

deleted

BOOLEAN

hide

STRING

unhide

STRING

my_favorite

BOOLEAN

_module

STRING

meetings

Purpose: This API is used to fetch all the meetings for the given credentials

Replication: Key Based Incremental

Replication Key: date_modified

Fields

NameData Type

id

STRING

name

STRING

date_entered

TIMESTAMP

date_modified

TIMESTAMP

modified_user_id

STRING

modified_by_name

STRING

modified_user_link

RECORD

created_by

STRING

created_by_name

STRING

created_by_link

RECORD

description

STRING

deleted

BOOLEAN

accept_status

STRING

set_accept_links

STRING

location

STRING

password

STRING

join_url

STRING

host_url

STRING

displayed_url

STRING

creator

STRING

external_id

STRING

duration_hours

NUMERIC

duration_minutes

NUMERIC

date_start

TIMESTAMP

date_end

TIMESTAMP

parent_type

STRING

status

STRING

type

STRING

direction

STRING

parent_id

STRING

reminder_checked

STRING

reminder_time

NUMERIC

email_reminder_checked

STRING

email_reminder_time

NUMERIC

email_reminder_sent

BOOLEAN

outlook_id

STRING

sequence

NUMERIC

contact_name

STRING

contacts

RECORD

parent_name

STRING

accept_status_users

STRING

internal_notes

STRING

contact_id

STRING

repeat_type

STRING

repeat_interval

NUMERIC

repeat_dow

STRING

repeat_until

STRING

repeat_count

NUMERIC

repeat_selector

STRING

repeat_days

STRING

repeat_ordinal

STRING

repeat_unit

STRING

repeat_parent_id

STRING

recurrence_id

STRING

recurring_source

STRING

following

BOOLEAN

my_favorite

BOOLEAN

sync_key

STRING

assigned_user_id

STRING

assigned_user_name

STRING

assigned_user_link

RECORD

team_count

STRING

team_count_link

RECORD

team_name

RECORD

type_of_meeting_c

STRING

_module

STRING

contacts

Purpose: This API is used to fetch all the contacts associated in the account

Replication: Key Based Incremental

Replication Key: date_modified

Fields

NameData Type

id

STRING

name

STRING

date_entered

TIMESTAMP

date_modified

TIMESTAMP

modified_user_id

STRING

modified_by_name

STRING

modified_user_link

RECORD

created_by

STRING

created_by_name

STRING

created_by_link

RECORD

description

STRING

deleted

BOOLEAN

salutation

STRING

first_name

STRING

last_name

STRING

full_name

STRING

title

STRING

facebook

STRING

twitter

STRING

googleplus

STRING

department

STRING

do_not_call

BOOLEAN

phone_home

STRING

phone_mobile

STRING

phone_work

STRING

phone_other

STRING

phone_fax

STRING

primary_address_street

STRING

primary_address_street_2

STRING

primary_address_street_3

STRING

primary_address_city

STRING

primary_address_state

STRING

primary_address_postalcode

STRING

primary_address_country

STRING

alt_address_street

STRING

alt_address_street_2

STRING

alt_address_street_3

STRING

alt_address_city

STRING

alt_address_state

STRING

alt_address_postalcode

STRING

alt_address_country

STRING

assistant

STRING

assistant_phone

STRING

picture

STRING

email_and_name1

STRING

lead_source

STRING

account_name

STRING

accounts

RECORD

account_id

STRING

dnb_principal_id

STRING

opportunity_role_fields

STRING

opportunities

RECORD

opportunity_role_id

STRING

opportunity_role

STRING

reports_to_id

STRING

report_to_name

STRING

reports_to_link

RECORD

birthdate

STRING

portal_name

STRING

portal_active

BOOLEAN

portal_app

STRING

portal_user_company_name

STRING

preferred_language

STRING

cookie_consent

BOOLEAN

cookie_consent_received_on

STRING

business_center_name

STRING

business_centers

RECORD

business_center_id

STRING

dp_consent_last_updated

DATE

campaign_id

STRING

campaign_name

STRING

campaign_contacts

RECORD

c_accept_status_fields

STRING

calls

RECORD

m_accept_status_fields

STRING

meetings

RECORD

accept_status_id

STRING

accept_status_name

STRING

accept_status_calls

STRING

accept_status_meetings

STRING

accept_status_messages

STRING

hint_account_size

STRING

hint_account_industry

STRING

hint_account_location

STRING

hint_account_description

STRING

hint_industry_tags

STRING

hint_account_founded_year

STRING

hint_account_facebook_handle

STRING

hint_account_twitter_handle

STRING

hint_account_logo

STRING

hint_contact_pic

STRING

hint_photo

STRING

hint_phone_1

STRING

hint_phone_2

STRING

hint_account_website

STRING

hint_account_naics_code_lbl

STRING

hint_account_sic_code_label

STRING

hint_account_fiscal_year_end

STRING

hint_account_annual_revenue

STRING

geocode_status

STRING

sync_contact

BOOLEAN

market_interest_prediction_score

STRING

mkto_sync

BOOLEAN

entry_source

STRING

site_user_id

STRING

following

BOOLEAN

my_favorite

BOOLEAN

sync_key

STRING

assigned_user_id

STRING

assigned_user_name

STRING

assigned_user_link

RECORD

team_count

STRING

team_count_link

RECORD

team_name

RECORD

email

RECORD

email1

STRING

email2

STRING

invalid_email

BOOLEAN

email_opt_out

BOOLEAN

email_addresses_non_primary

STRING

source_id

STRING

source_type

STRING

source_meta

STRING

denorm_account_name

STRING

last_activity_date_c

DATE

prosperworks_id_c

STRING

contact_status_c

STRING

interaction_count_c

NUMERIC

create_opportunity_c

STRING

linkedin_c

STRING

lead_created_c

STRING

_module

STRING

cases

Purpose: This API is used to fetch all the cases associated with the given account

Replication: Key Based Incremental

Replication Key: date_modified

Fields

NameData Type

id

STRING

name

STRING

date_entered

TIMESTAMP

date_modified

TIMESTAMP

modified_user_id

STRING

modified_by_name

STRING

modified_user_link

RECORD

created_by

STRING

created_by_name

STRING

created_by_link

RECORD

description

STRING

deleted

BOOLEAN

case_number

NUMERIC

type

STRING

status

STRING

priority

STRING

resolution

STRING

work_log

STRING

follow_up_datetime

TIMESTAMP

widget_follow_up_datetime

STRING

resolved_datetime

STRING

pending_processing

BOOLEAN

account_name

STRING

accounts

RECORD

account_id

STRING

service_level

STRING

business_center_name

STRING

business_centers

RECORD

business_center_id

STRING

source

STRING

request_close

BOOLEAN

request_close_date

STRING

portal_viewable

BOOLEAN

widget_status

STRING

primary_contact_name

STRING

case_contact

RECORD

primary_contact_id

STRING

following

BOOLEAN

my_favorite

BOOLEAN

sync_key

STRING

assigned_user_id

STRING

assigned_user_name

STRING

assigned_user_link

RECORD

team_count

STRING

team_count_link

RECORD

team_name

RECORD

source_id

STRING

source_type

STRING

source_meta

STRING

first_response_target_datetime

STRING

first_response_actual_datetime

STRING

first_response_sla_met

STRING

first_response_user_id

STRING

first_response_user_name

STRING

first_response_user_link

RECORD

first_response_sent

BOOLEAN

is_escalated

BOOLEAN

denorm_account_name

STRING

type_other_details_c

STRING

cases_cases_1_name

STRING

cases_cases_1_right

RECORD

cases_cases_1cases_ida

STRING

order_number_c

STRING

carrier_c

STRING

subcategory_c

STRING

in_progress_status_c

STRING

product_temp_class_c

STRING

root_cause_c

STRING

closed_reason_other_c

STRING

closed_reason_c

STRING

category_c

STRING

_module

STRING

calendar

Purpose: This API is used to fetch all the calendar details for the given account

Replication: Key Based Incremental

Replication Key: date_modified

Fields

NameData Type

id

STRING

name

STRING

date_entered

TIMESTAMP

date_modified

TIMESTAMP

modified_user_id

STRING

modified_by_name

STRING

modified_user_link

RECORD

created_by

STRING

created_by_name

STRING

created_by_link

RECORD

description

STRING

deleted

BOOLEAN

subject

STRING

calendar_module

STRING

event_start

STRING

event_end

STRING

duration_minutes

STRING

duration_hours

STRING

duration_days

STRING

calendar_type

STRING

color

STRING

dblclick_event

STRING

allow_create

BOOLEAN

allow_update

BOOLEAN

allow_delete

BOOLEAN

event_tooltip_template

STRING

day_event_template

STRING

week_event_template

STRING

month_event_template

STRING

agenda_event_template

STRING

timeline_event_template

STRING

schedulermonth_event_template

STRING

ical_event_template

STRING

calendar_filter

STRING

following

BOOLEAN

my_favorite

BOOLEAN

sync_key

STRING

team_count

STRING

team_count_link

RECORD

team_name

RECORD

assigned_user_id

STRING

assigned_user_name

STRING

assigned_user_link

RECORD

_module

STRING

emails

Purpose: This API is used to fetch all the emails for the given credentials

Replication: Key Based Incremental

Replication Key: date_modified

Fields

NameData Type

id

STRING

date_entered

TIMESTAMP

date_modified

TIMESTAMP

assigned_user_id

STRING

assigned_user_name

STRING

assigned_user_link

RECORD

modified_user_id

STRING

modified_by_name

STRING

modified_user_link

RECORD

created_by

STRING

created_by_name

STRING

created_by_link

RECORD

deleted

BOOLEAN

from_addr_name

STRING

to_addrs_names

STRING

description_html

STRING

description

STRING

date_sent

TIMESTAMP

message_id

STRING

message_uid

STRING

name

STRING

type

STRING

status

STRING

flagged

BOOLEAN

reply_to_status

BOOLEAN

intent

STRING

mailbox_id

STRING

mailbox_name

STRING

mailbox

RECORD

state

STRING

reply_to_id

STRING

parent_name

STRING

parent

RECORD

parent_type

STRING

parent_id

STRING

direction

STRING

total_attachments

NUMERIC

sync_key

STRING

my_favorite

BOOLEAN

following

BOOLEAN

team_count

STRING

team_count_link

RECORD

team_name

RECORD

_acl

RECORD

_module

STRING

product_catalog

Purpose: This API is used to fetch all the product catalogs for the given credentials

Replication: Key Based Incremental

Replication Key: date_modified

Fields

NameData Type

id

STRING

name

STRING

date_entered

TIMESTAMP

date_modified

TIMESTAMP

modified_user_id

STRING

modified_by_name

STRING

modified_user_link

RECORD

created_by

STRING

created_by_name

STRING

created_by_link

RECORD

description

STRING

deleted

BOOLEAN

type_id

STRING

manufacturer_id

STRING

manufacturer_name

STRING

manufacturer_link

RECORD

category_id

STRING

category_name

STRING

category_link

RECORD

type_name

STRING

type_link

RECORD

mft_part_num

STRING

vendor_part_num

STRING

date_cost_price

STRING

cost_price

STRING

discount_price

STRING

list_price

STRING

cost_usdollar

STRING

discount_usdollar

STRING

list_usdollar

STRING

status

STRING

tax_class

STRING

active_status

STRING

date_available

STRING

website

STRING

support_name

STRING

support_description

STRING

support_contact

STRING

support_term

STRING

pricing_formula

STRING

service_duration_unit

STRING

renewable

BOOLEAN

service

BOOLEAN

lock_duration

BOOLEAN

following

BOOLEAN

my_favorite

BOOLEAN

sync_key

STRING

assigned_user_id

STRING

assigned_user_name

STRING

assigned_user_link

RECORD

currency_id

STRING

base_rate

STRING

currency_name

STRING

currencies

RECORD

currency_symbol

STRING

team_count

STRING

team_count_link

RECORD

team_name

RECORD

_module

STRING

tags

Purpose: This API is used to fetch all the tags for the given account

Replication: Key Based Incremental

Replication Key: date_modified

Fields

NameData Type

id

STRING

name

STRING

date_entered

TIMESTAMP

date_modified

TIMESTAMP

modified_user_id

STRING

modified_by_name

STRING

modified_user_link

RECORD

created_by

STRING

created_by_name

STRING

created_by_link

RECORD

description

STRING

deleted

BOOLEAN

name_lower

STRING

following

BOOLEAN

my_favorite

BOOLEAN

sync_key

STRING

source_id

STRING

source_type

STRING

source_meta

STRING

assigned_user_id

STRING

assigned_user_name

STRING

assigned_user_link

RECORD

_module

STRING

purchases

Purpose: This API is used to fetch all the purchases for the given credentials

Replication: Key Based Incremental

Replication Key: date_modified

Fields

NameData Type

id

STRING

name

STRING

date_entered

TIMESTAMP

date_modified

TIMESTAMP

modified_user_id

STRING

modified_by_name

STRING

modified_user_link

RECORD

created_by

STRING

created_by_name

STRING

created_by_link

RECORD

description

STRING

deleted

BOOLEAN

start_date

DATE

end_date

DATE

service

BOOLEAN

total_revenue

STRING

total_quantity

NUMERIC

pli_count

NUMERIC

renewable

BOOLEAN

product_template_id

STRING

product_template_name

STRING

product_templates

RECORD

account_name

STRING

accounts

RECORD

account_id

STRING

type_id

STRING

type_name

STRING

product_types

RECORD

category_id

STRING

category_name

STRING

categories

RECORD

following

BOOLEAN

my_favorite

BOOLEAN

sync_key

STRING

assigned_user_id

STRING

assigned_user_name

STRING

assigned_user_link

RECORD

team_count

STRING

team_count_link

RECORD

team_name

RECORD

currency_id

STRING

base_rate

STRING

currency_name

STRING

currencies

RECORD

currency_symbol

STRING

_module

STRING

tasks

Purpose: This API is used to fetch all the tasks for the given credentials

Replication: Key Based Incremental

Replication Key: date_modified

Fields

NameData Type

id

STRING

name

STRING

date_entered

TIMESTAMP

date_modified

TIMESTAMP

modified_user_id

STRING

modified_by_name

STRING

modified_user_link

RECORD

created_by

STRING

created_by_name

STRING

created_by_link

RECORD

description

STRING

deleted

BOOLEAN

status

STRING

date_due_flag

BOOLEAN

date_due

TIMESTAMP

time_due

STRING

date_start_flag

BOOLEAN

date_start

TIMESTAMP

parent_type

STRING

parent_name

STRING

parent

RECORD

parent_id

STRING

contact_id

STRING

contact_name

STRING

contacts

RECORD

contact_phone

STRING

contact_email

STRING

priority

STRING

following

BOOLEAN

my_favorite

BOOLEAN

sync_key

STRING

assigned_user_id

STRING

assigned_user_name

STRING

assigned_user_link

RECORD

team_count

STRING

team_count_link

RECORD

team_name

RECORD

update_status_button_c

STRING

_module

STRING

calls

Purpose: This API is used to fetch all the calls for the given credentials

Replication: Key Based Incremental

Replication Key: date_modified

Fields

NameData Type

id

STRING

name

STRING

date_entered

TIMESTAMP

date_modified

TIMESTAMP

modified_user_id

STRING

modified_by_name

STRING

modified_user_link

RECORD

created_by

STRING

created_by_name

STRING

created_by_link

RECORD