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
  • Integrate ZohoCRM with Daton
  • Workflow
  • ZohoCRM Data

Was this helpful?

  1. Connectors
  2. Data Sources
  3. SaaS Integrations

Zoho CRM

Zoho CRM ETL connector for data replication

Snapshot

Features

Details

Release Status

Released

Source API Version

v2

Table Selection

Yes

Column Selection

Yes

Edit Integration

Yes

Replication Type Selection

No

Authentication Parameters

zoho account email Passoword

Replication Type

Key Based Replication

Replication Key

Modified_Time

Suggested Replication Frequency

24 hrs

Tables/APIs Supported

Quotes

Solutions

Vendors

Cases

Campaigns

Products

Leads

Accounts

Contacts

Deals

Tasks

Events

Calls

Price_Books

Sales_Orders

Purchase_Orders

Invoices

Notes

Activities

Integrate ZohoCRM with Daton

  1. Signin to Daton

  2. Select ZohoCRM 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. Provide Zoho Account Email and Password to authorize Daton to periodically extract data from ZohoCRM

  5. Post successful authentication, you will be prompted to choose from the list of available tables

  6. Then select all required fields for each table

  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

ZohoCRM Data

Quotes

Purpose: Sales Quotes are legally binding agreements between a customer and vendor to deliver the customer requested products in a specified time-frame at a predefined price.

Replication: Key-Based Replication

Replication Key: Modified_Time

Fields

Name

Target Datatype

Owner

RECORD

Discount

NUMERIC

Description

STRING

currency_symbol

STRING

Shipping_State

STRING

Tax

NUMERIC

Modified_By

RECORD

converted

BOOLEAN

process_flow

BOOLEAN

Deal_Name

STRING

Valid_Till

STRING

Billing_Country

STRING

Team

STRING

Account_Name

RECORD

id

STRING

Carrier

STRING

approved

BOOLEAN

Quote_Stage

STRING

Grand_Total

NUMERIC

approval

RECORD

Modified_Time

STRING

Billing_Street

STRING

Adjustment

NUMERIC

Created_Time

STRING

Terms_and_Conditions

STRING

Sub_Total

NUMERIC

editable

BOOLEAN

Billing_Code

STRING

Product_Details

RECORD

Subject

STRING

Contact_Name

RECORD

Shipping_City

STRING

Shipping_Country

STRING

Shipping_Code

STRING

Billing_City

STRING

Quote_Number

STRING

Billing_State

STRING

line_tax

RECORD

Created_By

RECORD

Tag

STRING

Shipping_Street

STRING

Solutions

Purpose: Set of solutions that will guide you in creating reports for widely asked Key Sales Performance metrics over the Zoho CRM data

Replication: Key-Based Replication

Replication Key: Modified_Time

Fields

Name

Target Datatype

Status

STRING

approval

RECORD

Owner

RECORD

Modified_Time

STRING

currency_symbol

STRING

Created_Time

STRING

Comments

STRING

No_of_comments

NUMERIC

Product_Name

STRING

editable

BOOLEAN

Add_Comment

STRING

Solution_Number

STRING

Answer

STRING

Modified_By

RECORD

process_flow

BOOLEAN

Solution_Title

STRING

Question

STRING

id

STRING

Created_By

RECORD

Tag

STRING

approved

BOOLEAN

Vendors

Purpose: Vendors include companies, people, and contractors from which your company gets products and services. They can be either direct manufacturers or resellers.

Replication: Key-Based Replication

Replication Key: Modified_Time

Fields

Name

Target Datatype

Owner

RECORD

Email

STRING

Category

STRING

Description

STRING

currency_symbol

STRING

Vendor_Name

STRING

Website

STRING

Record_Image

STRING

Modified_By

RECORD

process_flow

BOOLEAN

Phone

STRING

Street

STRING

Zip_Code

STRING

id

STRING

approved

BOOLEAN

approval

RECORD

