Zoho CRM Connector Reference

168 metrics716 dimensions

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)

IDTypeNameDescription
accounts_account_nameTEXTAccounts Account NameAccount Name
accounts_account_numberTEXTAccounts Account NumberAccount Number
accounts_account_siteTEXTAccounts Account SiteAccount Site
accounts_account_typeTEXTAccounts Account TypeAccount Type
accounts_annual_revenueTEXTAccounts Annual RevenueAnnual Revenue
accounts_billing_cityCITYAccounts Billing CityBilling City
accounts_billing_codeTEXTAccounts Billing CodeBilling Code
accounts_billing_countryCOUNTRYAccounts Billing CountryBilling Country
accounts_billing_stateTEXTAccounts Billing StateBilling State
accounts_billing_streetTEXTAccounts Billing StreetBilling Street
accounts_change_log_time__sTIMESTAMPAccounts Change Log TimeChange Log Time
accounts_created_byTEXTAccounts Created ByCreated By
accounts_created_timeTIMESTAMPAccounts Created TimeCreated Time
accounts_descriptionTEXTAccounts DescriptionDescription
accounts_employeesTEXTAccounts EmployeesEmployees
accounts_enrich_status__sTEXTAccounts Enrich StatusEnrich Status
accounts_faxTEXTAccounts FaxFax
accounts_idTEXTAccounts Record IdRecord Id
accounts_industryTEXTAccounts IndustryIndustry
accounts_last_activity_timeTIMESTAMPAccounts Last Activity TimeLast Activity Time
accounts_last_enriched_time__sTIMESTAMPAccounts Last Enriched TimeLast Enriched Time
accounts_locked__sTEXTAccounts LockedLocked
accounts_modified_byTEXTAccounts Modified ByModified By
accounts_modified_timeTIMESTAMPAccounts Modified TimeModified Time
accounts_ownerTEXTAccounts Account Owner idAccount Owner id
accounts_owner_first_nameTEXTAccounts Owner First NameAccounts Owner First Name
accounts_owner_last_nameTEXTAccounts Owner Last NameAccounts Owner Last Name
accounts_ownershipTEXTAccounts OwnershipOwnership
accounts_parent_accountTEXTAccounts Parent AccountParent Account
accounts_phoneTEXTAccounts PhonePhone
accounts_ratingTEXTAccounts RatingRating
accounts_record_imageTEXTAccounts Account ImageAccount Image
accounts_shipping_cityCITYAccounts Shipping CityShipping City
accounts_shipping_codeTEXTAccounts Shipping CodeShipping Code
accounts_shipping_countryCOUNTRYAccounts Shipping CountryShipping Country
accounts_shipping_stateTEXTAccounts Shipping StateShipping State
accounts_shipping_streetTEXTAccounts Shipping StreetShipping Street
accounts_sic_codeTEXTAccounts Sic CodeSic Code
accounts_tagTEXTAccounts TagTag
accounts_ticker_symbolTEXTAccounts Ticker SymbolTicker Symbol

Zoho CRM Accounts fields (accounts_website to accounts_website)

IDTypeNameDescription
accounts_websiteTEXTAccounts WebsiteWebsite

Zoho CRM Calls fields

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

IDTypeNameDescription
calls_call_agendaTEXTCall AgendaCall Agenda
calls_call_durationTEXTCall DurationCall Duration
calls_call_duration_in_secondsTEXTCall Duration (In Seconds)Call Duration (In Seconds)
calls_call_purposeTEXTCall PurposeCall Purpose
calls_call_resultTEXTCall ResultCall Result
calls_call_start_timeTIMESTAMPCall Start TimeCall Start Time
calls_call_typeTEXTCall TypeCall Type
calls_caller_idTEXTCaller IdCaller Id
calls_created_byTEXTCalls Created ByCreated By
calls_created_timeTIMESTAMPCalls Created TimeCreated Time
calls_cti_entryTEXTCti EntryCti Entry
calls_descriptionTEXTCalls DescriptionDescription
calls_dialled_numberTEXTDialled NumberDialled Number
calls_idTEXTCalls Record IdRecord Id
calls_modified_byTEXTCalls Modified ByModified By
calls_modified_timeTIMESTAMPCalls Modified TimeModified Time
calls_outgoing_call_statusTEXTOutgoing Call StatusOutgoing Call Status
calls_ownerTEXTCalls Call Owner idCall Owner id
calls_owner_first_nameTEXTCalls Owner First NameCalls Owner First Name
calls_owner_last_nameTEXTCalls Owner Last NameCalls Owner Last Name
calls_reminderTEXTCalls ReminderReminder
calls_scheduled_in_crmTEXTScheduled In CrmScheduled In Crm
calls_subjectTEXTCalls SubjectSubject
calls_tagTEXTCalls TagTag
calls_voice_recording__sTEXTVoice RecordingVoice Recording
calls_what_idTEXTRelated ToRelated To
calls_who_idTEXTCalls Contact NameContact 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)

IDTypeNameDescription
campaign_management_campaign_by_loaction_adNUMERICCampaign management campaign by loaction adCampaign management campaign by loaction ad
campaign_management_campaign_by_loaction_aeNUMERICCampaign management campaign by loaction aeCampaign management campaign by loaction ae
campaign_management_campaign_by_loaction_afNUMERICCampaign management campaign by loaction afCampaign management campaign by loaction af
campaign_management_campaign_by_loaction_alNUMERICCampaign management campaign by loaction alCampaign management campaign by loaction al
campaign_management_campaign_by_loaction_amNUMERICCampaign management campaign by loaction amCampaign management campaign by loaction am
campaign_management_campaign_by_loaction_arNUMERICCampaign management campaign by loaction arCampaign management campaign by loaction ar
campaign_management_campaign_by_loaction_atNUMERICCampaign management campaign by loaction atCampaign management campaign by loaction at
campaign_management_campaign_by_loaction_auNUMERICCampaign management campaign by loaction auCampaign management campaign by loaction au
campaign_management_campaign_by_loaction_azNUMERICCampaign management campaign by loaction azCampaign management campaign by loaction az
campaign_management_campaign_by_loaction_baNUMERICCampaign management campaign by loaction baCampaign management campaign by loaction ba
campaign_management_campaign_by_loaction_bdNUMERICCampaign management campaign by loaction bdCampaign management campaign by loaction bd
campaign_management_campaign_by_loaction_beNUMERICCampaign management campaign by loaction beCampaign management campaign by loaction be
campaign_management_campaign_by_loaction_bgNUMERICCampaign management campaign by loaction bgCampaign management campaign by loaction bg
campaign_management_campaign_by_loaction_bhNUMERICCampaign management campaign by loaction bhCampaign management campaign by loaction bh
campaign_management_campaign_by_loaction_boNUMERICCampaign management campaign by loaction boCampaign management campaign by loaction bo
campaign_management_campaign_by_loaction_brNUMERICCampaign management campaign by loaction brCampaign management campaign by loaction br
campaign_management_campaign_by_loaction_byNUMERICCampaign management campaign by loaction byCampaign management campaign by loaction by
campaign_management_campaign_by_loaction_bzNUMERICCampaign management campaign by loaction bzCampaign management campaign by loaction bz
campaign_management_campaign_by_loaction_caNUMERICCampaign management campaign by loaction caCampaign management campaign by loaction ca
campaign_management_campaign_by_loaction_cdNUMERICCampaign management campaign by loaction cdCampaign management campaign by loaction cd
campaign_management_campaign_by_loaction_chNUMERICCampaign management campaign by loaction chCampaign management campaign by loaction ch
campaign_management_campaign_by_loaction_ciNUMERICCampaign management campaign by loaction ciCampaign management campaign by loaction ci
campaign_management_campaign_by_loaction_clNUMERICCampaign management campaign by loaction clCampaign management campaign by loaction cl
campaign_management_campaign_by_loaction_cmNUMERICCampaign management campaign by loaction cmCampaign management campaign by loaction cm
campaign_management_campaign_by_loaction_cnNUMERICCampaign management campaign by loaction cnCampaign management campaign by loaction cn
campaign_management_campaign_by_loaction_coNUMERICCampaign management campaign by loaction coCampaign management campaign by loaction co
campaign_management_campaign_by_loaction_crNUMERICCampaign management campaign by loaction crCampaign management campaign by loaction cr
campaign_management_campaign_by_loaction_cwNUMERICCampaign management campaign by loaction cwCampaign management campaign by loaction cw
campaign_management_campaign_by_loaction_cyNUMERICCampaign management campaign by loaction cyCampaign management campaign by loaction cy
campaign_management_campaign_by_loaction_czNUMERICCampaign management campaign by loaction czCampaign management campaign by loaction cz
campaign_management_campaign_by_loaction_deNUMERICCampaign management campaign by loaction deCampaign management campaign by loaction de
campaign_management_campaign_by_loaction_dkNUMERICCampaign management campaign by loaction dkCampaign management campaign by loaction dk
campaign_management_campaign_by_loaction_doNUMERICCampaign management campaign by loaction doCampaign management campaign by loaction do
campaign_management_campaign_by_loaction_ecNUMERICCampaign management campaign by loaction ecCampaign management campaign by loaction ec
campaign_management_campaign_by_loaction_eeNUMERICCampaign management campaign by loaction eeCampaign management campaign by loaction ee
campaign_management_campaign_by_loaction_egNUMERICCampaign management campaign by loaction egCampaign management campaign by loaction eg
campaign_management_campaign_by_loaction_esNUMERICCampaign management campaign by loaction esCampaign management campaign by loaction es
campaign_management_campaign_by_loaction_fiNUMERICCampaign management campaign by loaction fiCampaign management campaign by loaction fi
campaign_management_campaign_by_loaction_frNUMERICCampaign management campaign by loaction frCampaign management campaign by loaction fr
campaign_management_campaign_by_loaction_gbNUMERICCampaign management campaign by loaction gbCampaign management campaign by loaction gb

