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.

IDTypeNameDescription
activity_sets__activitiesOBJECTactivity_sets.ACTIVITIESactivity_sets.ACTIVITIES
activity_sets__activityset_idNUMERICactivity_sets.ACTIVITYSET_IDactivity_sets.ACTIVITYSET_ID
activity_sets__for_contactsBOOLEANactivity_sets.FOR_CONTACTSactivity_sets.FOR_CONTACTS
activity_sets__for_leadsBOOLEANactivity_sets.FOR_LEADSactivity_sets.FOR_LEADS
activity_sets__for_opportunitiesBOOLEANactivity_sets.FOR_OPPORTUNITIESactivity_sets.FOR_OPPORTUNITIES
activity_sets__for_organisationsBOOLEANactivity_sets.FOR_ORGANISATIONSactivity_sets.FOR_ORGANISATIONS
activity_sets__for_projectsBOOLEANactivity_sets.FOR_PROJECTSactivity_sets.FOR_PROJECTS
activity_sets__nameTEXTactivity_sets.NAMEactivity_sets.NAME
activity_sets__owner_user_idNUMERICactivity_sets.OWNER_USER_IDactivity_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)

IDTypeNameDescription
contacts__address_mail_cityTEXTcontacts.ADDRESS_MAIL_CITYcontacts.ADDRESS_MAIL_CITY
contacts__address_mail_countryTEXTcontacts.ADDRESS_MAIL_COUNTRYcontacts.ADDRESS_MAIL_COUNTRY
contacts__address_mail_postcodeTEXTcontacts.ADDRESS_MAIL_POSTCODEcontacts.ADDRESS_MAIL_POSTCODE
contacts__address_mail_stateTEXTcontacts.ADDRESS_MAIL_STATEcontacts.ADDRESS_MAIL_STATE
contacts__address_mail_streetTEXTcontacts.ADDRESS_MAIL_STREETcontacts.ADDRESS_MAIL_STREET
contacts__address_other_cityTEXTcontacts.ADDRESS_OTHER_CITYcontacts.ADDRESS_OTHER_CITY
contacts__address_other_countryTEXTcontacts.ADDRESS_OTHER_COUNTRYcontacts.ADDRESS_OTHER_COUNTRY
contacts__address_other_postcodeTEXTcontacts.ADDRESS_OTHER_POSTCODEcontacts.ADDRESS_OTHER_POSTCODE
contacts__address_other_stateTEXTcontacts.ADDRESS_OTHER_STATEcontacts.ADDRESS_OTHER_STATE
contacts__address_other_streetTEXTcontacts.ADDRESS_OTHER_STREETcontacts.ADDRESS_OTHER_STREET
contacts__assistant_nameTEXTcontacts.ASSISTANT_NAMEcontacts.ASSISTANT_NAME
contacts__backgroundTEXTcontacts.BACKGROUNDcontacts.BACKGROUND
contacts__contact_idNUMERICcontacts.CONTACT_IDcontacts.CONTACT_ID
contacts__created_user_idNUMERICcontacts.CREATED_USER_IDcontacts.CREATED_USER_ID
contacts__customfieldsOBJECTcontacts.CUSTOMFIELDScontacts.CUSTOMFIELDS
contacts__date_created_utcTEXTcontacts.DATE_CREATED_UTCcontacts.DATE_CREATED_UTC
contacts__date_of_birthTEXTcontacts.DATE_OF_BIRTHcontacts.DATE_OF_BIRTH
contacts__date_updated_utcTEXTcontacts.DATE_UPDATED_UTCcontacts.DATE_UPDATED_UTC
contacts__datesOBJECTcontacts.DATEScontacts.DATES
contacts__email_addressTEXTcontacts.EMAIL_ADDRESScontacts.EMAIL_ADDRESS
contacts__email_opted_outBOOLEANcontacts.EMAIL_OPTED_OUTcontacts.EMAIL_OPTED_OUT
contacts__first_nameTEXTcontacts.FIRST_NAMEcontacts.FIRST_NAME
contacts__image_urlTEXTcontacts.IMAGE_URLcontacts.IMAGE_URL
contacts__last_activity_date_utcTEXTcontacts.LAST_ACTIVITY_DATE_UTCcontacts.LAST_ACTIVITY_DATE_UTC
contacts__last_nameTEXTcontacts.LAST_NAMEcontacts.LAST_NAME
contacts__linksOBJECTcontacts.LINKScontacts.LINKS
contacts__next_activity_date_utcTEXTcontacts.NEXT_ACTIVITY_DATE_UTCcontacts.NEXT_ACTIVITY_DATE_UTC
contacts__organisation_idNUMERICcontacts.ORGANISATION_IDcontacts.ORGANISATION_ID
contacts__owner_user_idNUMERICcontacts.OWNER_USER_IDcontacts.OWNER_USER_ID
contacts__phoneTEXTcontacts.PHONEcontacts.PHONE
contacts__phone_assistantTEXTcontacts.PHONE_ASSISTANTcontacts.PHONE_ASSISTANT
contacts__phone_faxTEXTcontacts.PHONE_FAXcontacts.PHONE_FAX
contacts__phone_homeTEXTcontacts.PHONE_HOMEcontacts.PHONE_HOME
contacts__phone_mobileTEXTcontacts.PHONE_MOBILEcontacts.PHONE_MOBILE
contacts__phone_otherTEXTcontacts.PHONE_OTHERcontacts.PHONE_OTHER
contacts__salutationTEXTcontacts.SALUTATIONcontacts.SALUTATION
contacts__social_facebookTEXTcontacts.SOCIAL_FACEBOOKcontacts.SOCIAL_FACEBOOK
contacts__social_linkedinTEXTcontacts.SOCIAL_LINKEDINcontacts.SOCIAL_LINKEDIN
contacts__social_twitterTEXTcontacts.SOCIAL_TWITTERcontacts.SOCIAL_TWITTER
contacts__tagsOBJECTcontacts.TAGScontacts.TAGS

