Need guide on Connecting to hubspot using Qliksense REST connector

[xy-siang]

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:

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

2. Below is my setting:

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

[DOD]

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]

Hi DOD, 

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

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

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

Data loaded successfully

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

[xy-siang]

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]

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

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]

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]

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]

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

[DOD]

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]

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