Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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
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.
Thank you very much for your reply. I would check with Hubspot.
@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.