Insightly contacts fields (contacts__title to contacts__visible_to)

IDTypeNameDescription
contacts__titleTEXTcontacts.TITLEcontacts.TITLE
contacts__visible_team_idNUMERICcontacts.VISIBLE_TEAM_IDcontacts.VISIBLE_TEAM_ID
contacts__visible_toTEXTcontacts.VISIBLE_TOcontacts.VISIBLE_TO

Insightly emails fields

The emails report of the Insightly connector includes 12 fields.

IDTypeNameDescription
emails__created_user_idNUMERICemails.CREATED_USER_IDemails.CREATED_USER_ID
emails__date_created_utcTEXTemails.DATE_CREATED_UTCemails.DATE_CREATED_UTC
emails__email_date_utcTEXTemails.EMAIL_DATE_UTCemails.EMAIL_DATE_UTC
emails__email_fromTEXTemails.EMAIL_FROMemails.EMAIL_FROM
emails__email_idNUMERICemails.EMAIL_IDemails.EMAIL_ID
emails__formatTEXTemails.FORMATemails.FORMAT
emails__linksOBJECTemails.LINKSemails.LINKS
emails__owner_user_idNUMERICemails.OWNER_USER_IDemails.OWNER_USER_ID
emails__queued_send_date_utcTEXTemails.QUEUED_SEND_DATE_UTCemails.QUEUED_SEND_DATE_UTC
emails__sizeNUMERICemails.SIZEemails.SIZE
emails__subjectTEXTemails.SUBJECTemails.SUBJECT
emails__tagsOBJECTemails.TAGSemails.TAGS

Insightly events fields

The events report of the Insightly connector includes 14 fields.

IDTypeNameDescription
events__all_dayBOOLEANevents.ALL_DAYevents.ALL_DAY
events__customfieldsOBJECTevents.CUSTOMFIELDSevents.CUSTOMFIELDS
events__date_created_utcTEXTevents.DATE_CREATED_UTCevents.DATE_CREATED_UTC
events__date_updated_utcTEXTevents.DATE_UPDATED_UTCevents.DATE_UPDATED_UTC
events__detailsTEXTevents.DETAILSevents.DETAILS
events__end_date_utcTEXTevents.END_DATE_UTCevents.END_DATE_UTC
events__event_idNUMERICevents.EVENT_IDevents.EVENT_ID
events__linksOBJECTevents.LINKSevents.LINKS
events__locationTEXTevents.LOCATIONevents.LOCATION
events__owner_user_idNUMERICevents.OWNER_USER_IDevents.OWNER_USER_ID
events__reminder_date_utcTEXTevents.REMINDER_DATE_UTCevents.REMINDER_DATE_UTC
events__reminder_sentBOOLEANevents.REMINDER_SENTevents.REMINDER_SENT
events__start_date_utcTEXTevents.START_DATE_UTCevents.START_DATE_UTC
events__titleTEXTevents.TITLEevents.TITLE

Insightly knowledge_article_categories fields

The knowledge_article_categories report of the Insightly connector includes 6 fields.

IDTypeNameDescription
knowledge_article_categories__category_idNUMERICknowledge_article_categories.CATEGORY_IDknowledge_article_categories.CATEGORY_ID
knowledge_article_categories__category_nameTEXTknowledge_article_categories.CATEGORY_NAMEknowledge_article_categories.CATEGORY_NAME
knowledge_article_categories__created_user_idNUMERICknowledge_article_categories.CREATED_USER_IDknowledge_article_categories.CREATED_USER_ID
knowledge_article_categories__date_created_utcTEXTknowledge_article_categories.DATE_CREATED_UTCknowledge_article_categories.DATE_CREATED_UTC
knowledge_article_categories__date_updated_utcTEXTknowledge_article_categories.DATE_UPDATED_UTCknowledge_article_categories.DATE_UPDATED_UTC
knowledge_article_categories__descriptionTEXTknowledge_article_categories.DESCRIPTIONknowledge_article_categories.DESCRIPTION

Insightly knowledge_article_folders fields

The knowledge_article_folders report of the Insightly connector includes 8 fields.

IDTypeNameDescription
knowledge_article_folders__category_idTEXTknowledge_article_folders.CATEGORY_IDknowledge_article_folders.CATEGORY_ID
knowledge_article_folders__created_user_idNUMERICknowledge_article_folders.CREATED_USER_IDknowledge_article_folders.CREATED_USER_ID
knowledge_article_folders__date_created_utcTEXTknowledge_article_folders.DATE_CREATED_UTCknowledge_article_folders.DATE_CREATED_UTC
knowledge_article_folders__date_updated_utcTEXTknowledge_article_folders.DATE_UPDATED_UTCknowledge_article_folders.DATE_UPDATED_UTC
knowledge_article_folders__folder_idNUMERICknowledge_article_folders.FOLDER_IDknowledge_article_folders.FOLDER_ID
knowledge_article_folders__folder_nameTEXTknowledge_article_folders.FOLDER_NAMEknowledge_article_folders.FOLDER_NAME
knowledge_article_folders__order_articlesTEXTknowledge_article_folders.ORDER_ARTICLESknowledge_article_folders.ORDER_ARTICLES
knowledge_article_folders__visibilityTEXTknowledge_article_folders.VISIBILITYknowledge_article_folders.VISIBILITY

