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

Was this helpful?

  1. Connectors
  2. Data Sources
  3. SaaS Integrations

LeadSquared V2

LeadSquared ETL connector for data replication

Snapshot

Features

Details

Release Status

Released

Source API Version

Table Selection

Yes

Column Selection

Yes

Edit Integration

Yes

Replication Type Selection

No

Authentication Parameters

LeadSquared Access Key LeadSquared Secret Key LeadSquared API Host

Replication Type

Key based Replication

Replication Key

NA LastRun

Suggested Replication Frequency

24 hrs

Tables/APIs Supported

Users

Lead

Lists

ActivityTypes

UserAttributes

Metdata

LeadFieldProperties

Products

All_Lead

Opportunity_Types

Opportunities

Teams

Campaign_Statistics

Task_Types

Reminders

Tasks

Integrate LeadSquared with Daton

  1. Signin to Daton

  2. Select Impact 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. After providing the details to authorize Daton to periodically extract data from Inventory Planner.

  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

LeadSquared Data

Users

Purpose: Retrieve a list of all Users

Replication: Key-Based Replication

Replication Key: NA

Fields

FullName
DATATYPE

ID

STRING

FirstName

STRING

LastName

STRING

EmailAddress

STRING

Role

STRING

StatusCode

NUMERIC

IsPhoneCallAgent

BOOLEAN

MemberOfGroups

STRING

Lead

Purpose: Returns lead's details

Replication: Key-Based Replication

Replication Key: NA

Fields

FullName
DataType

ProspectID

STRING

ProspectAutoId

STRING

ProspectActivityId_Max

STRING

ProspectActivityId_Min

STRING

StatusCode

STRING

StatusReason

STRING

DeletionStatusCode

STRING

IsLead

STRING

NotableEvent

STRING

NotableEventdate

STRING

LastVisitDate

STRING

ProspectActivityName_Max

STRING

ProspectActivityDate_Max

STRING

ProspectActivityDate_Min

STRING

LeadLastModifiedOn

STRING

FirstName

STRING

EmailAddress

STRING

Phone

STRING

DoNotEmail

STRING

DoNotCall

STRING

Score

STRING

EngagementScore

STRING

ProspectStage

STRING

OwnerId

STRING

CreatedBy

STRING

CreatedByName

STRING

CreatedOn

STRING

LeadConversionDate

STRING

ModifiedBy

STRING

ModifiedByName

STRING

ModifiedOn

STRING

OwnerIdName

STRING

OwnerIdEmailAddress

STRING

Origin

STRING

LeadAge

STRING

mx_Coding_Test_Attempt_Count

STRING

mx_Call_Status_Outcome

STRING

mx_Reason_for_Junk

STRING

mx_Callback_requested_time

STRING

mx_Outbound_call_completed

STRING

mx_Call_Back_Request_Push_Button

STRING

IsStarredLead

STRING

IsTaggedLead

STRING

CanUpdate

STRING

SourceCampaign

STRING

SourceMedium

STRING

mx_Registration_Date

STRING

mx_Graduation_Year

STRING

mx_Lead_Status

STRING

mx_Total_classes_attended

STRING

mx_Current_month_classes_attended

STRING

mx_Attended_this_month_Pre_course

STRING

mx_Assignment_Question_Solved

STRING

mx_ISA_signed

STRING

mx_Coding_Test_Result

STRING

mx_Interview_Status

STRING

mx_Prior_coding_test_count

STRING

mx_Prior_interview_count

STRING

mx_Total_Precourse_attended

STRING

mx_Graduation_Percentage

STRING

mx_College_Name

STRING

mx_Degree

STRING

mx_Department

STRING

mx_12th_Marks

STRING

mx_10th_Marks

STRING

mx_Lead_Type

STRING

mx_Lead_Sources

STRING

mx_First_Precourse_Selection

STRING

mx_Current_Precourse_Selection

STRING

mx_Lead_Content

STRING

mx_States

STRING

mx_Home_State

STRING

mx_Last_class_attended_date