Modified_Time

STRING

Created_Time

STRING

editable

BOOLEAN

City

STRING

State

STRING

GL_Account

STRING

Country

STRING

Created_By

RECORD

Tag

STRING

Cases

Purpose: In general, case trouble tickets are used to capture customer feedback on various types of issues that arise after purchasing a product or service from your company.

Replication: Key-Based Replication

Replication Key: Modified_Time

Fields

Name

Target Datatype

Owner

RECORD

Email

STRING

Description

STRING

currency_symbol

STRING

Internal_Comments

STRING

No_of_comments

NUMERIC

Reported_By

STRING

Case_Number

STRING

Modified_By

RECORD

process_flow

BOOLEAN

Deal_Name

RECORD

Phone

STRING

Account_Name

RECORD

id

STRING

approved

BOOLEAN

Solution

STRING

Status

STRING

approval

RECORD

Modified_Time

STRING

Priority

STRING

Created_Time

STRING

Comments

STRING

Product_Name

RECORD

editable

BOOLEAN

Add_Comment

STRING

Case_Origin

STRING

Case_Reason

STRING

Subject

STRING

Type

STRING

Tag

STRING

Created_By

RECORD

Related_To

RECORD

Campaigns

Purpose: campaign management helps you to plan, execute and monitor campaigns in an organized way. You can do the followin

Replication: Key-Based Replication

Replication Key: Modified_Time

Fields

Name

Target Datatype

Status

STRING

approval

RECORD

Owner

RECORD

Modified_Time

STRING

Description

STRING

currency_symbol

STRING

Campaign_Name

STRING

Created_Time

STRING

editable

BOOLEAN

End_Date

STRING

Type

STRING

Modified_By

RECORD

Num_sent

STRING

process_flow

BOOLEAN

Expected_Revenue

NUMERIC

Actual_Cost

NUMERIC

id

STRING

Expected_Response

STRING

Created_By

RECORD

Tag

STRING

Parent_Campaign

STRING

Start_Date

STRING

approved

BOOLEAN

Budgeted_Cost

NUMERIC

Products

Purpose: Products can be either goods or services, which are sold or procured by your organization

Replication: Key-Based Replication

Replication Key: Modified_Time

Fields

Name

Target Datatype

Product_Category

STRING

Qty_in_Demand

NUMERIC

Owner

RECORD

Description

STRING

currency_symbol

STRING

Vendor_Name

RECORD

Sales_Start_Date

STRING

Tax

STRING

Product_Active

BOOLEAN

Record_Image

STRING

Modified_By

RECORD

Product_Code

STRING

process_flow

BOOLEAN

Manufacturer

STRING

id

STRING

Support_Expiry_Date

STRING

approved

BOOLEAN

approval

RECORD

Modified_Time

STRING

Created_Time

STRING

Commission_Rate

NUMERIC

Product_Name

STRING

Handler

STRING

editable

BOOLEAN

Support_Start_Date

STRING

Usage_Unit

STRING

Qty_Ordered

NUMERIC

Qty_in_Stock

NUMERIC

Created_By

RECORD

Tag

STRING

Sales_End_Date

STRING

Unit_Price

NUMERIC

Taxable

BOOLEAN

Reorder_Level

NUMERIC

Leads

Purpose: Leads are the details gathered about an individual or representatives of an organization

Replication: Key-Based Replication

Replication Key: Modified_Time

Fields

Name

Target Datatype

Owner

RECORD

Company

STRING

Email

STRING

Description

STRING

currency_symbol

STRING

Rating

STRING

Website

STRING

Twitter

STRING

Salutation

STRING

Last_Activity_Time

STRING

First_Name

STRING

Full_Name

STRING

Lead_Status

STRING

Industry

STRING

Record_Image

STRING

Modified_By

RECORD

Skype_ID

STRING

converted

BOOLEAN

process_flow

BOOLEAN

Phone

STRING

Street

