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

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

Signin to Daton
Select Impact from Integrations page
Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
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
After providing the details to authorize Daton to periodically extract data from Inventory Planner.
Post successful authentication you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration.

Workflow

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

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

STRING

ActivityEventName

STRING

DisplayName

STRING

ActivityEvent

NUMERIC

Score

NUMERIC

EventType

NUMERIC