STRING

mx_Data_Contest_Attempted

STRING

mx_Data_Contest_Score

STRING

mx_Data_Contest_Attempt_Date

STRING

mx_Sapling_Assignments_Solved

STRING

mx_Reason_for_Not_Interested

STRING

Source

STRING

mx_Country

STRING

mx_Reason_for_Not_Connected

STRING

mx_Follow_Up

STRING

mx_AccioSAT_Date

STRING

mx_AccioSAT_Rank

STRING

mx_AccioSAT_Aptitude_Percent

STRING

mx_AccioSAT_Coding_Score

STRING

mx_AccioSAT_Scholarship_Percent

STRING

mx_Alumni_Request

STRING

mx_accessed_data_precourse

STRING

mx_Last_Discoung

STRING

LastName

STRING

mx_Early_Bird_Discount_Month

STRING

Lists

Purpose: Returns all lists

Replication: Key-Based Replication

Replication Key: NA

Fields

FullName
DataType

ListId

STRING

ListName

STRING

ListDescription

STRING

ListType

STRING

MemberCount

NUMERIC

ActivityTypes

Purpose: Retrieves all activity types

Replication: Key-Based Replication

Replication Key: NA

Fields

FullName
DataType

ID

STRING

ActivityEventName

STRING

DisplayName

STRING

ActivityEvent

NUMERIC

Score

NUMERIC

EventType

NUMERIC

Tags

STRING

Description

STRING

EventDirection

NUMERIC

Order

NUMERIC

ActivityProperties

STRING

CanRename

BOOLEAN

CanDeleteActivity

BOOLEAN

Total

NUMERIC

TrackLocation

BOOLEAN

IsEditable

NUMERIC

Fields

RECORD

Direction

NUMERIC

RestrictCustomFields

BOOLEAN

ShowInActivityGrid

BOOLEAN

FormLayout

STRING

AllowAttachments

BOOLEAN

StatusReason

NUMERIC

AuditActivity

BOOLEAN

AllowPreDatedActivity

BOOLEAN

QuickAdd

BOOLEAN

EnableActivityDetails

BOOLEAN

VCardFormLayout

STRING

LockActivity

RECORD

EntityType

NUMERIC

ActivityEventPluralName

STRING

ModifiedBy

STRING

ModifiedOn

STRING

Fields.SchemaName

STRING

Fields.InternalName

STRING

Fields.DisplayName

STRING

Fields.DataType

STRING

Fields.IsMandatory

BOOLEAN

Fields.ShowInForm

BOOLEAN

Fields.Sequence

NUMERIC

Fields.ParentField

STRING

Fields.OptionSet

STRING

Fields.DependentOptionSet

STRING

Fields.IsDefault

BOOLEAN

Fields.IsReadOnly

BOOLEAN

Fields.RenderType

STRING

Fields.ExportAsPlainText

BOOLEAN

Fields.IsMultiSelectDropdown

BOOLEAN

Fields.IncludeOthersOption

BOOLEAN

Fields.BehaviorOnMissingDropdownOption

NUMERIC

Fields.IsOthersValue

BOOLEAN

Fields.InternalSchemaName

STRING

Fields.CustomObjectType

NUMERIC

Fields.MaxFieldLength

NUMERIC

LockActivity.CanLock

BOOLEAN

LockActivity.Roles

STRING

UserAttributes

Purpose: Returns the attributes of a user

Replication: Key-Based Replication

Replication Key: NA

Fields

FullName
type

BaseTable

STRING

CanUserEdit

BOOLEAN

CreatedBy

STRING

CreatedByName

STRING

CreatedOn

DATETIME

DataType

NUMERIC

DisplayName

STRING

Id

STRING

InternalSchemaName

STRING

IsHidden

BOOLEAN

IsMandatory

BOOLEAN

ModifiedBy

STRING

ModifiedByName

STRING

ModifiedOn

DATETIME

Options

STRING

RangeMax

NUMERIC

RenderType

NUMERIC

SchemaName