Zoho CRM Campaign Management fields (campaign_management_campaign_by_loaction_ge to campaign_management_campaign_by_loaction_mm)

IDTypeNameDescription
campaign_management_campaign_by_loaction_geNUMERICCampaign management campaign by loaction geCampaign management campaign by loaction ge
campaign_management_campaign_by_loaction_ghNUMERICCampaign management campaign by loaction ghCampaign management campaign by loaction gh
campaign_management_campaign_by_loaction_gpNUMERICCampaign management campaign by loaction gpCampaign management campaign by loaction gp
campaign_management_campaign_by_loaction_grNUMERICCampaign management campaign by loaction grCampaign management campaign by loaction gr
campaign_management_campaign_by_loaction_gtNUMERICCampaign management campaign by loaction gtCampaign management campaign by loaction gt
campaign_management_campaign_by_loaction_hkNUMERICCampaign management campaign by loaction hkCampaign management campaign by loaction hk
campaign_management_campaign_by_loaction_hnNUMERICCampaign management campaign by loaction hnCampaign management campaign by loaction hn
campaign_management_campaign_by_loaction_hrNUMERICCampaign management campaign by loaction hrCampaign management campaign by loaction hr
campaign_management_campaign_by_loaction_huNUMERICCampaign management campaign by loaction huCampaign management campaign by loaction hu
campaign_management_campaign_by_loaction_idNUMERICCampaign management campaign by loaction idCampaign management campaign by loaction id
campaign_management_campaign_by_loaction_ieNUMERICCampaign management campaign by loaction ieCampaign management campaign by loaction ie
campaign_management_campaign_by_loaction_ilNUMERICCampaign management campaign by loaction ilCampaign management campaign by loaction il
campaign_management_campaign_by_loaction_imNUMERICCampaign management campaign by loaction imCampaign management campaign by loaction im
campaign_management_campaign_by_loaction_inNUMERICCampaign management campaign by loaction inCampaign management campaign by loaction in
campaign_management_campaign_by_loaction_iqNUMERICCampaign management campaign by loaction iqCampaign management campaign by loaction iq
campaign_management_campaign_by_loaction_irNUMERICCampaign management campaign by loaction irCampaign management campaign by loaction ir
campaign_management_campaign_by_loaction_isNUMERICCampaign management campaign by loaction isCampaign management campaign by loaction is
campaign_management_campaign_by_loaction_itNUMERICCampaign management campaign by loaction itCampaign management campaign by loaction it
campaign_management_campaign_by_loaction_joNUMERICCampaign management campaign by loaction joCampaign management campaign by loaction jo
campaign_management_campaign_by_loaction_jpNUMERICCampaign management campaign by loaction jpCampaign management campaign by loaction jp
campaign_management_campaign_by_loaction_keNUMERICCampaign management campaign by loaction keCampaign management campaign by loaction ke
campaign_management_campaign_by_loaction_kgNUMERICCampaign management campaign by loaction kgCampaign management campaign by loaction kg
campaign_management_campaign_by_loaction_khNUMERICCampaign management campaign by loaction khCampaign management campaign by loaction kh
campaign_management_campaign_by_loaction_krNUMERICCampaign management campaign by loaction krCampaign management campaign by loaction kr
campaign_management_campaign_by_loaction_kwNUMERICCampaign management campaign by loaction kwCampaign management campaign by loaction kw
campaign_management_campaign_by_loaction_kzNUMERICCampaign management campaign by loaction kzCampaign management campaign by loaction kz
campaign_management_campaign_by_loaction_laNUMERICCampaign management campaign by loaction laCampaign management campaign by loaction la
campaign_management_campaign_by_loaction_lbNUMERICCampaign management campaign by loaction lbCampaign management campaign by loaction lb
campaign_management_campaign_by_loaction_liNUMERICCampaign management campaign by loaction liCampaign management campaign by loaction li
campaign_management_campaign_by_loaction_lkNUMERICCampaign management campaign by loaction lkCampaign management campaign by loaction lk
campaign_management_campaign_by_loaction_ltNUMERICCampaign management campaign by loaction ltCampaign management campaign by loaction lt
campaign_management_campaign_by_loaction_luNUMERICCampaign management campaign by loaction luCampaign management campaign by loaction lu
campaign_management_campaign_by_loaction_lvNUMERICCampaign management campaign by loaction lvCampaign management campaign by loaction lv
campaign_management_campaign_by_loaction_maNUMERICCampaign management campaign by loaction maCampaign management campaign by loaction ma
campaign_management_campaign_by_loaction_mcNUMERICCampaign management campaign by loaction mcCampaign management campaign by loaction mc
campaign_management_campaign_by_loaction_mdNUMERICCampaign management campaign by loaction mdCampaign management campaign by loaction md
campaign_management_campaign_by_loaction_meNUMERICCampaign management campaign by loaction meCampaign management campaign by loaction me
campaign_management_campaign_by_loaction_mgNUMERICCampaign management campaign by loaction mgCampaign management campaign by loaction mg
campaign_management_campaign_by_loaction_mkNUMERICCampaign management campaign by loaction mkCampaign management campaign by loaction mk
campaign_management_campaign_by_loaction_mmNUMERICCampaign management campaign by loaction mmCampaign management campaign by loaction mm

Zoho CRM Campaign Management fields (campaign_management_campaign_by_loaction_mn to campaign_management_campaign_by_loaction_tn)

IDTypeNameDescription
campaign_management_campaign_by_loaction_mnNUMERICCampaign management campaign by loaction mnCampaign management campaign by loaction mn
campaign_management_campaign_by_loaction_mqNUMERICCampaign management campaign by loaction mqCampaign management campaign by loaction mq
campaign_management_campaign_by_loaction_mtNUMERICCampaign management campaign by loaction mtCampaign management campaign by loaction mt
campaign_management_campaign_by_loaction_muNUMERICCampaign management campaign by loaction muCampaign management campaign by loaction mu
campaign_management_campaign_by_loaction_mvNUMERICCampaign management campaign by loaction mvCampaign management campaign by loaction mv
campaign_management_campaign_by_loaction_mxNUMERICCampaign management campaign by loaction mxCampaign management campaign by loaction mx
campaign_management_campaign_by_loaction_myNUMERICCampaign management campaign by loaction myCampaign management campaign by loaction my
campaign_management_campaign_by_loaction_ncNUMERICCampaign management campaign by loaction ncCampaign management campaign by loaction nc
campaign_management_campaign_by_loaction_ngNUMERICCampaign management campaign by loaction ngCampaign management campaign by loaction ng
campaign_management_campaign_by_loaction_niNUMERICCampaign management campaign by loaction niCampaign management campaign by loaction ni
campaign_management_campaign_by_loaction_nlNUMERICCampaign management campaign by loaction nlCampaign management campaign by loaction nl
campaign_management_campaign_by_loaction_noNUMERICCampaign management campaign by loaction noCampaign management campaign by loaction no
campaign_management_campaign_by_loaction_npNUMERICCampaign management campaign by loaction npCampaign management campaign by loaction np
campaign_management_campaign_by_loaction_nzNUMERICCampaign management campaign by loaction nzCampaign management campaign by loaction nz
campaign_management_campaign_by_loaction_omNUMERICCampaign management campaign by loaction omCampaign management campaign by loaction om
campaign_management_campaign_by_loaction_paNUMERICCampaign management campaign by loaction paCampaign management campaign by loaction pa
campaign_management_campaign_by_loaction_peNUMERICCampaign management campaign by loaction peCampaign management campaign by loaction pe
campaign_management_campaign_by_loaction_phNUMERICCampaign management campaign by loaction phCampaign management campaign by loaction ph
campaign_management_campaign_by_loaction_pkNUMERICCampaign management campaign by loaction pkCampaign management campaign by loaction pk
campaign_management_campaign_by_loaction_plNUMERICCampaign management campaign by loaction plCampaign management campaign by loaction pl
campaign_management_campaign_by_loaction_prNUMERICCampaign management campaign by loaction prCampaign management campaign by loaction pr
campaign_management_campaign_by_loaction_psNUMERICCampaign management campaign by loaction psCampaign management campaign by loaction ps
campaign_management_campaign_by_loaction_ptNUMERICCampaign management campaign by loaction ptCampaign management campaign by loaction pt
campaign_management_campaign_by_loaction_pyNUMERICCampaign management campaign by loaction pyCampaign management campaign by loaction py
campaign_management_campaign_by_loaction_qaNUMERICCampaign management campaign by loaction qaCampaign management campaign by loaction qa
campaign_management_campaign_by_loaction_reNUMERICCampaign management campaign by loaction reCampaign management campaign by loaction re
campaign_management_campaign_by_loaction_roNUMERICCampaign management campaign by loaction roCampaign management campaign by loaction ro
campaign_management_campaign_by_loaction_rsNUMERICCampaign management campaign by loaction rsCampaign management campaign by loaction rs
campaign_management_campaign_by_loaction_ruNUMERICCampaign management campaign by loaction ruCampaign management campaign by loaction ru
campaign_management_campaign_by_loaction_rwNUMERICCampaign management campaign by loaction rwCampaign management campaign by loaction rw
campaign_management_campaign_by_loaction_saNUMERICCampaign management campaign by loaction saCampaign management campaign by loaction sa
campaign_management_campaign_by_loaction_seNUMERICCampaign management campaign by loaction seCampaign management campaign by loaction se
campaign_management_campaign_by_loaction_sgNUMERICCampaign management campaign by loaction sgCampaign management campaign by loaction sg
campaign_management_campaign_by_loaction_siNUMERICCampaign management campaign by loaction siCampaign management campaign by loaction si
campaign_management_campaign_by_loaction_skNUMERICCampaign management campaign by loaction skCampaign management campaign by loaction sk
campaign_management_campaign_by_loaction_snNUMERICCampaign management campaign by loaction snCampaign management campaign by loaction sn
campaign_management_campaign_by_loaction_srNUMERICCampaign management campaign by loaction srCampaign management campaign by loaction sr
campaign_management_campaign_by_loaction_svNUMERICCampaign management campaign by loaction svCampaign management campaign by loaction sv
campaign_management_campaign_by_loaction_thNUMERICCampaign management campaign by loaction thCampaign management campaign by loaction th
campaign_management_campaign_by_loaction_tnNUMERICCampaign management campaign by loaction tnCampaign management campaign by loaction tn

