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 |
- 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.
- 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
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 |