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