LeadSquared CRM
Leadsquared ETL for data replication
Features | Details |
---|---|
Release Status | Released |
Source API Version | |
Table Selection | Yes |
Column Selection | Yes |
Edit Integration | Yes |
Replication Type Selection | No |
Authentication Parameters | LeadSquared ClientKey
SecretKey |
Replication Type | Full Replication
Key Based Replication |
Replication Key | Date |
Suggested Replication Frequency | |
Products
ActivityTypes
Lists
Users
UserAtrributes
PermissionTemplate
- 1.Signin to Daton
- 2.Select LeadSquared 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 LeadSquared ClientKey and SecretKey to authorize Daton to periodically extract data from LeadSquared
- 5.Post successful authentication, you will be prompted to choose from the list of available tables
- 6.Then select all required fields for each table
- 7.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
Purpose: The Sales Activity resource represents product or service sales you’ve made.
Source API Documentation https://apidocs.leadsquared.com/retrieve-list-of-products/
Replication: Key-Based Replication
Replication Key: ModifiedOn
Fields
Name | Target Datatype |
---|---|
ProductId | STRING |
ProductAutoId | NUMERIC |
ProductSku | STRING |
Name | STRING |
Description | STRING |
CreatedBy | STRING |
StatusCode | NUMERIC |
CreatedByName | STRING |
CreatedOn | STRING |
ModifiedBy | STRING |
ModifiedByName | STRING |
ModifiedOn | STRING |
ImageUrl | STRING |
CategoryId | STRING |
Category | STRING |
Price | NUMERIC |
Purpose: Lists allow you to segment your leads so you can send the right message to a specific audience.
Source API Documentation https://apidocs.leadsquared.com/retrieve-all-lists/
Replication: Full Replication
Replication Key: NA
Name | Target Datatype |
---|---|
ListId | STRING |
ListName | STRING |
ListDescription | STRING |
ListType | STRING |
MemberCount | NUMERIC |
Purpose: The Activity resource represents all system and custom activities on posted on leads.
Source API Documentation https://apidocs.leadsquared.com/get-list-of-activity-types/
Replication: Full Replication
Replication Key: NA
Fields
Name | Target 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 | STRING |
Direction | NUMERIC |
RestrictCustomFields | BOOLEAN |
ShowInActivityGrid | BOOLEAN |
FormLayout | STRING |
AllowAttachments | BOOLEAN |
StatusReason | NUMERIC |
AuditActivity | BOOLEAN |
AllowPreDatedActivity | BOOLEAN |
ActionId | STRING |
QuickAdd | BOOLEAN |
Permissions | STRING |
EnableActivityDetails | BOOLEAN |
VCardFormLayout | STRING |
Purpose: The Users resource is the primary way of interacting with LeadSquared.
Source API Documentation https://apidocs.leadsquared.com/get-users/
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
---|---|
ID | STRING |
FirstName | STRING |
LastName | STRING |
EmailAddress | STRING |
Role | STRING |
StatusCode | NUMERIC |
Tag | STRING |
IsPhoneCallAgent | BOOLEAN |
Purpose: Deals with the attribute that associate with user.
Source API Documentation https://apidocs.leadsquared.com/retrieve-user-attributes/
Replication: Key-Based Replication
Replication Key: ModifiedOn
Fields
Name | Target Datatype |
---|---|
CanUserEdit | BOOLEAN |
Category | STRING |
CreatedBy | STRING |
CreatedByName | STRING |
CreatedOn | STRING |
DataType | NUMERIC |
DisplayName | STRING |
Id | STRING |
InternalSchemaName | STRING |
ModifiedBy | STRING |
ModifiedByName | STRING |
ModifiedOn | STRING |
Options | STRING |
RangeMax | NUMERIC |
RenderType | NUMERIC |
SchemaName | STRING |
Sequence | NUMERIC |
SortOrder | NUMERIC |
StatusCode | NUMERIC |
StatusReason | NUMERIC |
Type | NUMERIC |
Purpose: Permission Templates (a key user management tool) help you assign view and edit rights on leads and activities to your users.
Source API Documentation https://apidocs.leadsquared.com/retrieve-permission-template/
Replication: Key-Based Replication
Replication Key: ModifiedOn
Fields
Name | Target Datatype |
---|---|
Id | STRING |
Name | STRING |
Description | STRING |
EntityPermissions | RECORD |
CreatedBy | STRING |
CreatedOn | STRING |
ModifiedBy | STRING |
ModifiedOn | STRING |
CreatedByName | STRING |
ModifiedByName | STRING |
AssociatedUserIds | STRING |
AssociatedGroupIds | STRING |
AssociatedRoleIds | STRING |
Last modified 1yr ago