--- title: "Get deals where a product is attached to" method: GET path: "/products/{id}/deals" tags: ["Products"] --- # Get deals where a product is attached to `GET /products/{id}/deals` Returns data about deals that have a product attached to it. ## Path parameters - `id` integer, required ## Query parameters - `start` integer - `limit` integer - `status` 'open' | 'won' | 'lost' | 'deleted' | 'all_not_deleted' ## Response `200` The data of deals that have a product attached - object - `success` boolean — If the response is successful or not - `data` object[] — The array of deals - `id` integer — The ID of the deal - `creator_user_id` object — The creator of the deal - `id` integer — The ID of the deal creator - `name` string — The name of the deal creator - `email` string — The email of the deal creator - `has_pic` boolean — If the creator has a picture or not - `pic_hash` string, nullable — The creator picture hash - `active_flag` boolean — Whether the creator is active or not - `value` integer — The ID of the deal creator - `user_id` object — The user who is associated with the deal - `id` integer — The ID of the user - `name` string — The name of the user - `email` string — The email of the user - `has_pic` boolean — If the user has a picture or not - `pic_hash` string, nullable — The user picture hash - `active_flag` boolean — Whether the user is active or not - `value` integer — The ID of the user - `person_id` object — The person who is associated with the deal - `active_flag` boolean — Whether the associated person is active or not - `name` string — The name of the person associated with the deal - `email` object[] — The emails of the person associated with the deal - `label` string — The type of the email - `value` string — The email of the associated person - `primary` boolean — If this is the primary email or not - `phone` object[] — The phone numbers of the person associated with the deal - `label` string — The type of the phone number - `value` string — The phone number of the person associated with the deal - `primary` boolean — If this is the primary phone number or not - `owner_id` integer — The ID of the owner of the person that is associated with the deal - `value` integer — The ID of the person associated with the deal - `org_id` object — The organization which is associated with the deal - `name` string — The name of the organization associated with the deal - `people_count` integer — The number of people connected with the organization that is associated with the deal - `owner_id` integer — The ID of the owner of the organization that is associated with the deal - `address` string — The address of the organization that is associated with the deal - `active_flag` boolean — Whether the associated organization is active or not - `cc_email` string — The BCC email of the organization associated with the deal - `value` integer — The ID of the organization associated with the deal - `stage_id` integer — The ID of the deal stage - `title` string — The title of the deal - `value` number — The value of the deal - `currency` string — The currency associated with the deal - `add_time` string — The creation date and time of the deal - `update_time` string — The last updated date and time of the deal - `stage_change_time` string — The last updated date and time of the deal stage - `active` boolean — Whether the deal is active or not - `deleted` boolean — Whether the deal is deleted or not - `is_archived` boolean — Whether the deal is archived or not - `status` string — The status of the deal - `probability` number, nullable — The success probability percentage of the deal - `next_activity_date` string — The date of the next activity associated with the deal - `next_activity_time` string — The time of the next activity associated with the deal - `next_activity_id` integer, nullable — The ID of the next activity associated with the deal - `last_activity_id` integer, nullable — The ID of the last activity associated with the deal - `last_activity_date` string, nullable — The date of the last activity associated with the deal - `lost_reason` string, nullable — The reason for losing the deal - `visible_to` string — The visibility of the deal - `close_time` string, nullable — The date and time of closing the deal - `pipeline_id` integer — The ID of the pipeline associated with the deal - `won_time` string — The date and time of changing the deal status as won - `first_won_time` string — The date and time of the first time changing the deal status as won - `lost_time` string — The date and time of changing the deal status as lost - `products_count` integer — The number of products associated with the deal - `files_count` integer — The number of files associated with the deal - `notes_count` integer — The number of notes associated with the deal - `followers_count` integer — The number of followers associated with the deal - `email_messages_count` integer — The number of emails associated with the deal - `activities_count` integer — The number of activities associated with the deal - `done_activities_count` integer — The number of completed activities associated with the deal - `undone_activities_count` integer — The number of incomplete activities associated with the deal - `participants_count` integer — The number of participants associated with the deal - `expected_close_date` string, date — The expected close date of the deal - `last_incoming_mail_time` string — The date and time of the last incoming email associated with the deal - `last_outgoing_mail_time` string — The date and time of the last outgoing email associated with the deal - `label` string — The label or multiple labels assigned to the deal - `stage_order_nr` integer — The order number of the deal stage associated with the deal - `person_name` string — The name of the person associated with the deal - `org_name` string — The name of the organization associated with the deal - `next_activity_subject` string — The subject of the next activity associated with the deal - `next_activity_type` string — The type of the next activity associated with the deal - `next_activity_duration` string — The duration of the next activity associated with the deal - `next_activity_note` string — The note of the next activity associated with the deal - `formatted_value` string — The deal value formatted with selected currency. E.g. US$500 - `weighted_value` number — Probability times deal value. Probability can either be deal probability or if not set, then stage probability. - `formatted_weighted_value` string — The weighted_value formatted with selected currency. E.g. US$500 - `weighted_value_currency` string — The currency associated with the deal - `rotten_time` string, nullable — The date and time of changing the deal status as rotten - `owner_name` string — The name of the deal owner - `cc_email` string — The BCC email of the deal - `org_hidden` boolean — If the organization that is associated with the deal is hidden or not - `person_hidden` boolean — If the person that is associated with the deal is hidden or not - `origin` string — The way this Deal was created. `origin` field is set by Pipedrive when Deal is created and cannot be changed. - `origin_id` string, nullable — The optional ID to further distinguish the origin of the deal - e.g. Which API integration created this Deal. - `channel` integer, nullable — The ID of your Marketing channel this Deal was created from. Recognized Marketing channels can be configured in your Company settings. - `channel_id` string, nullable — The optional ID to further distinguish the Marketing channel. - `arr` number, nullable — Only available in Growth and above plans The Annual Recurring Revenue of the deal Null if there are no products attached to the deal - `mrr` number, nullable — Only available in Growth and above plans The Monthly Recurring Revenue of the deal Null if there are no products attached to the deal - `acv` number, nullable — Only available in Growth and above plans The Annual Contract Value of the deal Null if there are no products attached to the deal - `arr_currency` string, nullable — Only available in Growth and above plans The Currency for Annual Recurring Revenue of the deal If the `arr` is null, this will also be null - `mrr_currency` string, nullable — Only available in Growth and above plans The Currency for Monthly Recurring Revenue of the deal If the `mrr` is null, this will also be null - `acv_currency` string, nullable — Only available in Growth and above plans The Currency for Annual Contract Value of the deal If the `acv` is null, this will also be null - `additional_data` object — The additional data of the list - `start` integer — Pagination start - `limit` integer — Items shown per page - `more_items_in_collection` boolean — If there are more list items in the collection than displayed or not - `related_objects` object - `organization` object - `ORGANIZATION_ID` object — The ID of the organization associated with the item - `active_flag` boolean — Whether the associated organization is active or not - `id` integer — The ID of the organization associated with the item - `name` string — The name of the organization associated with the item - `people_count` integer — The number of people connected with the organization that is associated with the item - `owner_id` integer — The ID of the owner of the organization that is associated with the item - `address` string, nullable — The address of the organization - `cc_email` string, nullable — The BCC email of the organization associated with the item - `person` object - `PERSON_ID` object — The ID of the person associated with the item - `active_flag` boolean — Whether the associated person is active or not - `id` integer — The ID of the person associated with the item - `name` string — The name of the person associated with the item - `email` object[] — The emails of the person associated with the item - `label` string — The type of the email - `value` string — The email of the associated person - `primary` boolean — Whether this is the primary email or not - `phone` object[] — The phone numbers of the person associated with the item - `label` string — The type of the phone number - `value` string — The phone number of the person associated with the item - `primary` boolean — Whether this is the primary phone number or not - `owner_id` integer — The ID of the owner of the person that is associated with the item - `user` object - `USER_ID` object — The ID of the user - `id` integer — The ID of the user - `name` string — The name of the user - `email` string — The email of the user - `has_pic` integer — Whether the user has picture or not. 0 = No picture, 1 = Has picture. - `pic_hash` string, nullable — The user picture hash - `active_flag` boolean — Whether the user is active or not - `stage` object - `id` integer — The ID of the stage - `order_nr` integer — Defines the order of the stage - `name` string — The name of the stage - `active_flag` boolean — Whether the stage is active or deleted - `deal_probability` integer — The success probability percentage of the deal. Used/shown when the deal weighted values are used. - `pipeline_id` integer — The ID of the pipeline to add the stage to - `rotten_flag` boolean — Whether deals in this stage can become rotten - `rotten_days` integer — The number of days the deals not updated in this stage would become rotten. Applies only if the `rotten_flag` is set. - `add_time` string — The stage creation time. Format: YYYY-MM-DD HH:MM:SS. - `update_time` string — The stage update time. Format: YYYY-MM-DD HH:MM:SS. - `pipeline` object - `id` integer — The ID of the pipeline - `name` string — The name of the pipeline - `url_title` string — The pipeline title displayed in the URL - `order_nr` integer — Defines the order of pipelines. First order (`order_nr=0`) is the default pipeline. - `active` boolean — Whether this pipeline will be made inactive (hidden) or active - `deal_probability` boolean — Whether deal probability is disabled or enabled for this pipeline - `add_time` string — The pipeline creation time. Format: YYYY-MM-DD HH:MM:SS. - `update_time` string — The pipeline update time. Format: YYYY-MM-DD HH:MM:SS. --- [API](https://skmtc.net/pipedrive/apis/pipedrive-api-v1.md) · [All operations](https://skmtc.net/pipedrive/apis/pipedrive-api-v1/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/pipedrive/pipedrive-api-v1/versions/bf863a979545/schema)