LogoLogo
Daton
Daton
  • Daton Defined: From Web App Essentials to Advanced Integrations
  • Platform
    • Essentials
      • Billing
      • Integrate Facebook Ads on Daton
      • Integrate Shopify on Daton
      • Integrate Google Analytics on Daton
      • Access permissions for Daton
      • How to get started with Daton setup
      • Terminology in Daton
        • Source and Source_Table statuses
      • Various pages in Daton
    • Features
      • Navigating the pages in Daton
        • Notifications
        • Logs
        • Dashboard
        • My Account
        • Connectors
        • My Integrations
        • Integration Details
      • Templates
      • Account Management
        • My Account Page
      • Notifications
      • Monitoring
        • Logging and Log Retention
      • Manage Integrations
        • Handling Changes to Schema
        • Modifying an integration
      • Data
        • Handling Nested Data
        • Daton Metadata
        • Inserts, Updates, and Upserts
        • Data Type Mapping
        • Data Replication in Daton
          • Replication Fields
          • Replication Methods
            • Key-based Incremental Replication
      • Knowledge Base
        • What is ELT and how is it different from traditional ETL tools
          • Billing
      • Pipelines
        • Pipeline Jobs
        • Loading Behavior
      • Security
      • Feature Updates
        • Amazon Vendor Central
  • Connectors
    • Data Sources
      • Advertising
        • Adjust v1
        • Adjust v2
          • About Adjust v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Adjust v2 with Daton
          • Schema Information
        • Amazon Ads
          • Release Notes
        • Amazon Attribution
          • Release Notes
        • Amazon Brand Metrics
          • About Amazon Brand Metrics
          • Essential Attributes and Supported Tables
          • How to Integrate Amazon Brand Metrics with Daton
          • Schema Infomation
        • Amazon DSP V1
          • Release Notes
        • Amazon DSP V2
        • Amazon Marketing Cloud (AMC)
        • Amazon Marketing Streams
          • About Amazon Marketing Streams Connector
          • Essential Attributes
          • How to Integrate Amazon Marketing Streams with Daton
          • Release Notes
        • Amazon Sponsored Brand Ads
          • Release Notes
        • Amazon Sponsored Display Ads
          • Release Notes
        • Amazon Sponsored Product Ads
          • Release Notes
        • Amazon Sponsored TV Ads
        • Bing Ads
          • Release Notes
        • Bol Ads
          • Release Notes
        • Facebook Ads
          • Release Notes
        • Google Ads
          • Release Notes
        • Google My Business
        • Google My Business v2
          • About Google My Business v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Google Business Profile Account with Daton
          • Schema Information
        • Gorgias
        • Gorgias V2
        • HelpScout
        • HelpScout v2
          • About HelpScout Platform
          • Essential Attributes and Supported Tables
          • How to Integrate HelpScout with Daton
          • Schema Information
          • Release Notes
        • Outbrain
          • Release Notes
        • Outbrain v2
          • About Outbrain Platform
          • Essential Attributes & Supported Tables
          • How to Integrate Outbrain v2 with Daton
          • Schema Information
        • Pinterest v2
          • About Pinterest v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Pinterest v2 with Daton
          • Schema Information
        • Rakuten
          • About Rakuten Connector
          • Essential Attributes
          • How to Integrate Rakuten with Daton
        • StackAdapt
          • About StackAdapt Platform
          • Essential Attributes and Supported Tables
          • How to Integrate StackAdapt with Daton
          • Schema Information
        • Typeform
          • About Typeform Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Typeform with Daton
          • Schema Information
        • Upscribe
          • Release Notes
        • Upscribe V2
          • About Upscribe Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Upscribe v2 with Daton
          • Schema Information
      • Analytics Platforms
        • Appsflyer
        • GA4
          • About Google Analytics Platform
          • Essential Attributes and Table Selection
          • How to Integrate GA4 with Daton
          • Schema Information
        • Google Analytics
          • Release Notes
        • Jungle Scout
        • Northbeam
          • About Northbeam Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Northbeam with Daton
          • Schema Information
        • Prodco Analytics
          • About Prodco Analytics Platform
          • Essential Attributes and Table Selection
          • How to Integrate Prodco Analytics Account with Daton
          • Schema Information
        • Rainforest
          • About Rainforest Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Rainforest Account with Daton
          • Schema Information
        • Sprout Social
          • About Sprout Social Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Sprout Social with Daton
          • Schema Information
        • Taboola
        • Taboola v2
          • About Taboola v2
          • Essential Attributes and Supported Tables
          • How to Integrate Taboola v2 with Daton
          • Schema Information
        • Edge by Ascential
      • Business
        • ClickUp
          • About ClickUp Connector
          • Essential Attributes and Supported Tables
          • How to Integrate ClickUp with Daton
          • Schema Information
        • Bubble
        • Pipedrive
          • About Pipedrive Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Pipedrive with Daton
          • Schema Information
        • Teamwork
          • About Teamwork Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Teamwork with Daton
          • Schema Information
        • Teamwork v2
          • About Teamwork Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Teamwork v2 with Daton
          • Schema Information
        • TikTok Business
          • About TikTok Business Connector
          • Essential Attributes and Supported Tables
          • How to Integrate TikTok Business with Daton
          • Schema Information
        • Unbounce v2
          • About Unbounce v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Unbounce v2 with Daton
          • Schema Information
      • Call Center
        • Aircall
        • Callpage
        • JustCall
          • About JustCall Connector
          • Essential Attributes and Supported Tables
          • How to Integrate JustCall with Daton
          • Schema Information
      • Databases
        • Amazon Aurora MySQL
          • About Amazon Aurora Platform
          • Essential Attributes
          • How to Integrate Amazon Aurora with Daton
        • Amazon Redshift
          • About Amazon Redshift Platform
          • Essential Attributes
          • How to Integrate Amazon Redshift with Daton
        • GCP MySQL
          • About GCP MySQL Platform
          • Essential Attributes
          • How to Integrate GCP MySQL with Daton
        • GCP PostgreSQL
          • Setup Manual
        • Magento (DB)
          • About Magento Connector
          • Essential Attributes
          • How to Integrate Magento with Daton
        • MySQL
          • Release Notes
        • NetSuite
        • PostgreSQL
          • Release Notes
        • SQLServer
        • WooCommerce SQL
          • About WooCommerce SQL Platform
          • Essential Attributes
          • How to Integrate WooCommerce SQL with Daton
      • Daton Connector
        • Release Notes
      • Ecommerce Platforms
        • Amazon MWS
          • Release Notes
        • Amazon Selling Partner
          • All Report Types and Tables
          • Release Notes
        • Amazon Vendor Central
          • All Report Types and Tables
          • Real Time Reports
          • Daily Reports
          • Weekly Reports
          • Snapshot Reports
          • Monthly Reports
          • Raw Tables
          • Release Notes
        • Bigcommerce
        • BigCommerce v2
          • About BigCommerce Platform
          • Essential Attributes and Supported Tables
          • How to Integrate BigCommerce Account with Daton
          • Schema Information
          • Release Notes
        • Bol Retail v2
          • Release Notes
        • Capillary Martjack
          • Release Notes
        • Kaufland
          • About Kaufland Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Kaufland with Daton
          • Schema Information
        • Keepa
          • About Keepa Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Keepa with Daton
          • Schema Information
        • Lazada
        • Loopreturns
          • Release Notes
        • Magento
          • Release Notes
        • Magento 2 (APIs)
          • Release Notes
        • Mercado Libre
          • About Mercado Libre Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Mercado Libre with Daton
          • Schema Information
        • Shopify
          • Access tokens for Shopify
          • Release Notes
        • Shopify V2
        • Walmart
          • Release Notes
        • Walmart_v2
          • Release Notes
        • WooCommerce
      • Files
        • Amazon S3
          • Release Notes
        • Dropbox
          • Release Notes
        • Email Attachments
          • About Email Attachments Connector
          • Essential Attributes and Connector Guidelines
          • How to Integrate Email Attachments with Daton
        • Google Cloud Storage
          • Release Notes
        • Google Drive
        • Google Sheets
          • Release Notes
        • SFTP (SSH File Transfer Protocol)
      • OMS/WMS
        • Cin7
        • Goflow
          • About Goflow Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Goflow with Daton
          • Schema Information
        • Rippling
          • About Rippling Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Rippling with Daton
          • Schema Information
      • Payments
        • PayPal
          • About PayPal Connector
          • Essential Attributes and Supported Tables
          • How to Integrate PayPal with Daton
          • Schema Information
        • Razorpay
          • About Razorpay Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Razorpay with Daton
          • Schema Information
        • Razorpay v1
        • Stripe
      • Productivity Trackers
        • GitLab
          • Release Notes
        • Time Doctor
          • Release Notes
      • SaaS Integrations
        • Aftership
          • Release Notes
        • Aftership V2
        • Anvyl
        • Ascend
        • Awtomic
          • Release Notes
        • Braintree
          • About Braintree Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Braintree Account with Daton
          • Schema Information Braintree
        • Calendly
          • Release Notes
        • Calendly V2
        • Campaign Monitor
        • Capsule CRM
        • Chargebee
        • Freshworks CRM
        • Loop Subscription
        • Commission Junction
        • Constant Contact
        • Copper CRM
          • About Copper
          • Essential Attributes and Supported Tables
          • How to Integrate Copper Account with Daton
          • Schema Information
          • Release Notes
        • Criteo
        • Criteo Retail Media
        • Customer.io
        • DotDigital
        • dotdigital V2
        • Easyecom
        • EasyEcom V2
          • Release Notes
        • ePallet ERP
        • Etsy
        • Exchange Rates
          • About Exchange Rate Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Exchange Rates with Daton
          • Schema Information
          • Release Notes
        • Fairing (previously EnquireLabs)
          • Release Notes
        • FreshBooks
          • Release Notes
        • Freshdesk
          • Release Notes
        • Freshsales
          • Release Notes
        • Fulfil
        • Gladly
          • Release Notes
        • Google Search Console
          • Release Notes
        • HubSpot
          • Release Notes
        • HubSpot v2
          • About HubSpot v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate HubSpot v2 with Daton
          • Schema Information
        • Impact
          • Release Notes
        • Infusionsoft (now Keap Max Classic)
          • About Infusionsoft Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Infusionsoft with Daton
          • Schema Information
        • Insightly
        • Intercom
          • Release Notes
        • Intercom V2
          • Release Notes
        • Outbrain V2 (Old)
          • Release Notes
        • Inventory Planner
        • Jira
        • JudgeMe
          • Release Notes
        • Kibo Commerce
        • Klaviyo
          • Release Notes
        • Klaviyo V2
          • Release Notes
        • Kustomer
        • LeadSquared CRM
        • LeadSquared V2
        • LinkedIn Ads
        • LiveChat
        • LoyaltyLion
        • MailChimp
          • Release Notes
        • MNTN
        • Monday
        • NewRelic
        • Okendo Reviews
          • About Okendo Reviews Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Okendo Reviews with Daton
          • Schema Information
        • Optimove
          • Release Notes
        • Pingdom
        • Pinterest
        • Pipedrive
        • PushEngage
        • Quickbase
        • QuickBooks
        • Quickbooks v2
          • About Quickbooks Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Quickbooks v2 with Daton
          • Schema Information
        • Re:amaze
        • ReCharge Payments
          • Release Notes
        • ReCharge Payments v1
          • Setup Manual
          • Schema Information
        • Recharge Payments V2
          • Setup Manual
          • Schema Information
        • Reviewmonitoring
          • Release Notes
        • Salsify
          • Release Notes
        • SendGrid
          • Release Notes
        • Shiphero
        • Shippo
        • Shiprocket
          • Release Notes
        • Shiprocket v2
          • About Shiprocket Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Shiprocket with Daton
          • Schema Information
        • Shipstation
          • Release Notes
        • Skubana
        • SkuVault
          • About SkuVault Connector
          • Essential Attributes and Supported Tables
          • How to Integrate SkuVault with Daton
          • Schema Information
        • Smartrr
        • Smartrr v2
          • About Smartrr Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Smartrr v2 with Daton
          • Schema Information
        • Stamped.io
          • About Stamped.io Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Stamped.io with Daton
          • Schema Information
        • Stamped.io v1
        • Stay AI
        • Sticky.io
        • SugarCRM
          • Release Notes
        • Survey Monkey
        • Tune
        • Unbounce
        • Unicommerce
        • Unicommerce
          • About Unicommerce Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Unicommerce with Daton
          • Schema Information
          • Release Notes
        • When I Work
        • Xero
        • Xero V2
          • About Xero Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Xero V2 with Daton
          • Schema Information
        • Yahoo Gemini
        • Yotpo
        • Yotpo v2
          • About Yotpo Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Yotpo v2 with Daton
          • Schema Information
        • Zendesk Chat
        • Zendesk ETL
          • Release Notes
        • Zoho CRM
          • Release Notes
        • ZohoDesk
          • Release Notes
      • Surveys
        • Alchemer
          • About Alchemer Platform
          • Essential Attributes and Supported Tables Alchemer
          • How to Integrate Alchemer Account with Daton
          • Schema Information Alchemer
        • Fairing
          • About Fairing Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Fairing with Daton
          • Schema Information
        • Survicate
          • About Survicate Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Survicate with Daton
          • Schema Information
      • Shipping Platforms
        • 3PL Central
        • Byrd
        • Cin7
        • ClickPost
        • Dear
        • Easypost
        • Ohi
          • About Ohi Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Ohi with Daton
          • Schema Information
        • ShipBob
          • About ShipBob Connector
          • Essential Attributes and Supported Tables
          • How to Integrate ShipBob with Daton
          • Schema Information
      • Webhooks
    • Destinations
      • Amazon RDS PostgreSQL
        • Amazon RDS for PostgreSQL Integration with Daton
        • How to Set up RDS PostgreSQL Destination in Daton
      • Amazon RDS MySQL
        • About Integrating Amazon RDS for MySQL database with Daton
        • How to Set up RDS MySQL Destination in Daton
      • Amazon Redshift
        • Querying Daton created tables on RedShift
        • Release Notes
      • Amazon S3
        • Release Notes
      • Azure One Lake
        • About Azure One Lake as a connector in Daton
        • How to Set up an Azure One Lake Database for Integrating with Daton
        • How to Integrate your Azure One Lake Database as a Destination in Daton
      • Azure Data Lake Storage
        • About Azure Data Lake Storage as a connector in Daton
        • How to Set up an Azure Data Lake Storage for Integrating with Daton
        • How to Integrate Your Azure Data Lake Storage Database as a Destination in Daton
      • GCP PostgreSQL
        • About Google Cloud SQL for PostgreSQL Database with Daton
        • How to Set up GCP PostgreSQL Destination in Daton
      • Google BigQuery
        • Release Notes
      • GCS
      • MySQL
        • About Integrating MySQL with Daton
        • How to Set up a MySQL Database for Integrating with Daton
        • How to Set up Your MySQL Database as a Destination in Daton
      • Oracle Autonomous Data Warehouse
      • Snowflake
        • Release Notes
  • FAQs and Troubleshooting
    • Connector permissions and API Keys
      • Access tokens for Shopify
      • Amazon Ads Permissions
      • Where to find my Amazon MWS Merchant Token and Auth Token
      • How to create BigCommerce API Account and generate Client Id, Client Secret and Access tokens
      • How to create Client credentials for Bol Retail
      • How to create Developer application for Mercado Libre
      • How to create API Keys for SendGrid
      • Where to find API Keys for Freshsales
      • Where to find API Keys for Freshdesk
      • How to create REST API Keys for NewRelic
      • How to create API Keys for Chargebee
      • How to generate Access Token for Calendly
      • How to obtain Klaviyo API Key
      • Where to find API Keys for RazorPay
      • How to create API Keys for PushEngage
      • How to create Criteo API User and generate Client Id and Client Secret
      • How to find site-id/domain and create WooCommerce Consumer Key and Secret
    • Authentication Failure while connecting Database using SSH tunnel
    • Common Errors and Resolution
    • FAQs
      • How to get access to FB Ads Business Manager?
      • How to get access to Google Analytics?
      • Querying Daton created child tables for nested data
      • Google Analytics - FAQs
      • How does Lite Plan Work?
      • How do I upgrade my subscription?
      • How does loading behaviour impact billing?
      • What are the tables highlighted with the letter "F"?
      • Amazon Advertising FAQs
      • Amazon Business and Inventory Reports FAQs
      • Why don't I see my data?
      • How exactly do Business Reports work in Daton?
      • Steps to upload your own ASIN and SKU file in Amazon SP connectors
      • What are 'FATAL' and 'CANCELLED' report statuses in Amazon Selling Partner?
      • How to setup Google BigQuery Project
      • Amazon Selling Partner, Vendor Central - Access to resource denied error.
      • VendorSalesReportByManufacturing showing a FATAL report status?
      • How to Enable SSH Tunneling during a Database Source Authentication?
  • New Subscription Plans and Billing
    • Subscription Plans Overview
    • Find Your Perfect Data Integration Fit - Growth and Enterprise Plans Explored
    • Daton's Subscriptions Dashboard: Harness the Power of Your Data
    • How to Select and Subscribe to a Daton Subscription Plan?
    • Subscription Plan Upgrade and Downgrade
    • Changing Billing Cycle
  • Product Insights: Report, Roadmap, and Release Notes
    • Introduction to Product Insights
    • 2023 Recap and 2024 Roadmap
    • Release Notes
Powered by GitBook
On this page
  • Snapshot
  • Tables/APIs Supported
  • Integrate SugarCRM with Daton
  • Workflow
  • Sugar CRM Data
  • accounts
  • currencies
  • meetings
  • contacts
  • cases
  • calendar
  • emails
  • product_catalog
  • tags
  • purchases
  • tasks
  • calls
  • notes
  • purchased_line_items
  • calculated_fields_updater_queue

Was this helpful?

  1. Connectors
  2. Data Sources
  3. SaaS Integrations

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

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

PreviousSticky.ioNextRelease Notes

Last updated 2 years ago

Was this helpful?