Can I select deals filtered by their dealstage?

[justinteractive]

I'm wanting to select all deals in a particular deal stage from a pipeline. I can see how to get a pipeline, and also get all stages from the pipeline but no way to filter a record set by dealstage. Any suggestions very welcome.

[IsaacTakushi · Accepted solution]

Hi @justinteractive,

I'm not familiar with the approach @alexhubble cites, but I would love to learn more.

That said, the Deals API methods do not support this type of filtering. Instead, you must use one of the three GET endpoints:

• Get all deals
• Get recently created deals
• Get recently modified deals

and sort by the dealstage property on your end. Here's a similar topic.

[alexhubble]

There is a deals table which has a dealstage field - can you not see it in your hubspot schema ?