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

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 

Hi,

we are using Hubspot as our CRM and I want to use Qlik Sense to analyse the data in Hubspot. I can extract all the data using the REST API and build a data model. Only this takes quite a bit of time and energy. As we have not customised Hubspot I wonder if anybody out there has gone through the pains of building a datamodel already. We only need the standard things.... mainly deals, contacts and companies.
Please let me know should you be able to share a template.

Thanks
Mark

am new to qlik and I am trying to filter my data set with 

where clause.

example 

HI, I am using Qliksense and I want to change row color red when a field called variance is > 5%. in pivot table.

my pivot table has 4 dimension and 4 measure  and last measure is variance which will decide the color of row.

please help, i could find better option to change it..

My goal is to have multiple of the same filter on a page so that users can compare different values of the measure. Ex: User compares multiple locations for housing and see's pros and cons. These filters should only impact specific visuals on the page.

The key here is to NOT use Alternate States as I need to make the visuals a master item and that is a limited capability with alternate states.

Hi all,

This is my scenario:

I have set sheet triggers to select field values in every sheet.After hitting clear button,the triggers setting is also removed and all values are seen which is not ideal.

I refered the answer used in this question https://community.qlik.com/t5/QlikView-App-Dev/Clear-all-selections-removes-the-logic/td-p/1315902

It solves the purpose of retaining the triggers ,however if I clik Clear button for eg on 3rd sheet,it automatically goes to 2nd sheet where the bookmark was created.

Is there any way I can retain the trigger values and also remain on the same sheet ?

Hello,

I have a user directory with AD domain users and a user directory with users in a sql table.

The app includes following section access:

SECTION ACCESS;

secAccess:
LOAD * INLINE [
ACCESS,NTNAME
ADMIN,MYADDOMAIN\USER1
ADMIN,MYADDOMAIN\USER2
USER,SQLSERVERUSERDIRECTORY\USERSQL
];

I openthe app with a ticket and AD domain I have no problems.

When I try to acccess with the user in the SQLSERVERUSERDIRECTORY

I get a "Access Denied" message.

I see that USERSQL is among the users with SQLSERVERUSERDIRECTORY

I set a rule to allow the SQLSERVERUSERDIRECTORY to login (so I don't get the PASS not avialable message anymore)

Maybe I should try to write section access in a different way or what could I check?