API Data Provider - Online Help
Insightly Profile
Connecting to Insightly
Using the Profile
ADO.NET
JDBC
ODBC
PowerBI
SSIS
Excel
SQL Compliance
SELECT Statements
SQL Functions
String Functions
Date Functions
Math Functions
EXECUTE Statements
Schema Discovery
ADO.NET
JDBC
System Tables
sys_tables
sys_tablecolumns
sys_procedures
Tables
ActivitySets
CommentFileAttachments
Contacts
ContactsEmails
ContactsEvents
ContactsFileAttachments
ContactsFollow
ContactsLinks
ContactsNotes
ContactsTasks
Countries
Currencies
CustomFields
CustomFieldsSearch
CustomObjects
CustomObjectsRecords
EmailComments
EmailFileAttachments
EmailFollow
EmailLinks
Emails
Events
EventsLinks
FileCategories
Follows
Instance
Leads
LeadsEmails
LeadsEvents
LeadsFileAttachments
LeadsFollow
LeadsLinkEmailAddress
LeadsLinks
LeadsNotes
LeadSources
LeadsTasks
LeadStatuses
Me
Milestones
NoteLinks
Notes
NotesComments
NotesFileAttachments
NotesFollow
Opportunities
OpportunitiesEmails
OpportunitiesEvents
OpportunitiesFileAttachments
OpportunitiesFollow
OpportunitiesLinkEmailAddress
OpportunitiesLinks
OpportunitiesNotes
OpportunitiesStateHistory
OpportunitiesTasks
OpportunityCategories
OpportunityStateReasons
Organisations
OrganisationsEmails
OrganisationsEvents
OrganisationsFileAttachments
OrganisationsFollow
OrganisationsLinks
OrganisationsNotes
OrganisationsTasks
Permissions
Pipelines
PipelineStages
ProjectCategories
ProjectFileAttachments
Projects
ProjectsEmails
ProjectsEvents
ProjectsFollow
ProjectsLinkEmailAddress
ProjectsLinks
ProjectsMilestones
ProjectsNotes
ProjectsTasks
Relationships
Tags
TaskCategories
Tasks
TasksComments
TasksFollow
TasksLinks
TeamMembers
Teams
Users
TeamMembers
Gets a list of Team Members
Columns
Name
Type
References
MemberUserId [KEY]
Int
PermissionId
Long
TeamId
Long