Insightly knowledge_articles fields

The knowledge_articles report of the Insightly connector includes 23 fields.

IDTypeNameDescription
knowledge_articles__archived_date_utcTEXTknowledge_articles.ARCHIVED_DATE_UTCknowledge_articles.ARCHIVED_DATE_UTC
knowledge_articles__article_idNUMERICknowledge_articles.ARTICLE_IDknowledge_articles.ARTICLE_ID
knowledge_articles__article_noNUMERICknowledge_articles.ARTICLE_NOknowledge_articles.ARTICLE_NO
knowledge_articles__articleversionTEXTknowledge_articles.ArticleVersionknowledge_articles.ArticleVersion
knowledge_articles__bodyTEXTknowledge_articles.Bodyknowledge_articles.Body
knowledge_articles__category_idNUMERICknowledge_articles.CATEGORY_IDknowledge_articles.CATEGORY_ID
knowledge_articles__created_user_idNUMERICknowledge_articles.CREATED_USER_IDknowledge_articles.CREATED_USER_ID
knowledge_articles__customfieldsOBJECTknowledge_articles.CUSTOMFIELDSknowledge_articles.CUSTOMFIELDS
knowledge_articles__date_created_utcTEXTknowledge_articles.DATE_CREATED_UTCknowledge_articles.DATE_CREATED_UTC
knowledge_articles__date_updated_utcTEXTknowledge_articles.DATE_UPDATED_UTCknowledge_articles.DATE_UPDATED_UTC
knowledge_articles__downvote_countNUMERICknowledge_articles.DOWNVOTE_COUNTknowledge_articles.DOWNVOTE_COUNT
knowledge_articles__externallinkcountTEXTknowledge_articles.ExternalLinkCountknowledge_articles.ExternalLinkCount
knowledge_articles__first_published_date_utcTEXTknowledge_articles.FIRST_PUBLISHED_DATE_UTCknowledge_articles.FIRST_PUBLISHED_DATE_UTC
knowledge_articles__folder_idNUMERICknowledge_articles.FOLDER_IDknowledge_articles.FOLDER_ID
knowledge_articles__languageTEXTknowledge_articles.Languageknowledge_articles.Language
knowledge_articles__last_published_date_utcTEXTknowledge_articles.LAST_PUBLISHED_DATE_UTCknowledge_articles.LAST_PUBLISHED_DATE_UTC
knowledge_articles__owner_user_idNUMERICknowledge_articles.OWNER_USER_IDknowledge_articles.OWNER_USER_ID
knowledge_articles__promotedBOOLEANknowledge_articles.PROMOTEDknowledge_articles.PROMOTED
knowledge_articles__statusTEXTknowledge_articles.Statusknowledge_articles.Status
knowledge_articles__tagsOBJECTknowledge_articles.TAGSknowledge_articles.TAGS
knowledge_articles__titleTEXTknowledge_articles.Titleknowledge_articles.Title
knowledge_articles__upvote_countNUMERICknowledge_articles.UPVOTE_COUNTknowledge_articles.UPVOTE_COUNT
knowledge_articles__url_slugTEXTknowledge_articles.URL_SLUGknowledge_articles.URL_SLUG

Insightly lead_sources fields

The lead_sources report of the Insightly connector includes 4 fields.

IDTypeNameDescription
lead_sources__default_valueBOOLEANlead_sources.DEFAULT_VALUElead_sources.DEFAULT_VALUE
lead_sources__field_orderNUMERIClead_sources.FIELD_ORDERlead_sources.FIELD_ORDER
lead_sources__lead_sourceTEXTlead_sources.LEAD_SOURCElead_sources.LEAD_SOURCE
lead_sources__lead_source_idNUMERIClead_sources.LEAD_SOURCE_IDlead_sources.LEAD_SOURCE_ID

Insightly lead_statuses fields

The lead_statuses report of the Insightly connector includes 5 fields.

IDTypeNameDescription
lead_statuses__default_statusBOOLEANlead_statuses.DEFAULT_STATUSlead_statuses.DEFAULT_STATUS
lead_statuses__field_orderNUMERIClead_statuses.FIELD_ORDERlead_statuses.FIELD_ORDER
lead_statuses__lead_statusTEXTlead_statuses.LEAD_STATUSlead_statuses.LEAD_STATUS
lead_statuses__lead_status_idNUMERIClead_statuses.LEAD_STATUS_IDlead_statuses.LEAD_STATUS_ID
lead_statuses__status_typeNUMERIClead_statuses.STATUS_TYPElead_statuses.STATUS_TYPE

Insightly milestones fields

The milestones report of the Insightly connector includes 10 fields.

IDTypeNameDescription
milestones__completedBOOLEANmilestones.COMPLETEDmilestones.COMPLETED
milestones__completed_date_utcTEXTmilestones.COMPLETED_DATE_UTCmilestones.COMPLETED_DATE_UTC
milestones__date_created_utcTEXTmilestones.DATE_CREATED_UTCmilestones.DATE_CREATED_UTC
milestones__date_updated_utcTEXTmilestones.DATE_UPDATED_UTCmilestones.DATE_UPDATED_UTC
milestones__due_dateTEXTmilestones.DUE_DATEmilestones.DUE_DATE
milestones__milestone_idNUMERICmilestones.MILESTONE_IDmilestones.MILESTONE_ID
milestones__owner_user_idNUMERICmilestones.OWNER_USER_IDmilestones.OWNER_USER_ID
milestones__project_idNUMERICmilestones.PROJECT_IDmilestones.PROJECT_ID
milestones__responsible_userNUMERICmilestones.RESPONSIBLE_USERmilestones.RESPONSIBLE_USER
milestones__titleTEXTmilestones.TITLEmilestones.TITLE

