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.

  • Saras Pulse

    • Saras Daton

      • Saras IQ

        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