topic Re: Need guide on Connecting to hubspot using Qliksense REST connector in Connectivity & Data Prep

Need guide on Connecting to hubspot using Qliksense REST connector

xy-siang — Thu, 24 Sep 2020 08:39:23 GMT

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

Re: Need guide on Connecting to hubspot using Qliksense REST connector

DOD — Thu, 01 Oct 2020 12:23:39 GMT

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').

Re: Need guide on Connecting to hubspot using Qliksense REST connector

xy-siang — Fri, 02 Oct 2020 06:55:31 GMT

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?

Re: Need guide on Connecting to hubspot using Qliksense REST connector

xy-siang — Fri, 02 Oct 2020 06:57:56 GMT

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

Re: Need guide on Connecting to hubspot using Qliksense REST connector

xy-siang — Mon, 05 Oct 2020 09:32:36 GMT

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

Re: Need guide on Connecting to hubspot using Qliksense REST connector

DOD — Mon, 05 Oct 2020 09:53:20 GMT

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

Re: Need guide on Connecting to hubspot using Qliksense REST connector

DOD — Mon, 05 Oct 2020 10:14:16 GMT

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.

Re: Need guide on Connecting to hubspot using Qliksense REST connector

xy-siang — Tue, 06 Oct 2020 07:34:10 GMT

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

Re: Need guide on Connecting to hubspot using Qliksense REST connector

DOD — Tue, 06 Oct 2020 08:14:19 GMT

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

Re: Need guide on Connecting to hubspot using Qliksense REST connector

xy-siang — Tue, 06 Oct 2020 09:04:55 GMT

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,

Re: Need guide on Connecting to hubspot using Qliksense REST connector

DOD — Tue, 06 Oct 2020 09:45:44 GMT

Correct. You'll be building your data model in Qlik using the various object data.

Re: Need guide on Connecting to hubspot using Qliksense REST connector

xy-siang — Thu, 07 Jan 2021 08:16:48 GMT

Hi @DOD ,

Sorry to bother you again but need your advice if you happened to have knowledge on it.

In my hub ID - 3978304 account, there are about 2000 contacts. But when using API REST connection to pull data from hubspot to qliksense, I can only retrieve 100 records each time. Is there a way to retrieve all the 2000 contacts?

I try to use 'Next' or 'Offset' pagination type as shown below but doesn't seems to work well. Hence, could you advise what is the proper way if were to use Next' or 'Offset' pagination type?

Thank you

Re: Need guide on Connecting to hubspot using Qliksense REST connector

BayardBradford — Tue, 20 Apr 2021 23:56:42 GMT

A QlikSense connector for HubSpot is now available in the HubSpot App Marketplace. More information here. The connector uses a middleware application that loads the HubSpot data via the HubSpot APIs, so there’s no need to use the QlikSense REST connector.

Re: Need guide on Connecting to hubspot using Qliksense REST connector

DOD — Wed, 26 May 2021 10:08:33 GMT

Hi @xy-siang ,

I encountered the same issue. The pagination options in the connection setup did not work for loading all records, as some of the necessary parameter values did not exist.

To work around this, I used a loop in the load script to move to the next iteration after each value had been loaded.

Thanks,

Dod