Insightly notes fields

The notes report of the Insightly connector includes 7 fields.

IDTypeNameDescription
notes__bodyTEXTnotes.BODYnotes.BODY
notes__date_created_utcTEXTnotes.DATE_CREATED_UTCnotes.DATE_CREATED_UTC
notes__date_updated_utcTEXTnotes.DATE_UPDATED_UTCnotes.DATE_UPDATED_UTC
notes__linksOBJECTnotes.LINKSnotes.LINKS
notes__note_idNUMERICnotes.NOTE_IDnotes.NOTE_ID
notes__owner_user_idNUMERICnotes.OWNER_USER_IDnotes.OWNER_USER_ID
notes__titleTEXTnotes.TITLEnotes.TITLE

Insightly opportunities fields

The opportunities report of the Insightly connector includes 30 fields.

IDTypeNameDescription
opportunities__actual_close_dateTEXTopportunities.ACTUAL_CLOSE_DATEopportunities.ACTUAL_CLOSE_DATE
opportunities__bid_amountNUMERICopportunities.BID_AMOUNTopportunities.BID_AMOUNT
opportunities__bid_currencyTEXTopportunities.BID_CURRENCYopportunities.BID_CURRENCY
opportunities__bid_durationNUMERICopportunities.BID_DURATIONopportunities.BID_DURATION
opportunities__bid_typeTEXTopportunities.BID_TYPEopportunities.BID_TYPE
opportunities__category_idNUMERICopportunities.CATEGORY_IDopportunities.CATEGORY_ID
opportunities__created_user_idNUMERICopportunities.CREATED_USER_IDopportunities.CREATED_USER_ID
opportunities__customfieldsOBJECTopportunities.CUSTOMFIELDSopportunities.CUSTOMFIELDS
opportunities__date_created_utcTEXTopportunities.DATE_CREATED_UTCopportunities.DATE_CREATED_UTC
opportunities__date_updated_utcTEXTopportunities.DATE_UPDATED_UTCopportunities.DATE_UPDATED_UTC
opportunities__forecast_close_dateTEXTopportunities.FORECAST_CLOSE_DATEopportunities.FORECAST_CLOSE_DATE
opportunities__image_urlTEXTopportunities.IMAGE_URLopportunities.IMAGE_URL
opportunities__last_activity_date_utcTEXTopportunities.LAST_ACTIVITY_DATE_UTCopportunities.LAST_ACTIVITY_DATE_UTC
opportunities__linksOBJECTopportunities.LINKSopportunities.LINKS
opportunities__next_activity_date_utcTEXTopportunities.NEXT_ACTIVITY_DATE_UTCopportunities.NEXT_ACTIVITY_DATE_UTC
opportunities__opportunity_detailsTEXTopportunities.OPPORTUNITY_DETAILSopportunities.OPPORTUNITY_DETAILS
opportunities__opportunity_idNUMERICopportunities.OPPORTUNITY_IDopportunities.OPPORTUNITY_ID
opportunities__opportunity_nameTEXTopportunities.OPPORTUNITY_NAMEopportunities.OPPORTUNITY_NAME
opportunities__opportunity_stateTEXTopportunities.OPPORTUNITY_STATEopportunities.OPPORTUNITY_STATE
opportunities__opportunity_valueNUMERICopportunities.OPPORTUNITY_VALUEopportunities.OPPORTUNITY_VALUE
opportunities__organisation_idNUMERICopportunities.ORGANISATION_IDopportunities.ORGANISATION_ID
opportunities__owner_user_idNUMERICopportunities.OWNER_USER_IDopportunities.OWNER_USER_ID
opportunities__pipeline_idNUMERICopportunities.PIPELINE_IDopportunities.PIPELINE_ID
opportunities__pricebook_idNUMERICopportunities.PRICEBOOK_IDopportunities.PRICEBOOK_ID
opportunities__probabilityNUMERICopportunities.PROBABILITYopportunities.PROBABILITY
opportunities__responsible_user_idNUMERICopportunities.RESPONSIBLE_USER_IDopportunities.RESPONSIBLE_USER_ID
opportunities__stage_idNUMERICopportunities.STAGE_IDopportunities.STAGE_ID
opportunities__tagsOBJECTopportunities.TAGSopportunities.TAGS
opportunities__visible_team_idNUMERICopportunities.VISIBLE_TEAM_IDopportunities.VISIBLE_TEAM_ID
opportunities__visible_toTEXTopportunities.VISIBLE_TOopportunities.VISIBLE_TO

Insightly opportunity_categories fields

The opportunity_categories report of the Insightly connector includes 4 fields.

IDTypeNameDescription
opportunity_categories__activeBOOLEANopportunity_categories.ACTIVEopportunity_categories.ACTIVE
opportunity_categories__background_colorTEXTopportunity_categories.BACKGROUND_COLORopportunity_categories.BACKGROUND_COLOR
opportunity_categories__category_idNUMERICopportunity_categories.CATEGORY_IDopportunity_categories.CATEGORY_ID
opportunity_categories__category_nameTEXTopportunity_categories.CATEGORY_NAMEopportunity_categories.CATEGORY_NAME

