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
| ID | Type | Name | Description | Object Type |
|---|---|---|---|---|
| activity_flag | BOOLEAN | Activity Flag | The activity flag | stages; |
| add_time | DATE | Add Time | Time when the lead was added. | leads; stages; |
| cc_email | TEXT | Company Email | The company email | leads; |
| creator_id | NUMERIC | Creator ID | The Creator ID | leads; |
| deal_probability | NUMERIC | Deal Probability | The deal probability | stages; |
| expected_close_date | DATE | Expected Close Date | The expected close date. | leads; |
| is_archived | BOOLEAN | Is Archived | The lead is archived or not. | leads; |
| label_ids | OBJECT | Label IDs | The label IDs | leads; |
| lead_id | TEXT | Lead ID | The Lead ID | leads; |
| lead_title | TEXT | Lead Title | The Lead title | leads; |
| next_activity_id | NUMERIC | Next Activity ID | The next activity ID | leads; |
| order_nr | NUMERIC | Order Number | The order number | stages; |
| owner_id | NUMERIC | Pipedrive Lead Owner ID | The Owner ID | leads; |
| person_id | NUMERIC | Person ID | The person ID | leads; |
| pipedrive_organization_id | NUMERIC | Organization ID | The organization ID | leads; |
| pipedrive_pipeline_id | NUMERIC | Pipedrive Pipeline ID | The pipeline ID | stages; |
| pipeline_deal_probability | BOOLEAN | Pipeline Deal Probability | The pipeline deal probability | stages; |
| pipeline_name | TEXT | Pipeline Name | The pipeline name | stages; |
| rotten_days | NUMERIC | Rotten Days | The rotten days | stages; |
| rotten_flag | BOOLEAN | Rotten Flag | The rotten flag | stages; |
| source_name | TEXT | Source Name | The source name | leads; |
| stage_id | NUMERIC | Stage ID | The stage ID | stages; |
| stage_name | TEXT | Stage Name | The stage name | stages; |
| update_time | DATE | Update Time | Time when the lead was updated. | leads; stages; |
| value_amount | NUMERIC | Value Amount | The value's amount | leads; |
| value_currency | TEXT | Value Currency | The value's currency | leads; |
| visible_to | TEXT | Visible To | Visible to | leads; |
| was_seen | BOOLEAN | Was Seen | The lead was seen or not. | leads; |