STRING

Sequence

NUMERIC

SortOrder

NUMERIC

StatusCode

NUMERIC

StatusReason

NUMERIC

Type

NUMERIC

Category

STRING

MaxLength

NUMERIC

Metadata

Purpose: Returns the properties of all lead fields

Replication: Key-Based Replication

Replication Key: NA

Fields

FullName
DataType

Entity

STRING

SchemaName

STRING

DisplayName

STRING

DataType

STRING

IsMandatory

BOOLEAN

Options

RECORD

MaxLength

STRING

EntityAttributeId

STRING

Name

STRING

Description

STRING

EntityAttributeType

NUMERIC

RenderType

NUMERIC

RenderTypeTextValue

STRING

IsVisible

BOOLEAN

IsSearchable

BOOLEAN

DefaultValue

STRING

ShowInImport

BOOLEAN

ValidationMessage

STRING

Txt_Row

NUMERIC

Txt_Col

NUMERIC

OwnerID

STRING

CreatedBy

STRING

CreatedOn

STRING

ModifiedBy

STRING

ModifiedOn

STRING

OwnerIdName

STRING

CreatedByName

STRING

ModifiedByName

STRING

IsLeadIdentifier

BOOLEAN

LockAfterCreate

NUMERIC

UseInLeadClone

BOOLEAN

ParentField

STRING

IsSortable

BOOLEAN

RangeMin

STRING

DefaultMailMergeValue

STRING

ShowInMailMerge

BOOLEAN

AllowAutoUpdateToOptions

BOOLEAN

IsReadOnly

BOOLEAN

AllowMultiple

BOOLEAN

IsDerived

BOOLEAN

ShowInQuickAdd

BOOLEAN

ShowInQuickSearch

BOOLEAN

IsUnique

BOOLEAN

Options.Value

STRING

LeadFieldProperties

Purpose: Returns the properties of a specific lead field

Replication: Key-Based Replication

Replication Key: NA

Fields

FullName
DataType

Entity

STRING

SchemaName

STRING

DisplayName

STRING

DataType

STRING

IsMandatory

BOOLEAN

Options

RECORD

MaxLength

STRING

EntityAttributeId

STRING

Name

STRING

Description

STRING

EntityAttributeType

NUMERIC

RenderType

NUMERIC

RenderTypeTextValue

STRING

IsVisible

BOOLEAN

IsSearchable

BOOLEAN

DefaultValue

STRING

ShowInImport

BOOLEAN

ValidationMessage

STRING

Txt_Row

NUMERIC

Txt_Col

NUMERIC

OwnerID

STRING

CreatedBy

STRING

CreatedOn

STRING

ModifiedBy

STRING

ModifiedOn

STRING

OwnerIdName

STRING

CreatedByName

STRING

ModifiedByName

STRING

IsLeadIdentifier

BOOLEAN

LockAfterCreate

NUMERIC

UseInLeadClone

BOOLEAN

ParentField

STRING

IsSortable

BOOLEAN

RangeMin

STRING

DefaultMailMergeValue

STRING

ShowInMailMerge

BOOLEAN

AllowAutoUpdateToOptions

BOOLEAN

IsReadOnly

BOOLEAN

AllowMultiple

BOOLEAN

IsDerived

BOOLEAN

ShowInQuickAdd

BOOLEAN

ShowInQuickSearch

BOOLEAN

IsUnique

BOOLEAN

Options.Value

STRING

Products

Purpose: Returns products and their details

Replication: Key-Based Replication

Replication Key: NA

Fields

FullName
type

ProductId

STRING

ProductAutoId

NUMERIC

ProductSku

STRING

Name

STRING

Description

STRING

CreatedBy

STRING

StatusCode

NUMERIC

CreatedByName

STRING

CreatedOn

DATETIME

ModifiedBy

STRING

ModifiedByName

STRING

ModifiedOn

DATETIME

Price

NUMERIC

ModifiedByEmail

STRING

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

ImageUrl

STRING

CategoryId