Insightly opportunity_state_reasons fields

The opportunity_state_reasons report of the Insightly connector includes 3 fields.

IDTypeNameDescription
opportunity_state_reasons__for_opportunity_stateTEXTopportunity_state_reasons.FOR_OPPORTUNITY_STATEopportunity_state_reasons.FOR_OPPORTUNITY_STATE
opportunity_state_reasons__state_reasonTEXTopportunity_state_reasons.STATE_REASONopportunity_state_reasons.STATE_REASON
opportunity_state_reasons__state_reason_idNUMERICopportunity_state_reasons.STATE_REASON_IDopportunity_state_reasons.STATE_REASON_ID

Insightly organisations fields

The organisations report of the Insightly connector includes 33 fields.

IDTypeNameDescription
organisations__address_billing_cityTEXTorganisations.ADDRESS_BILLING_CITYorganisations.ADDRESS_BILLING_CITY
organisations__address_billing_countryTEXTorganisations.ADDRESS_BILLING_COUNTRYorganisations.ADDRESS_BILLING_COUNTRY
organisations__address_billing_postcodeTEXTorganisations.ADDRESS_BILLING_POSTCODEorganisations.ADDRESS_BILLING_POSTCODE
organisations__address_billing_stateTEXTorganisations.ADDRESS_BILLING_STATEorganisations.ADDRESS_BILLING_STATE
organisations__address_billing_streetTEXTorganisations.ADDRESS_BILLING_STREETorganisations.ADDRESS_BILLING_STREET
organisations__address_ship_cityTEXTorganisations.ADDRESS_SHIP_CITYorganisations.ADDRESS_SHIP_CITY
organisations__address_ship_countryTEXTorganisations.ADDRESS_SHIP_COUNTRYorganisations.ADDRESS_SHIP_COUNTRY
organisations__address_ship_postcodeTEXTorganisations.ADDRESS_SHIP_POSTCODEorganisations.ADDRESS_SHIP_POSTCODE
organisations__address_ship_stateTEXTorganisations.ADDRESS_SHIP_STATEorganisations.ADDRESS_SHIP_STATE
organisations__address_ship_streetTEXTorganisations.ADDRESS_SHIP_STREETorganisations.ADDRESS_SHIP_STREET
organisations__backgroundTEXTorganisations.BACKGROUNDorganisations.BACKGROUND
organisations__created_user_idNUMERICorganisations.CREATED_USER_IDorganisations.CREATED_USER_ID
organisations__customfieldsOBJECTorganisations.CUSTOMFIELDSorganisations.CUSTOMFIELDS
organisations__date_created_utcTEXTorganisations.DATE_CREATED_UTCorganisations.DATE_CREATED_UTC
organisations__date_updated_utcTEXTorganisations.DATE_UPDATED_UTCorganisations.DATE_UPDATED_UTC
organisations__datesOBJECTorganisations.DATESorganisations.DATES
organisations__emaildomainsOBJECTorganisations.EMAILDOMAINSorganisations.EMAILDOMAINS
organisations__image_urlTEXTorganisations.IMAGE_URLorganisations.IMAGE_URL
organisations__last_activity_date_utcTEXTorganisations.LAST_ACTIVITY_DATE_UTCorganisations.LAST_ACTIVITY_DATE_UTC
organisations__linksOBJECTorganisations.LINKSorganisations.LINKS
organisations__next_activity_date_utcTEXTorganisations.NEXT_ACTIVITY_DATE_UTCorganisations.NEXT_ACTIVITY_DATE_UTC
organisations__organisation_idNUMERICorganisations.ORGANISATION_IDorganisations.ORGANISATION_ID
organisations__organisation_nameTEXTorganisations.ORGANISATION_NAMEorganisations.ORGANISATION_NAME
organisations__owner_user_idNUMERICorganisations.OWNER_USER_IDorganisations.OWNER_USER_ID
organisations__phoneTEXTorganisations.PHONEorganisations.PHONE
organisations__phone_faxTEXTorganisations.PHONE_FAXorganisations.PHONE_FAX
organisations__social_facebookTEXTorganisations.SOCIAL_FACEBOOKorganisations.SOCIAL_FACEBOOK
organisations__social_linkedinTEXTorganisations.SOCIAL_LINKEDINorganisations.SOCIAL_LINKEDIN
organisations__social_twitterTEXTorganisations.SOCIAL_TWITTERorganisations.SOCIAL_TWITTER
organisations__tagsOBJECTorganisations.TAGSorganisations.TAGS
organisations__visible_team_idNUMERICorganisations.VISIBLE_TEAM_IDorganisations.VISIBLE_TEAM_ID
organisations__visible_toTEXTorganisations.VISIBLE_TOorganisations.VISIBLE_TO
organisations__websiteTEXTorganisations.WEBSITEorganisations.WEBSITE

Insightly pipeline_stages fields

The pipeline_stages report of the Insightly connector includes 6 fields.

IDTypeNameDescription
pipeline_stages__activityset_idNUMERICpipeline_stages.ACTIVITYSET_IDpipeline_stages.ACTIVITYSET_ID
pipeline_stages__owner_user_idNUMERICpipeline_stages.OWNER_USER_IDpipeline_stages.OWNER_USER_ID
pipeline_stages__pipeline_idNUMERICpipeline_stages.PIPELINE_IDpipeline_stages.PIPELINE_ID
pipeline_stages__stage_idNUMERICpipeline_stages.STAGE_IDpipeline_stages.STAGE_ID
pipeline_stages__stage_nameTEXTpipeline_stages.STAGE_NAMEpipeline_stages.STAGE_NAME
pipeline_stages__stage_orderNUMERICpipeline_stages.STAGE_ORDERpipeline_stages.STAGE_ORDER