STRING

Zip_Code

STRING

id

STRING

Email_Opt_Out

BOOLEAN

approved

BOOLEAN

Designation

STRING

approval

RECORD

Modified_Time

STRING

Created_Time

STRING

editable

BOOLEAN

City

STRING

No_of_Employees

NUMERIC

Mobile

STRING

Last_Name

STRING

State

STRING

Lead_Source

STRING

Country

STRING

Tag

STRING

Created_By

RECORD

Fax

STRING

Annual_Revenue

NUMERIC

Secondary_Email

STRING

Accounts

Purpose: Account represents a Company or a Department within the company, with which your organization is currently doing business with or is planning to do business with in the future

Replication: Key-Based Replication

Replication Key: Modified_Time

Fields

Name

Target Datatype

Owner

RECORD

Ownership

STRING

Description

STRING

currency_symbol

STRING

Account_Type

STRING

Rating

STRING

SIC_Code

NUMERIC

Shipping_State

STRING

Website

STRING

Employees

NUMERIC

Last_Activity_Time

STRING

Industry

STRING

Record_Image

STRING

Modified_By

RECORD

Account_Site

STRING

process_flow

BOOLEAN

Phone

STRING

Billing_Country

STRING

Account_Name

STRING

id

STRING

Account_Number

STRING

approved

BOOLEAN

Ticker_Symbol

STRING

approval

RECORD

Modified_Time

STRING

Billing_Street

STRING

Created_Time

STRING

editable

BOOLEAN

Billing_Code

STRING

Parent_Account

STRING

Shipping_City

STRING

Shipping_Country

STRING

Shipping_Code

STRING

Billing_City

STRING

Billing_State

STRING

Tag

STRING

Created_By

RECORD

Fax

STRING

Annual_Revenue

NUMERIC

Shipping_Street

STRING

Contacts

Purpose: Contacts are people with whom you communicate, either in pursuit of a business opportunity or for personal reasons

Replication: Key-Based Replication

Replication Key: Modified_Time

Fields

Name

Target Datatype

Owner

RECORD

Email

STRING

Description

STRING

currency_symbol

STRING

Vendor_Name

STRING

Mailing_Zip

STRING

Other_Phone

STRING

Mailing_State

STRING

Twitter

STRING

Other_Zip

STRING

Mailing_Street

STRING

Other_State

STRING

Salutation

STRING

Other_Country

STRING

Last_Activity_Time

STRING

First_Name

STRING

Full_Name

STRING

Asst_Phone

STRING

Record_Image

STRING

Department

STRING

Modified_By

RECORD

Skype_ID

STRING

process_flow

BOOLEAN

Assistant

STRING

Phone

STRING

Mailing_Country

STRING

Account_Name

STRING

id

STRING

Email_Opt_Out

BOOLEAN

approved

BOOLEAN

Reporting_To

STRING

approval

RECORD

Modified_Time

STRING

Date_of_Birth

STRING

Mailing_City

STRING

Other_City

STRING

Created_Time

STRING

Title

STRING

editable

BOOLEAN

Other_Street

STRING

Mobile

STRING

Home_Phone

STRING

Last_Name

STRING

Lead_Source

STRING

Tag

STRING

Created_By

RECORD

Fax

STRING

Secondary_Email

STRING

Tasks

Purpose: A task is a specific piece of work that is usually time bound. In Zoho CRM, tasks are listed in the record's Home page, Activities home page, and in other related records.

Replication: Key-Based Replication

Replication Key: Modified_Time

Fields

Name

Target Datatype

Status

STRING

approval

RECORD

Owner

RECORD

Modified_Time

STRING

Description

STRING

currency_symbol

STRING

Due_Date

STRING

Priority

STRING

Created_Time

STRING

Closed_Time

STRING

editable

BOOLEAN

Subject

STRING

Send_Notification_Email

BOOLEAN

se_module

STRING

Modified_By

RECORD

