Get all deals and &include_product_data

Hi, I would like to pull all deals (filtered) and include all the product data associated with those deals.

I can list products attached to a specific deal, but obviously, I want ALL deals and deal id is required in that request.

I would think it would look something like this but it doesn’t pull the product data:

https://api.pipedrive.com/v1/deals?filter_id=57&status=all_not_deleted&include_product_data=1&start=0&api_token=

Any hints on how to make this work?

This is helpful: https://www.youtube.com/watch?v=Iv8o0jlABn4&t=0s

Seems to work but then I have to use a =split formula on Google Sheets because multiple products are inserted into one cell with comma delimiters.

Steve

Nice find on that! I’ll have to give a shoutout to Pedro as well :slight_smile: