How to get total amount based on stages using HubSpot CRM API

DeepakKataria
Member

Hello Team,

 

Is it possible to get total deal amount group by deal stages in HubSpot API. Also, Is there any way to fetch deals with start/end filter using CRM SEARH API (https://api.hubapi.com/crm/v3/objects/deals?hapikey=XXX)

 

Thanks in advance.

0 Upvotes
3 Replies 3
FelipeFelix
Top Contributor

Hi @DeepakKataria!

I don't think HubSpot's API has that feature. You can get the total amount and the stage for each object record and then calculate it in your own system or you can also create a HubSpot report if you don't need to integrate that with another tool.

 

Best,
Felipe Felix

DeepakKataria
Member

Hi @FelipeFelix ,

 

Thank you for your response.

 

Can you please suggest me how to get the total amount and the stage for each object record. I tried to get deals with stages but there is a limit to get 100 records at a time.

 

0 Upvotes
FelipeFelix
Top Contributor

Hi @DeepakKataria!

That's true! HubSpot's batch API has a limitation of just 100 records each time. If you have a HubSpot Enterprise account, you can use a Workflow with webhook to make HubSpot send data to your endpoint. Or you can export regularly export your Deal Pipeline and then just sum everything.
If you don't have HubSpot Enterprise but have a little extra time, you can create a custom app Workflow action that sends webhooks.

How to create an app: https://developers.hubspot.com/docs/api/creating-an-app

Best,
Felipe Felix

0 Upvotes