Recurring_Activity

STRING

process_flow

BOOLEAN

What_Id

RECORD

id

STRING

Created_By

RECORD

Tag

STRING

approved

BOOLEAN

Remind_At

STRING

Who_Id

RECORD

Events

Purpose: An event is an activity that happens at a given place and time. They are listed in the Zoho CRM's Home page of the user, Activities home page, Calendar and in other related records.

Replication: Key-Based Replication

Replication Key: Modified_Time

Fields

Name

Target Datatype

All_day

BOOLEAN

Owner

RECORD

Check_In_State

STRING

Check_In_Address

STRING

Description

STRING

currency_symbol

STRING

Start_DateTime

STRING

Latitude

STRING

Participants

STRING

Event_Title

STRING

calendar_booking_event

BOOLEAN

End_DateTime

STRING

Check_In_By

STRING

Modified_By

RECORD

process_flow

BOOLEAN

Check_In_City

STRING

id

STRING

Check_In_Comment

STRING

approved

BOOLEAN

Remind_At

STRING

Who_Id

STRING

Check_In_Status

STRING

Check_In_Country

STRING

approval

RECORD

Modified_Time

STRING

Venue

STRING

ZIP_Code

STRING

Created_Time

STRING

editable

BOOLEAN

recurrence_id

STRING

Longitude

STRING

Check_In_Time

STRING

se_module

STRING

Recurring_Activity

STRING

What_Id

RECORD

Check_In_Sub_Locality

STRING

u_id

STRING

Created_By

RECORD

Tag

STRING

send_notification

BOOLEAN

Calls

Purpose:automatically log all call activities, texts, call recordings and voicemails under your contacts

Replication: Key-Based Replication

Replication Key: Modified_Time

Fields

Name

Target Datatype

Call_Duration

STRING

Owner

RECORD

Description

STRING

currency_symbol

STRING

calendar_booking_call

BOOLEAN

Modified_By

RECORD

process_flow

BOOLEAN

Call_Purpose

STRING

id

STRING

Call_Status

STRING

approved

BOOLEAN

Who_Id

STRING

approval

RECORD

Modified_Time

STRING

Reminder

STRING

Created_Time

STRING

Call_Start_Time

STRING

Billable

BOOLEAN

editable

BOOLEAN

Subject

STRING

se_module

STRING

Call_Type

STRING

Call_Result

STRING

What_Id

RECORD

Call_Duration_in_seconds

STRING

Created_By

RECORD

Tag

STRING

Price_Books

Purpose: Price Books are used for selling products at different prices, based on the agreement terms with a particular type of customer.

Replication: Key-Based Replication

Replication Key: Modified_Time

Fields

Name

Target Datatype

approval

RECORD

Owner

RECORD

Modified_Time

STRING

Pricing_Details

STRING

Description

STRING

currency_symbol

STRING

Created_Time

STRING

editable

BOOLEAN

Active

BOOLEAN

Modified_By

RECORD

Pricing_Model

STRING

process_flow

BOOLEAN

Price_Book_Name

STRING

id

STRING

Created_By

RECORD

Tag

STRING

approved

BOOLEAN

Purchase_Orders

Purpose: A Purchase Order is an order placed for procuring products or services from your vendors.

Replication: Key-Based Replication

Replication Key: Modified_Time

Fields

Name

Target Datatype

Owner

RECORD

Discount

NUMERIC

Description

STRING

currency_symbol

STRING

Vendor_Name

RECORD

Shipping_State

STRING

Tax

NUMERIC

PO_Date

STRING

Modified_By

RECORD

process_flow

BOOLEAN

Billing_Country

STRING

id

STRING

Carrier

STRING

approved

BOOLEAN

Status

STRING

Sales_Commission

NUMERIC

Grand_Total

NUMERIC

approval

RECORD

Modified_Time

STRING

PO_Number

STRING

Due_Date

STRING

Billing_Street

STRING