Insightly pipelines fields

The pipelines report of the Insightly connector includes 5 fields.

IDTypeNameDescription
pipelines__for_opportunitiesBOOLEANpipelines.FOR_OPPORTUNITIESpipelines.FOR_OPPORTUNITIES
pipelines__for_projectsBOOLEANpipelines.FOR_PROJECTSpipelines.FOR_PROJECTS
pipelines__owner_user_idNUMERICpipelines.OWNER_USER_IDpipelines.OWNER_USER_ID
pipelines__pipeline_idNUMERICpipelines.PIPELINE_IDpipelines.PIPELINE_ID
pipelines__pipeline_nameTEXTpipelines.PIPELINE_NAMEpipelines.PIPELINE_NAME

Insightly project_categories fields

The project_categories report of the Insightly connector includes 4 fields.

IDTypeNameDescription
project_categories__activeBOOLEANproject_categories.ACTIVEproject_categories.ACTIVE
project_categories__background_colorTEXTproject_categories.BACKGROUND_COLORproject_categories.BACKGROUND_COLOR
project_categories__category_idNUMERICproject_categories.CATEGORY_IDproject_categories.CATEGORY_ID
project_categories__category_nameTEXTproject_categories.CATEGORY_NAMEproject_categories.CATEGORY_NAME

Insightly projects fields

The projects report of the Insightly connector includes 23 fields.

IDTypeNameDescription
projects__category_idNUMERICprojects.CATEGORY_IDprojects.CATEGORY_ID
projects__completed_dateTEXTprojects.COMPLETED_DATEprojects.COMPLETED_DATE
projects__created_user_idNUMERICprojects.CREATED_USER_IDprojects.CREATED_USER_ID
projects__customfieldsOBJECTprojects.CUSTOMFIELDSprojects.CUSTOMFIELDS
projects__date_created_utcTEXTprojects.DATE_CREATED_UTCprojects.DATE_CREATED_UTC
projects__date_updated_utcTEXTprojects.DATE_UPDATED_UTCprojects.DATE_UPDATED_UTC
projects__image_urlTEXTprojects.IMAGE_URLprojects.IMAGE_URL
projects__last_activity_date_utcTEXTprojects.LAST_ACTIVITY_DATE_UTCprojects.LAST_ACTIVITY_DATE_UTC
projects__linksOBJECTprojects.LINKSprojects.LINKS
projects__next_activity_date_utcTEXTprojects.NEXT_ACTIVITY_DATE_UTCprojects.NEXT_ACTIVITY_DATE_UTC
projects__opportunity_idNUMERICprojects.OPPORTUNITY_IDprojects.OPPORTUNITY_ID
projects__owner_user_idNUMERICprojects.OWNER_USER_IDprojects.OWNER_USER_ID
projects__pipeline_idNUMERICprojects.PIPELINE_IDprojects.PIPELINE_ID
projects__project_detailsTEXTprojects.PROJECT_DETAILSprojects.PROJECT_DETAILS
projects__project_idNUMERICprojects.PROJECT_IDprojects.PROJECT_ID
projects__project_nameTEXTprojects.PROJECT_NAMEprojects.PROJECT_NAME
projects__responsible_user_idNUMERICprojects.RESPONSIBLE_USER_IDprojects.RESPONSIBLE_USER_ID
projects__stage_idNUMERICprojects.STAGE_IDprojects.STAGE_ID
projects__started_dateTEXTprojects.STARTED_DATEprojects.STARTED_DATE
projects__statusTEXTprojects.STATUSprojects.STATUS
projects__tagsOBJECTprojects.TAGSprojects.TAGS
projects__visible_team_idNUMERICprojects.VISIBLE_TEAM_IDprojects.VISIBLE_TEAM_ID
projects__visible_toTEXTprojects.VISIBLE_TOprojects.VISIBLE_TO

Insightly prospects fields

The prospects report of the Insightly connector includes 37 fields.