STRING

Category

STRING

All_Lead

Purpose: Returns the list of leads in a specific date range

Replication: Key-Based Replication

Replication Key: LastRun

Fields

FullName
DataType

ProspectID

STRING

ProspectAutoId

STRING

ProspectActivityId_Max

STRING

ProspectActivityId_Min

STRING

StatusCode

STRING

StatusReason

STRING

DeletionStatusCode

STRING

IsLead

STRING

NotableEvent

STRING

NotableEventdate

STRING

LastVisitDate

STRING

ProspectActivityName_Max

STRING

ProspectActivityDate_Max

STRING

ProspectActivityDate_Min

STRING

LeadLastModifiedOn

STRING

FirstName

STRING

Phone

STRING

DoNotEmail

STRING

DoNotCall

STRING

Source

STRING

Score

STRING

EngagementScore

STRING

ProspectStage

STRING

OwnerId

STRING

CreatedBy

STRING

CreatedByName

STRING

CreatedOn

STRING

LeadConversionDate

STRING

ModifiedBy

STRING

ModifiedByName

STRING

ModifiedOn

STRING

OwnerIdName

STRING

OwnerIdEmailAddress

STRING

Origin

STRING

mx_Outbound_call_completed

STRING

IsStarredLead

STRING

IsTaggedLead

STRING

CanUpdate

STRING

Total

STRING

LeadAge

STRING

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

EmailAddress

STRING

SourceCampaign

STRING

SourceMedium

STRING

mx_Registration_Date

STRING

mx_Home_State

STRING

mx_Graduation_Year

STRING

mx_Lead_Status

STRING

mx_Total_classes_attended

STRING

mx_Current_month_classes_attended

STRING

mx_Attended_this_month_Pre_course

STRING

mx_Assignment_Question_Solved

STRING

mx_ISA_signed

STRING

mx_Coding_Test_Attempt_Count

STRING

mx_Coding_Test_Result

STRING

mx_Interview_Status

STRING

mx_Prior_coding_test_count

STRING

mx_Prior_interview_count

STRING

mx_Total_Precourse_attended

STRING

mx_Graduation_Percentage

STRING

mx_12th_Marks

STRING

mx_10th_Marks

STRING

mx_Lead_Sources

STRING

mx_Sapling_Assignments_Solved

STRING

mx_First_Precourse_Selection

STRING

mx_Current_Precourse_Selection

STRING

mx_Lead_Content

STRING

mx_States

STRING

mx_Last_class_attended_date

STRING

mx_Call_Status_Outcome

STRING

mx_Reason_for_Not_Interested

STRING

LastName

STRING

JobTitle

STRING

Notes

STRING

CurrentOptInStatus

STRING

mx_Zoom_Demo_Conduction

STRING

mx_Call_Back_Request_Push_Button

STRING

mx_Interested_for_Counselling

STRING

Revenue

STRING

mx_AccioSAT_Date

STRING

mx_AccioSAT_Rank

STRING

mx_Follow_Up

STRING

mx_Course_Interested_In

STRING

mx_Interested_for

STRING

mx_Follow_up_type

STRING

mx_Ready_to_Pay

STRING

mx_Estimated_Payment_Date

STRING

mx_Booking_Amount

STRING

mx_Lead_Type

STRING

mx_AccioSAT_Aptitude_Percent

STRING

mx_AccioSAT_Coding_Score

STRING

mx_AccioSAT_Scholarship_Percent

STRING

mx_AccioSAT_Extra_Scholarship_Percent

STRING

TotalVisits

STRING

PageViewsPerVisit

STRING

AvgTimePerVisit

STRING

mx_Reason_for_Junk

STRING

mx_Callback_requested_time

STRING

mx_Referred_by_email

STRING

mx_Referred_by_name

STRING

mx_Alumni_Request

STRING

Mobile

STRING

mx_Prior_coding_test_date

STRING

mx_Prior_interview_date

STRING

mx_College_Name

STRING

mx_Degree

STRING

mx_Department

STRING