Adjustment

NUMERIC

Created_Time

STRING

Terms_and_Conditions

STRING

Sub_Total

NUMERIC

editable

BOOLEAN

Billing_Code

STRING

Product_Details

RECORD

Subject

STRING

Tracking_Number

STRING

Contact_Name

RECORD

Excise_Duty

NUMERIC

Shipping_City

STRING

Shipping_Country

STRING

Shipping_Code

STRING

Billing_City

STRING

Requisition_No

STRING

Billing_State

STRING

line_tax

RECORD

Created_By

RECORD

Tag

STRING

Shipping_Street

STRING

Notes

Purpose: In Zoho CRM, you can associate notes to the records by specifying the required detail

Replication: Key-Based Replication

Replication Key: Modified_Time

Fields

Name

Target Datatype

Owner

RECORD

Owner

RECORD

Modified_Time

STRING

attachments

STRING

Created_Time

STRING

Parent_Id

RECORD

editable

BOOLEAN

se_module

STRING

Modified_By

RECORD

size

STRING

voice_note

BOOLEAN

id

STRING

Created_By

RECORD

Note_Title

STRING

Note_Content

STRING

Activities

Purpose: An important aspect in CRM is to keep track of all the tasks, meetings, calls, events, or activity records.

Replication: Key-Based Replication

Replication Key: Modified_Time

Fields

Name

Target Datatype

All_day

STRING

Check_In_State

STRING

Owner

RECORD

currency_symbol

STRING

Latitude

STRING

Participants

STRING

process_flow

BOOLEAN

Check_In_City

STRING

Call_Purpose

STRING

id

STRING

Check_In_Comment

STRING

approved

BOOLEAN

Check_In_Status

STRING

Who_Id

STRING

Status

STRING

approval

RECORD

Venue

STRING

ZIP_Code

STRING

Activity_Type

STRING

Priority

STRING

Created_Time

STRING

Call_Start_Time

STRING

editable

BOOLEAN

Longitude

STRING

Check_In_Time

STRING

Call_Result

STRING

Recurring_Activity

STRING

What_Id

RECORD

Created_By

RECORD

Call_Duration

STRING

Check_In_Address

STRING

Description

STRING

Closed_Time

STRING

Start_DateTime

STRING

End_DateTime

STRING

Check_In_By

STRING

Modified_By

RECORD

Call_Status

STRING

Check_In_Country

STRING

Modified_Time

STRING

Reminder

STRING

Due_Date

STRING

Billable

BOOLEAN

Subject

STRING

se_module

STRING

Call_Type

STRING

Check_In_Sub_Locality

STRING

Call_Duration_in_seconds

STRING

Tag

STRING

PreviousRelease NotesNextRelease Notes

Last updated 5 years ago

Was this helpful?

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

https://www.zoho.com/crm/help/developer/api/quotes-response.html
https://www.zoho.com/crm/help/developer/api/solutions-response.html
https://www.zoho.com/crm/help/developer/api/vendors-response.html
https://www.zoho.com/crm/help/developer/api/cases-respones.html
https://www.zoho.com/crm/help/developer/api/campaigns-respones.html
https://www.zoho.com/crm/help/developer/api/products-respones.html
https://www.zoho.com/crm/help/developer/api/leads-respones.html
https://www.zoho.com/crm/help/developer/api/accounts-respones.html
https://www.zoho.com/crm/help/developer/api/contacts-respones.html
https://www.zoho.com/crm/help/developer/api/tasks-respones.html
https://www.zoho.com/crm/help/developer/api/events-respones.html
https://www.zoho.com/crm/help/developer/api/calls-respones.html
https://www.zoho.com/crm/help/developer/api/price-books-respones.html
https://www.zoho.com/crm/help/developer/api/purchase-orders-response.html
https://www.zoho.com/crm/help/developer/api/notes-response.html
https://www.zoho.com/crm/help/developer/api/activities-response.html