Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

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: 
xy-siang
Partner
Partner

Need guide on Connecting to hubspot using Qliksense REST connector

Hi All, 

Sry to trouble you all. I have never used Qliksense REST connector to connect  to Hubspot, to pull date from  the dashboard in bubspot to qliksense. I encountered an issue which I need help on it. 

1. This is the error I encountered:

hubspot issue.PNG

But I have already checked the "Check response type during 'Test Connection' ". Cannot figure out what is the cause of this. 

hubspot3.PNG

2. Below is my setting:

 

hubspot2.PNG

 

hubspot3.PNG

 

hubspot4.PNG

 

hubspot5.PNG

 

hubspot7.PNG

 

 

I followed the guide in this https://www.youtube.com/watch?v=FqwNU_pnFt4  . Can you anyone please advise me what should be the correct methods if the above are wrong?

Questions:

1. Is it because can't  use REST connection in qliksense to directly connect to hubspot?

2. If point #1 is true, then is it need to create a REST API out of the dashboard in hubspot first, before utilising REST connection in qliksense to pull data out of dashboard in hubspot?

Appreciate your help! Thank you.

Regards, 

XY Siang

 

 

13 Replies
DOD
Contributor III
Contributor III

Hi XY Siang,

The error message is indicating that the "Check response type during Test connection" checkbox should be deselected. You have mentioned that you have his checked in your settings.

Can you also confirm whether you have your API key included in the URL you have entered? This would be at the end of the string (i.e. hapikey='your_api_key').

xy-siang
Partner
Partner
Author

Hi DOD, 

Thanks for your reply. This issue is already resolved and I am facing another issue in REST connection

R6.png

R1.png

 

 

 

 

 

 

 

 

 

 

 

Setup the REST connection in qlik to pull data from dashboard in hubspot. Now able to generate the script to load data.

R2.png

 

 

 

 

 

 

Try different option but only the following options will work: Response Type – CSV and Delimiter - Tab

R3.png

 

 

 

 

 

 

 

Data loaded successfully

R4.png

 

 

 

 

 

 

 

 

 

 

 

But it’s only extracting HTML which is not very helpful. Any advice on this?

R6.png

 

xy-siang
Partner
Partner
Author

Hi DOD, 

Earlier you mentioned about this ->

Can you also confirm whether you have your API key included in the URL you have entered? This would be at the end of the string (i.e. hapikey='your_api_key').

If you don't mind, can you show me how you did it?

Regards, 

XY Siang

xy-siang
Partner
Partner
Author

Hi @DOD

I have included the API key included at the end of the my URL string (i.e. hapikey='your_api_key') as suggested by you previously.

Is it supposed to be like this, https://app.hubspot.com/contacts/8571348/contacts/list/view/all?hapikey= 'a397fd41-678d-431f-aa91-1bd2648282cc' or https://api.hubapi.com/contacts/v1/lists/all/contacts/recent?hapikey='a397fd41-678d-431f-aa91-1bd2648282cc' ?

Please correct me if neither is correct.

But encountered this error when using REST connection, 

Connection failed: HTTP protocol error 401 (Unauthorized):Requested resource requires authentication

xy-siang_0-1601884885168.png

Do you know how to solve such error ? (If anyone who knows about this,  can you please advise on solving this issue too?)

Thanks

 

XY Siang

DOD
Contributor III
Contributor III

Hi @xy-siang ,

I can see from the screenshots you've shared that you're getting a CSV response instead of JSON. The connection string appears to be incorrect from the URL which I see entered. It doesn't appear to include a valid HubSpot API call.

All of the endpoints for calling objects in HubSpot are in the following help documentation: https://developers.hubspot.com/docs/api/overview

E.g. For calling Contacts, the URL would be https://api.hubapi.com/crm/v3/objects/contacts?hapikey=YOUR_HUBSPOT_API_KEY

Thanks

DOD

DOD
Contributor III
Contributor III

I should add to answer your question, the second URL you listed is more accurate, but the single-quotes on your API Key are not needed.

xy-siang
Partner
Partner
Author

Hi  @DOD ,

Thanks for your suggestion and it works!  

I am able to pull data from hubspot to qliksense for standard objects in HubSpot - Contact, Company, Deal, and Tickets, based on the endpoints suggested by you and in the guide. 

But when I tried to pull data of dashboard  (Reports -> Dashboards )from hubspot, by using this endpoint to call dashboard, https://api.hubapi.com/crm/v3/objects/Reports?hapikey=9aebb661-a618-4cb0-a9ba-ca14dea534a1.

But it doesn't seems to work and is it because this is considered to be a CRM Custom Objects API? 

https://developers.hubspot.com/docs/api/crm/crm-custom-objectS

R7.PNG

DOD
Contributor III
Contributor III

Hi @xy-siang,

A custom object would be one created by you/your team within your own HubSpot environment. This would be unique to your enterprise account. There are instructions on how to create and define these in the section you've referred to.

Reports are not an object, which is why the endpoint you've listed is not working. Reports in the HubSpot UI are actually using the object data for calculation and presentation.

Thanks,

DOD

xy-siang
Partner
Partner
Author

Hi @DOD , 

Thanks for your explanation.

Since Report is not an object, I can only use the extracted data based on the standard object  e.g. contact, companies from hubspot to create the required dashboard in qliksense instead? 

Thanks, 

XY