mx_Eligible_for_Money_back_Guarantee

STRING

mx_Workshop_Name

STRING

mx_Workshop_Date

STRING

mx_Reason_for_Not_Connected

STRING

mx_Demo_session_attended_date

STRING

mx_Mode_of_Payment

STRING

mx_Loan_Amount

STRING

mx_Early_Bird_Discount_Month

STRING

mx_Zoom_Demo_Booking_Date

STRING

mx_Code_of_the_day_cleared

STRING

mx_Early_Bird_Discount

STRING

mx_Loan_Partner

STRING

mx_MBG_Signed

STRING

mx_Interested_for_1_ON_1

STRING

mx_APL_attempts

STRING

mx_Country

STRING

mx_Interview_Tag

STRING

mx_State

STRING

mx_Interested_in_demo_session

STRING

mx_accessed_data_precourse

STRING

mx_Data_Contest_Attempted

STRING

mx_Customer_Support_Date

STRING

mx_Data_Contest_Score

STRING

mx_Last_Discoung

STRING

mx_Coding_Test_Date_1

STRING

mx_Coding_Test_Date_2

STRING

mx_CBR_Push_Button

STRING

mx_Interview_Date

STRING

mx_AccioSAT_Scholarship

STRING

mx_Signup_Page_Type

STRING

mx_APL_this_month

STRING

mx_Connect_with_alumni_LP

STRING

mx_City

STRING

mx_Data_Contest_Attempt_Date

STRING

mx_All_Time_Classes_Attended_new

STRING

mx_Current_Month_Classes_Attended_new

STRING

mx_Current_Month_Beginner_Classes_Attended_new

STRING

mx_Current_Month_Intermediate_Classes_Attended_new

STRING

mx_All_Time_Beginner_Classes_Attended_new

STRING

mx_All_Time_Intermediate_Classes_Attended_new

STRING

mx_Current_Month_Intermediate_Recordings_Duration

STRING

mx_Current_Month_Beginner_Recordings_Duration

STRING

mx_All_Time_Recordings_Duration

STRING

mx_Current_Month_Live_Class_Attended_Duration

STRING

mx_All_Time_Live_Class_Attended_Duration

STRING

mx_Time_for_1_on_1

TIME

mx_Last_Class_Attended_Date_new

STRING

mx_Bootcamp_Assignments

STRING

mx_Bootcamp_Scholarship

STRING

mx_Tally_Form

STRING

Opportunity_Types

Purpose: Returns the details of all the Opportunity Types

Replication: Key-Based Replication

Replication Key: NA

Fields

FullName
DataType

AllowAttachments

BOOLEAN

CanDelete

BOOLEAN

Description

STRING

DisplayName

STRING

EventCode

NUMERIC

ID

STRING

IsAuditEnable

BOOLEAN

ModifiedBy

STRING

ModifiedOn

STRING

Name

STRING

PluralName

STRING

Score

NUMERIC

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

Opportunities

Purpose: Returns list of opportunity fields

Replication: Key-Based Replication

Replication Key: LastRun

Fields

FullName
DataType

ProspectId

STRING

FirstName

STRING

LastName

STRING

EmailAddress

STRING

Phone

STRING

DoNotCall

STRING

DoNotEmail

STRING

LeadName

STRING

LeadOwner

STRING

OpportunityEventType

STRING

OpportunityEvent

STRING

OpportunityNote

STRING

Score

STRING

PACreatedOn

DATETIME

PAModifiedOn

DATETIME

PACreatedByName

STRING

mx_Custom_1

STRING

Status

STRING

mx_Custom_2

STRING

mx_Custom_6

STRING

mx_Custom_8

DATETIME

Owner

STRING

OwnerName

STRING

OpportunityId

STRING

Total

STRING

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

Teams

Purpose: Retrieve the teams in your LeadSquared account

Replication: Key-Based Replication

Replication Key: NA

Fields

FullName
DataType

TeamId

STRING

Code

NUMERIC

Name

STRING

Description

STRING

