Windsor brings all your Insightly data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL

Insightly Field Reference

Fields

ID	Type	Name	Description	Report
activity_sets__activities	OBJECT	activity_sets.ACTIVITIES	activity_sets.ACTIVITIES	activity_sets
activity_sets__activityset_id	NUMERIC	activity_sets.ACTIVITYSET_ID	activity_sets.ACTIVITYSET_ID	activity_sets
activity_sets__for_contacts	BOOLEAN	activity_sets.FOR_CONTACTS	activity_sets.FOR_CONTACTS	activity_sets
activity_sets__for_leads	BOOLEAN	activity_sets.FOR_LEADS	activity_sets.FOR_LEADS	activity_sets
activity_sets__for_opportunities	BOOLEAN	activity_sets.FOR_OPPORTUNITIES	activity_sets.FOR_OPPORTUNITIES	activity_sets
activity_sets__for_organisations	BOOLEAN	activity_sets.FOR_ORGANISATIONS	activity_sets.FOR_ORGANISATIONS	activity_sets
activity_sets__for_projects	BOOLEAN	activity_sets.FOR_PROJECTS	activity_sets.FOR_PROJECTS	activity_sets
activity_sets__name	TEXT	activity_sets.NAME	activity_sets.NAME	activity_sets
activity_sets__owner_user_id	NUMERIC	activity_sets.OWNER_USER_ID	activity_sets.OWNER_USER_ID	activity_sets
contacts__address_mail_city	TEXT	contacts.ADDRESS_MAIL_CITY	contacts.ADDRESS_MAIL_CITY	contacts
contacts__address_mail_country	TEXT	contacts.ADDRESS_MAIL_COUNTRY	contacts.ADDRESS_MAIL_COUNTRY	contacts
contacts__address_mail_postcode	TEXT	contacts.ADDRESS_MAIL_POSTCODE	contacts.ADDRESS_MAIL_POSTCODE	contacts
contacts__address_mail_state	TEXT	contacts.ADDRESS_MAIL_STATE	contacts.ADDRESS_MAIL_STATE	contacts
contacts__address_mail_street	TEXT	contacts.ADDRESS_MAIL_STREET	contacts.ADDRESS_MAIL_STREET	contacts
contacts__address_other_city	TEXT	contacts.ADDRESS_OTHER_CITY	contacts.ADDRESS_OTHER_CITY	contacts
contacts__address_other_country	TEXT	contacts.ADDRESS_OTHER_COUNTRY	contacts.ADDRESS_OTHER_COUNTRY	contacts
contacts__address_other_postcode	TEXT	contacts.ADDRESS_OTHER_POSTCODE	contacts.ADDRESS_OTHER_POSTCODE	contacts
contacts__address_other_state	TEXT	contacts.ADDRESS_OTHER_STATE	contacts.ADDRESS_OTHER_STATE	contacts
contacts__address_other_street	TEXT	contacts.ADDRESS_OTHER_STREET	contacts.ADDRESS_OTHER_STREET	contacts
contacts__assistant_name	TEXT	contacts.ASSISTANT_NAME	contacts.ASSISTANT_NAME	contacts
contacts__background	TEXT	contacts.BACKGROUND	contacts.BACKGROUND	contacts
contacts__contact_id	NUMERIC	contacts.CONTACT_ID	contacts.CONTACT_ID	contacts
contacts__created_user_id	NUMERIC	contacts.CREATED_USER_ID	contacts.CREATED_USER_ID	contacts
contacts__customfields	OBJECT	contacts.CUSTOMFIELDS	contacts.CUSTOMFIELDS	contacts
contacts__date_created_utc	TEXT	contacts.DATE_CREATED_UTC	contacts.DATE_CREATED_UTC	contacts
contacts__date_of_birth	TEXT	contacts.DATE_OF_BIRTH	contacts.DATE_OF_BIRTH	contacts
contacts__date_updated_utc	TEXT	contacts.DATE_UPDATED_UTC	contacts.DATE_UPDATED_UTC	contacts
contacts__dates	OBJECT	contacts.DATES	contacts.DATES	contacts
contacts__email_address	TEXT	contacts.EMAIL_ADDRESS	contacts.EMAIL_ADDRESS	contacts
contacts__email_opted_out	BOOLEAN	contacts.EMAIL_OPTED_OUT	contacts.EMAIL_OPTED_OUT	contacts
contacts__first_name	TEXT	contacts.FIRST_NAME	contacts.FIRST_NAME	contacts
contacts__image_url	TEXT	contacts.IMAGE_URL	contacts.IMAGE_URL	contacts
contacts__last_activity_date_utc	TEXT	contacts.LAST_ACTIVITY_DATE_UTC	contacts.LAST_ACTIVITY_DATE_UTC	contacts
contacts__last_name	TEXT	contacts.LAST_NAME	contacts.LAST_NAME	contacts
contacts__links	OBJECT	contacts.LINKS	contacts.LINKS	contacts
contacts__next_activity_date_utc	TEXT	contacts.NEXT_ACTIVITY_DATE_UTC	contacts.NEXT_ACTIVITY_DATE_UTC	contacts
contacts__organisation_id	NUMERIC	contacts.ORGANISATION_ID	contacts.ORGANISATION_ID	contacts
contacts__owner_user_id	NUMERIC	contacts.OWNER_USER_ID	contacts.OWNER_USER_ID	contacts
contacts__phone	TEXT	contacts.PHONE	contacts.PHONE	contacts
contacts__phone_assistant	TEXT	contacts.PHONE_ASSISTANT	contacts.PHONE_ASSISTANT	contacts
contacts__phone_fax	TEXT	contacts.PHONE_FAX	contacts.PHONE_FAX	contacts
contacts__phone_home	TEXT	contacts.PHONE_HOME	contacts.PHONE_HOME	contacts
contacts__phone_mobile	TEXT	contacts.PHONE_MOBILE	contacts.PHONE_MOBILE	contacts
contacts__phone_other	TEXT	contacts.PHONE_OTHER	contacts.PHONE_OTHER	contacts
contacts__salutation	TEXT	contacts.SALUTATION	contacts.SALUTATION	contacts
contacts__social_facebook	TEXT	contacts.SOCIAL_FACEBOOK	contacts.SOCIAL_FACEBOOK	contacts
contacts__social_linkedin	TEXT	contacts.SOCIAL_LINKEDIN	contacts.SOCIAL_LINKEDIN	contacts
contacts__social_twitter	TEXT	contacts.SOCIAL_TWITTER	contacts.SOCIAL_TWITTER	contacts
contacts__tags	OBJECT	contacts.TAGS	contacts.TAGS	contacts
contacts__title	TEXT	contacts.TITLE	contacts.TITLE	contacts
contacts__visible_team_id	NUMERIC	contacts.VISIBLE_TEAM_ID	contacts.VISIBLE_TEAM_ID	contacts
contacts__visible_to	TEXT	contacts.VISIBLE_TO	contacts.VISIBLE_TO	contacts
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
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
emails__created_user_id	NUMERIC	emails.CREATED_USER_ID	emails.CREATED_USER_ID	emails
emails__date_created_utc	TEXT	emails.DATE_CREATED_UTC	emails.DATE_CREATED_UTC	emails
emails__email_date_utc	TEXT	emails.EMAIL_DATE_UTC	emails.EMAIL_DATE_UTC	emails
emails__email_from	TEXT	emails.EMAIL_FROM	emails.EMAIL_FROM	emails
emails__email_id	NUMERIC	emails.EMAIL_ID	emails.EMAIL_ID	emails
emails__format	TEXT	emails.FORMAT	emails.FORMAT	emails
emails__links	OBJECT	emails.LINKS	emails.LINKS	emails
emails__owner_user_id	NUMERIC	emails.OWNER_USER_ID	emails.OWNER_USER_ID	emails
emails__queued_send_date_utc	TEXT	emails.QUEUED_SEND_DATE_UTC	emails.QUEUED_SEND_DATE_UTC	emails
emails__size	NUMERIC	emails.SIZE	emails.SIZE	emails
emails__subject	TEXT	emails.SUBJECT	emails.SUBJECT	emails
emails__tags	OBJECT	emails.TAGS	emails.TAGS	emails
events__all_day	BOOLEAN	events.ALL_DAY	events.ALL_DAY	events
events__customfields	OBJECT	events.CUSTOMFIELDS	events.CUSTOMFIELDS	events
events__date_created_utc	TEXT	events.DATE_CREATED_UTC	events.DATE_CREATED_UTC	events
events__date_updated_utc	TEXT	events.DATE_UPDATED_UTC	events.DATE_UPDATED_UTC	events
events__details	TEXT	events.DETAILS	events.DETAILS	events
events__end_date_utc	TEXT	events.END_DATE_UTC	events.END_DATE_UTC	events
events__event_id	NUMERIC	events.EVENT_ID	events.EVENT_ID	events
events__links	OBJECT	events.LINKS	events.LINKS	events
events__location	TEXT	events.LOCATION	events.LOCATION	events
events__owner_user_id	NUMERIC	events.OWNER_USER_ID	events.OWNER_USER_ID	events
events__reminder_date_utc	TEXT	events.REMINDER_DATE_UTC	events.REMINDER_DATE_UTC	events
events__reminder_sent	BOOLEAN	events.REMINDER_SENT	events.REMINDER_SENT	events
events__start_date_utc	TEXT	events.START_DATE_UTC	events.START_DATE_UTC	events
events__title	TEXT	events.TITLE	events.TITLE	events
knowledge_article_categories__category_id	NUMERIC	knowledge_article_categories.CATEGORY_ID	knowledge_article_categories.CATEGORY_ID	knowledge_article_categories
knowledge_article_categories__category_name	TEXT	knowledge_article_categories.CATEGORY_NAME	knowledge_article_categories.CATEGORY_NAME	knowledge_article_categories
knowledge_article_categories__created_user_id	NUMERIC	knowledge_article_categories.CREATED_USER_ID	knowledge_article_categories.CREATED_USER_ID	knowledge_article_categories
knowledge_article_categories__date_created_utc	TEXT	knowledge_article_categories.DATE_CREATED_UTC	knowledge_article_categories.DATE_CREATED_UTC	knowledge_article_categories
knowledge_article_categories__date_updated_utc	TEXT	knowledge_article_categories.DATE_UPDATED_UTC	knowledge_article_categories.DATE_UPDATED_UTC	knowledge_article_categories
knowledge_article_categories__description	TEXT	knowledge_article_categories.DESCRIPTION	knowledge_article_categories.DESCRIPTION	knowledge_article_categories
knowledge_article_folders__category_id	TEXT	knowledge_article_folders.CATEGORY_ID	knowledge_article_folders.CATEGORY_ID	knowledge_article_folders
knowledge_article_folders__created_user_id	NUMERIC	knowledge_article_folders.CREATED_USER_ID	knowledge_article_folders.CREATED_USER_ID	knowledge_article_folders
knowledge_article_folders__date_created_utc	TEXT	knowledge_article_folders.DATE_CREATED_UTC	knowledge_article_folders.DATE_CREATED_UTC	knowledge_article_folders
knowledge_article_folders__date_updated_utc	TEXT	knowledge_article_folders.DATE_UPDATED_UTC	knowledge_article_folders.DATE_UPDATED_UTC	knowledge_article_folders
knowledge_article_folders__folder_id	NUMERIC	knowledge_article_folders.FOLDER_ID	knowledge_article_folders.FOLDER_ID	knowledge_article_folders
knowledge_article_folders__folder_name	TEXT	knowledge_article_folders.FOLDER_NAME	knowledge_article_folders.FOLDER_NAME	knowledge_article_folders
knowledge_article_folders__order_articles	TEXT	knowledge_article_folders.ORDER_ARTICLES	knowledge_article_folders.ORDER_ARTICLES	knowledge_article_folders
knowledge_article_folders__visibility	TEXT	knowledge_article_folders.VISIBILITY	knowledge_article_folders.VISIBILITY	knowledge_article_folders
knowledge_articles__archived_date_utc	TEXT	knowledge_articles.ARCHIVED_DATE_UTC	knowledge_articles.ARCHIVED_DATE_UTC	knowledge_articles
knowledge_articles__article_id	NUMERIC	knowledge_articles.ARTICLE_ID	knowledge_articles.ARTICLE_ID	knowledge_articles
knowledge_articles__article_no	NUMERIC	knowledge_articles.ARTICLE_NO	knowledge_articles.ARTICLE_NO	knowledge_articles
knowledge_articles__articleversion	TEXT	knowledge_articles.ArticleVersion	knowledge_articles.ArticleVersion	knowledge_articles
knowledge_articles__body	TEXT	knowledge_articles.Body	knowledge_articles.Body	knowledge_articles
knowledge_articles__category_id	NUMERIC	knowledge_articles.CATEGORY_ID	knowledge_articles.CATEGORY_ID	knowledge_articles
knowledge_articles__created_user_id	NUMERIC	knowledge_articles.CREATED_USER_ID	knowledge_articles.CREATED_USER_ID	knowledge_articles
knowledge_articles__customfields	OBJECT	knowledge_articles.CUSTOMFIELDS	knowledge_articles.CUSTOMFIELDS	knowledge_articles
knowledge_articles__date_created_utc	TEXT	knowledge_articles.DATE_CREATED_UTC	knowledge_articles.DATE_CREATED_UTC	knowledge_articles
knowledge_articles__date_updated_utc	TEXT	knowledge_articles.DATE_UPDATED_UTC	knowledge_articles.DATE_UPDATED_UTC	knowledge_articles
knowledge_articles__downvote_count	NUMERIC	knowledge_articles.DOWNVOTE_COUNT	knowledge_articles.DOWNVOTE_COUNT	knowledge_articles
knowledge_articles__externallinkcount	TEXT	knowledge_articles.ExternalLinkCount	knowledge_articles.ExternalLinkCount	knowledge_articles
knowledge_articles__first_published_date_utc	TEXT	knowledge_articles.FIRST_PUBLISHED_DATE_UTC	knowledge_articles.FIRST_PUBLISHED_DATE_UTC	knowledge_articles
knowledge_articles__folder_id	NUMERIC	knowledge_articles.FOLDER_ID	knowledge_articles.FOLDER_ID	knowledge_articles
knowledge_articles__language	TEXT	knowledge_articles.Language	knowledge_articles.Language	knowledge_articles
knowledge_articles__last_published_date_utc	TEXT	knowledge_articles.LAST_PUBLISHED_DATE_UTC	knowledge_articles.LAST_PUBLISHED_DATE_UTC	knowledge_articles
knowledge_articles__owner_user_id	NUMERIC	knowledge_articles.OWNER_USER_ID	knowledge_articles.OWNER_USER_ID	knowledge_articles
knowledge_articles__promoted	BOOLEAN	knowledge_articles.PROMOTED	knowledge_articles.PROMOTED	knowledge_articles
knowledge_articles__status	TEXT	knowledge_articles.Status	knowledge_articles.Status	knowledge_articles
knowledge_articles__tags	OBJECT	knowledge_articles.TAGS	knowledge_articles.TAGS	knowledge_articles
knowledge_articles__title	TEXT	knowledge_articles.Title	knowledge_articles.Title	knowledge_articles
knowledge_articles__upvote_count	NUMERIC	knowledge_articles.UPVOTE_COUNT	knowledge_articles.UPVOTE_COUNT	knowledge_articles
knowledge_articles__url_slug	TEXT	knowledge_articles.URL_SLUG	knowledge_articles.URL_SLUG	knowledge_articles
lead_sources__default_value	BOOLEAN	lead_sources.DEFAULT_VALUE	lead_sources.DEFAULT_VALUE	lead_sources
lead_sources__field_order	NUMERIC	lead_sources.FIELD_ORDER	lead_sources.FIELD_ORDER	lead_sources
lead_sources__lead_source	TEXT	lead_sources.LEAD_SOURCE	lead_sources.LEAD_SOURCE	lead_sources
lead_sources__lead_source_id	NUMERIC	lead_sources.LEAD_SOURCE_ID	lead_sources.LEAD_SOURCE_ID	lead_sources
lead_statuses__default_status	BOOLEAN	lead_statuses.DEFAULT_STATUS	lead_statuses.DEFAULT_STATUS	lead_statuses
lead_statuses__field_order	NUMERIC	lead_statuses.FIELD_ORDER	lead_statuses.FIELD_ORDER	lead_statuses
lead_statuses__lead_status	TEXT	lead_statuses.LEAD_STATUS	lead_statuses.LEAD_STATUS	lead_statuses
lead_statuses__lead_status_id	NUMERIC	lead_statuses.LEAD_STATUS_ID	lead_statuses.LEAD_STATUS_ID	lead_statuses
lead_statuses__status_type	NUMERIC	lead_statuses.STATUS_TYPE	lead_statuses.STATUS_TYPE	lead_statuses
milestones__completed	BOOLEAN	milestones.COMPLETED	milestones.COMPLETED	milestones
milestones__completed_date_utc	TEXT	milestones.COMPLETED_DATE_UTC	milestones.COMPLETED_DATE_UTC	milestones
milestones__date_created_utc	TEXT	milestones.DATE_CREATED_UTC	milestones.DATE_CREATED_UTC	milestones
milestones__date_updated_utc	TEXT	milestones.DATE_UPDATED_UTC	milestones.DATE_UPDATED_UTC	milestones
milestones__due_date	TEXT	milestones.DUE_DATE	milestones.DUE_DATE	milestones
milestones__milestone_id	NUMERIC	milestones.MILESTONE_ID	milestones.MILESTONE_ID	milestones
milestones__owner_user_id	NUMERIC	milestones.OWNER_USER_ID	milestones.OWNER_USER_ID	milestones
milestones__project_id	NUMERIC	milestones.PROJECT_ID	milestones.PROJECT_ID	milestones
milestones__responsible_user	NUMERIC	milestones.RESPONSIBLE_USER	milestones.RESPONSIBLE_USER	milestones
milestones__title	TEXT	milestones.TITLE	milestones.TITLE	milestones
notes__body	TEXT	notes.BODY	notes.BODY	notes
notes__date_created_utc	TEXT	notes.DATE_CREATED_UTC	notes.DATE_CREATED_UTC	notes
notes__date_updated_utc	TEXT	notes.DATE_UPDATED_UTC	notes.DATE_UPDATED_UTC	notes
notes__links	OBJECT	notes.LINKS	notes.LINKS	notes
notes__note_id	NUMERIC	notes.NOTE_ID	notes.NOTE_ID	notes
notes__owner_user_id	NUMERIC	notes.OWNER_USER_ID	notes.OWNER_USER_ID	notes
notes__title	TEXT	notes.TITLE	notes.TITLE	notes
opportunities__actual_close_date	TEXT	opportunities.ACTUAL_CLOSE_DATE	opportunities.ACTUAL_CLOSE_DATE	opportunities
opportunities__bid_amount	NUMERIC	opportunities.BID_AMOUNT	opportunities.BID_AMOUNT	opportunities
opportunities__bid_currency	TEXT	opportunities.BID_CURRENCY	opportunities.BID_CURRENCY	opportunities
opportunities__bid_duration	NUMERIC	opportunities.BID_DURATION	opportunities.BID_DURATION	opportunities
opportunities__bid_type	TEXT	opportunities.BID_TYPE	opportunities.BID_TYPE	opportunities
opportunities__category_id	NUMERIC	opportunities.CATEGORY_ID	opportunities.CATEGORY_ID	opportunities
opportunities__created_user_id	NUMERIC	opportunities.CREATED_USER_ID	opportunities.CREATED_USER_ID	opportunities
opportunities__customfields	OBJECT	opportunities.CUSTOMFIELDS	opportunities.CUSTOMFIELDS	opportunities
opportunities__date_created_utc	TEXT	opportunities.DATE_CREATED_UTC	opportunities.DATE_CREATED_UTC	opportunities
opportunities__date_updated_utc	TEXT	opportunities.DATE_UPDATED_UTC	opportunities.DATE_UPDATED_UTC	opportunities
opportunities__forecast_close_date	TEXT	opportunities.FORECAST_CLOSE_DATE	opportunities.FORECAST_CLOSE_DATE	opportunities
opportunities__image_url	TEXT	opportunities.IMAGE_URL	opportunities.IMAGE_URL	opportunities
opportunities__last_activity_date_utc	TEXT	opportunities.LAST_ACTIVITY_DATE_UTC	opportunities.LAST_ACTIVITY_DATE_UTC	opportunities
opportunities__links	OBJECT	opportunities.LINKS	opportunities.LINKS	opportunities
opportunities__next_activity_date_utc	TEXT	opportunities.NEXT_ACTIVITY_DATE_UTC	opportunities.NEXT_ACTIVITY_DATE_UTC	opportunities
opportunities__opportunity_details	TEXT	opportunities.OPPORTUNITY_DETAILS	opportunities.OPPORTUNITY_DETAILS	opportunities
opportunities__opportunity_id	NUMERIC	opportunities.OPPORTUNITY_ID	opportunities.OPPORTUNITY_ID	opportunities
opportunities__opportunity_name	TEXT	opportunities.OPPORTUNITY_NAME	opportunities.OPPORTUNITY_NAME	opportunities
opportunities__opportunity_state	TEXT	opportunities.OPPORTUNITY_STATE	opportunities.OPPORTUNITY_STATE	opportunities
opportunities__opportunity_value	NUMERIC	opportunities.OPPORTUNITY_VALUE	opportunities.OPPORTUNITY_VALUE	opportunities
opportunities__organisation_id	NUMERIC	opportunities.ORGANISATION_ID	opportunities.ORGANISATION_ID	opportunities
opportunities__owner_user_id	NUMERIC	opportunities.OWNER_USER_ID	opportunities.OWNER_USER_ID	opportunities
opportunities__pipeline_id	NUMERIC	opportunities.PIPELINE_ID	opportunities.PIPELINE_ID	opportunities
opportunities__pricebook_id	NUMERIC	opportunities.PRICEBOOK_ID	opportunities.PRICEBOOK_ID	opportunities
opportunities__probability	NUMERIC	opportunities.PROBABILITY	opportunities.PROBABILITY	opportunities
opportunities__responsible_user_id	NUMERIC	opportunities.RESPONSIBLE_USER_ID	opportunities.RESPONSIBLE_USER_ID	opportunities
opportunities__stage_id	NUMERIC	opportunities.STAGE_ID	opportunities.STAGE_ID	opportunities
opportunities__tags	OBJECT	opportunities.TAGS	opportunities.TAGS	opportunities
opportunities__visible_team_id	NUMERIC	opportunities.VISIBLE_TEAM_ID	opportunities.VISIBLE_TEAM_ID	opportunities
opportunities__visible_to	TEXT	opportunities.VISIBLE_TO	opportunities.VISIBLE_TO	opportunities
opportunity_categories__active	BOOLEAN	opportunity_categories.ACTIVE	opportunity_categories.ACTIVE	opportunity_categories
opportunity_categories__background_color	TEXT	opportunity_categories.BACKGROUND_COLOR	opportunity_categories.BACKGROUND_COLOR	opportunity_categories
opportunity_categories__category_id	NUMERIC	opportunity_categories.CATEGORY_ID	opportunity_categories.CATEGORY_ID	opportunity_categories
opportunity_categories__category_name	TEXT	opportunity_categories.CATEGORY_NAME	opportunity_categories.CATEGORY_NAME	opportunity_categories
opportunity_state_reasons__for_opportunity_state	TEXT	opportunity_state_reasons.FOR_OPPORTUNITY_STATE	opportunity_state_reasons.FOR_OPPORTUNITY_STATE	opportunity_state_reasons
opportunity_state_reasons__state_reason	TEXT	opportunity_state_reasons.STATE_REASON	opportunity_state_reasons.STATE_REASON	opportunity_state_reasons
opportunity_state_reasons__state_reason_id	NUMERIC	opportunity_state_reasons.STATE_REASON_ID	opportunity_state_reasons.STATE_REASON_ID	opportunity_state_reasons
organisations__address_billing_city	TEXT	organisations.ADDRESS_BILLING_CITY	organisations.ADDRESS_BILLING_CITY	organisations
organisations__address_billing_country	TEXT	organisations.ADDRESS_BILLING_COUNTRY	organisations.ADDRESS_BILLING_COUNTRY	organisations
organisations__address_billing_postcode	TEXT	organisations.ADDRESS_BILLING_POSTCODE	organisations.ADDRESS_BILLING_POSTCODE	organisations
organisations__address_billing_state	TEXT	organisations.ADDRESS_BILLING_STATE	organisations.ADDRESS_BILLING_STATE	organisations
organisations__address_billing_street	TEXT	organisations.ADDRESS_BILLING_STREET	organisations.ADDRESS_BILLING_STREET	organisations
organisations__address_ship_city	TEXT	organisations.ADDRESS_SHIP_CITY	organisations.ADDRESS_SHIP_CITY	organisations
organisations__address_ship_country	TEXT	organisations.ADDRESS_SHIP_COUNTRY	organisations.ADDRESS_SHIP_COUNTRY	organisations
organisations__address_ship_postcode	TEXT	organisations.ADDRESS_SHIP_POSTCODE	organisations.ADDRESS_SHIP_POSTCODE	organisations
organisations__address_ship_state	TEXT	organisations.ADDRESS_SHIP_STATE	organisations.ADDRESS_SHIP_STATE	organisations
organisations__address_ship_street	TEXT	organisations.ADDRESS_SHIP_STREET	organisations.ADDRESS_SHIP_STREET	organisations
organisations__background	TEXT	organisations.BACKGROUND	organisations.BACKGROUND	organisations
organisations__created_user_id	NUMERIC	organisations.CREATED_USER_ID	organisations.CREATED_USER_ID	organisations
organisations__customfields	OBJECT	organisations.CUSTOMFIELDS	organisations.CUSTOMFIELDS	organisations
organisations__date_created_utc	TEXT	organisations.DATE_CREATED_UTC	organisations.DATE_CREATED_UTC	organisations
organisations__date_updated_utc	TEXT	organisations.DATE_UPDATED_UTC	organisations.DATE_UPDATED_UTC	organisations
organisations__dates	OBJECT	organisations.DATES	organisations.DATES	organisations
organisations__emaildomains	OBJECT	organisations.EMAILDOMAINS	organisations.EMAILDOMAINS	organisations
organisations__image_url	TEXT	organisations.IMAGE_URL	organisations.IMAGE_URL	organisations
organisations__last_activity_date_utc	TEXT	organisations.LAST_ACTIVITY_DATE_UTC	organisations.LAST_ACTIVITY_DATE_UTC	organisations
organisations__links	OBJECT	organisations.LINKS	organisations.LINKS	organisations
organisations__next_activity_date_utc	TEXT	organisations.NEXT_ACTIVITY_DATE_UTC	organisations.NEXT_ACTIVITY_DATE_UTC	organisations
organisations__organisation_id	NUMERIC	organisations.ORGANISATION_ID	organisations.ORGANISATION_ID	organisations
organisations__organisation_name	TEXT	organisations.ORGANISATION_NAME	organisations.ORGANISATION_NAME	organisations
organisations__owner_user_id	NUMERIC	organisations.OWNER_USER_ID	organisations.OWNER_USER_ID	organisations
organisations__phone	TEXT	organisations.PHONE	organisations.PHONE	organisations
organisations__phone_fax	TEXT	organisations.PHONE_FAX	organisations.PHONE_FAX	organisations
organisations__social_facebook	TEXT	organisations.SOCIAL_FACEBOOK	organisations.SOCIAL_FACEBOOK	organisations
organisations__social_linkedin	TEXT	organisations.SOCIAL_LINKEDIN	organisations.SOCIAL_LINKEDIN	organisations
organisations__social_twitter	TEXT	organisations.SOCIAL_TWITTER	organisations.SOCIAL_TWITTER	organisations
organisations__tags	OBJECT	organisations.TAGS	organisations.TAGS	organisations
organisations__visible_team_id	NUMERIC	organisations.VISIBLE_TEAM_ID	organisations.VISIBLE_TEAM_ID	organisations
organisations__visible_to	TEXT	organisations.VISIBLE_TO	organisations.VISIBLE_TO	organisations
organisations__website	TEXT	organisations.WEBSITE	organisations.WEBSITE	organisations
pipeline_stages__activityset_id	NUMERIC	pipeline_stages.ACTIVITYSET_ID	pipeline_stages.ACTIVITYSET_ID	pipeline_stages
pipeline_stages__owner_user_id	NUMERIC	pipeline_stages.OWNER_USER_ID	pipeline_stages.OWNER_USER_ID	pipeline_stages
pipeline_stages__pipeline_id	NUMERIC	pipeline_stages.PIPELINE_ID	pipeline_stages.PIPELINE_ID	pipeline_stages
pipeline_stages__stage_id	NUMERIC	pipeline_stages.STAGE_ID	pipeline_stages.STAGE_ID	pipeline_stages
pipeline_stages__stage_name	TEXT	pipeline_stages.STAGE_NAME	pipeline_stages.STAGE_NAME	pipeline_stages
pipeline_stages__stage_order	NUMERIC	pipeline_stages.STAGE_ORDER	pipeline_stages.STAGE_ORDER	pipeline_stages
pipelines__for_opportunities	BOOLEAN	pipelines.FOR_OPPORTUNITIES	pipelines.FOR_OPPORTUNITIES	pipelines
pipelines__for_projects	BOOLEAN	pipelines.FOR_PROJECTS	pipelines.FOR_PROJECTS	pipelines
pipelines__owner_user_id	NUMERIC	pipelines.OWNER_USER_ID	pipelines.OWNER_USER_ID	pipelines
pipelines__pipeline_id	NUMERIC	pipelines.PIPELINE_ID	pipelines.PIPELINE_ID	pipelines
pipelines__pipeline_name	TEXT	pipelines.PIPELINE_NAME	pipelines.PIPELINE_NAME	pipelines
project_categories__active	BOOLEAN	project_categories.ACTIVE	project_categories.ACTIVE	project_categories
project_categories__background_color	TEXT	project_categories.BACKGROUND_COLOR	project_categories.BACKGROUND_COLOR	project_categories
project_categories__category_id	NUMERIC	project_categories.CATEGORY_ID	project_categories.CATEGORY_ID	project_categories
project_categories__category_name	TEXT	project_categories.CATEGORY_NAME	project_categories.CATEGORY_NAME	project_categories
projects__category_id	NUMERIC	projects.CATEGORY_ID	projects.CATEGORY_ID	projects
projects__completed_date	TEXT	projects.COMPLETED_DATE	projects.COMPLETED_DATE	projects
projects__created_user_id	NUMERIC	projects.CREATED_USER_ID	projects.CREATED_USER_ID	projects
projects__customfields	OBJECT	projects.CUSTOMFIELDS	projects.CUSTOMFIELDS	projects
projects__date_created_utc	TEXT	projects.DATE_CREATED_UTC	projects.DATE_CREATED_UTC	projects
projects__date_updated_utc	TEXT	projects.DATE_UPDATED_UTC	projects.DATE_UPDATED_UTC	projects
projects__image_url	TEXT	projects.IMAGE_URL	projects.IMAGE_URL	projects
projects__last_activity_date_utc	TEXT	projects.LAST_ACTIVITY_DATE_UTC	projects.LAST_ACTIVITY_DATE_UTC	projects
projects__links	OBJECT	projects.LINKS	projects.LINKS	projects
projects__next_activity_date_utc	TEXT	projects.NEXT_ACTIVITY_DATE_UTC	projects.NEXT_ACTIVITY_DATE_UTC	projects
projects__opportunity_id	NUMERIC	projects.OPPORTUNITY_ID	projects.OPPORTUNITY_ID	projects
projects__owner_user_id	NUMERIC	projects.OWNER_USER_ID	projects.OWNER_USER_ID	projects
projects__pipeline_id	NUMERIC	projects.PIPELINE_ID	projects.PIPELINE_ID	projects
projects__project_details	TEXT	projects.PROJECT_DETAILS	projects.PROJECT_DETAILS	projects
projects__project_id	NUMERIC	projects.PROJECT_ID	projects.PROJECT_ID	projects
projects__project_name	TEXT	projects.PROJECT_NAME	projects.PROJECT_NAME	projects
projects__responsible_user_id	NUMERIC	projects.RESPONSIBLE_USER_ID	projects.RESPONSIBLE_USER_ID	projects
projects__stage_id	NUMERIC	projects.STAGE_ID	projects.STAGE_ID	projects
projects__started_date	TEXT	projects.STARTED_DATE	projects.STARTED_DATE	projects
projects__status	TEXT	projects.STATUS	projects.STATUS	projects
projects__tags	OBJECT	projects.TAGS	projects.TAGS	projects
projects__visible_team_id	NUMERIC	projects.VISIBLE_TEAM_ID	projects.VISIBLE_TEAM_ID	projects
projects__visible_to	TEXT	projects.VISIBLE_TO	projects.VISIBLE_TO	projects
prospects__address_city	TEXT	prospects.ADDRESS_CITY	prospects.ADDRESS_CITY	prospects
prospects__address_country	TEXT	prospects.ADDRESS_COUNTRY	prospects.ADDRESS_COUNTRY	prospects
prospects__address_postcode	TEXT	prospects.ADDRESS_POSTCODE	prospects.ADDRESS_POSTCODE	prospects
prospects__address_state	TEXT	prospects.ADDRESS_STATE	prospects.ADDRESS_STATE	prospects
prospects__address_street	TEXT	prospects.ADDRESS_STREET	prospects.ADDRESS_STREET	prospects
prospects__contact_id	NUMERIC	prospects.CONTACT_ID	prospects.CONTACT_ID	prospects
prospects__created_user_id	NUMERIC	prospects.CREATED_USER_ID	prospects.CREATED_USER_ID	prospects
prospects__customfields	OBJECT	prospects.CUSTOMFIELDS	prospects.CUSTOMFIELDS	prospects
prospects__date_created_utc	TEXT	prospects.DATE_CREATED_UTC	prospects.DATE_CREATED_UTC	prospects
prospects__date_updated_utc	TEXT	prospects.DATE_UPDATED_UTC	prospects.DATE_UPDATED_UTC	prospects
prospects__description	TEXT	prospects.DESCRIPTION	prospects.DESCRIPTION	prospects
prospects__do_not_call	BOOLEAN	prospects.DO_NOT_CALL	prospects.DO_NOT_CALL	prospects
prospects__do_not_email	BOOLEAN	prospects.DO_NOT_EMAIL	prospects.DO_NOT_EMAIL	prospects
prospects__do_not_sync	BOOLEAN	prospects.DO_NOT_SYNC	prospects.DO_NOT_SYNC	prospects
prospects__email_address	TEXT	prospects.EMAIL_ADDRESS	prospects.EMAIL_ADDRESS	prospects
prospects__employee_count	NUMERIC	prospects.EMPLOYEE_COUNT	prospects.EMPLOYEE_COUNT	prospects
prospects__fax	TEXT	prospects.FAX	prospects.FAX	prospects
prospects__first_name	TEXT	prospects.FIRST_NAME	prospects.FIRST_NAME	prospects
prospects__grade	TEXT	prospects.GRADE	prospects.GRADE	prospects
prospects__grade_profile_id	NUMERIC	prospects.GRADE_PROFILE_ID	prospects.GRADE_PROFILE_ID	prospects
prospects__industry	TEXT	prospects.INDUSTRY	prospects.INDUSTRY	prospects
prospects__last_activity_date_utc	TEXT	prospects.LAST_ACTIVITY_DATE_UTC	prospects.LAST_ACTIVITY_DATE_UTC	prospects
prospects__last_name	TEXT	prospects.LAST_NAME	prospects.LAST_NAME	prospects
prospects__lead_conversion_date_utc	TEXT	prospects.LEAD_CONVERSION_DATE_UTC	prospects.LEAD_CONVERSION_DATE_UTC	prospects
prospects__lead_id	NUMERIC	prospects.LEAD_ID	prospects.LEAD_ID	prospects
prospects__mobile	TEXT	prospects.MOBILE	prospects.MOBILE	prospects
prospects__opted_out	BOOLEAN	prospects.OPTED_OUT	prospects.OPTED_OUT	prospects
prospects__organisation_id	NUMERIC	prospects.ORGANISATION_ID	prospects.ORGANISATION_ID	prospects
prospects__organisation_name	TEXT	prospects.ORGANISATION_NAME	prospects.ORGANISATION_NAME	prospects
prospects__owner_user_id	NUMERIC	prospects.OWNER_USER_ID	prospects.OWNER_USER_ID	prospects
prospects__phone	TEXT	prospects.PHONE	prospects.PHONE	prospects
prospects__prospect_id	NUMERIC	prospects.PROSPECT_ID	prospects.PROSPECT_ID	prospects
prospects__salutation	TEXT	prospects.SALUTATION	prospects.SALUTATION	prospects
prospects__score	NUMERIC	prospects.SCORE	prospects.SCORE	prospects
prospects__tags	OBJECT	prospects.TAGS	prospects.TAGS	prospects
prospects__title	TEXT	prospects.TITLE	prospects.TITLE	prospects
prospects__website	TEXT	prospects.WEBSITE	prospects.WEBSITE	prospects
relationships__for_contacts	BOOLEAN	relationships.FOR_CONTACTS	relationships.FOR_CONTACTS	relationships
relationships__for_organisations	BOOLEAN	relationships.FOR_ORGANISATIONS	relationships.FOR_ORGANISATIONS	relationships
relationships__forward	TEXT	relationships.FORWARD	relationships.FORWARD	relationships
relationships__forward_title	TEXT	relationships.FORWARD_TITLE	relationships.FORWARD_TITLE	relationships
relationships__relationship_id	NUMERIC	relationships.RELATIONSHIP_ID	relationships.RELATIONSHIP_ID	relationships
relationships__reverse	TEXT	relationships.REVERSE	relationships.REVERSE	relationships
relationships__reverse_title	TEXT	relationships.REVERSE_TITLE	relationships.REVERSE_TITLE	relationships
source	TEXT	Source	The name of the Windsor connector returning the row
task_categories__active	BOOLEAN	task_categories.ACTIVE	task_categories.ACTIVE	task_categories
task_categories__background_color	TEXT	task_categories.BACKGROUND_COLOR	task_categories.BACKGROUND_COLOR	task_categories
task_categories__category_id	NUMERIC	task_categories.CATEGORY_ID	task_categories.CATEGORY_ID	task_categories
task_categories__category_name	TEXT	task_categories.CATEGORY_NAME	task_categories.CATEGORY_NAME	task_categories
tasks__assigned_by_user_id	NUMERIC	tasks.ASSIGNED_BY_USER_ID	tasks.ASSIGNED_BY_USER_ID	tasks
tasks__assigned_date_utc	TEXT	tasks.ASSIGNED_DATE_UTC	tasks.ASSIGNED_DATE_UTC	tasks
tasks__assigned_team_id	NUMERIC	tasks.ASSIGNED_TEAM_ID	tasks.ASSIGNED_TEAM_ID	tasks
tasks__category_id	NUMERIC	tasks.CATEGORY_ID	tasks.CATEGORY_ID	tasks
tasks__completed	BOOLEAN	tasks.COMPLETED	tasks.COMPLETED	tasks
tasks__completed_date_utc	TEXT	tasks.COMPLETED_DATE_UTC	tasks.COMPLETED_DATE_UTC	tasks
tasks__created_user_id	NUMERIC	tasks.CREATED_USER_ID	tasks.CREATED_USER_ID	tasks
tasks__customfields	OBJECT	tasks.CUSTOMFIELDS	tasks.CUSTOMFIELDS	tasks
tasks__date_created_utc	TEXT	tasks.DATE_CREATED_UTC	tasks.DATE_CREATED_UTC	tasks
tasks__date_updated_utc	TEXT	tasks.DATE_UPDATED_UTC	tasks.DATE_UPDATED_UTC	tasks
tasks__details	TEXT	tasks.DETAILS	tasks.DETAILS	tasks
tasks__due_date	TEXT	tasks.DUE_DATE	tasks.DUE_DATE	tasks
tasks__email_id	NUMERIC	tasks.EMAIL_ID	tasks.EMAIL_ID	tasks
tasks__links	OBJECT	tasks.LINKS	tasks.LINKS	tasks
tasks__milestone_id	NUMERIC	tasks.MILESTONE_ID	tasks.MILESTONE_ID	tasks
tasks__opportunity_id	NUMERIC	tasks.OPPORTUNITY_ID	tasks.OPPORTUNITY_ID	tasks
tasks__owner_user_id	NUMERIC	tasks.OWNER_USER_ID	tasks.OWNER_USER_ID	tasks
tasks__owner_visible	BOOLEAN	tasks.OWNER_VISIBLE	tasks.OWNER_VISIBLE	tasks
tasks__parent_task_id	NUMERIC	tasks.PARENT_TASK_ID	tasks.PARENT_TASK_ID	tasks
tasks__percent_complete	NUMERIC	tasks.PERCENT_COMPLETE	tasks.PERCENT_COMPLETE	tasks
tasks__priority	NUMERIC	tasks.PRIORITY	tasks.PRIORITY	tasks
tasks__project_id	NUMERIC	tasks.PROJECT_ID	tasks.PROJECT_ID	tasks
tasks__publicly_visible	BOOLEAN	tasks.PUBLICLY_VISIBLE	tasks.PUBLICLY_VISIBLE	tasks
tasks__recurrence	TEXT	tasks.RECURRENCE	tasks.RECURRENCE	tasks
tasks__reminder_date_utc	TEXT	tasks.REMINDER_DATE_UTC	tasks.REMINDER_DATE_UTC	tasks
tasks__reminder_sent	BOOLEAN	tasks.REMINDER_SENT	tasks.REMINDER_SENT	tasks
tasks__responsible_user_id	NUMERIC	tasks.RESPONSIBLE_USER_ID	tasks.RESPONSIBLE_USER_ID	tasks
tasks__stage_id	NUMERIC	tasks.STAGE_ID	tasks.STAGE_ID	tasks
tasks__start_date	TEXT	tasks.START_DATE	tasks.START_DATE	tasks
tasks__status	TEXT	tasks.STATUS	tasks.STATUS	tasks
tasks__task_id	NUMERIC	tasks.TASK_ID	tasks.TASK_ID	tasks
tasks__title	TEXT	tasks.TITLE	tasks.TITLE	tasks
team_members__member_user_id	NUMERIC	team_members.MEMBER_USER_ID	team_members.MEMBER_USER_ID	team_members
team_members__permission_id	NUMERIC	team_members.PERMISSION_ID	team_members.PERMISSION_ID	team_members
team_members__team_id	NUMERIC	team_members.TEAM_ID	team_members.TEAM_ID	team_members
teams__anonymous_team	BOOLEAN	teams.ANONYMOUS_TEAM	teams.ANONYMOUS_TEAM	teams
teams__date_created_utc	TEXT	teams.DATE_CREATED_UTC	teams.DATE_CREATED_UTC	teams
teams__date_updated_utc	TEXT	teams.DATE_UPDATED_UTC	teams.DATE_UPDATED_UTC	teams
teams__team_id	NUMERIC	teams.TEAM_ID	teams.TEAM_ID	teams
teams__team_name	TEXT	teams.TEAM_NAME	teams.TEAM_NAME	teams
teams__teammembers	OBJECT	teams.TEAMMEMBERS	teams.TEAMMEMBERS	teams
today	DATE	Today	Today's date
users__account_owner	BOOLEAN	users.ACCOUNT_OWNER	users.ACCOUNT_OWNER	users
users__active	BOOLEAN	users.ACTIVE	users.ACTIVE	users
users__administrator	BOOLEAN	users.ADMINISTRATOR	users.ADMINISTRATOR	users
users__contact_display	TEXT	users.CONTACT_DISPLAY	users.CONTACT_DISPLAY	users
users__contact_id	NUMERIC	users.CONTACT_ID	users.CONTACT_ID	users
users__contact_order	TEXT	users.CONTACT_ORDER	users.CONTACT_ORDER	users
users__date_created_utc	TEXT	users.DATE_CREATED_UTC	users.DATE_CREATED_UTC	users
users__date_updated_utc	TEXT	users.DATE_UPDATED_UTC	users.DATE_UPDATED_UTC	users
users__email_address	TEXT	users.EMAIL_ADDRESS	users.EMAIL_ADDRESS	users
users__email_dropbox_address	TEXT	users.EMAIL_DROPBOX_ADDRESS	users.EMAIL_DROPBOX_ADDRESS	users
users__email_dropbox_identifier	TEXT	users.EMAIL_DROPBOX_IDENTIFIER	users.EMAIL_DROPBOX_IDENTIFIER	users
users__first_name	TEXT	users.FIRST_NAME	users.FIRST_NAME	users
users__instance_id	NUMERIC	users.INSTANCE_ID	users.INSTANCE_ID	users
users__last_name	TEXT	users.LAST_NAME	users.LAST_NAME	users
users__profile_id	NUMERIC	users.PROFILE_ID	users.PROFILE_ID	users
users__role_id	NUMERIC	users.ROLE_ID	users.ROLE_ID	users
users__task_week_start	NUMERIC	users.TASK_WEEK_START	users.TASK_WEEK_START	users
users__timezone_id	TEXT	users.TIMEZONE_ID	users.TIMEZONE_ID	users
users__user_currency	TEXT	users.USER_CURRENCY	users.USER_CURRENCY	users
users__user_id	NUMERIC	users.USER_ID	users.USER_ID	users