Qlik Community

Ask a Question

Integration, Extension & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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
Contributor

@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.