Sequence

NUMERIC

ParentCode

NUMERIC

ModifiedBy

STRING

ModifiedByName

STRING

ModifiedOn

DATETIME

WorkdayTemplateCode

NUMERIC

WorkDayTemplateName

STRING

IsWorkDayTemplateOverridden

BOOLEAN

HolidayCalendarCode

NUMERIC

HolidayCalendarName

STRING

IsHolidayCalendarOverridden

BOOLEAN

UserCount

NUMERIC

Depth

NUMERIC

SmartViewId

STRING

SmartViewCode

NUMERIC

SmartViewName

STRING

IsSmartViewOverridden

BOOLEAN

ReplaceUserSmartView

STRING

IsReplaceUserSmartViewOverridden

BOOLEAN

IsDashboardListOverridden

BOOLEAN

RelatedHomePageConfiguration

STRING

IsHomePageConfigurationOverridden

BOOLEAN

LeadDetailsViewName

STRING

IsLeadDetailsViewOverridden

BOOLEAN

IsReplaceUserLeadDetailsViewOverridden

BOOLEAN

LeadDetailsViewCode

NUMERIC

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

ParentId

STRING

ParentName

STRING

Campaign_Statistics

Purpose: Returns the statistics of email campaigns

Replication: Key-Based Replication

Replication Key: LastRun

Fields

FullName
DataType

Id

STRING

CampaignName

STRING

Subject

STRING

TotalRecipients

NUMERIC

ScheduledOn

DATETIME

NoAction

NUMERIC

Delivered

NUMERIC

Open

NUMERIC

Click

NUMERIC

Bounce

NUMERIC

Unsubscribed

NUMERIC

Spam

NUMERIC

FromUser

STRING

FromUserName

STRING

CreatedBy

STRING

CreatedByName

STRING

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

Task_Types

Purpose: Returns the list of Task Types

Replication: Key-Based Replication

Replication Key: NA

Fields

FullName
DataType

Category

NUMERIC

Color

STRING

ColumnConfiguration

RECORD

CreatedBy

STRING

CreatedOn

STRING

FormLayout

STRING

Id

STRING

IsDefault

BOOLEAN

IsDeleteable

BOOLEAN

IsEditable

BOOLEAN

ModifiedBy

STRING

ModifiedByEmail

STRING

ModifiedOn

STRING

Name

STRING

OpenCompletedTasks

BOOLEAN

PreventConflict

BOOLEAN

ReminderConfiguration

RECORD

Sequence

NUMERIC

Status

NUMERIC

TaskTypeConfiguration

RECORD

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

ColumnConfiguration.DataType

NUMERIC

ColumnConfiguration.DisplayName

STRING

ColumnConfiguration.InternalSchemaName

STRING

ColumnConfiguration.IsDefault

BOOLEAN

ColumnConfiguration.IsMandatoryConfigurable

BOOLEAN

ColumnConfiguration.Mandatory

BOOLEAN

ColumnConfiguration.RenderType

NUMERIC

ColumnConfiguration.SchemaName

STRING

ColumnConfiguration.Options

RECORD

ColumnConfiguration.Options.IsDefault

BOOLEAN

ColumnConfiguration.Options.Text

STRING

ColumnConfiguration.Options.Value

STRING

ReminderConfiguration.IsEnable

BOOLEAN

TaskTypeConfiguration.BusinessWorkFlow

RECORD

TaskTypeConfiguration.BusinessWorkFlow.IsEnabled

BOOLEAN

TaskTypeConfiguration.CalenderInvite

RECORD

TaskTypeConfiguration.CalenderInvite.Lead

RECORD

TaskTypeConfiguration.CalenderInvite.Lead.IsEnabled

BOOLEAN

TaskTypeConfiguration.CalenderInvite.Lead.Subject

STRING

TaskTypeConfiguration.CalenderInvite.Lead.TemplateContent

STRING

TaskTypeConfiguration.CalenderInvite.Organiser

RECORD

