API Connectors

users-love-us medal soc2
Send your Insightly data to
Data StudioGoogle SheetsChatGPTClaudePower BIExcelTableauGoogle BigQueryAmazon S3Azure Blob StorageSnowflakeMySQLPostgreSQLPythonAzure SQLAmazon RedshiftDatabricksWindsor MCPMicrosoft FabricCopilot AgentPerplexityLovableAntigravitySupabase

Insightly Connector Reference

109 metrics257 dimensions
Fields

The Insightly connector exposes 366 fields (109 metrics, 257 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Insightly Fields

Insightly activity_sets fields

The activity_sets report of the Insightly connector includes 9 fields.

ID Type Name Description
activity_sets__activities OBJECT activity_sets.ACTIVITIES activity_sets.ACTIVITIES
activity_sets__activityset_id NUMERIC activity_sets.ACTIVITYSET_ID activity_sets.ACTIVITYSET_ID
activity_sets__for_contacts BOOLEAN activity_sets.FOR_CONTACTS activity_sets.FOR_CONTACTS
activity_sets__for_leads BOOLEAN activity_sets.FOR_LEADS activity_sets.FOR_LEADS
activity_sets__for_opportunities BOOLEAN activity_sets.FOR_OPPORTUNITIES activity_sets.FOR_OPPORTUNITIES
activity_sets__for_organisations BOOLEAN activity_sets.FOR_ORGANISATIONS activity_sets.FOR_ORGANISATIONS
activity_sets__for_projects BOOLEAN activity_sets.FOR_PROJECTS activity_sets.FOR_PROJECTS
activity_sets__name TEXT activity_sets.NAME activity_sets.NAME
activity_sets__owner_user_id NUMERIC activity_sets.OWNER_USER_ID activity_sets.OWNER_USER_ID

Insightly contacts fields

The contacts report of the Insightly connector includes 43 fields.

Insightly contacts fields (contacts__address_mail_city to contacts__tags)

ID Type Name Description
contacts__address_mail_city TEXT contacts.ADDRESS_MAIL_CITY contacts.ADDRESS_MAIL_CITY
contacts__address_mail_country TEXT contacts.ADDRESS_MAIL_COUNTRY contacts.ADDRESS_MAIL_COUNTRY
contacts__address_mail_postcode TEXT contacts.ADDRESS_MAIL_POSTCODE contacts.ADDRESS_MAIL_POSTCODE
contacts__address_mail_state TEXT contacts.ADDRESS_MAIL_STATE contacts.ADDRESS_MAIL_STATE
contacts__address_mail_street TEXT contacts.ADDRESS_MAIL_STREET contacts.ADDRESS_MAIL_STREET
contacts__address_other_city TEXT contacts.ADDRESS_OTHER_CITY contacts.ADDRESS_OTHER_CITY
contacts__address_other_country TEXT contacts.ADDRESS_OTHER_COUNTRY contacts.ADDRESS_OTHER_COUNTRY
contacts__address_other_postcode TEXT contacts.ADDRESS_OTHER_POSTCODE contacts.ADDRESS_OTHER_POSTCODE
contacts__address_other_state TEXT contacts.ADDRESS_OTHER_STATE contacts.ADDRESS_OTHER_STATE
contacts__address_other_street TEXT contacts.ADDRESS_OTHER_STREET contacts.ADDRESS_OTHER_STREET
contacts__assistant_name TEXT contacts.ASSISTANT_NAME contacts.ASSISTANT_NAME
contacts__background TEXT contacts.BACKGROUND contacts.BACKGROUND
contacts__contact_id NUMERIC contacts.CONTACT_ID contacts.CONTACT_ID
contacts__created_user_id NUMERIC contacts.CREATED_USER_ID contacts.CREATED_USER_ID
contacts__customfields OBJECT contacts.CUSTOMFIELDS contacts.CUSTOMFIELDS
contacts__date_created_utc TEXT contacts.DATE_CREATED_UTC contacts.DATE_CREATED_UTC
contacts__date_of_birth TEXT contacts.DATE_OF_BIRTH contacts.DATE_OF_BIRTH
contacts__date_updated_utc TEXT contacts.DATE_UPDATED_UTC contacts.DATE_UPDATED_UTC
contacts__dates OBJECT contacts.DATES contacts.DATES
contacts__email_address TEXT contacts.EMAIL_ADDRESS contacts.EMAIL_ADDRESS
contacts__email_opted_out BOOLEAN contacts.EMAIL_OPTED_OUT contacts.EMAIL_OPTED_OUT
contacts__first_name TEXT contacts.FIRST_NAME contacts.FIRST_NAME
contacts__image_url TEXT contacts.IMAGE_URL contacts.IMAGE_URL
contacts__last_activity_date_utc TEXT contacts.LAST_ACTIVITY_DATE_UTC contacts.LAST_ACTIVITY_DATE_UTC
contacts__last_name TEXT contacts.LAST_NAME contacts.LAST_NAME
contacts__links OBJECT contacts.LINKS contacts.LINKS
contacts__next_activity_date_utc TEXT contacts.NEXT_ACTIVITY_DATE_UTC contacts.NEXT_ACTIVITY_DATE_UTC
contacts__organisation_id NUMERIC contacts.ORGANISATION_ID contacts.ORGANISATION_ID
contacts__owner_user_id NUMERIC contacts.OWNER_USER_ID contacts.OWNER_USER_ID
contacts__phone TEXT contacts.PHONE contacts.PHONE
contacts__phone_assistant TEXT contacts.PHONE_ASSISTANT contacts.PHONE_ASSISTANT
contacts__phone_fax TEXT contacts.PHONE_FAX contacts.PHONE_FAX
contacts__phone_home TEXT contacts.PHONE_HOME contacts.PHONE_HOME
contacts__phone_mobile TEXT contacts.PHONE_MOBILE contacts.PHONE_MOBILE
contacts__phone_other TEXT contacts.PHONE_OTHER contacts.PHONE_OTHER
contacts__salutation TEXT contacts.SALUTATION contacts.SALUTATION
contacts__social_facebook TEXT contacts.SOCIAL_FACEBOOK contacts.SOCIAL_FACEBOOK
contacts__social_linkedin TEXT contacts.SOCIAL_LINKEDIN contacts.SOCIAL_LINKEDIN
contacts__social_twitter TEXT contacts.SOCIAL_TWITTER contacts.SOCIAL_TWITTER
contacts__tags OBJECT contacts.TAGS contacts.TAGS

Insightly contacts fields (contacts__title to contacts__visible_to)

ID Type Name Description
contacts__title TEXT contacts.TITLE contacts.TITLE
contacts__visible_team_id NUMERIC contacts.VISIBLE_TEAM_ID contacts.VISIBLE_TEAM_ID
contacts__visible_to TEXT contacts.VISIBLE_TO contacts.VISIBLE_TO

Insightly emails fields

The emails report of the Insightly connector includes 12 fields.

ID Type Name Description
emails__created_user_id NUMERIC emails.CREATED_USER_ID emails.CREATED_USER_ID
emails__date_created_utc TEXT emails.DATE_CREATED_UTC emails.DATE_CREATED_UTC
emails__email_date_utc TEXT emails.EMAIL_DATE_UTC emails.EMAIL_DATE_UTC
emails__email_from TEXT emails.EMAIL_FROM emails.EMAIL_FROM
emails__email_id NUMERIC emails.EMAIL_ID emails.EMAIL_ID
emails__format TEXT emails.FORMAT emails.FORMAT
emails__links OBJECT emails.LINKS emails.LINKS
emails__owner_user_id NUMERIC emails.OWNER_USER_ID emails.OWNER_USER_ID
emails__queued_send_date_utc TEXT emails.QUEUED_SEND_DATE_UTC emails.QUEUED_SEND_DATE_UTC
emails__size NUMERIC emails.SIZE emails.SIZE
emails__subject TEXT emails.SUBJECT emails.SUBJECT
emails__tags OBJECT emails.TAGS emails.TAGS

Insightly events fields

The events report of the Insightly connector includes 14 fields.

ID Type Name Description
events__all_day BOOLEAN events.ALL_DAY events.ALL_DAY
events__customfields OBJECT events.CUSTOMFIELDS events.CUSTOMFIELDS
events__date_created_utc TEXT events.DATE_CREATED_UTC events.DATE_CREATED_UTC
events__date_updated_utc TEXT events.DATE_UPDATED_UTC events.DATE_UPDATED_UTC
events__details TEXT events.DETAILS events.DETAILS
events__end_date_utc TEXT events.END_DATE_UTC events.END_DATE_UTC
events__event_id NUMERIC events.EVENT_ID events.EVENT_ID
events__links OBJECT events.LINKS events.LINKS
events__location TEXT events.LOCATION events.LOCATION
events__owner_user_id NUMERIC events.OWNER_USER_ID events.OWNER_USER_ID
events__reminder_date_utc TEXT events.REMINDER_DATE_UTC events.REMINDER_DATE_UTC
events__reminder_sent BOOLEAN events.REMINDER_SENT events.REMINDER_SENT
events__start_date_utc TEXT events.START_DATE_UTC events.START_DATE_UTC
events__title TEXT events.TITLE events.TITLE

Insightly knowledge_article_categories fields

The knowledge_article_categories report of the Insightly connector includes 6 fields.

ID Type Name Description
knowledge_article_categories__category_id NUMERIC knowledge_article_categories.CATEGORY_ID knowledge_article_categories.CATEGORY_ID
knowledge_article_categories__category_name TEXT knowledge_article_categories.CATEGORY_NAME knowledge_article_categories.CATEGORY_NAME
knowledge_article_categories__created_user_id NUMERIC knowledge_article_categories.CREATED_USER_ID knowledge_article_categories.CREATED_USER_ID
knowledge_article_categories__date_created_utc TEXT knowledge_article_categories.DATE_CREATED_UTC knowledge_article_categories.DATE_CREATED_UTC
knowledge_article_categories__date_updated_utc TEXT knowledge_article_categories.DATE_UPDATED_UTC knowledge_article_categories.DATE_UPDATED_UTC
knowledge_article_categories__description TEXT knowledge_article_categories.DESCRIPTION knowledge_article_categories.DESCRIPTION

Insightly knowledge_article_folders fields

The knowledge_article_folders report of the Insightly connector includes 8 fields.

ID Type Name Description
knowledge_article_folders__category_id TEXT knowledge_article_folders.CATEGORY_ID knowledge_article_folders.CATEGORY_ID
knowledge_article_folders__created_user_id NUMERIC knowledge_article_folders.CREATED_USER_ID knowledge_article_folders.CREATED_USER_ID
knowledge_article_folders__date_created_utc TEXT knowledge_article_folders.DATE_CREATED_UTC knowledge_article_folders.DATE_CREATED_UTC
knowledge_article_folders__date_updated_utc TEXT knowledge_article_folders.DATE_UPDATED_UTC knowledge_article_folders.DATE_UPDATED_UTC
knowledge_article_folders__folder_id NUMERIC knowledge_article_folders.FOLDER_ID knowledge_article_folders.FOLDER_ID
knowledge_article_folders__folder_name TEXT knowledge_article_folders.FOLDER_NAME knowledge_article_folders.FOLDER_NAME
knowledge_article_folders__order_articles TEXT knowledge_article_folders.ORDER_ARTICLES knowledge_article_folders.ORDER_ARTICLES
knowledge_article_folders__visibility TEXT knowledge_article_folders.VISIBILITY knowledge_article_folders.VISIBILITY

Insightly knowledge_articles fields

The knowledge_articles report of the Insightly connector includes 23 fields.

ID Type Name Description
knowledge_articles__archived_date_utc TEXT knowledge_articles.ARCHIVED_DATE_UTC knowledge_articles.ARCHIVED_DATE_UTC
knowledge_articles__article_id NUMERIC knowledge_articles.ARTICLE_ID knowledge_articles.ARTICLE_ID
knowledge_articles__article_no NUMERIC knowledge_articles.ARTICLE_NO knowledge_articles.ARTICLE_NO
knowledge_articles__articleversion TEXT knowledge_articles.ArticleVersion knowledge_articles.ArticleVersion
knowledge_articles__body TEXT knowledge_articles.Body knowledge_articles.Body
knowledge_articles__category_id NUMERIC knowledge_articles.CATEGORY_ID knowledge_articles.CATEGORY_ID
knowledge_articles__created_user_id NUMERIC knowledge_articles.CREATED_USER_ID knowledge_articles.CREATED_USER_ID
knowledge_articles__customfields OBJECT knowledge_articles.CUSTOMFIELDS knowledge_articles.CUSTOMFIELDS
knowledge_articles__date_created_utc TEXT knowledge_articles.DATE_CREATED_UTC knowledge_articles.DATE_CREATED_UTC
knowledge_articles__date_updated_utc TEXT knowledge_articles.DATE_UPDATED_UTC knowledge_articles.DATE_UPDATED_UTC
knowledge_articles__downvote_count NUMERIC knowledge_articles.DOWNVOTE_COUNT knowledge_articles.DOWNVOTE_COUNT
knowledge_articles__externallinkcount TEXT knowledge_articles.ExternalLinkCount knowledge_articles.ExternalLinkCount
knowledge_articles__first_published_date_utc TEXT knowledge_articles.FIRST_PUBLISHED_DATE_UTC knowledge_articles.FIRST_PUBLISHED_DATE_UTC
knowledge_articles__folder_id NUMERIC knowledge_articles.FOLDER_ID knowledge_articles.FOLDER_ID
knowledge_articles__language TEXT knowledge_articles.Language knowledge_articles.Language
knowledge_articles__last_published_date_utc TEXT knowledge_articles.LAST_PUBLISHED_DATE_UTC knowledge_articles.LAST_PUBLISHED_DATE_UTC
knowledge_articles__owner_user_id NUMERIC knowledge_articles.OWNER_USER_ID knowledge_articles.OWNER_USER_ID
knowledge_articles__promoted BOOLEAN knowledge_articles.PROMOTED knowledge_articles.PROMOTED
knowledge_articles__status TEXT knowledge_articles.Status knowledge_articles.Status
knowledge_articles__tags OBJECT knowledge_articles.TAGS knowledge_articles.TAGS
knowledge_articles__title TEXT knowledge_articles.Title knowledge_articles.Title
knowledge_articles__upvote_count NUMERIC knowledge_articles.UPVOTE_COUNT knowledge_articles.UPVOTE_COUNT
knowledge_articles__url_slug TEXT knowledge_articles.URL_SLUG knowledge_articles.URL_SLUG

Insightly lead_sources fields

The lead_sources report of the Insightly connector includes 4 fields.

ID Type Name Description
lead_sources__default_value BOOLEAN lead_sources.DEFAULT_VALUE lead_sources.DEFAULT_VALUE
lead_sources__field_order NUMERIC lead_sources.FIELD_ORDER lead_sources.FIELD_ORDER
lead_sources__lead_source TEXT lead_sources.LEAD_SOURCE lead_sources.LEAD_SOURCE
lead_sources__lead_source_id NUMERIC lead_sources.LEAD_SOURCE_ID lead_sources.LEAD_SOURCE_ID

Insightly lead_statuses fields

The lead_statuses report of the Insightly connector includes 5 fields.

ID Type Name Description
lead_statuses__default_status BOOLEAN lead_statuses.DEFAULT_STATUS lead_statuses.DEFAULT_STATUS
lead_statuses__field_order NUMERIC lead_statuses.FIELD_ORDER lead_statuses.FIELD_ORDER
lead_statuses__lead_status TEXT lead_statuses.LEAD_STATUS lead_statuses.LEAD_STATUS
lead_statuses__lead_status_id NUMERIC lead_statuses.LEAD_STATUS_ID lead_statuses.LEAD_STATUS_ID
lead_statuses__status_type NUMERIC lead_statuses.STATUS_TYPE lead_statuses.STATUS_TYPE

Insightly milestones fields

The milestones report of the Insightly connector includes 10 fields.

ID Type Name Description
milestones__completed BOOLEAN milestones.COMPLETED milestones.COMPLETED
milestones__completed_date_utc TEXT milestones.COMPLETED_DATE_UTC milestones.COMPLETED_DATE_UTC
milestones__date_created_utc TEXT milestones.DATE_CREATED_UTC milestones.DATE_CREATED_UTC
milestones__date_updated_utc TEXT milestones.DATE_UPDATED_UTC milestones.DATE_UPDATED_UTC
milestones__due_date TEXT milestones.DUE_DATE milestones.DUE_DATE
milestones__milestone_id NUMERIC milestones.MILESTONE_ID milestones.MILESTONE_ID
milestones__owner_user_id NUMERIC milestones.OWNER_USER_ID milestones.OWNER_USER_ID
milestones__project_id NUMERIC milestones.PROJECT_ID milestones.PROJECT_ID
milestones__responsible_user NUMERIC milestones.RESPONSIBLE_USER milestones.RESPONSIBLE_USER
milestones__title TEXT milestones.TITLE milestones.TITLE

Insightly notes fields

The notes report of the Insightly connector includes 7 fields.

ID Type Name Description
notes__body TEXT notes.BODY notes.BODY
notes__date_created_utc TEXT notes.DATE_CREATED_UTC notes.DATE_CREATED_UTC
notes__date_updated_utc TEXT notes.DATE_UPDATED_UTC notes.DATE_UPDATED_UTC
notes__links OBJECT notes.LINKS notes.LINKS
notes__note_id NUMERIC notes.NOTE_ID notes.NOTE_ID
notes__owner_user_id NUMERIC notes.OWNER_USER_ID notes.OWNER_USER_ID
notes__title TEXT notes.TITLE notes.TITLE

Insightly opportunities fields

The opportunities report of the Insightly connector includes 30 fields.

ID Type Name Description
opportunities__actual_close_date TEXT opportunities.ACTUAL_CLOSE_DATE opportunities.ACTUAL_CLOSE_DATE
opportunities__bid_amount NUMERIC opportunities.BID_AMOUNT opportunities.BID_AMOUNT
opportunities__bid_currency TEXT opportunities.BID_CURRENCY opportunities.BID_CURRENCY
opportunities__bid_duration NUMERIC opportunities.BID_DURATION opportunities.BID_DURATION
opportunities__bid_type TEXT opportunities.BID_TYPE opportunities.BID_TYPE
opportunities__category_id NUMERIC opportunities.CATEGORY_ID opportunities.CATEGORY_ID
opportunities__created_user_id NUMERIC opportunities.CREATED_USER_ID opportunities.CREATED_USER_ID
opportunities__customfields OBJECT opportunities.CUSTOMFIELDS opportunities.CUSTOMFIELDS
opportunities__date_created_utc TEXT opportunities.DATE_CREATED_UTC opportunities.DATE_CREATED_UTC
opportunities__date_updated_utc TEXT opportunities.DATE_UPDATED_UTC opportunities.DATE_UPDATED_UTC
opportunities__forecast_close_date TEXT opportunities.FORECAST_CLOSE_DATE opportunities.FORECAST_CLOSE_DATE
opportunities__image_url TEXT opportunities.IMAGE_URL opportunities.IMAGE_URL
opportunities__last_activity_date_utc TEXT opportunities.LAST_ACTIVITY_DATE_UTC opportunities.LAST_ACTIVITY_DATE_UTC
opportunities__links OBJECT opportunities.LINKS opportunities.LINKS
opportunities__next_activity_date_utc TEXT opportunities.NEXT_ACTIVITY_DATE_UTC opportunities.NEXT_ACTIVITY_DATE_UTC
opportunities__opportunity_details TEXT opportunities.OPPORTUNITY_DETAILS opportunities.OPPORTUNITY_DETAILS
opportunities__opportunity_id NUMERIC opportunities.OPPORTUNITY_ID opportunities.OPPORTUNITY_ID
opportunities__opportunity_name TEXT opportunities.OPPORTUNITY_NAME opportunities.OPPORTUNITY_NAME
opportunities__opportunity_state TEXT opportunities.OPPORTUNITY_STATE opportunities.OPPORTUNITY_STATE
opportunities__opportunity_value NUMERIC opportunities.OPPORTUNITY_VALUE opportunities.OPPORTUNITY_VALUE
opportunities__organisation_id NUMERIC opportunities.ORGANISATION_ID opportunities.ORGANISATION_ID
opportunities__owner_user_id NUMERIC opportunities.OWNER_USER_ID opportunities.OWNER_USER_ID
opportunities__pipeline_id NUMERIC opportunities.PIPELINE_ID opportunities.PIPELINE_ID
opportunities__pricebook_id NUMERIC opportunities.PRICEBOOK_ID opportunities.PRICEBOOK_ID
opportunities__probability NUMERIC opportunities.PROBABILITY opportunities.PROBABILITY
opportunities__responsible_user_id NUMERIC opportunities.RESPONSIBLE_USER_ID opportunities.RESPONSIBLE_USER_ID
opportunities__stage_id NUMERIC opportunities.STAGE_ID opportunities.STAGE_ID
opportunities__tags OBJECT opportunities.TAGS opportunities.TAGS
opportunities__visible_team_id NUMERIC opportunities.VISIBLE_TEAM_ID opportunities.VISIBLE_TEAM_ID
opportunities__visible_to TEXT opportunities.VISIBLE_TO opportunities.VISIBLE_TO

Insightly opportunity_categories fields

The opportunity_categories report of the Insightly connector includes 4 fields.

ID Type Name Description
opportunity_categories__active BOOLEAN opportunity_categories.ACTIVE opportunity_categories.ACTIVE
opportunity_categories__background_color TEXT opportunity_categories.BACKGROUND_COLOR opportunity_categories.BACKGROUND_COLOR
opportunity_categories__category_id NUMERIC opportunity_categories.CATEGORY_ID opportunity_categories.CATEGORY_ID
opportunity_categories__category_name TEXT opportunity_categories.CATEGORY_NAME opportunity_categories.CATEGORY_NAME

Insightly opportunity_state_reasons fields

The opportunity_state_reasons report of the Insightly connector includes 3 fields.

ID Type Name Description
opportunity_state_reasons__for_opportunity_state TEXT opportunity_state_reasons.FOR_OPPORTUNITY_STATE opportunity_state_reasons.FOR_OPPORTUNITY_STATE
opportunity_state_reasons__state_reason TEXT opportunity_state_reasons.STATE_REASON opportunity_state_reasons.STATE_REASON
opportunity_state_reasons__state_reason_id NUMERIC opportunity_state_reasons.STATE_REASON_ID opportunity_state_reasons.STATE_REASON_ID

Insightly organisations fields

The organisations report of the Insightly connector includes 33 fields.

ID Type Name Description
organisations__address_billing_city TEXT organisations.ADDRESS_BILLING_CITY organisations.ADDRESS_BILLING_CITY
organisations__address_billing_country TEXT organisations.ADDRESS_BILLING_COUNTRY organisations.ADDRESS_BILLING_COUNTRY
organisations__address_billing_postcode TEXT organisations.ADDRESS_BILLING_POSTCODE organisations.ADDRESS_BILLING_POSTCODE
organisations__address_billing_state TEXT organisations.ADDRESS_BILLING_STATE organisations.ADDRESS_BILLING_STATE
organisations__address_billing_street TEXT organisations.ADDRESS_BILLING_STREET organisations.ADDRESS_BILLING_STREET
organisations__address_ship_city TEXT organisations.ADDRESS_SHIP_CITY organisations.ADDRESS_SHIP_CITY
organisations__address_ship_country TEXT organisations.ADDRESS_SHIP_COUNTRY organisations.ADDRESS_SHIP_COUNTRY
organisations__address_ship_postcode TEXT organisations.ADDRESS_SHIP_POSTCODE organisations.ADDRESS_SHIP_POSTCODE
organisations__address_ship_state TEXT organisations.ADDRESS_SHIP_STATE organisations.ADDRESS_SHIP_STATE
organisations__address_ship_street TEXT organisations.ADDRESS_SHIP_STREET organisations.ADDRESS_SHIP_STREET
organisations__background TEXT organisations.BACKGROUND organisations.BACKGROUND
organisations__created_user_id NUMERIC organisations.CREATED_USER_ID organisations.CREATED_USER_ID
organisations__customfields OBJECT organisations.CUSTOMFIELDS organisations.CUSTOMFIELDS
organisations__date_created_utc TEXT organisations.DATE_CREATED_UTC organisations.DATE_CREATED_UTC
organisations__date_updated_utc TEXT organisations.DATE_UPDATED_UTC organisations.DATE_UPDATED_UTC
organisations__dates OBJECT organisations.DATES organisations.DATES
organisations__emaildomains OBJECT organisations.EMAILDOMAINS organisations.EMAILDOMAINS
organisations__image_url TEXT organisations.IMAGE_URL organisations.IMAGE_URL
organisations__last_activity_date_utc TEXT organisations.LAST_ACTIVITY_DATE_UTC organisations.LAST_ACTIVITY_DATE_UTC
organisations__links OBJECT organisations.LINKS organisations.LINKS
organisations__next_activity_date_utc TEXT organisations.NEXT_ACTIVITY_DATE_UTC organisations.NEXT_ACTIVITY_DATE_UTC
organisations__organisation_id NUMERIC organisations.ORGANISATION_ID organisations.ORGANISATION_ID
organisations__organisation_name TEXT organisations.ORGANISATION_NAME organisations.ORGANISATION_NAME
organisations__owner_user_id NUMERIC organisations.OWNER_USER_ID organisations.OWNER_USER_ID
organisations__phone TEXT organisations.PHONE organisations.PHONE
organisations__phone_fax TEXT organisations.PHONE_FAX organisations.PHONE_FAX
organisations__social_facebook TEXT organisations.SOCIAL_FACEBOOK organisations.SOCIAL_FACEBOOK
organisations__social_linkedin TEXT organisations.SOCIAL_LINKEDIN organisations.SOCIAL_LINKEDIN
organisations__social_twitter TEXT organisations.SOCIAL_TWITTER organisations.SOCIAL_TWITTER
organisations__tags OBJECT organisations.TAGS organisations.TAGS
organisations__visible_team_id NUMERIC organisations.VISIBLE_TEAM_ID organisations.VISIBLE_TEAM_ID
organisations__visible_to TEXT organisations.VISIBLE_TO organisations.VISIBLE_TO
organisations__website TEXT organisations.WEBSITE organisations.WEBSITE

Insightly pipeline_stages fields

The pipeline_stages report of the Insightly connector includes 6 fields.

ID Type Name Description
pipeline_stages__activityset_id NUMERIC pipeline_stages.ACTIVITYSET_ID pipeline_stages.ACTIVITYSET_ID
pipeline_stages__owner_user_id NUMERIC pipeline_stages.OWNER_USER_ID pipeline_stages.OWNER_USER_ID
pipeline_stages__pipeline_id NUMERIC pipeline_stages.PIPELINE_ID pipeline_stages.PIPELINE_ID
pipeline_stages__stage_id NUMERIC pipeline_stages.STAGE_ID pipeline_stages.STAGE_ID
pipeline_stages__stage_name TEXT pipeline_stages.STAGE_NAME pipeline_stages.STAGE_NAME
pipeline_stages__stage_order NUMERIC pipeline_stages.STAGE_ORDER pipeline_stages.STAGE_ORDER

Insightly pipelines fields

The pipelines report of the Insightly connector includes 5 fields.

ID Type Name Description
pipelines__for_opportunities BOOLEAN pipelines.FOR_OPPORTUNITIES pipelines.FOR_OPPORTUNITIES
pipelines__for_projects BOOLEAN pipelines.FOR_PROJECTS pipelines.FOR_PROJECTS
pipelines__owner_user_id NUMERIC pipelines.OWNER_USER_ID pipelines.OWNER_USER_ID
pipelines__pipeline_id NUMERIC pipelines.PIPELINE_ID pipelines.PIPELINE_ID
pipelines__pipeline_name TEXT pipelines.PIPELINE_NAME pipelines.PIPELINE_NAME

Insightly project_categories fields

The project_categories report of the Insightly connector includes 4 fields.

ID Type Name Description
project_categories__active BOOLEAN project_categories.ACTIVE project_categories.ACTIVE
project_categories__background_color TEXT project_categories.BACKGROUND_COLOR project_categories.BACKGROUND_COLOR
project_categories__category_id NUMERIC project_categories.CATEGORY_ID project_categories.CATEGORY_ID
project_categories__category_name TEXT project_categories.CATEGORY_NAME project_categories.CATEGORY_NAME

Insightly projects fields

The projects report of the Insightly connector includes 23 fields.

ID Type Name Description
projects__category_id NUMERIC projects.CATEGORY_ID projects.CATEGORY_ID
projects__completed_date TEXT projects.COMPLETED_DATE projects.COMPLETED_DATE
projects__created_user_id NUMERIC projects.CREATED_USER_ID projects.CREATED_USER_ID
projects__customfields OBJECT projects.CUSTOMFIELDS projects.CUSTOMFIELDS
projects__date_created_utc TEXT projects.DATE_CREATED_UTC projects.DATE_CREATED_UTC
projects__date_updated_utc TEXT projects.DATE_UPDATED_UTC projects.DATE_UPDATED_UTC
projects__image_url TEXT projects.IMAGE_URL projects.IMAGE_URL
projects__last_activity_date_utc TEXT projects.LAST_ACTIVITY_DATE_UTC projects.LAST_ACTIVITY_DATE_UTC
projects__links OBJECT projects.LINKS projects.LINKS
projects__next_activity_date_utc TEXT projects.NEXT_ACTIVITY_DATE_UTC projects.NEXT_ACTIVITY_DATE_UTC
projects__opportunity_id NUMERIC projects.OPPORTUNITY_ID projects.OPPORTUNITY_ID
projects__owner_user_id NUMERIC projects.OWNER_USER_ID projects.OWNER_USER_ID
projects__pipeline_id NUMERIC projects.PIPELINE_ID projects.PIPELINE_ID
projects__project_details TEXT projects.PROJECT_DETAILS projects.PROJECT_DETAILS
projects__project_id NUMERIC projects.PROJECT_ID projects.PROJECT_ID
projects__project_name TEXT projects.PROJECT_NAME projects.PROJECT_NAME
projects__responsible_user_id NUMERIC projects.RESPONSIBLE_USER_ID projects.RESPONSIBLE_USER_ID
projects__stage_id NUMERIC projects.STAGE_ID projects.STAGE_ID
projects__started_date TEXT projects.STARTED_DATE projects.STARTED_DATE
projects__status TEXT projects.STATUS projects.STATUS
projects__tags OBJECT projects.TAGS projects.TAGS
projects__visible_team_id NUMERIC projects.VISIBLE_TEAM_ID projects.VISIBLE_TEAM_ID
projects__visible_to TEXT projects.VISIBLE_TO projects.VISIBLE_TO

Insightly prospects fields

The prospects report of the Insightly connector includes 37 fields.

ID Type Name Description
prospects__address_city TEXT prospects.ADDRESS_CITY prospects.ADDRESS_CITY
prospects__address_country TEXT prospects.ADDRESS_COUNTRY prospects.ADDRESS_COUNTRY
prospects__address_postcode TEXT prospects.ADDRESS_POSTCODE prospects.ADDRESS_POSTCODE
prospects__address_state TEXT prospects.ADDRESS_STATE prospects.ADDRESS_STATE
prospects__address_street TEXT prospects.ADDRESS_STREET prospects.ADDRESS_STREET
prospects__contact_id NUMERIC prospects.CONTACT_ID prospects.CONTACT_ID
prospects__created_user_id NUMERIC prospects.CREATED_USER_ID prospects.CREATED_USER_ID
prospects__customfields OBJECT prospects.CUSTOMFIELDS prospects.CUSTOMFIELDS
prospects__date_created_utc TEXT prospects.DATE_CREATED_UTC prospects.DATE_CREATED_UTC
prospects__date_updated_utc TEXT prospects.DATE_UPDATED_UTC prospects.DATE_UPDATED_UTC
prospects__description TEXT prospects.DESCRIPTION prospects.DESCRIPTION
prospects__do_not_call BOOLEAN prospects.DO_NOT_CALL prospects.DO_NOT_CALL
prospects__do_not_email BOOLEAN prospects.DO_NOT_EMAIL prospects.DO_NOT_EMAIL
prospects__do_not_sync BOOLEAN prospects.DO_NOT_SYNC prospects.DO_NOT_SYNC
prospects__email_address TEXT prospects.EMAIL_ADDRESS prospects.EMAIL_ADDRESS
prospects__employee_count NUMERIC prospects.EMPLOYEE_COUNT prospects.EMPLOYEE_COUNT
prospects__fax TEXT prospects.FAX prospects.FAX
prospects__first_name TEXT prospects.FIRST_NAME prospects.FIRST_NAME
prospects__grade TEXT prospects.GRADE prospects.GRADE
prospects__grade_profile_id NUMERIC prospects.GRADE_PROFILE_ID prospects.GRADE_PROFILE_ID
prospects__industry TEXT prospects.INDUSTRY prospects.INDUSTRY
prospects__last_activity_date_utc TEXT prospects.LAST_ACTIVITY_DATE_UTC prospects.LAST_ACTIVITY_DATE_UTC
prospects__last_name TEXT prospects.LAST_NAME prospects.LAST_NAME
prospects__lead_conversion_date_utc TEXT prospects.LEAD_CONVERSION_DATE_UTC prospects.LEAD_CONVERSION_DATE_UTC
prospects__lead_id NUMERIC prospects.LEAD_ID prospects.LEAD_ID
prospects__mobile TEXT prospects.MOBILE prospects.MOBILE
prospects__opted_out BOOLEAN prospects.OPTED_OUT prospects.OPTED_OUT
prospects__organisation_id NUMERIC prospects.ORGANISATION_ID prospects.ORGANISATION_ID
prospects__organisation_name TEXT prospects.ORGANISATION_NAME prospects.ORGANISATION_NAME
prospects__owner_user_id NUMERIC prospects.OWNER_USER_ID prospects.OWNER_USER_ID
prospects__phone TEXT prospects.PHONE prospects.PHONE
prospects__prospect_id NUMERIC prospects.PROSPECT_ID prospects.PROSPECT_ID
prospects__salutation TEXT prospects.SALUTATION prospects.SALUTATION
prospects__score NUMERIC prospects.SCORE prospects.SCORE
prospects__tags OBJECT prospects.TAGS prospects.TAGS
prospects__title TEXT prospects.TITLE prospects.TITLE
prospects__website TEXT prospects.WEBSITE prospects.WEBSITE

Insightly relationships fields

The relationships report of the Insightly connector includes 7 fields.

ID Type Name Description
relationships__for_contacts BOOLEAN relationships.FOR_CONTACTS relationships.FOR_CONTACTS
relationships__for_organisations BOOLEAN relationships.FOR_ORGANISATIONS relationships.FOR_ORGANISATIONS
relationships__forward TEXT relationships.FORWARD relationships.FORWARD
relationships__forward_title TEXT relationships.FORWARD_TITLE relationships.FORWARD_TITLE
relationships__relationship_id NUMERIC relationships.RELATIONSHIP_ID relationships.RELATIONSHIP_ID
relationships__reverse TEXT relationships.REVERSE relationships.REVERSE
relationships__reverse_title TEXT relationships.REVERSE_TITLE relationships.REVERSE_TITLE

Insightly task_categories fields

The task_categories report of the Insightly connector includes 4 fields.

ID Type Name Description
task_categories__active BOOLEAN task_categories.ACTIVE task_categories.ACTIVE
task_categories__background_color TEXT task_categories.BACKGROUND_COLOR task_categories.BACKGROUND_COLOR
task_categories__category_id NUMERIC task_categories.CATEGORY_ID task_categories.CATEGORY_ID
task_categories__category_name TEXT task_categories.CATEGORY_NAME task_categories.CATEGORY_NAME

Insightly tasks fields

The tasks report of the Insightly connector includes 32 fields.

ID Type Name Description
tasks__assigned_by_user_id NUMERIC tasks.ASSIGNED_BY_USER_ID tasks.ASSIGNED_BY_USER_ID
tasks__assigned_date_utc TEXT tasks.ASSIGNED_DATE_UTC tasks.ASSIGNED_DATE_UTC
tasks__assigned_team_id NUMERIC tasks.ASSIGNED_TEAM_ID tasks.ASSIGNED_TEAM_ID
tasks__category_id NUMERIC tasks.CATEGORY_ID tasks.CATEGORY_ID
tasks__completed BOOLEAN tasks.COMPLETED tasks.COMPLETED
tasks__completed_date_utc TEXT tasks.COMPLETED_DATE_UTC tasks.COMPLETED_DATE_UTC
tasks__created_user_id NUMERIC tasks.CREATED_USER_ID tasks.CREATED_USER_ID
tasks__customfields OBJECT tasks.CUSTOMFIELDS tasks.CUSTOMFIELDS
tasks__date_created_utc TEXT tasks.DATE_CREATED_UTC tasks.DATE_CREATED_UTC
tasks__date_updated_utc TEXT tasks.DATE_UPDATED_UTC tasks.DATE_UPDATED_UTC
tasks__details TEXT tasks.DETAILS tasks.DETAILS
tasks__due_date TEXT tasks.DUE_DATE tasks.DUE_DATE
tasks__email_id NUMERIC tasks.EMAIL_ID tasks.EMAIL_ID
tasks__links OBJECT tasks.LINKS tasks.LINKS
tasks__milestone_id NUMERIC tasks.MILESTONE_ID tasks.MILESTONE_ID
tasks__opportunity_id NUMERIC tasks.OPPORTUNITY_ID tasks.OPPORTUNITY_ID
tasks__owner_user_id NUMERIC tasks.OWNER_USER_ID tasks.OWNER_USER_ID
tasks__owner_visible BOOLEAN tasks.OWNER_VISIBLE tasks.OWNER_VISIBLE
tasks__parent_task_id NUMERIC tasks.PARENT_TASK_ID tasks.PARENT_TASK_ID
tasks__percent_complete NUMERIC tasks.PERCENT_COMPLETE tasks.PERCENT_COMPLETE
tasks__priority NUMERIC tasks.PRIORITY tasks.PRIORITY
tasks__project_id NUMERIC tasks.PROJECT_ID tasks.PROJECT_ID
tasks__publicly_visible BOOLEAN tasks.PUBLICLY_VISIBLE tasks.PUBLICLY_VISIBLE
tasks__recurrence TEXT tasks.RECURRENCE tasks.RECURRENCE
tasks__reminder_date_utc TEXT tasks.REMINDER_DATE_UTC tasks.REMINDER_DATE_UTC
tasks__reminder_sent BOOLEAN tasks.REMINDER_SENT tasks.REMINDER_SENT
tasks__responsible_user_id NUMERIC tasks.RESPONSIBLE_USER_ID tasks.RESPONSIBLE_USER_ID
tasks__stage_id NUMERIC tasks.STAGE_ID tasks.STAGE_ID
tasks__start_date TEXT tasks.START_DATE tasks.START_DATE
tasks__status TEXT tasks.STATUS tasks.STATUS
tasks__task_id NUMERIC tasks.TASK_ID tasks.TASK_ID
tasks__title TEXT tasks.TITLE tasks.TITLE

Insightly team_members fields

The team_members report of the Insightly connector includes 3 fields.

ID Type Name Description
team_members__member_user_id NUMERIC team_members.MEMBER_USER_ID team_members.MEMBER_USER_ID
team_members__permission_id NUMERIC team_members.PERMISSION_ID team_members.PERMISSION_ID
team_members__team_id NUMERIC team_members.TEAM_ID team_members.TEAM_ID

Insightly teams fields

The teams report of the Insightly connector includes 6 fields.

ID Type Name Description
teams__anonymous_team BOOLEAN teams.ANONYMOUS_TEAM teams.ANONYMOUS_TEAM
teams__date_created_utc TEXT teams.DATE_CREATED_UTC teams.DATE_CREATED_UTC
teams__date_updated_utc TEXT teams.DATE_UPDATED_UTC teams.DATE_UPDATED_UTC
teams__team_id NUMERIC teams.TEAM_ID teams.TEAM_ID
teams__team_name TEXT teams.TEAM_NAME teams.TEAM_NAME
teams__teammembers OBJECT teams.TEAMMEMBERS teams.TEAMMEMBERS

Insightly users fields

The users report of the Insightly connector includes 20 fields.

ID Type Name Description
users__account_owner BOOLEAN users.ACCOUNT_OWNER users.ACCOUNT_OWNER
users__active BOOLEAN users.ACTIVE users.ACTIVE
users__administrator BOOLEAN users.ADMINISTRATOR users.ADMINISTRATOR
users__contact_display TEXT users.CONTACT_DISPLAY users.CONTACT_DISPLAY
users__contact_id NUMERIC users.CONTACT_ID users.CONTACT_ID
users__contact_order TEXT users.CONTACT_ORDER users.CONTACT_ORDER
users__date_created_utc TEXT users.DATE_CREATED_UTC users.DATE_CREATED_UTC
users__date_updated_utc TEXT users.DATE_UPDATED_UTC users.DATE_UPDATED_UTC
users__email_address TEXT users.EMAIL_ADDRESS users.EMAIL_ADDRESS
users__email_dropbox_address TEXT users.EMAIL_DROPBOX_ADDRESS users.EMAIL_DROPBOX_ADDRESS
users__email_dropbox_identifier TEXT users.EMAIL_DROPBOX_IDENTIFIER users.EMAIL_DROPBOX_IDENTIFIER
users__first_name TEXT users.FIRST_NAME users.FIRST_NAME
users__instance_id NUMERIC users.INSTANCE_ID users.INSTANCE_ID
users__last_name TEXT users.LAST_NAME users.LAST_NAME
users__profile_id NUMERIC users.PROFILE_ID users.PROFILE_ID
users__role_id NUMERIC users.ROLE_ID users.ROLE_ID
users__task_week_start NUMERIC users.TASK_WEEK_START users.TASK_WEEK_START
users__timezone_id TEXT users.TIMEZONE_ID users.TIMEZONE_ID
users__user_currency TEXT users.USER_CURRENCY users.USER_CURRENCY
users__user_id NUMERIC users.USER_ID users.USER_ID

Insightly other fields

The Insightly connector has 8 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID Type Name Description Report
countries__country_name TEXT countries.COUNTRY_NAME countries.COUNTRY_NAME countries
currencies__currency_code TEXT currencies.CURRENCY_CODE currencies.CURRENCY_CODE currencies
currencies__currency_symbol TEXT currencies.CURRENCY_SYMBOL currencies.CURRENCY_SYMBOL currencies
data_fetched_at TIMESTAMP Data fetched at UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource TEXT Data Source The name of the Windsor connector returning the row
now TIMESTAMP Now Current timestamp
source TEXT Source The name of the Windsor connector returning the row
today DATE Today Today's date