Zoho CRM Campaign Management fields (campaign_management_campaign_by_loaction_tr to campaign_management_campaign_reports_spams_count)

IDTypeNameDescription
campaign_management_campaign_by_loaction_trNUMERICCampaign management campaign by loaction trCampaign management campaign by loaction tr
campaign_management_campaign_by_loaction_ttNUMERICCampaign management campaign by loaction ttCampaign management campaign by loaction tt
campaign_management_campaign_by_loaction_twNUMERICCampaign management campaign by loaction twCampaign management campaign by loaction tw
campaign_management_campaign_by_loaction_tzNUMERICCampaign management campaign by loaction tzCampaign management campaign by loaction tz
campaign_management_campaign_by_loaction_uaNUMERICCampaign management campaign by loaction uaCampaign management campaign by loaction ua
campaign_management_campaign_by_loaction_ugNUMERICCampaign management campaign by loaction ugCampaign management campaign by loaction ug
campaign_management_campaign_by_loaction_usNUMERICCampaign management campaign by loaction usCampaign management campaign by loaction us
campaign_management_campaign_by_loaction_uyNUMERICCampaign management campaign by loaction uyCampaign management campaign by loaction uy
campaign_management_campaign_by_loaction_veNUMERICCampaign management campaign by loaction veCampaign management campaign by loaction ve
campaign_management_campaign_by_loaction_vnNUMERICCampaign management campaign by loaction vnCampaign management campaign by loaction vn
campaign_management_campaign_by_loaction_yeNUMERICCampaign management campaign by loaction yeCampaign management campaign by loaction ye
campaign_management_campaign_by_loaction_zaNUMERICCampaign management campaign by loaction zaCampaign management campaign by loaction za
campaign_management_campaign_by_loaction_zwNUMERICCampaign management campaign by loaction zwCampaign management campaign by loaction zw
campaign_management_campaign_details_campaign_keyTEXTCampaign management campaign details campaign keyCampaign management campaign details campaign key
campaign_management_campaign_details_campaign_nameTEXTCampaign management campaign details campaign nameCampaign management campaign details campaign name
campaign_management_campaign_details_created_timeTIMESTAMPCampaign management campaign details created timeCampaign management campaign details created time
campaign_management_campaign_details_email_fromTEXTCampaign management campaign details email fromCampaign management campaign details email from
campaign_management_campaign_details_email_optionsTEXTCampaign management campaign details email optionsCampaign management campaign details email options
campaign_management_campaign_details_email_subjectTEXTCampaign management campaign details email subjectCampaign management campaign details email subject
campaign_management_campaign_details_email_typeTEXTCampaign management campaign details email typeCampaign management campaign details email type
campaign_management_campaign_details_reply_toTEXTCampaign management campaign details reply toCampaign management campaign details reply to
campaign_management_campaign_details_sent_timeTIMESTAMPCampaign management campaign details sent timeCampaign management campaign details sent time
campaign_management_campaign_reports_autoreply_countNUMERICCampaign management campaign reports autoreply countCampaign management campaign reports autoreply count
campaign_management_campaign_reports_bounce_percentPERCENTCampaign management campaign reports bounce percentCampaign management campaign reports bounce percent
campaign_management_campaign_reports_bounces_countNUMERICCampaign management campaign reports bounces countCampaign management campaign reports bounces count
campaign_management_campaign_reports_campaign_nameTEXTCampaign management campaign reports campaign nameCampaign management campaign reports campaign name
campaign_management_campaign_reports_clicksperopenratePERCENTCampaign management campaign reports clicksperopenrateCampaign management campaign reports clicksperopenrate
campaign_management_campaign_reports_complaints_countNUMERICCampaign management campaign reports complaints countCampaign management campaign reports complaints count
campaign_management_campaign_reports_complaints_percentPERCENTCampaign management campaign reports complaints percentCampaign management campaign reports complaints percent
campaign_management_campaign_reports_delivered_countNUMERICCampaign management campaign reports delivered countCampaign management campaign reports delivered count
campaign_management_campaign_reports_delivered_percentPERCENTCampaign management campaign reports delivered percentCampaign management campaign reports delivered percent
campaign_management_campaign_reports_emails_sent_countNUMERICCampaign management campaign reports emails sent countCampaign management campaign reports emails sent count
campaign_management_campaign_reports_forward_percentPERCENTCampaign management campaign reports forward percentCampaign management campaign reports forward percent
campaign_management_campaign_reports_forwards_countNUMERICCampaign management campaign reports forwards countCampaign management campaign reports forwards count
campaign_management_campaign_reports_hardbounce_countNUMERICCampaign management campaign reports hardbounce countCampaign management campaign reports hardbounce count
campaign_management_campaign_reports_open_percentPERCENTCampaign management campaign reports open percentCampaign management campaign reports open percent
campaign_management_campaign_reports_opens_countNUMERICCampaign management campaign reports opens countCampaign management campaign reports opens count
campaign_management_campaign_reports_softbounce_countNUMERICCampaign management campaign reports softbounce countCampaign management campaign reports softbounce count
campaign_management_campaign_reports_spam_percentPERCENTCampaign management campaign reports spam percentCampaign management campaign reports spam percent
campaign_management_campaign_reports_spams_countNUMERICCampaign management campaign reports spams countCampaign management campaign reports spams count

Zoho CRM Campaign Management fields (campaign_management_campaign_reports_unique_clicked_percent to campaign_management_campaign_reports_unsubscribe_percent)

IDTypeNameDescription
campaign_management_campaign_reports_unique_clicked_percentPERCENTCampaign management campaign reports unique clicked percentCampaign management campaign reports unique clicked percent
campaign_management_campaign_reports_unique_clicks_countNUMERICCampaign management campaign reports unique clicks countCampaign management campaign reports unique clicks count
campaign_management_campaign_reports_unopenedTEXTCampaign management campaign reports unopenedCampaign management campaign reports unopened
campaign_management_campaign_reports_unopened_percentPERCENTCampaign management campaign reports unopened percentCampaign management campaign reports unopened percent
campaign_management_campaign_reports_unsent_countNUMERICCampaign management campaign reports unsent countCampaign management campaign reports unsent count
campaign_management_campaign_reports_unsent_percentPERCENTCampaign management campaign reports unsent percentCampaign management campaign reports unsent percent
campaign_management_campaign_reports_unsub_countNUMERICCampaign management campaign reports unsub countCampaign management campaign reports unsub count
campaign_management_campaign_reports_unsubscribe_percentPERCENTCampaign management campaign reports unsubscribe percentCampaign management campaign reports unsubscribe percent

Zoho CRM Campaigns fields

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

IDTypeNameDescription
campaigns_actual_costTEXTActual CostThe actual cost spent on the campaign
campaigns_budgeted_costTEXTBudgeted CostThe planned amount to be spent on the campaign
campaigns_campaign_nameTEXTCampaigns Campaign NameName of the Campaign
campaigns_created_byTEXTCampaigns Created ByCreated By
campaigns_created_timeTIMESTAMPCampaigns Created TimeDate and time at which the record was created. This is a system-generated field. You cannot modify it.
campaigns_currencyTEXTCampaign CurrencyThe currency in which the revenue is generated
campaigns_descriptionTEXTCampaigns DescriptionDescription about the Campaign
campaigns_end_dateDATEEnd DateThe date on which the Campaign ends
campaigns_exchange_rateTEXTExchange RateRepresents the exchange rate of the currency of the campaign amount
campaigns_expected_responseTEXTExpected ResponseExpected response
campaigns_expected_revenueTEXTCampaigns Expected RevenueRepresents the expected revenue of the campaign.
campaigns_idTEXTCampaigns IdThe unique ID of the campaign
campaigns_layoutTEXTCampaigns LayoutLayout
campaigns_modified_byTEXTCampaigns Modified ByModified By
campaigns_modified_timeTIMESTAMPCampaigns Modified TimeDate and time at which the record was last modified. This is a system-generated field. You cannot modify it.
campaigns_num_sentTEXTNum SentThe number of leads/contacts to whom the campaign details have been sent
campaigns_ownerTEXTCampaigns Campaign Owner idCampaign Owner id
campaigns_owner_first_nameTEXTCampaigns Owner First NameCampaigns Owner First Name
campaigns_owner_last_nameTEXTCampaigns Owner Last NameCampaigns Owner Last Name
campaigns_parent_campaignTEXTParent CampaignRepresents the details of the parent campaign, if any
campaigns_start_dateDATEStart DateThe date on which the Campaign starts
campaigns_statusTEXTCampaigns StatusRepresents the status of the campaign
campaigns_tagTEXTCampaigns TagTag
campaigns_typeTEXTCampaigns TypeRepresents the type of Campaign