TaskTypeConfiguration.CalenderInvite.Organiser.IsEnabled

BOOLEAN

TaskTypeConfiguration.CalenderInvite.Organiser.Subject

STRING

TaskTypeConfiguration.CalenderInvite.Organiser.TemplateContent

STRING

TaskTypeConfiguration.CalenderInvite.Owner

RECORD

TaskTypeConfiguration.CalenderInvite.Owner.IsEnabled

BOOLEAN

TaskTypeConfiguration.CalenderInvite.Owner.Subject

STRING

TaskTypeConfiguration.CalenderInvite.Owner.TemplateContent

STRING

TaskTypeConfiguration.CalenderInvite.ParticipantUsers

RECORD

TaskTypeConfiguration.CalenderInvite.ParticipantUsers.IsEnabled

BOOLEAN

TaskTypeConfiguration.Duration

RECORD

TaskTypeConfiguration.Duration.IsEnabled

BOOLEAN

TaskTypeConfiguration.Duration.Value

STRING

TaskTypeConfiguration.EffortEstimate

RECORD

TaskTypeConfiguration.EffortEstimate.IsEnabled

BOOLEAN

TaskTypeConfiguration.EffortEstimate.Value

STRING

TaskTypeConfiguration.EffortEstimate.ValueUnit

STRING

TaskTypeConfiguration.Location

RECORD

TaskTypeConfiguration.Location.GeofenceLocation

BOOLEAN

TaskTypeConfiguration.Location.GeofenceRange

NUMERIC

TaskTypeConfiguration.Location.IsEnabled

BOOLEAN

TaskTypeConfiguration.Location.IsMandatory

BOOLEAN

TaskTypeConfiguration.Priority

RECORD

TaskTypeConfiguration.Priority.IsEnabled

BOOLEAN

TaskTypeConfiguration.TaskCompleted

RECORD

TaskTypeConfiguration.TaskCompleted.IsEnabled

BOOLEAN

Reminders

Purpose: Returns the number of tasks due in the next 15 minutes.

Replication: Key-Based Replication

Replication Key: NA

Fields

FullName
DataType

TaskFilter

STRING

Count

STRING

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

Tasks

Purpose: Returns tasks assigned to a particular owner/user

Replication: Key-Based Replication

Replication Key: LastRun

Fields

FullName
type

TaskID

STRING

Name

STRING

Description

STRING

DueDate

DATETIME

CreatedOn

DATETIME

OwnerID

STRING

OwnerName

STRING

CreatedBy

STRING

CreatedByName

STRING

Status

STRING

Reminder

STRING

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

CompletedBy

STRING

CompletedByName

STRING

CompletedOn

DATETIME

PreviousLeadSquared CRMNextLinkedIn Ads

Last updated 1 year ago

Was this helpful?

Provide your LeadSquared access key, LeadSquared secret key, LeadSquared api host. to learn more about access key and secret key to learn more about API host

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:

Click here
Click here
https://apidocs.leadsquared.com/get-users/#api
https://apidocs.leadsquared.com/get-a-lead-by-email-id/#api
https://apidocs.leadsquared.com/retrieve-all-lists/#api
https://apidocs.leadsquared.com/get-list-of-activity-types/#api
https://apidocs.leadsquared.com/retrieve-user-attributes/#api
https://apidocs.leadsquared.com/meta-data/#api
https://apidocs.leadsquared.com/meta-data/#api
https://apidocs.leadsquared.com/retrieve-list-of-products/#api
https://apidocs.leadsquared.com/get-leads-by-date-range/#api
https://apidocs.leadsquared.com/get-opportunity-types/#api
https://apidocs.leadsquared.com/get-opportunities-by-lead-id/#api
https://apidocs.leadsquared.com/get-teams/#api
https://apidocs.leadsquared.com/retrieve-campaign-statistics/#api
https://apidocs.leadsquared.com/get-list-of-task-types-2/#api
https://apidocs.leadsquared.com/get-reminders/#api
https://apidocs.leadsquared.com/retrieve-tasks/#api