Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

lewiszman
New Contributor

Please help with HubSpot API pagination settings

Hi,

I'm using Qlik Sense' REST API connector to pull data from HubSpot CRM. HubSpot documentation reads:

"Get all of the deals in a portal.  Returns a paginated set of deals.

In addition to the list of deals, each request will also return two values, offset and hasMore. If hasMore is true, you'll need to make another request, using the offset to get the next page of deal records." (from Get all deals‌ )

Default records returned is 100.

I need help configuring the 'pagination type' settings in Qlik Sense. Please help.

9 Replies
lewiszman
New Contributor

Re: Please help with HubSpot API pagination settings

To clarify, here is the response I'm getting:

{deals":[{"portalId":1208841,"dealId":247301077,"isDeleted":false,"associations":null,"properties":{"dealname":{"value":"Sample Deal Name 1","timestamp":1516321349923,"source":"IMPORT","sourceId":"DealTasksSmiley Very HappyealsImport","versions":[{"name":"dealname","value":"Sample Deal Name 1","timestamp":1516321349923,"sourceId":"DealTasksSmiley Very HappyealsImport","source":"IMPORT","sourceVid":[]}]},"hubspot_owner_id":{"value":"5327004","timestamp":1516321349923,"source":"IMPORT","sourceId":"DealTasksSmiley Very HappyealsImport","versions":[{"name":"hubspot_owner_id","value":"5327004","timestamp":1516321349923,"sourceId":"DealTasksSmiley Very HappyealsImport","source":"IMPORT","sourceVid":[]}]}},"imports":[],"stateChanges":[]}],"hasMore":true,"offset":247301077}


offset returns a timestamp of the last request

hasMore: true indicates there are more records

Which pagination type in Qlik Sense REST API connector should I be using, and how should the parameters be configured?


Thank you.

gngijben
New Contributor III

Re: Please help with HubSpot API pagination settings

Did you find the solution? Facing the same problem.

gamaescalante
New Contributor II

Re: Please help with HubSpot API pagination settings

I'm looking to connect QlikSense & HubSpot data as well.  Any progress made?

gngijben
New Contributor III

Re: Please help with HubSpot API pagination settings

Yes, i succesfully managed to load all contacts. What exactly is your question?

gamaescalante
New Contributor II

Re: Please help with HubSpot API pagination settings

I am looking to load contacts and timeline/note activity in HubSpot to Qliksense...but not sure what documentation to reference for the setup.  Any assistance would be greatly appreciated.  Currently we've had success connecting QlikSense with a SQL Server Database. 

neeraj712
New Contributor

Re: Please help with HubSpot API pagination settings

i am trying to pull all Email Events from Hubspot , at a time one page appears with offset and hasMore=true, is there are option through REST API connection to read all pages ?

How did you read all contacts in single API  request ?

neeraj712
New Contributor

Re: Please help with HubSpot API pagination settings

Hi Gerco ,

How did you manage to access all pages to get all contact through API call?

I have to pull all Email Events from Hubspot , at a time one page appears with offset token and hasMore=true, when i use pagination technique "Next token"  and setting next token path to 'root/offset'. Data extracts is very slow and pull around 80k rows in 30 minutes.

Let me know steps you have performed to get all contact in singe request.



aferrari7
New Contributor II

Re: Please help with HubSpot API pagination settings

Hi Gerco,


Could you please share with us your code to paginate the .json?

gamaescalante
New Contributor II

Re: Please help with HubSpot API pagination settings

Did you have any luck connecting?