Zoho CRM Cases fields

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

IDTypeNameDescription
cases_account_nameTEXTCases Account NameAccount Name
cases_add_commentTEXTCases Add CommentAdd Comment
cases_case_numberTEXTCase NumberCase Number
cases_case_originTEXTCase OriginCase Origin
cases_commentsTEXTCases CommentsComments
cases_created_byTEXTCases Created ByCreated By
cases_created_timeTIMESTAMPCases Created TimeCreated Time
cases_deal_nameTEXTCases Deal NameDeal Name
cases_descriptionTEXTCases DescriptionDescription
cases_emailTEXTCases EmailEmail
cases_idTEXTCases Record IdRecord Id
cases_internal_commentsTEXTCases Internal CommentsInternal Comments
cases_locked__sTEXTCases LockedLocked
cases_modified_byTEXTCases Modified ByModified By
cases_modified_timeTIMESTAMPCases Modified TimeModified Time
cases_no_of_commentsTEXTCases No. Of CommentsNo. Of Comments
cases_ownerTEXTCases Case Owner idCase Owner id
cases_owner_first_nameTEXTCases Owner First NameCases Owner First Name
cases_owner_last_nameTEXTCases Owner Last NameCases Owner Last Name
cases_phoneTEXTCases PhonePhone
cases_priorityTEXTCases PriorityPriority
cases_product_nameTEXTCases Product NameProduct Name
TEXTCases Related ToRelated To
cases_reported_byTEXTCases Reported ByReported By
cases_solutionTEXTCases SolutionSolution
cases_statusTEXTCases StatusStatus
cases_subjectTEXTCases SubjectSubject
cases_tagTEXTCases Cases TagTag
cases_typeTEXTCases TypeType

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)

IDTypeNameDescription
contacts_account_nameTEXTContacts Account NameAccount Name
contacts_adTEXTContact AdAd
contacts_ad_campaign_nameTEXTContacts Ad campaign nameAd campaign name
contacts_ad_click_dateDATEContacts Ad click dateAd click date
contacts_ad_networkTEXTContacts Ad networkAd Network
contacts_adgroup_nameTEXTContacts Adgroup nameAdgroup name
contacts_adgroupidTEXTContacts AdgroupidAdgroupid
contacts_adidTEXTContacts AdidAdid
contacts_assistantTEXTContacts AssistantName of the contact's assistant
contacts_asst_phoneTEXTContacts Asst phonePhone number of the Contact's assistant, if any
contacts_average_time_spent_minutesTIMESTAMPContacts Average time spent minutesAverage time spent minutes
contacts_change_log_time__sTIMESTAMPContacts Change Log TimeChange Log Time
contacts_click_typeTEXTContacts Contact Click typeClick type
contacts_conversion_export_statusTEXTContacts Conversion export statusConversion export status
contacts_conversion_exported_onTEXTContacts Conversion exported onConversion exported on
contacts_cost_per_clickTEXTContacts Cost per clickCost per click
contacts_cost_per_conversionTEXTContacts Contact Cost per conversionCost per conversion
contacts_created_byTEXTContacts Created ByCreated By
contacts_created_timeTIMESTAMPContacts Created timeDate and time at which the record was created. This is a system-generated field. You cannot modify it.
contacts_date_of_birthDATEContacts Date of birthDate of birth of the Contact in mm/dd/yyyy format
contacts_days_visitedTEXTContacts Days visitedThe number of days the contact visited Zoho CRM
contacts_departmentTEXTContacts DepartmentRepresents the department of the contact
contacts_descriptionTEXTContacts Contact DescriptionDescription of the Contact
contacts_device_typeTEXTContacts Contact Device typeDevice type
contacts_emailTEXTContacts EmailEmail ID of the contact
contacts_email_opt_outTEXTContacts Email opt outSpecifies whether the contact has opted out of email notifications from Zoho CRM
contacts_enrich_status__sTEXTContacts Enrich StatusEnrich Status
contacts_faxTEXTContacts FaxFax number of the Contact
contacts_first_nameTEXTContacts First nameRepresents the first name of the Contact
contacts_first_visited_timeTIMESTAMPContacts First visited timeDate and time at which the Contact first visited Zoho CRM. This is a system-generated field. You cannot modify it.
contacts_first_visited_urlTEXTContacts First visited urlThe URL address of the page that the contact visited first. This is a system-generated field. You cannot modify it.
contacts_full_nameTEXTContacts Full nameRepresents the full name of the Contact
contacts_gadconfigidTEXTContacts GadconfigidGadconfigid
contacts_gclidTEXTContacts GclidGCL ID
contacts_home_phoneTEXTHome PhoneHome Phone
contacts_idTEXTContacts IdUnique ID of the Contact
contacts_keywordTEXTContacts Contact Keywordkeyword
contacts_last_activity_timeTIMESTAMPContacts Last activity timeThe 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__sTIMESTAMPContacts Last Enriched TimeLast Enriched Time
contacts_last_nameTEXTContacts Last nameLast name of the Contact. This is a mandatory field.

Zoho CRM Contacts fields (contacts_last_visited_time to contacts_zcampaignid)

IDTypeNameDescription
contacts_last_visited_timeTIMESTAMPContacts Last visited timeThe date and time at which the Contact last visited Zoho CRM. This is a system-generated field. You cannot modify it.
contacts_lead_sourceTEXTContacts Lead sourceContacts Lead Source
contacts_locked__sTEXTContacts LockedLocked
contacts_mailing_cityCITYContacts Mailing cityRepresents address details of the Contact
contacts_mailing_countryCOUNTRYContacts Mailing countryThe other address of the contact, if any
contacts_mailing_stateTEXTContacts Mailing statePrimary mailing address of the contact
contacts_mailing_streetTEXTContacts Mailing streetRepresents address details of the Contact
contacts_mailing_zipTEXTContacts Mailing zipRepresents address details of the Contact
contacts_mobileTEXTContacts MobileMobile number of the Contact
contacts_modified_byTEXTContacts Modified ByModified By
contacts_modified_timeTIMESTAMPContacts Modified timeDate and time at which the record was last modified. This is a system-generated field. You cannot modify it.
contacts_number_of_chatsTEXTContacts Number of chatsThe 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_cityCITYContacts Other cityRepresents address details of the Contact
contacts_other_countryCOUNTRYContacts Other countryThe other address of the contact, if any
contacts_other_phoneTEXTContacts Other phoneThe other phone number of the contact, if any
contacts_other_stateREGIONContacts Other stateThe other address of the contact, if any
contacts_other_streetTEXTContacts Other streetRepresents address details of the Contact
contacts_other_zipTEXTContacts Other zipRepresents address details of the Contact
contacts_ownerTEXTContacts Contact Owner idContact Owner id
contacts_owner_first_nameTEXTContacts Owner First NameContacts Owner First Name
contacts_owner_last_nameTEXTContacts Owner Last NameContacts Owner Last Name
contacts_phoneTEXTContacts PhoneThe phone number of the Contact
contacts_reason_for_conversion_failureTEXTContacts Reason for conversion failureReason for conversion failure
contacts_referrerTEXTContacts Contact ReferrerReferrer
contacts_reporting_toTEXTContacts Reporting toReporting to
contacts_salutationTEXTContacts SalutationMr., Ms, Mrs., or others
contacts_search_partner_networkTEXTContacts Search partner networkSearch partner network
contacts_secondary_emailTEXTContacts Secondary emailAlternate email address of the contact
contacts_skype_idTEXTContacts Skype idThe Skype ID of the Contact
contacts_tagTEXTContacts Contact TagName and ID of the Contact who referred this Contact
contacts_titleTEXTContacts Contact TitleTitle/job position of the Contact
contacts_twitterTEXTContacts TwitterThe Twitter handle of the contact
contacts_unsubscribed_modeTEXTContacts Unsubscribed modeUnsubscribed mode
contacts_unsubscribed_timeTIMESTAMPContacts Unsubscribed timeUnsubscribed time
contacts_vendor_nameTEXTContacts Vendor nameVendor Name
contacts_visitor_scoreTEXTContacts Visitor scoreScore for the contact obtained from SalesIQ
contacts_zcampaignidTEXTContacts ZcampaignidZcampaignid

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)