IDTypeNameDescription
prospects__address_cityTEXTprospects.ADDRESS_CITYprospects.ADDRESS_CITY
prospects__address_countryTEXTprospects.ADDRESS_COUNTRYprospects.ADDRESS_COUNTRY
prospects__address_postcodeTEXTprospects.ADDRESS_POSTCODEprospects.ADDRESS_POSTCODE
prospects__address_stateTEXTprospects.ADDRESS_STATEprospects.ADDRESS_STATE
prospects__address_streetTEXTprospects.ADDRESS_STREETprospects.ADDRESS_STREET
prospects__contact_idNUMERICprospects.CONTACT_IDprospects.CONTACT_ID
prospects__created_user_idNUMERICprospects.CREATED_USER_IDprospects.CREATED_USER_ID
prospects__customfieldsOBJECTprospects.CUSTOMFIELDSprospects.CUSTOMFIELDS
prospects__date_created_utcTEXTprospects.DATE_CREATED_UTCprospects.DATE_CREATED_UTC
prospects__date_updated_utcTEXTprospects.DATE_UPDATED_UTCprospects.DATE_UPDATED_UTC
prospects__descriptionTEXTprospects.DESCRIPTIONprospects.DESCRIPTION
prospects__do_not_callBOOLEANprospects.DO_NOT_CALLprospects.DO_NOT_CALL
prospects__do_not_emailBOOLEANprospects.DO_NOT_EMAILprospects.DO_NOT_EMAIL
prospects__do_not_syncBOOLEANprospects.DO_NOT_SYNCprospects.DO_NOT_SYNC
prospects__email_addressTEXTprospects.EMAIL_ADDRESSprospects.EMAIL_ADDRESS
prospects__employee_countNUMERICprospects.EMPLOYEE_COUNTprospects.EMPLOYEE_COUNT
prospects__faxTEXTprospects.FAXprospects.FAX
prospects__first_nameTEXTprospects.FIRST_NAMEprospects.FIRST_NAME
prospects__gradeTEXTprospects.GRADEprospects.GRADE
prospects__grade_profile_idNUMERICprospects.GRADE_PROFILE_IDprospects.GRADE_PROFILE_ID
prospects__industryTEXTprospects.INDUSTRYprospects.INDUSTRY
prospects__last_activity_date_utcTEXTprospects.LAST_ACTIVITY_DATE_UTCprospects.LAST_ACTIVITY_DATE_UTC
prospects__last_nameTEXTprospects.LAST_NAMEprospects.LAST_NAME
prospects__lead_conversion_date_utcTEXTprospects.LEAD_CONVERSION_DATE_UTCprospects.LEAD_CONVERSION_DATE_UTC
prospects__lead_idNUMERICprospects.LEAD_IDprospects.LEAD_ID
prospects__mobileTEXTprospects.MOBILEprospects.MOBILE
prospects__opted_outBOOLEANprospects.OPTED_OUTprospects.OPTED_OUT
prospects__organisation_idNUMERICprospects.ORGANISATION_IDprospects.ORGANISATION_ID
prospects__organisation_nameTEXTprospects.ORGANISATION_NAMEprospects.ORGANISATION_NAME
prospects__owner_user_idNUMERICprospects.OWNER_USER_IDprospects.OWNER_USER_ID
prospects__phoneTEXTprospects.PHONEprospects.PHONE
prospects__prospect_idNUMERICprospects.PROSPECT_IDprospects.PROSPECT_ID
prospects__salutationTEXTprospects.SALUTATIONprospects.SALUTATION
prospects__scoreNUMERICprospects.SCOREprospects.SCORE
prospects__tagsOBJECTprospects.TAGSprospects.TAGS
prospects__titleTEXTprospects.TITLEprospects.TITLE
prospects__websiteTEXTprospects.WEBSITEprospects.WEBSITE

Insightly relationships fields

The relationships report of the Insightly connector includes 7 fields.

IDTypeNameDescription
relationships__for_contactsBOOLEANrelationships.FOR_CONTACTSrelationships.FOR_CONTACTS
relationships__for_organisationsBOOLEANrelationships.FOR_ORGANISATIONSrelationships.FOR_ORGANISATIONS
relationships__forwardTEXTrelationships.FORWARDrelationships.FORWARD
relationships__forward_titleTEXTrelationships.FORWARD_TITLErelationships.FORWARD_TITLE
relationships__relationship_idNUMERICrelationships.RELATIONSHIP_IDrelationships.RELATIONSHIP_ID
relationships__reverseTEXTrelationships.REVERSErelationships.REVERSE
relationships__reverse_titleTEXTrelationships.REVERSE_TITLErelationships.REVERSE_TITLE

Insightly task_categories fields

The task_categories report of the Insightly connector includes 4 fields.

IDTypeNameDescription
task_categories__activeBOOLEANtask_categories.ACTIVEtask_categories.ACTIVE
task_categories__background_colorTEXTtask_categories.BACKGROUND_COLORtask_categories.BACKGROUND_COLOR
task_categories__category_idNUMERICtask_categories.CATEGORY_IDtask_categories.CATEGORY_ID
task_categories__category_nameTEXTtask_categories.CATEGORY_NAMEtask_categories.CATEGORY_NAME

Insightly tasks fields

The tasks report of the Insightly connector includes 32 fields.

