Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Neeraja005
Contributor II
Contributor II

Pagination of hubspot deals API

Hello People,

I am really new to work with REST connectors on Qlik.

I tried integrating Hubspot CRM deals API (https://api.hubapi.com/crm/v3/objects/deals) using REST connector.

More info about API endpoint ->Hubspot deals API 

I also could paginate the API using the following parameters:

  • Pagination type: Next page
  • 'Next page' parameter name: after
  • 'Next page' initial value: 1
  • 'Page size' parameter name: limit
  • 'Page size' value: 100
  • Data indicator path :root/paging/next/after

I hope these parameters are correct. Please check with me if I am wrong anywhere.

Also after this when I try to load data the API works nearly for 1 hour (loading values) and gives me a 502 error
(take a look at the attachment).

This error is really often when I try to fetch data.

Please let me know if someone can help me with this problem.

Thank you very much.

Neeraja

Qlik Sense 

Labels (5)
3 Replies
Levi_Turner
Employee
Employee

If things are running for 1 hour then I suspect the configuration on your end is setup correctly. The 502 response from Hubspot is very odd. That suggests that their back-end servers which are delivering the data are not responding properly (https://developer.mozilla.org/en-US/docs/Web/HTTP/Status/502). 

If you were getting a 429 response, that would signal that you've hit a Hubspot quota (see Rate limits on https://developers.hubspot.com/docs/api/usage-details) but that isn't the case here.

Are you able to pull the needed information in another tool / approach? Because my first go to if I were in your shoes is to contact Hubspot about why their back-end servers are not responding in an expected manner.

Neeraja005
Contributor II
Contributor II
Author

Thank you very much for your reply. I would check with Hubspot.

BayardBradford
Contributor II
Contributor II

@Neeraja005 @Levi_Turner  A QlikSense connector for HubSpot is now available in the HubSpot App Marketplace. More information here.  The design of the integration resolves problems with pagination by pulling HubSpot CRM data via the APIs into a SQL Server data warehouse.