IDTypeNameDescription
deals_account_nameTEXTDeals Account NameAccount Name
deals_adTEXTDeals AdAd
deals_ad_campaign_nameTEXTDeals Ad Campaign NameAd Campaign Name
deals_ad_click_dateDATEDeals Ad Click DateAd Click Date
deals_ad_networkTEXTDeals Ad NetworkAd Network
deals_adgroup_nameTEXTDeals Adgroup NameAdgroup Name
deals_adgroupidTEXTDeals AdgroupidAdgroupid
deals_adidTEXTDeals AdidAdid
deals_amountNUMERICDeals AmountAmount
deals_campaign_sourceTEXTDeals Campaign SourceCampaign Source
deals_campaign_source_idTEXTDeals Campaign Source IdId of the campaign a deal is associated with, for joining deals to the Campaigns table
deals_campaign_source_nameTEXTDeals Campaign Source NameName of the campaign a deal is associated with
deals_change_log_time__sTIMESTAMPDeals Change Log TimeChange Log Time
deals_click_typeTEXTDeals Click TypeClick Type
deals_closing_dateDATEDeals Closing DateClosing Date
deals_contact_first_nameTEXTDeals Contact First NameDeals Contact First Name
deals_contact_idTEXTDeals Contact idDeals Contact id
deals_contact_last_nameTEXTDeals Contact last NameDeals Contact last Name
deals_contact_nameTEXTDeals Contact First Name (alias for deals_contact_first_name)Deals Contact First Name
deals_conversion_export_statusTEXTDeals Conversion Export StatusConversion Export Status
deals_conversion_exported_onTEXTDeals Conversion Exported OnConversion Exported On
deals_cost_per_clickTEXTDeals Cost Per ClickCost Per Click
deals_cost_per_conversionTEXTDeals Cost Per ConversionCost Per Conversion
deals_created_byTEXTDeals Created ByCreated By
deals_created_timeTIMESTAMPDeals Created TimeCreated Time
deals_deal_nameTEXTDeals Deal NameDeal Name
deals_descriptionTEXTDeals DescriptionDescription
deals_device_typeTEXTDeals Device TypeDevice Type
deals_expected_revenueTEXTDeals Expected RevenueExpected Revenue
deals_gadconfigidTEXTDeals GadconfigidGadconfigid
deals_gclidTEXTDeals GclidGclid
deals_idTEXTDeals Record IdRecord Id
deals_keywordTEXTDeals KeywordKeyword
deals_keywordidTEXTDeals KeywordidKeywordid
deals_last_activity_timeTIMESTAMPDeals Last Activity TimeLast Activity Time
deals_lead_conversion_timeTIMESTAMPDeals Lead Conversion TimeLead Conversion Time
deals_lead_sourceTEXTDeals Lead SourceLead Source
deals_locked__sTEXTDeals LockedLocked
deals_modified_byTEXTDeals Modified ByModified By
deals_modified_timeTIMESTAMPDeals Modified TimeModified Time

Zoho CRM Deals fields (deals_next_step to deals_zcampaignid)

IDTypeNameDescription
deals_next_stepTEXTDeals Next StepNext Step
deals_overall_sales_durationTEXTDeals Overall Sales DurationOverall Sales Duration
deals_ownerTEXTDeals Deal Owner idDeal Owner id
deals_owner_first_nameTEXTDeals Owner First NameDeals Owner First Name
deals_owner_last_nameTEXTDeals Owner Last NameDeals Owner Last Name
deals_probabilityTEXTDeals Probability (%)Probability (%)
deals_reason_for_conversion_failureTEXTDeals Reason For Conversion FailureReason For Conversion Failure
deals_sales_cycle_durationTEXTDeals Sales Cycle DurationSales Cycle Duration
deals_search_partner_networkTEXTDeals Search Partner NetworkSearch Partner Network
deals_stageTEXTDeals StageStage
deals_tagTEXTDeals TagTag
deals_typeTEXTDeals TypeType
deals_zcampaignidTEXTDeals ZcampaignidZcampaignid

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)

IDTypeNameDescription
ticket_approval_countNUMERICTicket approval countNumber of approvals associated with the ticket
ticket_assigneeOBJECTTicket assignee detailsAgent assigned to resolve the ticket
ticket_assignee_idTEXTTicket assignee IDID of agent to whom the ticket is assigned
ticket_attachment_countNUMERICTicket attachment countNumber of attachments in the ticket
ticket_categoryTEXTTicket categoryCategory of the ticket
ticket_channelTEXTTicket channelChannel through which the ticket originated (e.g. email)
ticket_channel_codeTEXTTicket channel codeCode of the ticket's source channel
ticket_classificationTEXTTicket typeType of ticket. Values supported are Problem, Request, Question, and Others.
ticket_closed_dateDATETicket closed date and timeTime of closing the ticket
ticket_comment_countNUMERICTicket comments countNumber of comments in the ticket
ticket_contactOBJECTTicket contact detailsDetails of the contact who raised the ticket
ticket_contact_idTEXTTicket contact IDID of the contact who raised the ticket
ticket_created_dateDATETicket created datetimeDate and time of creating the ticket
ticket_custom_fieldsOBJECTTicket custom fieldsCustom fields in the ticket
ticket_customer_response_dateDATETicket customer response date and timeTime of receiving customer response
ticket_departmentOBJECTTicket department detailsDetails of the department to which the ticket belongs
ticket_department_idTEXTTicket department IDID of the department to which the ticket belongs
ticket_due_dateDATETicket due date and timeDue date and time for resolving the ticket
ticket_emailTEXTTicket emailEmail in the ticket
ticket_idTEXTZoho Desk Ticket IDID of the ticket
ticket_is_deletedBOOLEANIs ticket deletedKey that returns if the ticket is deleted or not
ticket_is_followingBOOLEANIs ticket followingKey that returns if the current user follows the ticket or not
ticket_is_readBOOLEANIs ticket readKey that denotes if the current user has read the ticket or not
ticket_is_trashedBOOLEANIs ticket trashedField that denotes whether the ticket is in trash
ticket_languageTEXTTicket languageLanguage preference to set for the ticket
ticket_modified_dateDATETicket modified datetimeDate and time of modifying the ticket
ticket_numberTEXTTicket numberIndex/Serial number of the ticket
ticket_phoneTEXTTicket phonePhone number in the ticket
ticket_priorityTEXTTicket priorityPriority of the ticket
ticket_productOBJECTTicket product detailsProduct associated with the ticket
ticket_resolutionTEXTTicket resolutionResolution notes recorded in the ticket
ticket_response_due_dateDATETicket response due date and timeDate on or before which a response must be sent for the ticket
ticket_sourceOBJECTTicket source detailsDetails of the ticket source from channel
ticket_statusTEXTZoho Desk Ticket statusStatus of the ticket. Includes the custom statuses configured in your help desk portal.
ticket_status_typeTEXTTicket Status TypeType of ticket resolution status.The values supported are OPEN and ON HOLD and CLOSED.
ticket_subcategoryTEXTTicket subcategorySubcategory of the ticket
ticket_subjectTEXTTicket subjectSubject of the ticket
ticket_tagsTEXTTicket tagsComma-separated list of ticket tags
ticket_task_countNUMERICTicket task countNumber of tasks associated with the ticket
ticket_teamOBJECTTicket team detailsDetails of the team assigned to resolve the ticket

Zoho CRM Desk fields (ticket_team_id to ticket_url)

IDTypeNameDescription
ticket_team_idTEXTTicket team IDID of the team assigned to resolve the ticket
ticket_thread_countNUMERICTicket thread countNumber of threads associated in the ticket
ticket_time_entry_countNUMERICTicket time entry countNumber of time entries recorded in the ticket
ticket_urlTEXTTicket URLURL to access the resource

Zoho CRM Events fields

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

IDTypeNameDescription
events_all_dayTEXTEvents All DayAll Day
events_check_in_addressTEXTCheck-In AddressCheck-In Address
events_check_in_byTEXTCheck-In ByCheck-In By
events_check_in_cityCITYCheck-In CityCheck-In City
events_check_in_commentTEXTCheck-In CommentCheck-In Comment
events_check_in_countryCOUNTRYCheck-In CountryCheck-In Country
events_check_in_stateTEXTCheck-In StateCheck-In State
events_check_in_statusTEXTChecked In StatusChecked In Status
events_check_in_sub_localityTEXTCheck-In Sub-LocalityCheck-In Sub-Locality
events_check_in_timeTIMESTAMPCheck-In TimeCheck-In Time
events_created_byTEXTEvents Created ByCreated By
events_created_timeTIMESTAMPEvents Created TimeCreated Time
events_descriptionTEXTEvents DescriptionDescription
events_end_datetimeTIMESTAMPEvents ToTo
events_event_titleTEXTEvents TitleTitle
events_idTEXTEvents Record IdRecord Id
events_latitudeTEXTEvents LatitudeLatitude
events_longitudeTEXTEvents LongitudeLongitude
events_modified_byTEXTEvents Modified ByModified By
events_modified_timeTIMESTAMPEvents Modified TimeModified Time
events_ownerTEXTEvents Event Owner idEvent Owner id
events_owner_first_nameTEXTEvents Owner First NameEvents Owner First Name
events_owner_last_nameTEXTEvents Owner Last NameEvents Owner Last Name
events_participantsTEXTEvents ParticipantsParticipants
events_recurring_activityTEXTEvents RepeatRepeat
events_remind_atTEXTEvent ReminderReminder
events_remind_participantsTEXTEvents Participants ReminderParticipants Reminder
events_start_datetimeTIMESTAMPEvents FromFrom
events_tagTEXTEvents TagTag
events_venueTEXTEvents LocationLocation
events_what_idTEXTEvents Related ToRelated To
events_who_idTEXTEvents Contact NameContact Name
events_zip_codeTEXTEvents Zip CodeZip 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)

