APIs & Integrations

mingheng_moka
メンバー

Hard limit for no. of deal records extracted using API (Ticket number: #2057435)

解決

Hi,

I'm doing the ETL of Hubspot data to my company data warehouse. Have tried extracting all the deals as well as recently modified deals using API from the following endpoints:

https://api.hubapi.com/deals/v1/deal/paged?hapikey=
https://api.hubapi.com/deals/v1/deal/recent/modified?hapikey=

Extraction would halt after 10k records. Have checked response and its due to rate limit (see attached screenshot)

Pls note that I've set it to extract up to 250 records per query but it only extracts 100

Have lodged a ticket, but was directed to post my query here instead.

Please advise.

Thank you.

Regards,
Mingheng

0 いいね!
1件の承認済みベストアンサー
IsaacTakushi
解決策
HubSpot Employee
HubSpot Employee

Hard limit for no. of deal records extracted using API (Ticket number: #2057435)

解決

Hi @mingheng_moka,

Thank you for the URL. You are only receiving 100 deals per call because you are using count=250 instead of limit=250.

The count parameter is used for the Get recently modified deals endpoint while the limit parameter is used for the Get all deals endpoint.

Use this request URL instead:

https://api.hubapi.com/deals/v1/deal/paged?hapikey=XXXXXXXXXXXX&properties=dealstage&properties=invoice_number&properties=createdate&properties=closed_won_reason&properties=closed_lost_reason&properties=pipeline&properties=dealtype&properties=amount&properties=hubspot_owner_id&properties=activation_email&properties=hs_lastmodifieddate&limit=250&includeAssociations=true

Isaac Takushi

Associate Certification Manager

元の投稿で解決策を見る

0 いいね!
3件の返信
IsaacTakushi
解決策
HubSpot Employee
HubSpot Employee

Hard limit for no. of deal records extracted using API (Ticket number: #2057435)

解決

Hi @mingheng_moka,

Thank you for the URL. You are only receiving 100 deals per call because you are using count=250 instead of limit=250.

The count parameter is used for the Get recently modified deals endpoint while the limit parameter is used for the Get all deals endpoint.

Use this request URL instead:

https://api.hubapi.com/deals/v1/deal/paged?hapikey=XXXXXXXXXXXX&properties=dealstage&properties=invoice_number&properties=createdate&properties=closed_won_reason&properties=closed_lost_reason&properties=pipeline&properties=dealtype&properties=amount&properties=hubspot_owner_id&properties=activation_email&properties=hs_lastmodifieddate&limit=250&includeAssociations=true

Isaac Takushi

Associate Certification Manager
0 いいね!
IsaacTakushi
HubSpot Employee
HubSpot Employee

Hard limit for no. of deal records extracted using API (Ticket number: #2057435)

解決

Hi @mingheng_moka,

As stated in this documentation, the Get recently modified deals endpoint only returns up to the 10,000 most recently modified deals. Please refer to this similar topic.

Regarding the limit value used for the Get all deals endpoint, please share your Hub ID and the full request URL you are using (not including your API key).

Isaac Takushi

Associate Certification Manager
0 いいね!
mingheng_moka
メンバー

Hard limit for no. of deal records extracted using API (Ticket number: #2057435)

解決

Hi Issac,

Hubspot ID : is 2528720

Full request url for all deals is:
'https://api.hubapi.com/deals/v1/deal/paged?hapikey=XXXXXXXXXXXX&properties=dealstage&properties=invo...'

Thanks!

0 いいね!