IDTypeNameDescription
tasks__assigned_by_user_idNUMERICtasks.ASSIGNED_BY_USER_IDtasks.ASSIGNED_BY_USER_ID
tasks__assigned_date_utcTEXTtasks.ASSIGNED_DATE_UTCtasks.ASSIGNED_DATE_UTC
tasks__assigned_team_idNUMERICtasks.ASSIGNED_TEAM_IDtasks.ASSIGNED_TEAM_ID
tasks__category_idNUMERICtasks.CATEGORY_IDtasks.CATEGORY_ID
tasks__completedBOOLEANtasks.COMPLETEDtasks.COMPLETED
tasks__completed_date_utcTEXTtasks.COMPLETED_DATE_UTCtasks.COMPLETED_DATE_UTC
tasks__created_user_idNUMERICtasks.CREATED_USER_IDtasks.CREATED_USER_ID
tasks__customfieldsOBJECTtasks.CUSTOMFIELDStasks.CUSTOMFIELDS
tasks__date_created_utcTEXTtasks.DATE_CREATED_UTCtasks.DATE_CREATED_UTC
tasks__date_updated_utcTEXTtasks.DATE_UPDATED_UTCtasks.DATE_UPDATED_UTC
tasks__detailsTEXTtasks.DETAILStasks.DETAILS
tasks__due_dateTEXTtasks.DUE_DATEtasks.DUE_DATE
tasks__email_idNUMERICtasks.EMAIL_IDtasks.EMAIL_ID
tasks__linksOBJECTtasks.LINKStasks.LINKS
tasks__milestone_idNUMERICtasks.MILESTONE_IDtasks.MILESTONE_ID
tasks__opportunity_idNUMERICtasks.OPPORTUNITY_IDtasks.OPPORTUNITY_ID
tasks__owner_user_idNUMERICtasks.OWNER_USER_IDtasks.OWNER_USER_ID
tasks__owner_visibleBOOLEANtasks.OWNER_VISIBLEtasks.OWNER_VISIBLE
tasks__parent_task_idNUMERICtasks.PARENT_TASK_IDtasks.PARENT_TASK_ID
tasks__percent_completeNUMERICtasks.PERCENT_COMPLETEtasks.PERCENT_COMPLETE
tasks__priorityNUMERICtasks.PRIORITYtasks.PRIORITY
tasks__project_idNUMERICtasks.PROJECT_IDtasks.PROJECT_ID
tasks__publicly_visibleBOOLEANtasks.PUBLICLY_VISIBLEtasks.PUBLICLY_VISIBLE
tasks__recurrenceTEXTtasks.RECURRENCEtasks.RECURRENCE
tasks__reminder_date_utcTEXTtasks.REMINDER_DATE_UTCtasks.REMINDER_DATE_UTC
tasks__reminder_sentBOOLEANtasks.REMINDER_SENTtasks.REMINDER_SENT
tasks__responsible_user_idNUMERICtasks.RESPONSIBLE_USER_IDtasks.RESPONSIBLE_USER_ID
tasks__stage_idNUMERICtasks.STAGE_IDtasks.STAGE_ID
tasks__start_dateTEXTtasks.START_DATEtasks.START_DATE
tasks__statusTEXTtasks.STATUStasks.STATUS
tasks__task_idNUMERICtasks.TASK_IDtasks.TASK_ID
tasks__titleTEXTtasks.TITLEtasks.TITLE

Insightly team_members fields

The team_members report of the Insightly connector includes 3 fields.

IDTypeNameDescription
team_members__member_user_idNUMERICteam_members.MEMBER_USER_IDteam_members.MEMBER_USER_ID
team_members__permission_idNUMERICteam_members.PERMISSION_IDteam_members.PERMISSION_ID
team_members__team_idNUMERICteam_members.TEAM_IDteam_members.TEAM_ID

Insightly teams fields

The teams report of the Insightly connector includes 6 fields.

IDTypeNameDescription
teams__anonymous_teamBOOLEANteams.ANONYMOUS_TEAMteams.ANONYMOUS_TEAM
teams__date_created_utcTEXTteams.DATE_CREATED_UTCteams.DATE_CREATED_UTC
teams__date_updated_utcTEXTteams.DATE_UPDATED_UTCteams.DATE_UPDATED_UTC
teams__team_idNUMERICteams.TEAM_IDteams.TEAM_ID
teams__team_nameTEXTteams.TEAM_NAMEteams.TEAM_NAME
teams__teammembersOBJECTteams.TEAMMEMBERSteams.TEAMMEMBERS

Insightly users fields

The users report of the Insightly connector includes 20 fields.

IDTypeNameDescription
users__account_ownerBOOLEANusers.ACCOUNT_OWNERusers.ACCOUNT_OWNER
users__activeBOOLEANusers.ACTIVEusers.ACTIVE
users__administratorBOOLEANusers.ADMINISTRATORusers.ADMINISTRATOR
users__contact_displayTEXTusers.CONTACT_DISPLAYusers.CONTACT_DISPLAY
users__contact_idNUMERICusers.CONTACT_IDusers.CONTACT_ID
users__contact_orderTEXTusers.CONTACT_ORDERusers.CONTACT_ORDER
users__date_created_utcTEXTusers.DATE_CREATED_UTCusers.DATE_CREATED_UTC
users__date_updated_utcTEXTusers.DATE_UPDATED_UTCusers.DATE_UPDATED_UTC
users__email_addressTEXTusers.EMAIL_ADDRESSusers.EMAIL_ADDRESS
users__email_dropbox_addressTEXTusers.EMAIL_DROPBOX_ADDRESSusers.EMAIL_DROPBOX_ADDRESS
users__email_dropbox_identifierTEXTusers.EMAIL_DROPBOX_IDENTIFIERusers.EMAIL_DROPBOX_IDENTIFIER
users__first_nameTEXTusers.FIRST_NAMEusers.FIRST_NAME
users__instance_idNUMERICusers.INSTANCE_IDusers.INSTANCE_ID
users__last_nameTEXTusers.LAST_NAMEusers.LAST_NAME
users__profile_idNUMERICusers.PROFILE_IDusers.PROFILE_ID
users__role_idNUMERICusers.ROLE_IDusers.ROLE_ID
users__task_week_startNUMERICusers.TASK_WEEK_STARTusers.TASK_WEEK_START
users__timezone_idTEXTusers.TIMEZONE_IDusers.TIMEZONE_ID
users__user_currencyTEXTusers.USER_CURRENCYusers.USER_CURRENCY
users__user_idNUMERICusers.USER_IDusers.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.

IDTypeNameDescriptionReport
countries__country_nameTEXTcountries.COUNTRY_NAMEcountries.COUNTRY_NAMEcountries
currencies__currency_codeTEXTcurrencies.CURRENCY_CODEcurrencies.CURRENCY_CODEcurrencies
currencies__currency_symbolTEXTcurrencies.CURRENCY_SYMBOLcurrencies.CURRENCY_SYMBOLcurrencies
data_fetched_atTIMESTAMPData fetched atUTC 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.
datasourceTEXTData SourceThe name of the Windsor connector returning the row
nowTIMESTAMPNowCurrent timestamp
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date