IDTypeNameDescription
invoices_account_nameTEXTInvoices Account NameAccount Name
invoices_adjustmentTEXTInvoices AdjustmentAdjustment
invoices_billing_cityCITYInvoices Billing CityBilling City
invoices_billing_codeTEXTInvoices Billing CodeBilling Code
invoices_billing_countryCOUNTRYInvoices Billing CountryBilling Country
invoices_billing_stateTEXTInvoices Billing StateBilling State
invoices_billing_streetTEXTInvoices Billing StreetBilling Street
invoices_contact_first_nameTEXTInvoices Contact First NameInvoices Contact First Name
invoices_contact_idTEXTInvoices Contact idInvoices Contact id
invoices_contact_last_nameTEXTInvoices Contact last NameInvoices Contact last Name
invoices_contact_nameTEXTInvoices Contact First Name (alias for invoices_contact_first_name)Invoices Contact First Name
invoices_created_byTEXTInvoices Created ByCreated By
invoices_created_timeTIMESTAMPInvoices Created TimeCreated Time
invoices_descriptionTEXTInvoices DescriptionDescription
invoices_discountTEXTInvoices DiscountDiscount
invoices_due_dateDATEInvoices Due DateDue Date
invoices_excise_dutyTEXTInvoices Excise DutyExcise Duty
invoices_grand_totalTEXTInvoices Grand TotalGrand Total
invoices_idTEXTInvoices Record IdRecord Id
invoices_invoice_dateDATEInvoice DateInvoice Date
invoices_invoice_numberTEXTInvoices Invoice NumberInvoice Number
invoices_invoiced_itemsTEXTInvoices Invoiced ItemsInvoiced Items
invoices_locked__sTEXTInvoices LockedLocked
invoices_modified_byTEXTInvoices Modified ByModified By
invoices_modified_timeTIMESTAMPInvoices Modified TimeModified Time
invoices_ownerTEXTInvoices Invoice Owner idInvoice Owner id
invoices_owner_first_nameTEXTInvoices Owner First NameInvoices Owner First Name
invoices_owner_last_nameTEXTInvoices Owner Last NameInvoices Owner Last Name
invoices_purchase_orderTEXTInvoices Purchase OrderPurchase Order
invoices_sales_commissionTEXTInvoices Sales CommissionSales Commission
invoices_sales_orderTEXTInvoices Sales OrderSales Order
invoices_shipping_cityCITYInvoices Shipping CityShipping City
invoices_shipping_codeTEXTInvoices Shipping CodeShipping Code
invoices_shipping_countryCOUNTRYInvoices Shipping CountryShipping Country
invoices_shipping_stateTEXTInvoices Shipping StateShipping State
invoices_shipping_streetTEXTInvoices Shipping StreetShipping Street
invoices_statusTEXTInvoices StatusStatus
invoices_sub_totalTEXTInvoices Sub TotalSub Total
invoices_subjectTEXTInvoices SubjectSubject
invoices_tagTEXTInvoices TagTag

Zoho CRM Invoices fields (invoices_tax to invoices_terms_and_conditions)

IDTypeNameDescription
invoices_taxTEXTInvoices TaxTax
invoices_terms_and_conditionsTEXTInvoices Terms And ConditionsTerms 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)

IDTypeNameDescription
countryCOUNTRYCountryCountry
emailTEXTEmailEmail
first_visited_timeTIMESTAMPFirst Visited TimeFirst Visited Time
first_visited_urlTEXTFirst Visited URLFirst Visited URL
firstnameTEXTFirst NameFirst Name
lastnameTEXTLast NameLast Name
lead_statusTEXTLead StatusLead Status
leads_adTEXTLeads AdAd
leads_ad_campaign_nameTEXTLeads Ad Campaign NameAd Campaign Name
leads_ad_click_dateDATELeads Ad Click DateAd Click Date
leads_ad_networkTEXTLeads Ad NetworkAd Network
leads_adgroup_nameTEXTLeads AdGroup NameLeads AdGroup Name
leads_adgroupidTEXTAdgroupidAdgroupid
leads_adidTEXTLeads AdidAdid
leads_annual_revenueTEXTLeads Annual RevenueAnnual Revenue
leads_average_time_spent_minutesTEXTAverage Time Spent (Minutes)Average Time Spent (Minutes)
leads_change_log_time__sTIMESTAMPLeads Change Log TimeChange Log Time
leads_cityCITYLeads CityCity
leads_click_typeTEXTLeads Click TypeClick Type
leads_companyTEXTCompanyCompany
leads_conversion_export_statusTEXTLeads Conversion Export StatusConversion Export Status
leads_conversion_exported_onTEXTLeads Conversion Exported OnConversion Exported On
leads_converted__sTEXTIs ConvertedIs Converted
leads_converted_accountTEXTConverted AccountConverted Account
leads_converted_contactTEXTConverted ContactConverted Contact
leads_converted_date_timeTIMESTAMPConverted Date TimeConverted Date Time
leads_converted_dealTEXTConverted DealConverted Deal
leads_cost_per_clickTEXTCost Per ClickCost Per Click
leads_cost_per_conversionTEXTLeads Cost Per ConversionCost Per Conversion
leads_countryCOUNTRYLeads CountryCountry
leads_created_byTEXTCreated ByCreated By
leads_created_timeTIMESTAMPLeads Created TimeCreated Time
leads_days_visitedTEXTDays VisitedDays Visited
leads_descriptionTEXTLeads DescriptionDescription
leads_designationTEXTLeads TitleTitle
leads_device_typeTEXTLeads Device TypeDevice Type
leads_emailTEXTLeads EmailEmail
leads_email_opt_outTEXTEmail Opt OutEmail Opt Out
leads_enrich_status__sTEXTEnrich StatusEnrich Status
leads_faxTEXTFaxFax

Zoho CRM Leads fields (leads_first_name to leads_unsubscribed_time)

IDTypeNameDescription
leads_first_nameTEXTLeads First NameFirst Name
leads_first_visited_timeTIMESTAMPFirst VisitFirst Visit
leads_first_visited_urlTEXTFirst Page VisitedFirst Page Visited
leads_full_nameTEXTLeads Full NameFull Name
leads_gadconfigidTEXTLeads GadconfigidGadconfigid
leads_gclidTEXTLeads GclidGclid
leads_idTEXTLeads Record IdRecord Id
leads_industryTEXTLeads IndustryIndustry
leads_keywordTEXTLeads KeywordKeyword
leads_keywordidTEXTLeads KeywordidKeywordid
leads_last_activity_timeTIMESTAMPLast Activity TimeLast Activity Time
leads_last_enriched_time__sTIMESTAMPLeads Last Enriched TimeLast Enriched Time
leads_last_nameTEXTLeads Last NameLast Name
leads_last_visited_timeTIMESTAMPMost Recent VisitMost Recent Visit
leads_lead_conversion_timeTIMESTAMPLead Conversion TimeLead Conversion Time
leads_lead_sourceTEXTLeads Lead SourceLead Source
leads_lead_statusTEXTLeads Lead StatusLead Status
leads_locked__sTEXTLeads LockedLocked
leads_mobileTEXTMobileMobile
leads_modified_byTEXTLeads Modified ByModified By
leads_modified_timeTIMESTAMPLeads Modified TimeModified Time
leads_no_of_employeesTEXTNo. Of EmployeesNo. Of Employees
leads_number_of_chatsTEXTNumber Of ChatsNumber Of Chats
leads_ownerTEXTLeads Lead Owner idLead Owner id
leads_owner_first_nameTEXTLeads Owner First NameLeads Owner First Name
leads_owner_last_nameTEXTLeads Owner Last NameLeads Owner Last Name
leads_phoneTEXTPhonePhone
leads_ratingTEXTLeads RatingRating
leads_reason_for_conversion_failureTEXTReason For Conversion FailureReason For Conversion Failure
leads_referrerTEXTLeads ReferrerReferrer
leads_salutationTEXTLeads SalutationSalutation
leads_search_partner_networkTEXTLeads Search Partner NetworkSearch Partner Network
leads_secondary_emailTEXTSecondary EmailSecondary Email
leads_skype_idTEXTSkype IdSkype Id
leads_stateTEXTLeads StateState
leads_streetTEXTLeads StreetStreet
leads_tagTEXTLeads TagTag
leads_twitterTEXTLeads TwitterTwitter
leads_unsubscribed_modeTEXTUnsubscribed ModeUnsubscribed Mode
leads_unsubscribed_timeTIMESTAMPUnsubscribed TimeUnsubscribed Time

Zoho CRM Leads fields (leads_visitor_score to trial_started_date)

IDTypeNameDescription
leads_visitor_scoreTEXTVisitor ScoreVisitor Score
leads_websiteTEXTLeads WebsiteWebsite
leads_zcampaignidTEXTZcampaignidZcampaignid
leads_zip_codeTEXTLeads Zip CodeZip Code
onboarding_completedTEXTOnboarding CompletedOnboarding Completed
onboarding_startedTEXTOnboarding StartedOnboarding Started
referrerTEXTReferrerReferrer
trial_started_dateDATETrial Started DateTrial Started Date

