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. 1.
    Signin to Daton
  2. 2.
    Select Impact from Integrations page
  3. 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. 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. 5.
    After providing the details to authorize Daton to periodically extract data from Inventory Planner.
  6. 6.
    Post successful authentication you will be prompted to choose from the list of available tables
  7. 7.
    Then select all required fields for each table
  8. 8.
    Submit the integration.

Workflow

  1. 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. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 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