---
description: LeadSquared ETL connector for data replication
---

# LeadSquared V2

Snapshot

| Features                        | Details                                                                         |
| ------------------------------- | ------------------------------------------------------------------------------- |
| Release Status                  | Released                                                                        |
| Source API Version              |                                                                                 |
| Table Selection                 | Yes                                                                             |
| Column Selection                | Yes                                                                             |
| Edit Integration                | Yes                                                                             |
| Replication Type Selection      | No                                                                              |
| Authentication Parameters       | <p>LeadSquared Access Key<br>LeadSquared Secret Key<br>LeadSquared API Host</p> |
| Replication Type                | Key based Replication                                                           |
| Replication Key                 | <p>NA<br>LastRun</p>                                                            |
| 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](https://apidocs.leadsquared.com/authentication/#api) to learn more about access key and secret key\
   [Click here](https://apidocs.leadsquared.com/api-host/#api) 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](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](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](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](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](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](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](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](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](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](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](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](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](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](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](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](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 |