Zoho CRM Price_Books fields

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

IDTypeNameDescription
price_books_activeTEXTPrice ActiveActive
price_books_created_byTEXTPrice Created ByCreated By
price_books_created_timeTIMESTAMPPrice Created TimeCreated Time
price_books_descriptionTEXTPrice DescriptionDescription
price_books_idTEXTPrice Record IdRecord Id
price_books_locked__sTEXTPrice LockedLocked
price_books_modified_byTEXTPrice Modified ByModified By
price_books_modified_timeTIMESTAMPPrice Modified TimeModified Time
price_books_ownerTEXTPrice Books Price Book Owner idPrice Book Owner id
price_books_owner_first_nameTEXTPrice Books Owner First NamePrice Books Owner First Name
price_books_owner_last_nameTEXTPrice Books Owner Last NamePrice Books Owner Last Name
price_books_price_book_nameTEXTPrice Book NamePrice Book Name
price_books_pricing_detailsTEXTPrice Pricing DetailsPricing Details
price_books_pricing_modelTEXTPrice Pricing ModelPricing Model
price_books_tagTEXTPrice TagTag

Zoho CRM Products fields

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

IDTypeNameDescription
products_commission_rateTEXTCommission RateCommission Rate
products_created_byTEXTProducts Created ByCreated By
products_created_timeTIMESTAMPProducts Created TimeCreated Time
products_descriptionTEXTProducts DescriptionDescription
products_handlerTEXTHandlerHandler
products_idTEXTProducts Record IdRecord Id
products_manufacturerTEXTManufacturerManufacturer
products_modified_byTEXTProducts Modified ByModified By
products_modified_timeTIMESTAMPProducts Modified TimeModified Time
products_ownerTEXTProducts Product Owner idProduct Owner id
products_owner_first_nameTEXTProducts Owner First NameProducts Owner First Name
products_owner_last_nameTEXTProducts Owner Last NameProducts Owner Last Name
products_product_activeTEXTProduct ActiveProduct Active
products_product_categoryTEXTProducts Product CategoryProduct Category
products_product_codeTEXTProduct CodeProduct Code
products_product_nameTEXTProducts Product NameProduct Name
products_qty_in_demandTEXTQuantity In DemandQuantity In Demand
products_qty_in_stockTEXTQuantity In StockQuantity In Stock
products_qty_orderedTEXTQty OrderedQty Ordered
products_record_imageTEXTProduct ImageProduct Image
products_reorder_levelTEXTReorder LevelReorder Level
products_sales_end_dateDATESales End DateSales End Date
products_sales_start_dateDATESales Start DateSales Start Date
products_support_expiry_dateDATESupport End DateSupport End Date
products_support_start_dateDATESupport Start DateSupport Start Date
products_tagTEXTProducts TagTag
products_taxTEXTProducts TaxTax
products_taxableTEXTTaxableTaxable
products_unit_priceTEXTUnit PriceUnit Price
products_usage_unitTEXTUsage UnitUsage Unit
products_vendor_nameTEXTProducts Vendor NameVendor Name

Zoho CRM Purchase_Orders fields

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

IDTypeNameDescription
purchase_orders_adjustmentTEXTPurchase AdjustmentAdjustment
purchase_orders_billing_cityCITYPurchase Billing CityBilling City
purchase_orders_billing_codeTEXTPurchase Billing CodeBilling Code
purchase_orders_billing_countryCOUNTRYPurchase Billing CountryBilling Country
purchase_orders_billing_stateTEXTPurchase Billing StateBilling State
purchase_orders_billing_streetTEXTPurchase Billing StreetBilling Street
purchase_orders_carrierTEXTPurchase CarrierCarrier
purchase_orders_contact_first_nameTEXTPurchase Orders Contact First NamePurchase Orders Contact First Name
purchase_orders_contact_idTEXTPurchase Orders Contact idPurchase Orders Contact id
purchase_orders_contact_last_nameTEXTPurchase Orders Contact last NamePurchase Orders Contact last Name
purchase_orders_contact_nameTEXTPurchase Orders Contact First Name (alias for purchase_orders_contact_first_name)Purchase Orders Contact First Name
purchase_orders_created_byTEXTPurchase Created ByCreated By
purchase_orders_descriptionTEXTPurchase DescriptionDescription
purchase_orders_discountTEXTPurchase DiscountDiscount
purchase_orders_due_dateDATEPurchase Due DateDue Date
purchase_orders_excise_dutyTEXTPurchase Excise DutyExcise Duty
purchase_orders_grand_totalTEXTPurchase Grand TotalGrand Total
purchase_orders_idTEXTPurchase Record IdRecord Id
purchase_orders_locked__sTEXTPurchase LockedLocked
purchase_orders_modified_byTEXTPurchase Modified ByModified By
purchase_orders_modified_timeTIMESTAMPPurchase Modified TimeModified Time
purchase_orders_ownerTEXTPurchase Orders Purchase Order Owner idPurchase Order Owner id
purchase_orders_owner_first_nameTEXTPurchase Orders Owner First NamePurchase Orders Owner First Name
purchase_orders_owner_last_nameTEXTPurchase Orders Owner Last NamePurchase Orders Owner Last Name
purchase_orders_po_dateDATEPurchase Po DatePo Date
purchase_orders_po_numberTEXTPurchase Po NumberPo Number
purchase_orders_purchase_itemsTEXTPurchase ItemsPurchase Items
purchase_orders_sales_commissionTEXTPurchase Sales CommissionSales Commission
purchase_orders_shipping_cityCITYPurchase Shipping CityShipping City
purchase_orders_shipping_codeTEXTPurchase Shipping CodeShipping Code
purchase_orders_shipping_countryCOUNTRYShipping CountryShipping Country
purchase_orders_shipping_stateTEXTPurchase Shipping StateShipping State
purchase_orders_shipping_streetTEXTPurchase Shipping StreetShipping Street
purchase_orders_statusTEXTPurchase StatusStatus
purchase_orders_sub_totalTEXTPurchase Sub TotalSub Total
purchase_orders_subjectTEXTPurchase SubjectSubject
purchase_orders_tagTEXTPurchase TagTag
purchase_orders_taxTEXTPurchase TaxTax
purchase_orders_terms_and_conditionsTEXTPurchase Terms And ConditionsTerms And Conditions
purchase_orders_vendor_nameTEXTPurchase Vendor NameVendor Name

Zoho CRM Quotes fields

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

IDTypeNameDescription
quotes_account_nameTEXTQuotes Account NameAccount Name
quotes_adjustmentTEXTQuotes AdjustmentAdjustment
quotes_billing_cityCITYQuotes Billing CityBilling City
quotes_billing_codeTEXTQuotes Billing CodeBilling Code
quotes_billing_countryCOUNTRYQuotes Billing CountryBilling Country
quotes_billing_stateTEXTQuotes Billing StateBilling State
quotes_billing_streetTEXTQuotes Billing StreetBilling Street
quotes_carrierTEXTQuotes CarrierCarrier
quotes_contact_first_nameTEXTQuotes Contact First NameQuotes Contact First Name
quotes_contact_idTEXTQuotes Contact idQuotes Contact id
quotes_contact_last_nameTEXTQuotes Contact last NameQuotes Contact last Name
quotes_contact_nameTEXTQuotes Contact First Name (alias for quotes_contact_first_name)Quotes Contact First Name
quotes_created_byTEXTQuotes Created ByCreated By
quotes_created_timeTIMESTAMPQuotes Created TimeCreated Time
quotes_deal_nameTEXTQuotes Deal NameDeal Name
quotes_descriptionTEXTQuotes DescriptionDescription
quotes_discountTEXTQuotes DiscountDiscount
quotes_grand_totalTEXTQuotes Grand TotalGrand Total
quotes_idTEXTQuotes Record IdRecord Id
quotes_locked__sTEXTLockedLocked
quotes_modified_byTEXTQuotes Modified ByModified By
quotes_modified_timeTIMESTAMPQuotes Modified TimeModified Time
quotes_ownerTEXTQuotes Quote Owner idQuote Owner id
quotes_owner_first_nameTEXTQuotes Owner First NameQuotes Owner First Name
quotes_owner_last_nameTEXTQuotes Owner Last NameQuotes Owner Last Name
quotes_quote_numberTEXTQuote NumberQuote Number
quotes_quote_stageTEXTQuote StageQuote Stage
quotes_quoted_itemsTEXTQuoted ItemsQuoted Items
quotes_shipping_cityCITYQuotes Shipping CityShipping City
quotes_shipping_codeTEXTQuotes Shipping CodeShipping Code
quotes_shipping_countryCOUNTRYQuotes Shipping CountryShipping Country
quotes_shipping_stateTEXTQuotes Shipping StateShipping State
quotes_shipping_streetTEXTQuotes Shipping StreetShipping Street
quotes_sub_totalTEXTQuotes Sub TotalSub Total
quotes_subjectTEXTQuotes SubjectSubject
quotes_tagTEXTQuotes TagTag
quotes_taxTEXTQuotes TaxTax
quotes_terms_and_conditionsTEXTQuotes Terms And ConditionsTerms And Conditions
quotes_valid_tillTEXTValid UntilValid 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)

