Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

SugarCRM

SugarCRM ETL connector for data replication

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Pulse

    • Daton

      Need help with something?

      Talk to data expert

      SugarCRM

      SugarCRM ETL connector for data replication

      Snapshot

      Features Details
      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

      Name Data 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

      Name Data 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

      Name Data 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

      Name Data 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

      Name Data 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

      Name Data 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

      Name Data 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

      Name Data 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

      Name Data 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

      Name Data 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

      Name Data 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

      Name Data 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
      internal_notes
      STRING
      duration_hours
      NUMERIC
      duration_minutes
      NUMERIC
      date_start
      TIMESTAMP
      date_end
      TIMESTAMP
      parent_type
      STRING
      parent_name
      STRING
      email_reminder_checked
      STRING
      email_reminder_time
      NUMERIC
      email_reminder_sent
      BOOLEAN
      outlook_id
      STRING
      accept_status
      STRING
      set_accept_links
      STRING
      contact_name
      STRING
      contacts
      RECORD
      lead_id
      STRING
      leads
      RECORD
      lead_name
      STRING
      accept_status_users
      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
      transcript
      STRING
      aws_contact_id
      STRING
      call_recording_url
      STRING
      call_recording
      STRING
      aws_lens_data
      STRING
      sentiment_score_agent_string
      STRING
      sentiment_score_customer_string
      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
      call_type_c
      STRING
      contact_c
      STRING
      next_steps_c
      STRING
      _module
      STRING

      notes

      Purpose: This API is used to fetch all the notes for the given credentials     
      Replication: Key Based Incremental     
      Replication Key: date_modified

      Fields

      Name Data 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
      file_mime_type
      STRING
      file_ext
      STRING
      file_source
      STRING
      file_size
      NUMERIC
      file_url
      STRING
      filename
      STRING
      upload_id
      STRING
      email_type
      STRING
      email_id
      STRING
      note_parent_id
      STRING
      parent_type
      STRING
      parent_id
      STRING
      contact_id
      STRING
      portal_flag
      BOOLEAN
      embed_flag
      BOOLEAN
      parent_name
      STRING
      parent
      RECORD
      contact_name
      STRING
      contact
      RECORD
      contact_phone
      STRING
      contact_email
      STRING
      account_id
      STRING
      opportunity_id
      STRING
      acase_id
      STRING
      lead_id
      STRING
      product_id
      STRING
      quote_id
      STRING
      user_name
      STRING
      external_user
      RECORD
      external_id
      STRING
      entry_source
      STRING
      attachment_flag
      BOOLEAN
      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
      _module
      STRING

      purchased_line_items

      Purpose: This API is used to fetch all the purchased line items for the given credentials    
      Replication: Key Based Incremental    
      Replication Key: date_modified

      Fields

      Name Data 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
      annual_revenue
      STRING
      book_value_usdollar
      STRING
      cost_price
      STRING
      cost_usdollar
      STRING
      date_closed
      DATE
      date_closed_timestamp
      NUMERIC
      deal_calc
      STRING
      deal_calc_usdollar
      STRING
      discount_amount
      STRING
      discount_amount_signed
      STRING
      discount_amount_usdollar
      NUMERIC
      discount_price
      STRING
      discount_select
      BOOLEAN
      discount_usdollar
      STRING
      list_usdollar
      STRING
      mft_part_num
      STRING
      revenue
      STRING
      revenue_usdollar
      STRING
      total_amount
      STRING
      subtotal
      STRING
      category_id
      STRING
      category_name
      STRING
      categories
      RECORD
      manufacturer_id
      STRING
      manufacturer_name
      STRING
      manufacturer
      RECORD
      product_template_id
      STRING
      product_template_name
      STRING
      product_templates
      RECORD
      lock_duration
      BOOLEAN
      product_type_id
      STRING
      product_type_name
      STRING
      product_type
      RECORD
      purchase_id
      STRING
      purchase_name
      STRING
      purchase
      RECORD
      revenuelineitem_id
      STRING
      revenuelineitem_name
      STRING
      revenuelineitem
      RECORD
      account_id
      STRING
      account_name
      STRING
      account_link
      RECORD
      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
      asset_number
      STRING
      book_value
      STRING
      book_value_date
      STRING
      date_purchased
      STRING
      date_support_expires
      STRING
      date_support_starts
      STRING
      list_price
      STRING
      pricing_formula
      STRING
      quantity
      NUMERIC
      serial_number
      STRING
      renewable
      BOOLEAN
      service
      BOOLEAN
      service_duration_value
      NUMERIC
      service_duration_unit
      STRING
      catalog_service_duration_unit
      STRING
      service_duration_multiplier
      NUMERIC
      service_end_date
      DATE
      service_start_date
      DATE
      support_contact
      STRING
      support_description
      STRING
      support_name
      STRING
      support_term
      STRING
      tax_class
      STRING
      vendor_part_num
      STRING
      website
      STRING
      renewal
      BOOLEAN
      currency_id
      STRING
      base_rate
      STRING
      currency_name
      STRING
      currencies
      RECORD
      currency_symbol
      STRING
      denorm_account_name
      STRING
      _module
      STRING

      calculated_fields_updater_queue

      Purpose: This API is used to fetch all the calculated fields updater queue for the given credentials  
      Replication: Key Based Incremental  
      Replication Key: date_modified

      Fields

      Name Text
      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
      target_module
      STRING
      parent_name
      STRING
      parent
      RECORD
      parent_type
      STRING
      parent_id
      STRING
      record_state
      STRING
      processed_date
      TIMESTAMP
      pre_update_record_structure
      STRING
      post_update_record_structure
      STRING
      queue_number
      NUMERIC
      processed_fields
      STRING
      wcfu_config_name
      STRING
      wsys_wcfuconfigs_wsys_wcfuqueue
      RECORD
      wcfu_config_id
      STRING
      wcfu_log_name
      STRING
      wsys_wcfulogs_wsys_wcfuqueue
      RECORD
      wcfu_log_id
      STRING
      db_parent_name
      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
      wsys_wcfuconfigs_wsys_wcfuqueue_name
      STRING
      wsys_wcfuconfigs_wsys_wcfuqueuewsys_wcfuconfigs_ida
      STRING
      wsys_wcfulogs_wsys_wcfuqueue_name
      STRING
      wsys_wcfulogs_wsys_wcfuqueuewsys_wcfulogs_ida
      STRING
      _module
      STRING

      Was this article helpful?

      Yes
      No
      Give feedback about this article

      Related Articles

      • Release Notes

      Table of Contents

      Snapshot Tables/APIs Supported Integrate SugarCRM with Daton Workflow Sugar CRM Data accounts currencies contacts cases calendar emails product_catalog purchases tasks calls notes purchased_line_items calculated_fields_updater_queue

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Experts
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Follow Us

      Linkedin Youtube

      Company

      • Customers
      • Partner With Us
      • Contact Us

      Culture

      • About
      • People
      • Careers

      Offerings

      • Daton
      • For Brands
      • For Agencies

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA

      Follow Us

      Linkedin Youtube

      DISCLAIMER: Various trademarks are held by their respective owners

      © 2023 sarasanalytics.com

      Sitemap

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Sales
      DISCLAIMER: Trademarks are held by their respective owners
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Company

      • Customers
      • Partners
      • About
      • People
      • Careers
      • Contact Us

      Offerings

      • Daton
      • Solution for Brands
      • Solution for Agencies
      • Dashboards
      • Founder's Note
      • Status

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA
      • Sitemap

      © 2023 sarasanalytics.com

      Linkedin Youtube

      Knowledge Base Software powered by Helpjuice

      Expand