Insightly Tables
The provider models the data in API as a list of tables in a relational database that can be queried using standard SQL statements.
Insightly Tables
| Name | Description |
| ActivitySets | Gets a list of Activity Sets |
| CommentFileAttachments | Gets a Comment's File Attachments |
| Contacts | Gets a filtered list of Contacts |
| ContactsEmails | Gets a list of a Contact's Emails |
| ContactsEvents | Gets a Contact's Events |
| ContactsFileAttachments | Gets a Contact's File Attachments |
| ContactsFollow | Gets a Follow state for a Contact |
| ContactsLinks | Gets a Contact's Links |
| ContactsNotes | Gets a Contact's Notes |
| ContactsTasks | Gets a list of a Contact's Tasks |
| Countries | Gets a list of Countries used by Insightly |
| Currencies | Gets a list of Currencies used by Insightly |
| CustomFields | Gets a list of Custom Fields |
| CustomFieldsSearch | Gets a Custom Field by name |
| CustomObjects | Gets a list of custom objects |
| CustomObjectsRecords | Gets a filtered list of records |
| EmailComments | Gets an Email's Comments |
| EmailFileAttachments | Gets an Email's File Attachments |
| EmailFollow | Gets a Follow state for an Email |
| EmailLinks | Gets an Email's Links |
| Emails | Gets a filtered list of Emails |
| Events | Gets a filtered list of Events |
| EventsLinks | Gets an Event's Links |
| FileCategories | Gets a list of File Categories |
| Follows | Gets a list of followed records for the user |
| Instance | Gets the Instance |
| Leads | Gets a filtered list of Leads |
| LeadsEmails | Gets a list of a Lead's Emails |
| LeadsEvents | Gets a Lead's Events |
| LeadsFileAttachments | Gets a Lead's File Attachments |
| LeadsFollow | Gets a Follow state for a Lead |
| LeadsLinkEmailAddress | Gets the email address to use for linking with the Lead |
| LeadsLinks | Gets a Lead's Links |
| LeadsNotes | Gets a Lead's Notes |
| LeadSources | Gets a list of Lead Sources |
| LeadsTasks | Gets a list of a Lead's Tasks |
| LeadStatuses | Gets a list of Lead Statuses |
| Me | Gets the User object for the calling user. |
| Milestones | Gets a filtered list of Milestones |
| NoteLinks | Gets a Note's Links |
| Notes | Gets a filtered list of Notes |
| NotesComments | Gets a Note's Comments |
| NotesFileAttachments | Gets a Note's File Attachments |
| NotesFollow | Gets a Follow state for a Note |
| Opportunities | Gets a filtered list of Opportunities |
| OpportunitiesEmails | Gets a list of an Opportunity's Emails |
| OpportunitiesEvents | Gets an Opportunity's Events |
| OpportunitiesFileAttachments | Gets an Opportunity's File Attachments |
| OpportunitiesFollow | Gets a Follow state for an Opportunity |
| OpportunitiesLinkEmailAddress | Gets the email address to use for linking with the Opportunity |
| OpportunitiesLinks | Gets an Opportunity's Links |
| OpportunitiesNotes | Gets an Opportunity's Notes |
| OpportunitiesStateHistory | Gets the history of States and Reasons for an Opportunity. |
| OpportunitiesTasks | Gets a list of an Opportunity's Tasks |
| OpportunityCategories | Gets a list of Opportunity Categories |
| OpportunityStateReasons | Gets a list of Opportunity State Reasons |
| Organisations | Gets a filtered list of Organizations |
| OrganisationsEmails | Gets a list of an Organization's Emails |
| OrganisationsEvents | Gets an Organization's Events |
| OrganisationsFileAttachments | Gets an Organization's File Attachments |
| OrganisationsFollow | Gets a Follow state for an Organization |
| OrganisationsLinks | Gets an Organization's Links |
| OrganisationsNotes | Gets an Organization's Notes |
| OrganisationsTasks | Gets a list of an Organization's Tasks |
| Permissions | Gets the Permissions for a User |
| Pipelines | Gets a list of Pipelines |
| PipelineStages | Gets a list of Pipeline Stages |
| ProjectCategories | Gets a list of Project Categories |
| ProjectFileAttachments | Gets a Project's File Attachments |
| Projects | Gets a filtered list of Projects |
| ProjectsEmails | Gets a list of a Project's Emails |
| ProjectsEvents | Gets a Project's Events |
| ProjectsFollow | Gets a Follow state for a Project |
| ProjectsLinkEmailAddress | Gets the email address to use for linking with the Project |
| ProjectsLinks | Gets a Project's Links |
| ProjectsMilestones | Gets a list of a Project's Milestones |
| ProjectsNotes | Gets a Project's Notes |
| ProjectsTasks | Gets a list of a Project's Tasks |
| Relationships | Gets a list of Relationships |
| Tags | Returns a list of tags associated with a record type: contacts,leads,opportunities,organisations,projects,emails |
| TaskCategories | Gets a list of Task Categories |
| Tasks | Gets a filtered list of Tasks |
| TasksComments | Gets a Task's Comments |
| TasksFollow | Gets a Follow state for a Task |
| TasksLinks | Gets a Task's Links |
| TeamMembers | Gets a list of Team Members |
| Teams | Gets a list of Teams. |
| Users | Gets a filtered list of Users |