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

      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