API Connectors

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

Zoho CRM Connector Reference

168 metrics716 dimensions
Fields

https://connectors.windsor.ai/zoho?api_key=[your API
key]&date_preset=last_7d&fields=email,lead_statu,firstname,lastname,date

The Zoho CRM connector exposes 884 fields (168 metrics, 716 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Zoho CRM Fields

Zoho CRM Accounts fields

The Accounts report of the Zoho CRM connector includes 41 fields.

Zoho CRM Accounts fields (accounts_account_name to accounts_ticker_symbol)

ID Type Name Description
accounts_account_name TEXT Accounts Account Name Account Name
accounts_account_number TEXT Accounts Account Number Account Number
accounts_account_site TEXT Accounts Account Site Account Site
accounts_account_type TEXT Accounts Account Type Account Type
accounts_annual_revenue TEXT Accounts Annual Revenue Annual Revenue
accounts_billing_city CITY Accounts Billing City Billing City
accounts_billing_code TEXT Accounts Billing Code Billing Code
accounts_billing_country COUNTRY Accounts Billing Country Billing Country
accounts_billing_state TEXT Accounts Billing State Billing State
accounts_billing_street TEXT Accounts Billing Street Billing Street
accounts_change_log_time__s TIMESTAMP Accounts Change Log Time Change Log Time
accounts_created_by TEXT Accounts Created By Created By
accounts_created_time TIMESTAMP Accounts Created Time Created Time
accounts_description TEXT Accounts Description Description
accounts_employees TEXT Accounts Employees Employees
accounts_enrich_status__s TEXT Accounts Enrich Status Enrich Status
accounts_fax TEXT Accounts Fax Fax
accounts_id TEXT Accounts Record Id Record Id
accounts_industry TEXT Accounts Industry Industry
accounts_last_activity_time TIMESTAMP Accounts Last Activity Time Last Activity Time
accounts_last_enriched_time__s TIMESTAMP Accounts Last Enriched Time Last Enriched Time
accounts_locked__s TEXT Accounts Locked Locked
accounts_modified_by TEXT Accounts Modified By Modified By
accounts_modified_time TIMESTAMP Accounts Modified Time Modified Time
accounts_owner TEXT Accounts Account Owner id Account Owner id
accounts_owner_first_name TEXT Accounts Owner First Name Accounts Owner First Name
accounts_owner_last_name TEXT Accounts Owner Last Name Accounts Owner Last Name
accounts_ownership TEXT Accounts Ownership Ownership
accounts_parent_account TEXT Accounts Parent Account Parent Account
accounts_phone TEXT Accounts Phone Phone
accounts_rating TEXT Accounts Rating Rating
accounts_record_image TEXT Accounts Account Image Account Image
accounts_shipping_city CITY Accounts Shipping City Shipping City
accounts_shipping_code TEXT Accounts Shipping Code Shipping Code
accounts_shipping_country COUNTRY Accounts Shipping Country Shipping Country
accounts_shipping_state TEXT Accounts Shipping State Shipping State
accounts_shipping_street TEXT Accounts Shipping Street Shipping Street
accounts_sic_code TEXT Accounts Sic Code Sic Code
accounts_tag TEXT Accounts Tag Tag
accounts_ticker_symbol TEXT Accounts Ticker Symbol Ticker Symbol

Zoho CRM Accounts fields (accounts_website to accounts_website)

ID Type Name Description
accounts_website TEXT Accounts Website Website

Zoho CRM Calls fields

The Calls report of the Zoho CRM connector includes 27 fields.

ID Type Name Description
calls_call_agenda TEXT Call Agenda Call Agenda
calls_call_duration TEXT Call Duration Call Duration
calls_call_duration_in_seconds TEXT Call Duration (In Seconds) Call Duration (In Seconds)
calls_call_purpose TEXT Call Purpose Call Purpose
calls_call_result TEXT Call Result Call Result
calls_call_start_time TIMESTAMP Call Start Time Call Start Time
calls_call_type TEXT Call Type Call Type
calls_caller_id TEXT Caller Id Caller Id
calls_created_by TEXT Calls Created By Created By
calls_created_time TIMESTAMP Calls Created Time Created Time
calls_cti_entry TEXT Cti Entry Cti Entry
calls_description TEXT Calls Description Description
calls_dialled_number TEXT Dialled Number Dialled Number
calls_id TEXT Calls Record Id Record Id
calls_modified_by TEXT Calls Modified By Modified By
calls_modified_time TIMESTAMP Calls Modified Time Modified Time
calls_outgoing_call_status TEXT Outgoing Call Status Outgoing Call Status
calls_owner TEXT Calls Call Owner id Call Owner id
calls_owner_first_name TEXT Calls Owner First Name Calls Owner First Name
calls_owner_last_name TEXT Calls Owner Last Name Calls Owner Last Name
calls_reminder TEXT Calls Reminder Reminder
calls_scheduled_in_crm TEXT Scheduled In Crm Scheduled In Crm
calls_subject TEXT Calls Subject Subject
calls_tag TEXT Calls Tag Tag
calls_voice_recording__s TEXT Voice Recording Voice Recording
calls_what_id TEXT Related To Related To
calls_who_id TEXT Calls Contact Name Contact Name

Zoho CRM Campaign Management fields

The Campaign Management report of the Zoho CRM connector includes 168 fields.

Zoho CRM Campaign Management fields (campaign_management_campaign_by_loaction_ad to campaign_management_campaign_by_loaction_gb)

ID Type Name Description
campaign_management_campaign_by_loaction_ad NUMERIC Campaign management campaign by loaction ad Campaign management campaign by loaction ad
campaign_management_campaign_by_loaction_ae NUMERIC Campaign management campaign by loaction ae Campaign management campaign by loaction ae
campaign_management_campaign_by_loaction_af NUMERIC Campaign management campaign by loaction af Campaign management campaign by loaction af
campaign_management_campaign_by_loaction_al NUMERIC Campaign management campaign by loaction al Campaign management campaign by loaction al
campaign_management_campaign_by_loaction_am NUMERIC Campaign management campaign by loaction am Campaign management campaign by loaction am
campaign_management_campaign_by_loaction_ar NUMERIC Campaign management campaign by loaction ar Campaign management campaign by loaction ar
campaign_management_campaign_by_loaction_at NUMERIC Campaign management campaign by loaction at Campaign management campaign by loaction at
campaign_management_campaign_by_loaction_au NUMERIC Campaign management campaign by loaction au Campaign management campaign by loaction au
campaign_management_campaign_by_loaction_az NUMERIC Campaign management campaign by loaction az Campaign management campaign by loaction az
campaign_management_campaign_by_loaction_ba NUMERIC Campaign management campaign by loaction ba Campaign management campaign by loaction ba
campaign_management_campaign_by_loaction_bd NUMERIC Campaign management campaign by loaction bd Campaign management campaign by loaction bd
campaign_management_campaign_by_loaction_be NUMERIC Campaign management campaign by loaction be Campaign management campaign by loaction be
campaign_management_campaign_by_loaction_bg NUMERIC Campaign management campaign by loaction bg Campaign management campaign by loaction bg
campaign_management_campaign_by_loaction_bh NUMERIC Campaign management campaign by loaction bh Campaign management campaign by loaction bh
campaign_management_campaign_by_loaction_bo NUMERIC Campaign management campaign by loaction bo Campaign management campaign by loaction bo
campaign_management_campaign_by_loaction_br NUMERIC Campaign management campaign by loaction br Campaign management campaign by loaction br
campaign_management_campaign_by_loaction_by NUMERIC Campaign management campaign by loaction by Campaign management campaign by loaction by
campaign_management_campaign_by_loaction_bz NUMERIC Campaign management campaign by loaction bz Campaign management campaign by loaction bz
campaign_management_campaign_by_loaction_ca NUMERIC Campaign management campaign by loaction ca Campaign management campaign by loaction ca
campaign_management_campaign_by_loaction_cd NUMERIC Campaign management campaign by loaction cd Campaign management campaign by loaction cd
campaign_management_campaign_by_loaction_ch NUMERIC Campaign management campaign by loaction ch Campaign management campaign by loaction ch
campaign_management_campaign_by_loaction_ci NUMERIC Campaign management campaign by loaction ci Campaign management campaign by loaction ci
campaign_management_campaign_by_loaction_cl NUMERIC Campaign management campaign by loaction cl Campaign management campaign by loaction cl
campaign_management_campaign_by_loaction_cm NUMERIC Campaign management campaign by loaction cm Campaign management campaign by loaction cm
campaign_management_campaign_by_loaction_cn NUMERIC Campaign management campaign by loaction cn Campaign management campaign by loaction cn
campaign_management_campaign_by_loaction_co NUMERIC Campaign management campaign by loaction co Campaign management campaign by loaction co
campaign_management_campaign_by_loaction_cr NUMERIC Campaign management campaign by loaction cr Campaign management campaign by loaction cr
campaign_management_campaign_by_loaction_cw NUMERIC Campaign management campaign by loaction cw Campaign management campaign by loaction cw
campaign_management_campaign_by_loaction_cy NUMERIC Campaign management campaign by loaction cy Campaign management campaign by loaction cy
campaign_management_campaign_by_loaction_cz NUMERIC Campaign management campaign by loaction cz Campaign management campaign by loaction cz
campaign_management_campaign_by_loaction_de NUMERIC Campaign management campaign by loaction de Campaign management campaign by loaction de
campaign_management_campaign_by_loaction_dk NUMERIC Campaign management campaign by loaction dk Campaign management campaign by loaction dk
campaign_management_campaign_by_loaction_do NUMERIC Campaign management campaign by loaction do Campaign management campaign by loaction do
campaign_management_campaign_by_loaction_ec NUMERIC Campaign management campaign by loaction ec Campaign management campaign by loaction ec
campaign_management_campaign_by_loaction_ee NUMERIC Campaign management campaign by loaction ee Campaign management campaign by loaction ee
campaign_management_campaign_by_loaction_eg NUMERIC Campaign management campaign by loaction eg Campaign management campaign by loaction eg
campaign_management_campaign_by_loaction_es NUMERIC Campaign management campaign by loaction es Campaign management campaign by loaction es
campaign_management_campaign_by_loaction_fi NUMERIC Campaign management campaign by loaction fi Campaign management campaign by loaction fi
campaign_management_campaign_by_loaction_fr NUMERIC Campaign management campaign by loaction fr Campaign management campaign by loaction fr
campaign_management_campaign_by_loaction_gb NUMERIC Campaign management campaign by loaction gb Campaign management campaign by loaction gb

Zoho CRM Campaign Management fields (campaign_management_campaign_by_loaction_ge to campaign_management_campaign_by_loaction_mm)

ID Type Name Description
campaign_management_campaign_by_loaction_ge NUMERIC Campaign management campaign by loaction ge Campaign management campaign by loaction ge
campaign_management_campaign_by_loaction_gh NUMERIC Campaign management campaign by loaction gh Campaign management campaign by loaction gh
campaign_management_campaign_by_loaction_gp NUMERIC Campaign management campaign by loaction gp Campaign management campaign by loaction gp
campaign_management_campaign_by_loaction_gr NUMERIC Campaign management campaign by loaction gr Campaign management campaign by loaction gr
campaign_management_campaign_by_loaction_gt NUMERIC Campaign management campaign by loaction gt Campaign management campaign by loaction gt
campaign_management_campaign_by_loaction_hk NUMERIC Campaign management campaign by loaction hk Campaign management campaign by loaction hk
campaign_management_campaign_by_loaction_hn NUMERIC Campaign management campaign by loaction hn Campaign management campaign by loaction hn
campaign_management_campaign_by_loaction_hr NUMERIC Campaign management campaign by loaction hr Campaign management campaign by loaction hr
campaign_management_campaign_by_loaction_hu NUMERIC Campaign management campaign by loaction hu Campaign management campaign by loaction hu
campaign_management_campaign_by_loaction_id NUMERIC Campaign management campaign by loaction id Campaign management campaign by loaction id
campaign_management_campaign_by_loaction_ie NUMERIC Campaign management campaign by loaction ie Campaign management campaign by loaction ie
campaign_management_campaign_by_loaction_il NUMERIC Campaign management campaign by loaction il Campaign management campaign by loaction il
campaign_management_campaign_by_loaction_im NUMERIC Campaign management campaign by loaction im Campaign management campaign by loaction im
campaign_management_campaign_by_loaction_in NUMERIC Campaign management campaign by loaction in Campaign management campaign by loaction in
campaign_management_campaign_by_loaction_iq NUMERIC Campaign management campaign by loaction iq Campaign management campaign by loaction iq
campaign_management_campaign_by_loaction_ir NUMERIC Campaign management campaign by loaction ir Campaign management campaign by loaction ir
campaign_management_campaign_by_loaction_is NUMERIC Campaign management campaign by loaction is Campaign management campaign by loaction is
campaign_management_campaign_by_loaction_it NUMERIC Campaign management campaign by loaction it Campaign management campaign by loaction it
campaign_management_campaign_by_loaction_jo NUMERIC Campaign management campaign by loaction jo Campaign management campaign by loaction jo
campaign_management_campaign_by_loaction_jp NUMERIC Campaign management campaign by loaction jp Campaign management campaign by loaction jp
campaign_management_campaign_by_loaction_ke NUMERIC Campaign management campaign by loaction ke Campaign management campaign by loaction ke
campaign_management_campaign_by_loaction_kg NUMERIC Campaign management campaign by loaction kg Campaign management campaign by loaction kg
campaign_management_campaign_by_loaction_kh NUMERIC Campaign management campaign by loaction kh Campaign management campaign by loaction kh
campaign_management_campaign_by_loaction_kr NUMERIC Campaign management campaign by loaction kr Campaign management campaign by loaction kr
campaign_management_campaign_by_loaction_kw NUMERIC Campaign management campaign by loaction kw Campaign management campaign by loaction kw
campaign_management_campaign_by_loaction_kz NUMERIC Campaign management campaign by loaction kz Campaign management campaign by loaction kz
campaign_management_campaign_by_loaction_la NUMERIC Campaign management campaign by loaction la Campaign management campaign by loaction la
campaign_management_campaign_by_loaction_lb NUMERIC Campaign management campaign by loaction lb Campaign management campaign by loaction lb
campaign_management_campaign_by_loaction_li NUMERIC Campaign management campaign by loaction li Campaign management campaign by loaction li
campaign_management_campaign_by_loaction_lk NUMERIC Campaign management campaign by loaction lk Campaign management campaign by loaction lk
campaign_management_campaign_by_loaction_lt NUMERIC Campaign management campaign by loaction lt Campaign management campaign by loaction lt
campaign_management_campaign_by_loaction_lu NUMERIC Campaign management campaign by loaction lu Campaign management campaign by loaction lu
campaign_management_campaign_by_loaction_lv NUMERIC Campaign management campaign by loaction lv Campaign management campaign by loaction lv
campaign_management_campaign_by_loaction_ma NUMERIC Campaign management campaign by loaction ma Campaign management campaign by loaction ma
campaign_management_campaign_by_loaction_mc NUMERIC Campaign management campaign by loaction mc Campaign management campaign by loaction mc
campaign_management_campaign_by_loaction_md NUMERIC Campaign management campaign by loaction md Campaign management campaign by loaction md
campaign_management_campaign_by_loaction_me NUMERIC Campaign management campaign by loaction me Campaign management campaign by loaction me
campaign_management_campaign_by_loaction_mg NUMERIC Campaign management campaign by loaction mg Campaign management campaign by loaction mg
campaign_management_campaign_by_loaction_mk NUMERIC Campaign management campaign by loaction mk Campaign management campaign by loaction mk
campaign_management_campaign_by_loaction_mm NUMERIC Campaign management campaign by loaction mm Campaign management campaign by loaction mm

Zoho CRM Campaign Management fields (campaign_management_campaign_by_loaction_mn to campaign_management_campaign_by_loaction_tn)

ID Type Name Description
campaign_management_campaign_by_loaction_mn NUMERIC Campaign management campaign by loaction mn Campaign management campaign by loaction mn
campaign_management_campaign_by_loaction_mq NUMERIC Campaign management campaign by loaction mq Campaign management campaign by loaction mq
campaign_management_campaign_by_loaction_mt NUMERIC Campaign management campaign by loaction mt Campaign management campaign by loaction mt
campaign_management_campaign_by_loaction_mu NUMERIC Campaign management campaign by loaction mu Campaign management campaign by loaction mu
campaign_management_campaign_by_loaction_mv NUMERIC Campaign management campaign by loaction mv Campaign management campaign by loaction mv
campaign_management_campaign_by_loaction_mx NUMERIC Campaign management campaign by loaction mx Campaign management campaign by loaction mx
campaign_management_campaign_by_loaction_my NUMERIC Campaign management campaign by loaction my Campaign management campaign by loaction my
campaign_management_campaign_by_loaction_nc NUMERIC Campaign management campaign by loaction nc Campaign management campaign by loaction nc
campaign_management_campaign_by_loaction_ng NUMERIC Campaign management campaign by loaction ng Campaign management campaign by loaction ng
campaign_management_campaign_by_loaction_ni NUMERIC Campaign management campaign by loaction ni Campaign management campaign by loaction ni
campaign_management_campaign_by_loaction_nl NUMERIC Campaign management campaign by loaction nl Campaign management campaign by loaction nl
campaign_management_campaign_by_loaction_no NUMERIC Campaign management campaign by loaction no Campaign management campaign by loaction no
campaign_management_campaign_by_loaction_np NUMERIC Campaign management campaign by loaction np Campaign management campaign by loaction np
campaign_management_campaign_by_loaction_nz NUMERIC Campaign management campaign by loaction nz Campaign management campaign by loaction nz
campaign_management_campaign_by_loaction_om NUMERIC Campaign management campaign by loaction om Campaign management campaign by loaction om
campaign_management_campaign_by_loaction_pa NUMERIC Campaign management campaign by loaction pa Campaign management campaign by loaction pa
campaign_management_campaign_by_loaction_pe NUMERIC Campaign management campaign by loaction pe Campaign management campaign by loaction pe
campaign_management_campaign_by_loaction_ph NUMERIC Campaign management campaign by loaction ph Campaign management campaign by loaction ph
campaign_management_campaign_by_loaction_pk NUMERIC Campaign management campaign by loaction pk Campaign management campaign by loaction pk
campaign_management_campaign_by_loaction_pl NUMERIC Campaign management campaign by loaction pl Campaign management campaign by loaction pl
campaign_management_campaign_by_loaction_pr NUMERIC Campaign management campaign by loaction pr Campaign management campaign by loaction pr
campaign_management_campaign_by_loaction_ps NUMERIC Campaign management campaign by loaction ps Campaign management campaign by loaction ps
campaign_management_campaign_by_loaction_pt NUMERIC Campaign management campaign by loaction pt Campaign management campaign by loaction pt
campaign_management_campaign_by_loaction_py NUMERIC Campaign management campaign by loaction py Campaign management campaign by loaction py
campaign_management_campaign_by_loaction_qa NUMERIC Campaign management campaign by loaction qa Campaign management campaign by loaction qa
campaign_management_campaign_by_loaction_re NUMERIC Campaign management campaign by loaction re Campaign management campaign by loaction re
campaign_management_campaign_by_loaction_ro NUMERIC Campaign management campaign by loaction ro Campaign management campaign by loaction ro
campaign_management_campaign_by_loaction_rs NUMERIC Campaign management campaign by loaction rs Campaign management campaign by loaction rs
campaign_management_campaign_by_loaction_ru NUMERIC Campaign management campaign by loaction ru Campaign management campaign by loaction ru
campaign_management_campaign_by_loaction_rw NUMERIC Campaign management campaign by loaction rw Campaign management campaign by loaction rw
campaign_management_campaign_by_loaction_sa NUMERIC Campaign management campaign by loaction sa Campaign management campaign by loaction sa
campaign_management_campaign_by_loaction_se NUMERIC Campaign management campaign by loaction se Campaign management campaign by loaction se
campaign_management_campaign_by_loaction_sg NUMERIC Campaign management campaign by loaction sg Campaign management campaign by loaction sg
campaign_management_campaign_by_loaction_si NUMERIC Campaign management campaign by loaction si Campaign management campaign by loaction si
campaign_management_campaign_by_loaction_sk NUMERIC Campaign management campaign by loaction sk Campaign management campaign by loaction sk
campaign_management_campaign_by_loaction_sn NUMERIC Campaign management campaign by loaction sn Campaign management campaign by loaction sn
campaign_management_campaign_by_loaction_sr NUMERIC Campaign management campaign by loaction sr Campaign management campaign by loaction sr
campaign_management_campaign_by_loaction_sv NUMERIC Campaign management campaign by loaction sv Campaign management campaign by loaction sv
campaign_management_campaign_by_loaction_th NUMERIC Campaign management campaign by loaction th Campaign management campaign by loaction th
campaign_management_campaign_by_loaction_tn NUMERIC Campaign management campaign by loaction tn Campaign management campaign by loaction tn

Zoho CRM Campaign Management fields (campaign_management_campaign_by_loaction_tr to campaign_management_campaign_reports_spams_count)

ID Type Name Description
campaign_management_campaign_by_loaction_tr NUMERIC Campaign management campaign by loaction tr Campaign management campaign by loaction tr
campaign_management_campaign_by_loaction_tt NUMERIC Campaign management campaign by loaction tt Campaign management campaign by loaction tt
campaign_management_campaign_by_loaction_tw NUMERIC Campaign management campaign by loaction tw Campaign management campaign by loaction tw
campaign_management_campaign_by_loaction_tz NUMERIC Campaign management campaign by loaction tz Campaign management campaign by loaction tz
campaign_management_campaign_by_loaction_ua NUMERIC Campaign management campaign by loaction ua Campaign management campaign by loaction ua
campaign_management_campaign_by_loaction_ug NUMERIC Campaign management campaign by loaction ug Campaign management campaign by loaction ug
campaign_management_campaign_by_loaction_us NUMERIC Campaign management campaign by loaction us Campaign management campaign by loaction us
campaign_management_campaign_by_loaction_uy NUMERIC Campaign management campaign by loaction uy Campaign management campaign by loaction uy
campaign_management_campaign_by_loaction_ve NUMERIC Campaign management campaign by loaction ve Campaign management campaign by loaction ve
campaign_management_campaign_by_loaction_vn NUMERIC Campaign management campaign by loaction vn Campaign management campaign by loaction vn
campaign_management_campaign_by_loaction_ye NUMERIC Campaign management campaign by loaction ye Campaign management campaign by loaction ye
campaign_management_campaign_by_loaction_za NUMERIC Campaign management campaign by loaction za Campaign management campaign by loaction za
campaign_management_campaign_by_loaction_zw NUMERIC Campaign management campaign by loaction zw Campaign management campaign by loaction zw
campaign_management_campaign_details_campaign_key TEXT Campaign management campaign details campaign key Campaign management campaign details campaign key
campaign_management_campaign_details_campaign_name TEXT Campaign management campaign details campaign name Campaign management campaign details campaign name
campaign_management_campaign_details_created_time TIMESTAMP Campaign management campaign details created time Campaign management campaign details created time
campaign_management_campaign_details_email_from TEXT Campaign management campaign details email from Campaign management campaign details email from
campaign_management_campaign_details_email_options TEXT Campaign management campaign details email options Campaign management campaign details email options
campaign_management_campaign_details_email_subject TEXT Campaign management campaign details email subject Campaign management campaign details email subject
campaign_management_campaign_details_email_type TEXT Campaign management campaign details email type Campaign management campaign details email type
campaign_management_campaign_details_reply_to TEXT Campaign management campaign details reply to Campaign management campaign details reply to
campaign_management_campaign_details_sent_time TIMESTAMP Campaign management campaign details sent time Campaign management campaign details sent time
campaign_management_campaign_reports_autoreply_count NUMERIC Campaign management campaign reports autoreply count Campaign management campaign reports autoreply count
campaign_management_campaign_reports_bounce_percent PERCENT Campaign management campaign reports bounce percent Campaign management campaign reports bounce percent
campaign_management_campaign_reports_bounces_count NUMERIC Campaign management campaign reports bounces count Campaign management campaign reports bounces count
campaign_management_campaign_reports_campaign_name TEXT Campaign management campaign reports campaign name Campaign management campaign reports campaign name
campaign_management_campaign_reports_clicksperopenrate PERCENT Campaign management campaign reports clicksperopenrate Campaign management campaign reports clicksperopenrate
campaign_management_campaign_reports_complaints_count NUMERIC Campaign management campaign reports complaints count Campaign management campaign reports complaints count
campaign_management_campaign_reports_complaints_percent PERCENT Campaign management campaign reports complaints percent Campaign management campaign reports complaints percent
campaign_management_campaign_reports_delivered_count NUMERIC Campaign management campaign reports delivered count Campaign management campaign reports delivered count
campaign_management_campaign_reports_delivered_percent PERCENT Campaign management campaign reports delivered percent Campaign management campaign reports delivered percent
campaign_management_campaign_reports_emails_sent_count NUMERIC Campaign management campaign reports emails sent count Campaign management campaign reports emails sent count
campaign_management_campaign_reports_forward_percent PERCENT Campaign management campaign reports forward percent Campaign management campaign reports forward percent
campaign_management_campaign_reports_forwards_count NUMERIC Campaign management campaign reports forwards count Campaign management campaign reports forwards count
campaign_management_campaign_reports_hardbounce_count NUMERIC Campaign management campaign reports hardbounce count Campaign management campaign reports hardbounce count
campaign_management_campaign_reports_open_percent PERCENT Campaign management campaign reports open percent Campaign management campaign reports open percent
campaign_management_campaign_reports_opens_count NUMERIC Campaign management campaign reports opens count Campaign management campaign reports opens count
campaign_management_campaign_reports_softbounce_count NUMERIC Campaign management campaign reports softbounce count Campaign management campaign reports softbounce count
campaign_management_campaign_reports_spam_percent PERCENT Campaign management campaign reports spam percent Campaign management campaign reports spam percent
campaign_management_campaign_reports_spams_count NUMERIC Campaign management campaign reports spams count Campaign management campaign reports spams count

Zoho CRM Campaign Management fields (campaign_management_campaign_reports_unique_clicked_percent to campaign_management_campaign_reports_unsubscribe_percent)

ID Type Name Description
campaign_management_campaign_reports_unique_clicked_percent PERCENT Campaign management campaign reports unique clicked percent Campaign management campaign reports unique clicked percent
campaign_management_campaign_reports_unique_clicks_count NUMERIC Campaign management campaign reports unique clicks count Campaign management campaign reports unique clicks count
campaign_management_campaign_reports_unopened TEXT Campaign management campaign reports unopened Campaign management campaign reports unopened
campaign_management_campaign_reports_unopened_percent PERCENT Campaign management campaign reports unopened percent Campaign management campaign reports unopened percent
campaign_management_campaign_reports_unsent_count NUMERIC Campaign management campaign reports unsent count Campaign management campaign reports unsent count
campaign_management_campaign_reports_unsent_percent PERCENT Campaign management campaign reports unsent percent Campaign management campaign reports unsent percent
campaign_management_campaign_reports_unsub_count NUMERIC Campaign management campaign reports unsub count Campaign management campaign reports unsub count
campaign_management_campaign_reports_unsubscribe_percent PERCENT Campaign management campaign reports unsubscribe percent Campaign management campaign reports unsubscribe percent

Zoho CRM Campaigns fields

The Campaigns report of the Zoho CRM connector includes 24 fields.

ID Type Name Description
campaigns_actual_cost TEXT Actual Cost The actual cost spent on the campaign
campaigns_budgeted_cost TEXT Budgeted Cost The planned amount to be spent on the campaign
campaigns_campaign_name TEXT Campaigns Campaign Name Name of the Campaign
campaigns_created_by TEXT Campaigns Created By Created By
campaigns_created_time TIMESTAMP Campaigns Created Time Date and time at which the record was created. This is a system-generated field. You cannot modify it.
campaigns_currency TEXT Campaign Currency The currency in which the revenue is generated
campaigns_description TEXT Campaigns Description Description about the Campaign
campaigns_end_date DATE End Date The date on which the Campaign ends
campaigns_exchange_rate TEXT Exchange Rate Represents the exchange rate of the currency of the campaign amount
campaigns_expected_response TEXT Expected Response Expected response
campaigns_expected_revenue TEXT Campaigns Expected Revenue Represents the expected revenue of the campaign.
campaigns_id TEXT Campaigns Id The unique ID of the campaign
campaigns_layout TEXT Campaigns Layout Layout
campaigns_modified_by TEXT Campaigns Modified By Modified By
campaigns_modified_time TIMESTAMP Campaigns Modified Time Date and time at which the record was last modified. This is a system-generated field. You cannot modify it.
campaigns_num_sent TEXT Num Sent The number of leads/contacts to whom the campaign details have been sent
campaigns_owner TEXT Campaigns Campaign Owner id Campaign Owner id
campaigns_owner_first_name TEXT Campaigns Owner First Name Campaigns Owner First Name
campaigns_owner_last_name TEXT Campaigns Owner Last Name Campaigns Owner Last Name
campaigns_parent_campaign TEXT Parent Campaign Represents the details of the parent campaign, if any
campaigns_start_date DATE Start Date The date on which the Campaign starts
campaigns_status TEXT Campaigns Status Represents the status of the campaign
campaigns_tag TEXT Campaigns Tag Tag
campaigns_type TEXT Campaigns Type Represents the type of Campaign

Zoho CRM Cases fields

The Cases report of the Zoho CRM connector includes 29 fields.

ID Type Name Description
cases_account_name TEXT Cases Account Name Account Name
cases_add_comment TEXT Cases Add Comment Add Comment
cases_case_number TEXT Case Number Case Number
cases_case_origin TEXT Case Origin Case Origin
cases_comments TEXT Cases Comments Comments
cases_created_by TEXT Cases Created By Created By
cases_created_time TIMESTAMP Cases Created Time Created Time
cases_deal_name TEXT Cases Deal Name Deal Name
cases_description TEXT Cases Description Description
cases_email TEXT Cases Email Email
cases_id TEXT Cases Record Id Record Id
cases_internal_comments TEXT Cases Internal Comments Internal Comments
cases_locked__s TEXT Cases Locked Locked
cases_modified_by TEXT Cases Modified By Modified By
cases_modified_time TIMESTAMP Cases Modified Time Modified Time
cases_no_of_comments TEXT Cases No. Of Comments No. Of Comments
cases_owner TEXT Cases Case Owner id Case Owner id
cases_owner_first_name TEXT Cases Owner First Name Cases Owner First Name
cases_owner_last_name TEXT Cases Owner Last Name Cases Owner Last Name
cases_phone TEXT Cases Phone Phone
cases_priority TEXT Cases Priority Priority
cases_product_name TEXT Cases Product Name Product Name
TEXT Cases Related To Related To
cases_reported_by TEXT Cases Reported By Reported By
cases_solution TEXT Cases Solution Solution
cases_status TEXT Cases Status Status
cases_subject TEXT Cases Subject Subject
cases_tag TEXT Cases Cases Tag Tag
cases_type TEXT Cases Type Type

Zoho CRM Contacts fields

The Contacts report of the Zoho CRM connector includes 77 fields.

Zoho CRM Contacts fields (contacts_account_name to contacts_last_name)

ID Type Name Description
contacts_account_name TEXT Contacts Account Name Account Name
contacts_ad TEXT Contact Ad Ad
contacts_ad_campaign_name TEXT Contacts Ad campaign name Ad campaign name
contacts_ad_click_date DATE Contacts Ad click date Ad click date
contacts_ad_network TEXT Contacts Ad network Ad Network
contacts_adgroup_name TEXT Contacts Adgroup name Adgroup name
contacts_adgroupid TEXT Contacts Adgroupid Adgroupid
contacts_adid TEXT Contacts Adid Adid
contacts_assistant TEXT Contacts Assistant Name of the contact's assistant
contacts_asst_phone TEXT Contacts Asst phone Phone number of the Contact's assistant, if any
contacts_average_time_spent_minutes TIMESTAMP Contacts Average time spent minutes Average time spent minutes
contacts_change_log_time__s TIMESTAMP Contacts Change Log Time Change Log Time
contacts_click_type TEXT Contacts Contact Click type Click type
contacts_conversion_export_status TEXT Contacts Conversion export status Conversion export status
contacts_conversion_exported_on TEXT Contacts Conversion exported on Conversion exported on
contacts_cost_per_click TEXT Contacts Cost per click Cost per click
contacts_cost_per_conversion TEXT Contacts Contact Cost per conversion Cost per conversion
contacts_created_by TEXT Contacts Created By Created By
contacts_created_time TIMESTAMP Contacts Created time Date and time at which the record was created. This is a system-generated field. You cannot modify it.
contacts_date_of_birth DATE Contacts Date of birth Date of birth of the Contact in mm/dd/yyyy format
contacts_days_visited TEXT Contacts Days visited The number of days the contact visited Zoho CRM
contacts_department TEXT Contacts Department Represents the department of the contact
contacts_description TEXT Contacts Contact Description Description of the Contact
contacts_device_type TEXT Contacts Contact Device type Device type
contacts_email TEXT Contacts Email Email ID of the contact
contacts_email_opt_out TEXT Contacts Email opt out Specifies whether the contact has opted out of email notifications from Zoho CRM
contacts_enrich_status__s TEXT Contacts Enrich Status Enrich Status
contacts_fax TEXT Contacts Fax Fax number of the Contact
contacts_first_name TEXT Contacts First name Represents the first name of the Contact
contacts_first_visited_time TIMESTAMP Contacts First visited time Date and time at which the Contact first visited Zoho CRM. This is a system-generated field. You cannot modify it.
contacts_first_visited_url TEXT Contacts First visited url The URL address of the page that the contact visited first. This is a system-generated field. You cannot modify it.
contacts_full_name TEXT Contacts Full name Represents the full name of the Contact
contacts_gadconfigid TEXT Contacts Gadconfigid Gadconfigid
contacts_gclid TEXT Contacts Gclid GCL ID
contacts_home_phone TEXT Home Phone Home Phone
contacts_id TEXT Contacts Id Unique ID of the Contact
contacts_keyword TEXT Contacts Contact Keyword keyword
contacts_last_activity_time TIMESTAMP Contacts Last activity time The date and time at which the record was last used in an operation. This is a system-generated field. You cannot modify it.
contacts_last_enriched_time__s TIMESTAMP Contacts Last Enriched Time Last Enriched Time
contacts_last_name TEXT Contacts Last name Last name of the Contact. This is a mandatory field.

Zoho CRM Contacts fields (contacts_last_visited_time to contacts_zcampaignid)

ID Type Name Description
contacts_last_visited_time TIMESTAMP Contacts Last visited time The date and time at which the Contact last visited Zoho CRM. This is a system-generated field. You cannot modify it.
contacts_lead_source TEXT Contacts Lead source Contacts Lead Source
contacts_locked__s TEXT Contacts Locked Locked
contacts_mailing_city CITY Contacts Mailing city Represents address details of the Contact
contacts_mailing_country COUNTRY Contacts Mailing country The other address of the contact, if any
contacts_mailing_state TEXT Contacts Mailing state Primary mailing address of the contact
contacts_mailing_street TEXT Contacts Mailing street Represents address details of the Contact
contacts_mailing_zip TEXT Contacts Mailing zip Represents address details of the Contact
contacts_mobile TEXT Contacts Mobile Mobile number of the Contact
contacts_modified_by TEXT Contacts Modified By Modified By
contacts_modified_time TIMESTAMP Contacts Modified time Date and time at which the record was last modified. This is a system-generated field. You cannot modify it.
contacts_number_of_chats TEXT Contacts Number of chats The number of times the contact has had a chat with the Zoho CRM team. This is a system-generated field. You cannot modify it.
contacts_other_city CITY Contacts Other city Represents address details of the Contact
contacts_other_country COUNTRY Contacts Other country The other address of the contact, if any
contacts_other_phone TEXT Contacts Other phone The other phone number of the contact, if any
contacts_other_state REGION Contacts Other state The other address of the contact, if any
contacts_other_street TEXT Contacts Other street Represents address details of the Contact
contacts_other_zip TEXT Contacts Other zip Represents address details of the Contact
contacts_owner TEXT Contacts Contact Owner id Contact Owner id
contacts_owner_first_name TEXT Contacts Owner First Name Contacts Owner First Name
contacts_owner_last_name TEXT Contacts Owner Last Name Contacts Owner Last Name
contacts_phone TEXT Contacts Phone The phone number of the Contact
contacts_reason_for_conversion_failure TEXT Contacts Reason for conversion failure Reason for conversion failure
contacts_referrer TEXT Contacts Contact Referrer Referrer
contacts_reporting_to TEXT Contacts Reporting to Reporting to
contacts_salutation TEXT Contacts Salutation Mr., Ms, Mrs., or others
contacts_search_partner_network TEXT Contacts Search partner network Search partner network
contacts_secondary_email TEXT Contacts Secondary email Alternate email address of the contact
contacts_skype_id TEXT Contacts Skype id The Skype ID of the Contact
contacts_tag TEXT Contacts Contact Tag Name and ID of the Contact who referred this Contact
contacts_title TEXT Contacts Contact Title Title/job position of the Contact
contacts_twitter TEXT Contacts Twitter The Twitter handle of the contact
contacts_unsubscribed_mode TEXT Contacts Unsubscribed mode Unsubscribed mode
contacts_unsubscribed_time TIMESTAMP Contacts Unsubscribed time Unsubscribed time
contacts_vendor_name TEXT Contacts Vendor name Vendor Name
contacts_visitor_score TEXT Contacts Visitor score Score for the contact obtained from SalesIQ
contacts_zcampaignid TEXT Contacts Zcampaignid Zcampaignid

Zoho CRM Deals fields

The Deals report of the Zoho CRM connector includes 53 fields.

Zoho CRM Deals fields (deals_account_name to deals_modified_time)

ID Type Name Description
deals_account_name TEXT Deals Account Name Account Name
deals_ad TEXT Deals Ad Ad
deals_ad_campaign_name TEXT Deals Ad Campaign Name Ad Campaign Name
deals_ad_click_date DATE Deals Ad Click Date Ad Click Date
deals_ad_network TEXT Deals Ad Network Ad Network
deals_adgroup_name TEXT Deals Adgroup Name Adgroup Name
deals_adgroupid TEXT Deals Adgroupid Adgroupid
deals_adid TEXT Deals Adid Adid
deals_amount NUMERIC Deals Amount Amount
deals_campaign_source TEXT Deals Campaign Source Campaign Source
deals_campaign_source_id TEXT Deals Campaign Source Id Id of the campaign a deal is associated with, for joining deals to the Campaigns table
deals_campaign_source_name TEXT Deals Campaign Source Name Name of the campaign a deal is associated with
deals_change_log_time__s TIMESTAMP Deals Change Log Time Change Log Time
deals_click_type TEXT Deals Click Type Click Type
deals_closing_date DATE Deals Closing Date Closing Date
deals_contact_first_name TEXT Deals Contact First Name Deals Contact First Name
deals_contact_id TEXT Deals Contact id Deals Contact id
deals_contact_last_name TEXT Deals Contact last Name Deals Contact last Name
deals_contact_name TEXT Deals Contact First Name (alias for deals_contact_first_name) Deals Contact First Name
deals_conversion_export_status TEXT Deals Conversion Export Status Conversion Export Status
deals_conversion_exported_on TEXT Deals Conversion Exported On Conversion Exported On
deals_cost_per_click TEXT Deals Cost Per Click Cost Per Click
deals_cost_per_conversion TEXT Deals Cost Per Conversion Cost Per Conversion
deals_created_by TEXT Deals Created By Created By
deals_created_time TIMESTAMP Deals Created Time Created Time
deals_deal_name TEXT Deals Deal Name Deal Name
deals_description TEXT Deals Description Description
deals_device_type TEXT Deals Device Type Device Type
deals_expected_revenue TEXT Deals Expected Revenue Expected Revenue
deals_gadconfigid TEXT Deals Gadconfigid Gadconfigid
deals_gclid TEXT Deals Gclid Gclid
deals_id TEXT Deals Record Id Record Id
deals_keyword TEXT Deals Keyword Keyword
deals_keywordid TEXT Deals Keywordid Keywordid
deals_last_activity_time TIMESTAMP Deals Last Activity Time Last Activity Time
deals_lead_conversion_time TIMESTAMP Deals Lead Conversion Time Lead Conversion Time
deals_lead_source TEXT Deals Lead Source Lead Source
deals_locked__s TEXT Deals Locked Locked
deals_modified_by TEXT Deals Modified By Modified By
deals_modified_time TIMESTAMP Deals Modified Time Modified Time

Zoho CRM Deals fields (deals_next_step to deals_zcampaignid)

ID Type Name Description
deals_next_step TEXT Deals Next Step Next Step
deals_overall_sales_duration TEXT Deals Overall Sales Duration Overall Sales Duration
deals_owner TEXT Deals Deal Owner id Deal Owner id
deals_owner_first_name TEXT Deals Owner First Name Deals Owner First Name
deals_owner_last_name TEXT Deals Owner Last Name Deals Owner Last Name
deals_probability TEXT Deals Probability (%) Probability (%)
deals_reason_for_conversion_failure TEXT Deals Reason For Conversion Failure Reason For Conversion Failure
deals_sales_cycle_duration TEXT Deals Sales Cycle Duration Sales Cycle Duration
deals_search_partner_network TEXT Deals Search Partner Network Search Partner Network
deals_stage TEXT Deals Stage Stage
deals_tag TEXT Deals Tag Tag
deals_type TEXT Deals Type Type
deals_zcampaignid TEXT Deals Zcampaignid Zcampaignid

Zoho CRM Desk fields

The Desk report of the Zoho CRM connector includes 44 fields.

Zoho CRM Desk fields (ticket_approval_count to ticket_team)

ID Type Name Description
ticket_approval_count NUMERIC Ticket approval count Number of approvals associated with the ticket
ticket_assignee OBJECT Ticket assignee details Agent assigned to resolve the ticket
ticket_assignee_id TEXT Ticket assignee ID ID of agent to whom the ticket is assigned
ticket_attachment_count NUMERIC Ticket attachment count Number of attachments in the ticket
ticket_category TEXT Ticket category Category of the ticket
ticket_channel TEXT Ticket channel Channel through which the ticket originated (e.g. email)
ticket_channel_code TEXT Ticket channel code Code of the ticket's source channel
ticket_classification TEXT Ticket type Type of ticket. Values supported are Problem, Request, Question, and Others.
ticket_closed_date DATE Ticket closed date and time Time of closing the ticket
ticket_comment_count NUMERIC Ticket comments count Number of comments in the ticket
ticket_contact OBJECT Ticket contact details Details of the contact who raised the ticket
ticket_contact_id TEXT Ticket contact ID ID of the contact who raised the ticket
ticket_created_date DATE Ticket created datetime Date and time of creating the ticket
ticket_custom_fields OBJECT Ticket custom fields Custom fields in the ticket
ticket_customer_response_date DATE Ticket customer response date and time Time of receiving customer response
ticket_department OBJECT Ticket department details Details of the department to which the ticket belongs
ticket_department_id TEXT Ticket department ID ID of the department to which the ticket belongs
ticket_due_date DATE Ticket due date and time Due date and time for resolving the ticket
ticket_email TEXT Ticket email Email in the ticket
ticket_id TEXT Zoho Desk Ticket ID ID of the ticket
ticket_is_deleted BOOLEAN Is ticket deleted Key that returns if the ticket is deleted or not
ticket_is_following BOOLEAN Is ticket following Key that returns if the current user follows the ticket or not
ticket_is_read BOOLEAN Is ticket read Key that denotes if the current user has read the ticket or not
ticket_is_trashed BOOLEAN Is ticket trashed Field that denotes whether the ticket is in trash
ticket_language TEXT Ticket language Language preference to set for the ticket
ticket_modified_date DATE Ticket modified datetime Date and time of modifying the ticket
ticket_number TEXT Ticket number Index/Serial number of the ticket
ticket_phone TEXT Ticket phone Phone number in the ticket
ticket_priority TEXT Ticket priority Priority of the ticket
ticket_product OBJECT Ticket product details Product associated with the ticket
ticket_resolution TEXT Ticket resolution Resolution notes recorded in the ticket
ticket_response_due_date DATE Ticket response due date and time Date on or before which a response must be sent for the ticket
ticket_source OBJECT Ticket source details Details of the ticket source from channel
ticket_status TEXT Zoho Desk Ticket status Status of the ticket. Includes the custom statuses configured in your help desk portal.
ticket_status_type TEXT Ticket Status Type Type of ticket resolution status.The values supported are OPEN and ON HOLD and CLOSED.
ticket_subcategory TEXT Ticket subcategory Subcategory of the ticket
ticket_subject TEXT Ticket subject Subject of the ticket
ticket_tags TEXT Ticket tags Comma-separated list of ticket tags
ticket_task_count NUMERIC Ticket task count Number of tasks associated with the ticket
ticket_team OBJECT Ticket team details Details of the team assigned to resolve the ticket

Zoho CRM Desk fields (ticket_team_id to ticket_url)

ID Type Name Description
ticket_team_id TEXT Ticket team ID ID of the team assigned to resolve the ticket
ticket_thread_count NUMERIC Ticket thread count Number of threads associated in the ticket
ticket_time_entry_count NUMERIC Ticket time entry count Number of time entries recorded in the ticket
ticket_url TEXT Ticket URL URL to access the resource

Zoho CRM Events fields

The Events report of the Zoho CRM connector includes 33 fields.

ID Type Name Description
events_all_day TEXT Events All Day All Day
events_check_in_address TEXT Check-In Address Check-In Address
events_check_in_by TEXT Check-In By Check-In By
events_check_in_city CITY Check-In City Check-In City
events_check_in_comment TEXT Check-In Comment Check-In Comment
events_check_in_country COUNTRY Check-In Country Check-In Country
events_check_in_state TEXT Check-In State Check-In State
events_check_in_status TEXT Checked In Status Checked In Status
events_check_in_sub_locality TEXT Check-In Sub-Locality Check-In Sub-Locality
events_check_in_time TIMESTAMP Check-In Time Check-In Time
events_created_by TEXT Events Created By Created By
events_created_time TIMESTAMP Events Created Time Created Time
events_description TEXT Events Description Description
events_end_datetime TIMESTAMP Events To To
events_event_title TEXT Events Title Title
events_id TEXT Events Record Id Record Id
events_latitude TEXT Events Latitude Latitude
events_longitude TEXT Events Longitude Longitude
events_modified_by TEXT Events Modified By Modified By
events_modified_time TIMESTAMP Events Modified Time Modified Time
events_owner TEXT Events Event Owner id Event Owner id
events_owner_first_name TEXT Events Owner First Name Events Owner First Name
events_owner_last_name TEXT Events Owner Last Name Events Owner Last Name
events_participants TEXT Events Participants Participants
events_recurring_activity TEXT Events Repeat Repeat
events_remind_at TEXT Event Reminder Reminder
events_remind_participants TEXT Events Participants Reminder Participants Reminder
events_start_datetime TIMESTAMP Events From From
events_tag TEXT Events Tag Tag
events_venue TEXT Events Location Location
events_what_id TEXT Events Related To Related To
events_who_id TEXT Events Contact Name Contact Name
events_zip_code TEXT Events Zip Code Zip Code

Zoho CRM Invoices fields

The Invoices report of the Zoho CRM connector includes 42 fields.

Zoho CRM Invoices fields (invoices_account_name to invoices_tag)

ID Type Name Description
invoices_account_name TEXT Invoices Account Name Account Name
invoices_adjustment TEXT Invoices Adjustment Adjustment
invoices_billing_city CITY Invoices Billing City Billing City
invoices_billing_code TEXT Invoices Billing Code Billing Code
invoices_billing_country COUNTRY Invoices Billing Country Billing Country
invoices_billing_state TEXT Invoices Billing State Billing State
invoices_billing_street TEXT Invoices Billing Street Billing Street
invoices_contact_first_name TEXT Invoices Contact First Name Invoices Contact First Name
invoices_contact_id TEXT Invoices Contact id Invoices Contact id
invoices_contact_last_name TEXT Invoices Contact last Name Invoices Contact last Name
invoices_contact_name TEXT Invoices Contact First Name (alias for invoices_contact_first_name) Invoices Contact First Name
invoices_created_by TEXT Invoices Created By Created By
invoices_created_time TIMESTAMP Invoices Created Time Created Time
invoices_description TEXT Invoices Description Description
invoices_discount TEXT Invoices Discount Discount
invoices_due_date DATE Invoices Due Date Due Date
invoices_excise_duty TEXT Invoices Excise Duty Excise Duty
invoices_grand_total TEXT Invoices Grand Total Grand Total
invoices_id TEXT Invoices Record Id Record Id
invoices_invoice_date DATE Invoice Date Invoice Date
invoices_invoice_number TEXT Invoices Invoice Number Invoice Number
invoices_invoiced_items TEXT Invoices Invoiced Items Invoiced Items
invoices_locked__s TEXT Invoices Locked Locked
invoices_modified_by TEXT Invoices Modified By Modified By
invoices_modified_time TIMESTAMP Invoices Modified Time Modified Time
invoices_owner TEXT Invoices Invoice Owner id Invoice Owner id
invoices_owner_first_name TEXT Invoices Owner First Name Invoices Owner First Name
invoices_owner_last_name TEXT Invoices Owner Last Name Invoices Owner Last Name
invoices_purchase_order TEXT Invoices Purchase Order Purchase Order
invoices_sales_commission TEXT Invoices Sales Commission Sales Commission
invoices_sales_order TEXT Invoices Sales Order Sales Order
invoices_shipping_city CITY Invoices Shipping City Shipping City
invoices_shipping_code TEXT Invoices Shipping Code Shipping Code
invoices_shipping_country COUNTRY Invoices Shipping Country Shipping Country
invoices_shipping_state TEXT Invoices Shipping State Shipping State
invoices_shipping_street TEXT Invoices Shipping Street Shipping Street
invoices_status TEXT Invoices Status Status
invoices_sub_total TEXT Invoices Sub Total Sub Total
invoices_subject TEXT Invoices Subject Subject
invoices_tag TEXT Invoices Tag Tag

Zoho CRM Invoices fields (invoices_tax to invoices_terms_and_conditions)

ID Type Name Description
invoices_tax TEXT Invoices Tax Tax
invoices_terms_and_conditions TEXT Invoices Terms And Conditions Terms And Conditions

Zoho CRM Leads fields

The Leads report of the Zoho CRM connector includes 88 fields.

Zoho CRM Leads fields (country to leads_fax)

ID Type Name Description
country COUNTRY Country Country
email TEXT Email Email
first_visited_time TIMESTAMP First Visited Time First Visited Time
first_visited_url TEXT First Visited URL First Visited URL
firstname TEXT First Name First Name
lastname TEXT Last Name Last Name
lead_status TEXT Lead Status Lead Status
leads_ad TEXT Leads Ad Ad
leads_ad_campaign_name TEXT Leads Ad Campaign Name Ad Campaign Name
leads_ad_click_date DATE Leads Ad Click Date Ad Click Date
leads_ad_network TEXT Leads Ad Network Ad Network
leads_adgroup_name TEXT Leads AdGroup Name Leads AdGroup Name
leads_adgroupid TEXT Adgroupid Adgroupid
leads_adid TEXT Leads Adid Adid
leads_annual_revenue TEXT Leads Annual Revenue Annual Revenue
leads_average_time_spent_minutes TEXT Average Time Spent (Minutes) Average Time Spent (Minutes)
leads_change_log_time__s TIMESTAMP Leads Change Log Time Change Log Time
leads_city CITY Leads City City
leads_click_type TEXT Leads Click Type Click Type
leads_company TEXT Company Company
leads_conversion_export_status TEXT Leads Conversion Export Status Conversion Export Status
leads_conversion_exported_on TEXT Leads Conversion Exported On Conversion Exported On
leads_converted__s TEXT Is Converted Is Converted
leads_converted_account TEXT Converted Account Converted Account
leads_converted_contact TEXT Converted Contact Converted Contact
leads_converted_date_time TIMESTAMP Converted Date Time Converted Date Time
leads_converted_deal TEXT Converted Deal Converted Deal
leads_cost_per_click TEXT Cost Per Click Cost Per Click
leads_cost_per_conversion TEXT Leads Cost Per Conversion Cost Per Conversion
leads_country COUNTRY Leads Country Country
leads_created_by TEXT Created By Created By
leads_created_time TIMESTAMP Leads Created Time Created Time
leads_days_visited TEXT Days Visited Days Visited
leads_description TEXT Leads Description Description
leads_designation TEXT Leads Title Title
leads_device_type TEXT Leads Device Type Device Type
leads_email TEXT Leads Email Email
leads_email_opt_out TEXT Email Opt Out Email Opt Out
leads_enrich_status__s TEXT Enrich Status Enrich Status
leads_fax TEXT Fax Fax

Zoho CRM Leads fields (leads_first_name to leads_unsubscribed_time)

ID Type Name Description
leads_first_name TEXT Leads First Name First Name
leads_first_visited_time TIMESTAMP First Visit First Visit
leads_first_visited_url TEXT First Page Visited First Page Visited
leads_full_name TEXT Leads Full Name Full Name
leads_gadconfigid TEXT Leads Gadconfigid Gadconfigid
leads_gclid TEXT Leads Gclid Gclid
leads_id TEXT Leads Record Id Record Id
leads_industry TEXT Leads Industry Industry
leads_keyword TEXT Leads Keyword Keyword
leads_keywordid TEXT Leads Keywordid Keywordid
leads_last_activity_time TIMESTAMP Last Activity Time Last Activity Time
leads_last_enriched_time__s TIMESTAMP Leads Last Enriched Time Last Enriched Time
leads_last_name TEXT Leads Last Name Last Name
leads_last_visited_time TIMESTAMP Most Recent Visit Most Recent Visit
leads_lead_conversion_time TIMESTAMP Lead Conversion Time Lead Conversion Time
leads_lead_source TEXT Leads Lead Source Lead Source
leads_lead_status TEXT Leads Lead Status Lead Status
leads_locked__s TEXT Leads Locked Locked
leads_mobile TEXT Mobile Mobile
leads_modified_by TEXT Leads Modified By Modified By
leads_modified_time TIMESTAMP Leads Modified Time Modified Time
leads_no_of_employees TEXT No. Of Employees No. Of Employees
leads_number_of_chats TEXT Number Of Chats Number Of Chats
leads_owner TEXT Leads Lead Owner id Lead Owner id
leads_owner_first_name TEXT Leads Owner First Name Leads Owner First Name
leads_owner_last_name TEXT Leads Owner Last Name Leads Owner Last Name
leads_phone TEXT Phone Phone
leads_rating TEXT Leads Rating Rating
leads_reason_for_conversion_failure TEXT Reason For Conversion Failure Reason For Conversion Failure
leads_referrer TEXT Leads Referrer Referrer
leads_salutation TEXT Leads Salutation Salutation
leads_search_partner_network TEXT Leads Search Partner Network Search Partner Network
leads_secondary_email TEXT Secondary Email Secondary Email
leads_skype_id TEXT Skype Id Skype Id
leads_state TEXT Leads State State
leads_street TEXT Leads Street Street
leads_tag TEXT Leads Tag Tag
leads_twitter TEXT Leads Twitter Twitter
leads_unsubscribed_mode TEXT Unsubscribed Mode Unsubscribed Mode
leads_unsubscribed_time TIMESTAMP Unsubscribed Time Unsubscribed Time

Zoho CRM Leads fields (leads_visitor_score to trial_started_date)

ID Type Name Description
leads_visitor_score TEXT Visitor Score Visitor Score
leads_website TEXT Leads Website Website
leads_zcampaignid TEXT Zcampaignid Zcampaignid
leads_zip_code TEXT Leads Zip Code Zip Code
onboarding_completed TEXT Onboarding Completed Onboarding Completed
onboarding_started TEXT Onboarding Started Onboarding Started
referrer TEXT Referrer Referrer
trial_started_date DATE Trial Started Date Trial Started Date

Zoho CRM Price_Books fields

The Price_Books report of the Zoho CRM connector includes 15 fields.

ID Type Name Description
price_books_active TEXT Price Active Active
price_books_created_by TEXT Price Created By Created By
price_books_created_time TIMESTAMP Price Created Time Created Time
price_books_description TEXT Price Description Description
price_books_id TEXT Price Record Id Record Id
price_books_locked__s TEXT Price Locked Locked
price_books_modified_by TEXT Price Modified By Modified By
price_books_modified_time TIMESTAMP Price Modified Time Modified Time
price_books_owner TEXT Price Books Price Book Owner id Price Book Owner id
price_books_owner_first_name TEXT Price Books Owner First Name Price Books Owner First Name
price_books_owner_last_name TEXT Price Books Owner Last Name Price Books Owner Last Name
price_books_price_book_name TEXT Price Book Name Price Book Name
price_books_pricing_details TEXT Price Pricing Details Pricing Details
price_books_pricing_model TEXT Price Pricing Model Pricing Model
price_books_tag TEXT Price Tag Tag

Zoho CRM Products fields

The Products report of the Zoho CRM connector includes 31 fields.

ID Type Name Description
products_commission_rate TEXT Commission Rate Commission Rate
products_created_by TEXT Products Created By Created By
products_created_time TIMESTAMP Products Created Time Created Time
products_description TEXT Products Description Description
products_handler TEXT Handler Handler
products_id TEXT Products Record Id Record Id
products_manufacturer TEXT Manufacturer Manufacturer
products_modified_by TEXT Products Modified By Modified By
products_modified_time TIMESTAMP Products Modified Time Modified Time
products_owner TEXT Products Product Owner id Product Owner id
products_owner_first_name TEXT Products Owner First Name Products Owner First Name
products_owner_last_name TEXT Products Owner Last Name Products Owner Last Name
products_product_active TEXT Product Active Product Active
products_product_category TEXT Products Product Category Product Category
products_product_code TEXT Product Code Product Code
products_product_name TEXT Products Product Name Product Name
products_qty_in_demand TEXT Quantity In Demand Quantity In Demand
products_qty_in_stock TEXT Quantity In Stock Quantity In Stock
products_qty_ordered TEXT Qty Ordered Qty Ordered
products_record_image TEXT Product Image Product Image
products_reorder_level TEXT Reorder Level Reorder Level
products_sales_end_date DATE Sales End Date Sales End Date
products_sales_start_date DATE Sales Start Date Sales Start Date
products_support_expiry_date DATE Support End Date Support End Date
products_support_start_date DATE Support Start Date Support Start Date
products_tag TEXT Products Tag Tag
products_tax TEXT Products Tax Tax
products_taxable TEXT Taxable Taxable
products_unit_price TEXT Unit Price Unit Price
products_usage_unit TEXT Usage Unit Usage Unit
products_vendor_name TEXT Products Vendor Name Vendor Name

Zoho CRM Purchase_Orders fields

The Purchase_Orders report of the Zoho CRM connector includes 40 fields.

ID Type Name Description
purchase_orders_adjustment TEXT Purchase Adjustment Adjustment
purchase_orders_billing_city CITY Purchase Billing City Billing City
purchase_orders_billing_code TEXT Purchase Billing Code Billing Code
purchase_orders_billing_country COUNTRY Purchase Billing Country Billing Country
purchase_orders_billing_state TEXT Purchase Billing State Billing State
purchase_orders_billing_street TEXT Purchase Billing Street Billing Street
purchase_orders_carrier TEXT Purchase Carrier Carrier
purchase_orders_contact_first_name TEXT Purchase Orders Contact First Name Purchase Orders Contact First Name
purchase_orders_contact_id TEXT Purchase Orders Contact id Purchase Orders Contact id
purchase_orders_contact_last_name TEXT Purchase Orders Contact last Name Purchase Orders Contact last Name
purchase_orders_contact_name TEXT Purchase Orders Contact First Name (alias for purchase_orders_contact_first_name) Purchase Orders Contact First Name
purchase_orders_created_by TEXT Purchase Created By Created By
purchase_orders_description TEXT Purchase Description Description
purchase_orders_discount TEXT Purchase Discount Discount
purchase_orders_due_date DATE Purchase Due Date Due Date
purchase_orders_excise_duty TEXT Purchase Excise Duty Excise Duty
purchase_orders_grand_total TEXT Purchase Grand Total Grand Total
purchase_orders_id TEXT Purchase Record Id Record Id
purchase_orders_locked__s TEXT Purchase Locked Locked
purchase_orders_modified_by TEXT Purchase Modified By Modified By
purchase_orders_modified_time TIMESTAMP Purchase Modified Time Modified Time
purchase_orders_owner TEXT Purchase Orders Purchase Order Owner id Purchase Order Owner id
purchase_orders_owner_first_name TEXT Purchase Orders Owner First Name Purchase Orders Owner First Name
purchase_orders_owner_last_name TEXT Purchase Orders Owner Last Name Purchase Orders Owner Last Name
purchase_orders_po_date DATE Purchase Po Date Po Date
purchase_orders_po_number TEXT Purchase Po Number Po Number
purchase_orders_purchase_items TEXT Purchase Items Purchase Items
purchase_orders_sales_commission TEXT Purchase Sales Commission Sales Commission
purchase_orders_shipping_city CITY Purchase Shipping City Shipping City
purchase_orders_shipping_code TEXT Purchase Shipping Code Shipping Code
purchase_orders_shipping_country COUNTRY Shipping Country Shipping Country
purchase_orders_shipping_state TEXT Purchase Shipping State Shipping State
purchase_orders_shipping_street TEXT Purchase Shipping Street Shipping Street
purchase_orders_status TEXT Purchase Status Status
purchase_orders_sub_total TEXT Purchase Sub Total Sub Total
purchase_orders_subject TEXT Purchase Subject Subject
purchase_orders_tag TEXT Purchase Tag Tag
purchase_orders_tax TEXT Purchase Tax Tax
purchase_orders_terms_and_conditions TEXT Purchase Terms And Conditions Terms And Conditions
purchase_orders_vendor_name TEXT Purchase Vendor Name Vendor Name

Zoho CRM Quotes fields

The Quotes report of the Zoho CRM connector includes 39 fields.

ID Type Name Description
quotes_account_name TEXT Quotes Account Name Account Name
quotes_adjustment TEXT Quotes Adjustment Adjustment
quotes_billing_city CITY Quotes Billing City Billing City
quotes_billing_code TEXT Quotes Billing Code Billing Code
quotes_billing_country COUNTRY Quotes Billing Country Billing Country
quotes_billing_state TEXT Quotes Billing State Billing State
quotes_billing_street TEXT Quotes Billing Street Billing Street
quotes_carrier TEXT Quotes Carrier Carrier
quotes_contact_first_name TEXT Quotes Contact First Name Quotes Contact First Name
quotes_contact_id TEXT Quotes Contact id Quotes Contact id
quotes_contact_last_name TEXT Quotes Contact last Name Quotes Contact last Name
quotes_contact_name TEXT Quotes Contact First Name (alias for quotes_contact_first_name) Quotes Contact First Name
quotes_created_by TEXT Quotes Created By Created By
quotes_created_time TIMESTAMP Quotes Created Time Created Time
quotes_deal_name TEXT Quotes Deal Name Deal Name
quotes_description TEXT Quotes Description Description
quotes_discount TEXT Quotes Discount Discount
quotes_grand_total TEXT Quotes Grand Total Grand Total
quotes_id TEXT Quotes Record Id Record Id
quotes_locked__s TEXT Locked Locked
quotes_modified_by TEXT Quotes Modified By Modified By
quotes_modified_time TIMESTAMP Quotes Modified Time Modified Time
quotes_owner TEXT Quotes Quote Owner id Quote Owner id
quotes_owner_first_name TEXT Quotes Owner First Name Quotes Owner First Name
quotes_owner_last_name TEXT Quotes Owner Last Name Quotes Owner Last Name
quotes_quote_number TEXT Quote Number Quote Number
quotes_quote_stage TEXT Quote Stage Quote Stage
quotes_quoted_items TEXT Quoted Items Quoted Items
quotes_shipping_city CITY Quotes Shipping City Shipping City
quotes_shipping_code TEXT Quotes Shipping Code Shipping Code
quotes_shipping_country COUNTRY Quotes Shipping Country Shipping Country
quotes_shipping_state TEXT Quotes Shipping State Shipping State
quotes_shipping_street TEXT Quotes Shipping Street Shipping Street
quotes_sub_total TEXT Quotes Sub Total Sub Total
quotes_subject TEXT Quotes Subject Subject
quotes_tag TEXT Quotes Tag Tag
quotes_tax TEXT Quotes Tax Tax
quotes_terms_and_conditions TEXT Quotes Terms And Conditions Terms And Conditions
quotes_valid_till TEXT Valid Until Valid Until

Zoho CRM Sales_Orders fields

The Sales_Orders report of the Zoho CRM connector includes 44 fields.

Zoho CRM Sales_Orders fields (sales_orders_account_name to sales_orders_sub_total)

ID Type Name Description
sales_orders_account_name TEXT Sales Orders Account Name Account Name
sales_orders_adjustment TEXT Sales Adjustment Adjustment
sales_orders_billing_city CITY Sales Billing City Billing City
sales_orders_billing_code TEXT Sales Billing Code Billing Code
sales_orders_billing_country COUNTRY Sales Billing Country Billing Country
sales_orders_billing_state TEXT Sales Billing State Billing State
sales_orders_billing_street TEXT Sales Billing Street Billing Street
sales_orders_carrier TEXT Sales Carrier Carrier
sales_orders_contact_first_name TEXT Sales Orders Contact First Name Sales Orders Contact First Name
sales_orders_contact_id TEXT Sales Orders Contact id Sales Orders Contact id
sales_orders_contact_last_name TEXT Sales Orders Contact last Name Sales Orders Contact last Name
sales_orders_contact_name TEXT Sales Orders Contact First Name (alias for sales_orders_contact_first_name) Sales Orders Contact First Name
sales_orders_created_by TEXT Sales Created By Created By
sales_orders_created_time TIMESTAMP Sales Created Time Created Time
sales_orders_deal_name TEXT Sales Deal Name Deal Name
sales_orders_description TEXT Sales Description Description
sales_orders_discount TEXT Sales Discount Discount
sales_orders_due_date DATE Due Date Due Date
sales_orders_excise_duty TEXT Excise Duty Excise Duty
sales_orders_grand_total TEXT Sales Grand Total Grand Total
sales_orders_id TIMESTAMP Sales Record Id Record Id
sales_orders_locked__s TEXT Sales Locked Locked
sales_orders_modified_by TEXT Sales Modified By Modified By
sales_orders_modified_time TIMESTAMP Sales Modified Time Modified Time
sales_orders_ordered_items TEXT Sales Ordered Items Ordered Items
sales_orders_owner TEXT Sales Orders Sales Order Owner id Sales Order Owner id
sales_orders_owner_first_name TEXT Sales Orders Owner First Name Sales Orders Owner First Name
sales_orders_owner_last_name TEXT Sales Orders Owner Last Name Sales Orders Owner Last Name
sales_orders_pending TEXT Pending Pending
sales_orders_purchase_order TEXT Purchase Order Purchase Order
sales_orders_quote_name TEXT Quote Name Quote Name
sales_orders_sales_commission TEXT Sales Sales Commission Sales Commission
sales_orders_shipping_city CITY Sales Shipping City Shipping City
sales_orders_shipping_code TEXT Sales Shipping Code Shipping Code
sales_orders_shipping_country COUNTRY Sales Shipping Country Shipping Country
sales_orders_shipping_state TEXT Sales Shipping State Shipping State
sales_orders_shipping_street TEXT Sales Shipping Street Shipping Street
sales_orders_so_number TEXT So Number So Number
sales_orders_status TEXT Sales Orders Status Status
sales_orders_sub_total TEXT Sales Sub Total Sub Total

Zoho CRM Sales_Orders fields (sales_orders_subject to sales_orders_terms_and_conditions)

ID Type Name Description
sales_orders_subject TEXT Sales Subject Subject
sales_orders_tag TEXT Sales Tag Tag
sales_orders_tax TEXT Sales Tax Tax
sales_orders_terms_and_conditions TEXT Sales Terms And Conditions Terms And Conditions

Zoho CRM Solutions fields

The Solutions report of the Zoho CRM connector includes 20 fields.

ID Type Name Description
solutions_add_comment TEXT Solutions Add Comment Add Comment
solutions_answer TEXT Solutions Answer Answer
solutions_comments TEXT Solutions Comments Comments
solutions_created_by TEXT Solutions Created By Created By
solutions_created_time TIMESTAMP Solutions Created Time Created Time
solutions_id TEXT Solutions Record Id Record Id
solutions_locked__s TEXT Solutions Locked Locked
solutions_modified_by TEXT Solutions Modified By Modified By
solutions_modified_time TIMESTAMP Solutions Modified Time Modified Time
solutions_no_of_comments TEXT Solutions No. Of Comments No. Of Comments
solutions_owner TEXT Solutions Solution Owner id Solution Owner id
solutions_owner_first_name TEXT Solutions Owner First Name Solutions Owner First Name
solutions_owner_last_name TEXT Solutions Owner Last Name Solutions Owner Last Name
solutions_product_name TEXT Solutions Product Name Product Name
solutions_published TEXT Solutions Published Published
solutions_question TEXT Solutions Question Question
solutions_solution_number TEXT Solution Number Solution Number
solutions_solution_title TEXT Solution Title Solution Title
solutions_status TEXT Solutions Status Status
solutions_tag TEXT Solutions Tag Tag

Zoho CRM Stage_History fields

The Stage_History report of the Zoho CRM connector includes 9 fields.

ID Type Name Description
stage_history_amount NUMERIC Stage History Amount Deal amount at the time of the stage change.
stage_history_closing_date DATE Stage History Closing Date Closing date at the time of the stage change.
stage_history_deal_id TEXT Stage History Deal ID Parent Deal record ID for the stage transition.
stage_history_duration NUMERIC Stage History Duration Number of days the deal stayed in the previous stage.
stage_history_expected_revenue NUMERIC Stage History Expected Revenue Expected revenue at the time of the stage change.
stage_history_modified_by TEXT Stage History Modified By Name of the user who changed the stage.
stage_history_modified_time TIMESTAMP Stage History Modified Time Timestamp of the stage change.
stage_history_probability NUMERIC Stage History Probability Probability percentage mapped to the stage.
stage_history_stage TEXT Stage History Stage Stage name at the time of the transition.

Zoho CRM Tasks fields

The Tasks report of the Zoho CRM connector includes 21 fields.

ID Type Name Description
tasks_closed_time TIMESTAMP Tasks Closed Time Closed Time
tasks_created_by TEXT Tasks Created By Created By
tasks_created_time TIMESTAMP Tasks Created Time Created Time
tasks_description TEXT Tasks Description Description
tasks_due_date DATE Tasks Due Date Due Date
tasks_id TEXT Tasks Record Id Record Id
tasks_locked__s TEXT Tasks Locked Locked
tasks_modified_by TEXT Tasks Modified By Modified By
tasks_modified_time TIMESTAMP Tasks Modified Time Modified Time
tasks_owner TEXT Tasks Task Owner id Task Owner id
tasks_owner_first_name TEXT Tasks Owner First Name Tasks Owner First Name
tasks_owner_last_name TEXT Tasks Owner Last Name Tasks Owner Last Name
tasks_priority TEXT Tasks Priority Priority
tasks_recurring_activity TEXT Tasks Repeat Repeat
tasks_remind_at TEXT Tasks Reminder Reminder
tasks_send_notification_email TEXT Tasks Send Notification Email Send Notification Email
tasks_status TEXT Tasks Status Status
tasks_subject TEXT Tasks Subject Subject
tasks_tag TEXT Tasks Tag Tag
tasks_what_id TEXT Tasks Related To Related To
tasks_who_id TEXT Tasks Contact Name Contact Name

Zoho CRM Vendors fields

The Vendors report of the Zoho CRM connector includes 23 fields.

ID Type Name Description
vendors_category TEXT Vendors Category Category
vendors_city CITY Vendors City City
vendors_country COUNTRY Vendors Country Country
vendors_created_by TEXT Vendors Created By Created By
vendors_created_time TIMESTAMP Vendors Created Time Created Time
vendors_description TEXT Vendors Description Description
vendors_email TEXT Vendors Email Email
vendors_gl_account TEXT Vendors Gl Account Gl Account
vendors_id TEXT Vendors Record Id Record Id
vendors_locked__s TEXT Vendors Locked Locked
vendors_modified_by TEXT Vendors Modified By Modified By
vendors_modified_time TIMESTAMP Vendors Modified Time Modified Time
vendors_owner TEXT Vendors Vendor Owner id Vendor Owner id
vendors_owner_first_name TEXT Vendors Owner First Name Vendors Owner First Name
vendors_owner_last_name TEXT Vendors Owner Last Name Vendors Owner Last Name
vendors_phone TEXT Vendors Phone Phone
vendors_record_image TEXT Vendor Image Vendor Image
vendors_state TEXT Vendors State State
vendors_street TEXT Vendors Street Street
vendors_tag TEXT Vendors Tag Tag
vendors_vendor_name TEXT Vendors Vendor Name Vendor Name
vendors_website TEXT Vendors Website Website
vendors_zip_code TEXT Vendors Zip Code Zip Code

Zoho CRM other fields

The Zoho CRM connector has 19 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
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
date DATE Date Date at which the record was created.
day_of_month TEXT Day of month Day of the month
month TEXT Month Number of the month
now TIMESTAMP Now Current timestamp
source TEXT Source The name of the Windsor connector returning the row
today DATE Today Today's date
week TEXT Week Week (Sun-Sat).
week_day TEXT Day of week and day number Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso TEXT Day of week and day number, ISO Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso TEXT Week ISO Week, ISO format (Mon-Sun).
year TEXT Year Year
year_month TEXT Yearmonth Year and month, e.g. 2024|3
year_month_name TEXT Year month name Year and month with the month name written out, e.g. "Jan 2025".
year_of_week TEXT Year of week The year that contains first day of the week (Sun-Sat).
year_of_week_iso TEXT Year of week, ISO The year that contains first day of the ISO week (Mon-Sun).
year_week TEXT Year week Year and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_iso TEXT Year week ISO Year and week for ISO weeks (Mon-Sun), e.g. 2024|20