Pipedrive Field Reference

Sample

The Pipedrive connector retrieves data from the lead and stage objects in Pipedrive.

Sample URL to retrieve lead related data

https://connectors.windsor.ai/pipedrive?date_preset=last_7d&api_key=[API Key]&fields=add_time,cc_email,creator_id,expected_close_date,is_archived,label_ids,lead_id,lead_title,next_activity_id,owner_id,person_id,pipedrive_organization_id,source_name,update_time,value_amount,value_currency,visible_to,was_seen

Sample URL to retrieve stage related data

https://connectors.windsor.ai/pipedrive?date_preset=last_7d&api_key=[API Key]&fields=activity_flag,add_time,deal_probability,order_nr,pipedrive_pipeline_id,pipeline_deal_probability,pipeline_name,rotten_days,rotten_flag,stage_id,stage_name,update_time


Fields

IDTypeNameDescriptionObject Type
activity_flagBOOLEANActivity FlagThe activity flagstages
add_timeDATEAdd TimeTime when the lead was added.leads
stages
cc_emailTEXTCompany EmailThe company emailleads
creator_idNUMERICCreator IDThe Creator IDleads
deal_probabilityNUMERICDeal ProbabilityThe deal probabilitystages
expected_close_dateDATEExpected Close DateThe expected close date.leads
is_archivedBOOLEANIs ArchivedThe lead is archived or not.leads
label_idsOBJECTLabel IDsThe label IDsleads
lead_idTEXTLead IDThe Lead IDleads
lead_titleTEXTLead TitleThe Lead titleleads
next_activity_idNUMERICNext Activity IDThe next activity IDleads
order_nrNUMERICOrder NumberThe order numberstages
owner_idNUMERICPipedrive Lead Owner IDThe Owner IDleads
person_idNUMERICPerson IDThe person IDleads
pipedrive_organization_idNUMERICOrganization IDThe organization IDleads
pipedrive_pipeline_idNUMERICPipedrive Pipeline IDThe pipeline IDstages
pipeline_deal_probabilityBOOLEANPipeline Deal ProbabilityThe pipeline deal probabilitystages
pipeline_nameTEXTPipeline NameThe pipeline namestages
rotten_daysNUMERICRotten DaysThe rotten daysstages
rotten_flagBOOLEANRotten FlagThe rotten flagstages
source_nameTEXTSource NameThe source nameleads
stage_idNUMERICStage IDThe stage IDstages
stage_nameTEXTStage NameThe stage namestages
update_timeDATEUpdate TimeTime when the lead was updated.leads
stages
value_amountNUMERICValue AmountThe value's amountleads
value_currencyTEXTValue CurrencyThe value's currencyleads
visible_toTEXTVisible ToVisible toleads
was_seenBOOLEANWas SeenThe lead was seen or not.leads