Documentation

Contact Us

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

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

  • Talk To sales
  • Start Trial

LeadSquared V2

LeadSquared ETL connector for data replication

Contact Us

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

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

  • Saras Pulse

    • Saras Daton

      • Saras IQ

        Need help with something?

        Talk to data expert

        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. Provide your LeadSquared access key, LeadSquared secret key, LeadSquared api host. 
          Click here to learn more about access key and secret key
          Click here to learn more about API host
        5. After providing the details to authorize Daton to periodically extract data from Inventory Planner.
        6. Post successful authentication you will be prompted to choose from the list of available tables
        7. Then select all required fields for each table
        8. 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           
        Source API Documentation: https://apidocs.leadsquared.com/get-users/#api

        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          
        Source API Documentation: https://apidocs.leadsquared.com/get-a-lead-by-email-id/#api          
        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         
        Source API Documentation: https://apidocs.leadsquared.com/retrieve-all-lists/#api

        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        
        Source API Documentation: https://apidocs.leadsquared.com/get-list-of-activity-types/#api

        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      
        Source API Documentation: https://apidocs.leadsquared.com/retrieve-user-attributes/#api

        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     
        Source API Documentation: https://apidocs.leadsquared.com/meta-data/#api

        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    
        Source API Documentation: https://apidocs.leadsquared.com/meta-data/#api

        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   
        Source API Documentation: https://apidocs.leadsquared.com/retrieve-list-of-products/#api

        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     
        Source API Documentation: https://apidocs.leadsquared.com/get-leads-by-date-range/#api

        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    
        Source API Documentation: https://apidocs.leadsquared.com/get-opportunity-types/#api

        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   
        Source API Documentation: https://apidocs.leadsquared.com/get-opportunities-by-lead-id/#api

        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       
        Source API Documentation: https://apidocs.leadsquared.com/get-teams/#api

        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      
        Source API Documentation: https://apidocs.leadsquared.com/retrieve-campaign-statistics/#api

        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     
        Source API Documentation: https://apidocs.leadsquared.com/get-list-of-task-types-2/#api

        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.    
        Source API Documentation: https://apidocs.leadsquared.com/get-reminders/#api

        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   
        Source API Documentation: https://apidocs.leadsquared.com/retrieve-tasks/#api

        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
        crm lead generation

        Was this article helpful?

        Yes
        No
        Give feedback about this article

        Related Articles

        • Chargebee
        • Easyecom
        • Ascend
        • Calendly V2

        Table of Contents

        Snapshot Integrate LeadSquared with Daton Workflow LeadSquared Data

        Get Started on your Data Journey Today!

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

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

        Follow Us

        Linkedin Youtube

        Company

        • Customers
        • Partner With Us
        • Contact Us

        Culture

        • About
        • People
        • Careers

        Offerings

        • Daton
        • For Brands
        • For Agencies

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA

        Follow Us

        Linkedin Youtube

        DISCLAIMER: Various trademarks are held by their respective owners

        © 2023 sarasanalytics.com

        Sitemap

        Get Started on your Data Journey Today!

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

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

        Company

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

        Offerings

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

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA
        • Sitemap

        © 2023 sarasanalytics.com

        Linkedin Youtube

        Knowledge Base Software powered by Helpjuice

        Expand