Get total value of all deals in pipeline by stage

[brian929394]

Hi, Can I get the total value of all deals in the pipeline by stage? And/or forecast totals? I have a nice forecast chart in my hubspot, but I just want to retrieve those values by API.

Thanks!

[sylvain_tirreau]

Hi,

Take a look at this to see if you can find something that looks like what you want: https://www.linkedin.com/posts/hubspot-tips-and-tricks_hubspottipsandtricks-hubspotunderrated-report...

Best

[BérangèreL]

Bonjour @sylvain_tirreau, thanks a lot for going the extra mile and sharing the LinkedIn HubSpot Tips and Tricks post with @brian929394! ⭐

Thanks for all your valuable contributions, it is really appreciated and it helps many HubSpot Community Members ❤️

Bon week-end !
Bérangère

[sylvain_tirreau · Accepted solution]

Hi,

This isn't data that's delivered ready-made by the API. You have to retrieve deal data on one side, pipeline data on the other, and then aggregate everything yourself.

Best.

[BérangèreL]

Hi @brian929394, I hope that you are well!

Thanks for asking the HubSpot Community!

For information, I'd like to share these endpoints that might be of interest to you:

- Deals API
- Pipelines API
- Deals V1

Also, I'd love to put you in touch with our Top Experts: Hi @sylvain_tirreau, @zach_threadint and @Bortami do you have suggestions to help @brian929394, please?

Have a lovely day and thanks so much in advance for your help! ⭐
Bérangère