IDTypeNameDescription
sales_orders_account_nameTEXTSales Orders Account NameAccount Name
sales_orders_adjustmentTEXTSales AdjustmentAdjustment
sales_orders_billing_cityCITYSales Billing CityBilling City
sales_orders_billing_codeTEXTSales Billing CodeBilling Code
sales_orders_billing_countryCOUNTRYSales Billing CountryBilling Country
sales_orders_billing_stateTEXTSales Billing StateBilling State
sales_orders_billing_streetTEXTSales Billing StreetBilling Street
sales_orders_carrierTEXTSales CarrierCarrier
sales_orders_contact_first_nameTEXTSales Orders Contact First NameSales Orders Contact First Name
sales_orders_contact_idTEXTSales Orders Contact idSales Orders Contact id
sales_orders_contact_last_nameTEXTSales Orders Contact last NameSales Orders Contact last Name
sales_orders_contact_nameTEXTSales Orders Contact First Name (alias for sales_orders_contact_first_name)Sales Orders Contact First Name
sales_orders_created_byTEXTSales Created ByCreated By
sales_orders_created_timeTIMESTAMPSales Created TimeCreated Time
sales_orders_deal_nameTEXTSales Deal NameDeal Name
sales_orders_descriptionTEXTSales DescriptionDescription
sales_orders_discountTEXTSales DiscountDiscount
sales_orders_due_dateDATEDue DateDue Date
sales_orders_excise_dutyTEXTExcise DutyExcise Duty
sales_orders_grand_totalTEXTSales Grand TotalGrand Total
sales_orders_idTIMESTAMPSales Record IdRecord Id
sales_orders_locked__sTEXTSales LockedLocked
sales_orders_modified_byTEXTSales Modified ByModified By
sales_orders_modified_timeTIMESTAMPSales Modified TimeModified Time
sales_orders_ordered_itemsTEXTSales Ordered ItemsOrdered Items
sales_orders_ownerTEXTSales Orders Sales Order Owner idSales Order Owner id
sales_orders_owner_first_nameTEXTSales Orders Owner First NameSales Orders Owner First Name
sales_orders_owner_last_nameTEXTSales Orders Owner Last NameSales Orders Owner Last Name
sales_orders_pendingTEXTPendingPending
sales_orders_purchase_orderTEXTPurchase OrderPurchase Order
sales_orders_quote_nameTEXTQuote NameQuote Name
sales_orders_sales_commissionTEXTSales Sales CommissionSales Commission
sales_orders_shipping_cityCITYSales Shipping CityShipping City
sales_orders_shipping_codeTEXTSales Shipping CodeShipping Code
sales_orders_shipping_countryCOUNTRYSales Shipping CountryShipping Country
sales_orders_shipping_stateTEXTSales Shipping StateShipping State
sales_orders_shipping_streetTEXTSales Shipping StreetShipping Street
sales_orders_so_numberTEXTSo NumberSo Number
sales_orders_statusTEXTSales Orders StatusStatus
sales_orders_sub_totalTEXTSales Sub TotalSub Total

Zoho CRM Sales_Orders fields (sales_orders_subject to sales_orders_terms_and_conditions)

IDTypeNameDescription
sales_orders_subjectTEXTSales SubjectSubject
sales_orders_tagTEXTSales TagTag
sales_orders_taxTEXTSales TaxTax
sales_orders_terms_and_conditionsTEXTSales Terms And ConditionsTerms And Conditions

Zoho CRM Solutions fields

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

IDTypeNameDescription
solutions_add_commentTEXTSolutions Add CommentAdd Comment
solutions_answerTEXTSolutions AnswerAnswer
solutions_commentsTEXTSolutions CommentsComments
solutions_created_byTEXTSolutions Created ByCreated By
solutions_created_timeTIMESTAMPSolutions Created TimeCreated Time
solutions_idTEXTSolutions Record IdRecord Id
solutions_locked__sTEXTSolutions LockedLocked
solutions_modified_byTEXTSolutions Modified ByModified By
solutions_modified_timeTIMESTAMPSolutions Modified TimeModified Time
solutions_no_of_commentsTEXTSolutions No. Of CommentsNo. Of Comments
solutions_ownerTEXTSolutions Solution Owner idSolution Owner id
solutions_owner_first_nameTEXTSolutions Owner First NameSolutions Owner First Name
solutions_owner_last_nameTEXTSolutions Owner Last NameSolutions Owner Last Name
solutions_product_nameTEXTSolutions Product NameProduct Name
solutions_publishedTEXTSolutions PublishedPublished
solutions_questionTEXTSolutions QuestionQuestion
solutions_solution_numberTEXTSolution NumberSolution Number
solutions_solution_titleTEXTSolution TitleSolution Title
solutions_statusTEXTSolutions StatusStatus
solutions_tagTEXTSolutions TagTag

Zoho CRM Stage_History fields

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

IDTypeNameDescription
stage_history_amountNUMERICStage History AmountDeal amount at the time of the stage change.
stage_history_closing_dateDATEStage History Closing DateClosing date at the time of the stage change.
stage_history_deal_idTEXTStage History Deal IDParent Deal record ID for the stage transition.
stage_history_durationNUMERICStage History DurationNumber of days the deal stayed in the previous stage.
stage_history_expected_revenueNUMERICStage History Expected RevenueExpected revenue at the time of the stage change.
stage_history_modified_byTEXTStage History Modified ByName of the user who changed the stage.
stage_history_modified_timeTIMESTAMPStage History Modified TimeTimestamp of the stage change.
stage_history_probabilityNUMERICStage History ProbabilityProbability percentage mapped to the stage.
stage_history_stageTEXTStage History StageStage name at the time of the transition.

Zoho CRM Tasks fields

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

IDTypeNameDescription
tasks_closed_timeTIMESTAMPTasks Closed TimeClosed Time
tasks_created_byTEXTTasks Created ByCreated By
tasks_created_timeTIMESTAMPTasks Created TimeCreated Time
tasks_descriptionTEXTTasks DescriptionDescription
tasks_due_dateDATETasks Due DateDue Date
tasks_idTEXTTasks Record IdRecord Id
tasks_locked__sTEXTTasks LockedLocked
tasks_modified_byTEXTTasks Modified ByModified By
tasks_modified_timeTIMESTAMPTasks Modified TimeModified Time
tasks_ownerTEXTTasks Task Owner idTask Owner id
tasks_owner_first_nameTEXTTasks Owner First NameTasks Owner First Name
tasks_owner_last_nameTEXTTasks Owner Last NameTasks Owner Last Name
tasks_priorityTEXTTasks PriorityPriority
tasks_recurring_activityTEXTTasks RepeatRepeat
tasks_remind_atTEXTTasks ReminderReminder
tasks_send_notification_emailTEXTTasks Send Notification EmailSend Notification Email
tasks_statusTEXTTasks StatusStatus
tasks_subjectTEXTTasks SubjectSubject
tasks_tagTEXTTasks TagTag
tasks_what_idTEXTTasks Related ToRelated To
tasks_who_idTEXTTasks Contact NameContact Name

Zoho CRM Vendors fields

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

IDTypeNameDescription
vendors_categoryTEXTVendors CategoryCategory
vendors_cityCITYVendors CityCity
vendors_countryCOUNTRYVendors CountryCountry
vendors_created_byTEXTVendors Created ByCreated By
vendors_created_timeTIMESTAMPVendors Created TimeCreated Time
vendors_descriptionTEXTVendors DescriptionDescription
vendors_emailTEXTVendors EmailEmail
vendors_gl_accountTEXTVendors Gl AccountGl Account
vendors_idTEXTVendors Record IdRecord Id
vendors_locked__sTEXTVendors LockedLocked
vendors_modified_byTEXTVendors Modified ByModified By
vendors_modified_timeTIMESTAMPVendors Modified TimeModified Time
vendors_ownerTEXTVendors Vendor Owner idVendor Owner id
vendors_owner_first_nameTEXTVendors Owner First NameVendors Owner First Name
vendors_owner_last_nameTEXTVendors Owner Last NameVendors Owner Last Name
vendors_phoneTEXTVendors PhonePhone
vendors_record_imageTEXTVendor ImageVendor Image
vendors_stateTEXTVendors StateState
vendors_streetTEXTVendors StreetStreet
vendors_tagTEXTVendors TagTag
vendors_vendor_nameTEXTVendors Vendor NameVendor Name
vendors_websiteTEXTVendors WebsiteWebsite
vendors_zip_codeTEXTVendors Zip CodeZip 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.

IDTypeNameDescriptionReport
data_fetched_atTIMESTAMPData fetched atUTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateDate at which the record was created.
day_of_monthTEXTDay of monthDay of the month
monthTEXTMonthNumber of the month
nowTIMESTAMPNowCurrent timestamp
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date
weekTEXTWeekWeek (Sun-Sat).
week_dayTEXTDay of week and day numberWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_isoTEXTDay of week and day number, ISOWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_isoTEXTWeek ISOWeek, ISO format (Mon-Sun).
yearTEXTYearYear
year_monthTEXTYearmonthYear and month, e.g. 2024|3
year_month_nameTEXTYear month nameYear and month with the month name written out, e.g. "Jan 2025".
year_of_weekTEXTYear of weekThe year that contains first day of the week (Sun-Sat).
year_of_week_isoTEXTYear of week, ISOThe year that contains first day of the ISO week (Mon-Sun).
year_weekTEXTYear weekYear and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_isoTEXTYear week ISOYear and week for ISO weeks (Mon-Sun), e.g. 2024|20