Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

Highlighted
Sarathenk
New Contributor

Getting data from HubSpot

Hi,

I am trying to read data from HubSpot using Qlik General Web Connector.

Selected JSonToTable type and added parameters.

Please find the below screen shot of the same.

image.pngConfig General Web Connector

With the same url in the browser, it shows the details as below. There are details from contact table but not getting properly in Qlik Data Preview.

-----------

{"contacts":[{"addedAt":1562062156151,"vid":1,"canonical-vid":1,"merged-vids":[],"portal-id":6086531,"is-contact":true,"profile-token":"AO_T-mNCZ9c-HRRmXG6XxhIHFzy6vrAu329-xfD1bOcwo8kWngoCwYaYHjBtfikTGmPNp58ckmdoP42Rn6Fcth1TPwK75poPvhIdkqJECGdv_1pVjkk_4c78p_xMgqeSV9j0tF0M_a5L","profile-url":"/contact/60","properties":{"firstname":{"value":"Cool"},"lastmodifieddate":{"value":"1562062164332"}... (Sample Contact)"}},"form-submissions":[],"identity-profiles":[{"vid":1,"saved-at-timestamp":1562062156045,"deleted-changed-timestamp":0,"identities":[{"type":"EMAIL","value":"coolrobot@hubspot.com","timestamp":1562062155964,"is-primary":true},{"type":"LEAD_GUID","value":"bb4d9b96-ec3c-4948-b169-725c3948918b","timestamp":1562062156041}]}],"merge-audits":[]},{"addedAt":1562062156333,"vid":51,"canonical-vid":51,"merged-vids":[],"portal-id":6086531,"is-contact":true,"profile-token":"AO_T-mPhjP8QaJPjQS66c4u5ieoP2qyTycjXamBMAClEpNF0yvVzHl13sJX1xUSIjwoaq6ZX-FdgV69zVVxiWSlwcDpkgjaL_jEKVgCiO5myJymLOnMtkgjzRz5Fd2u2ZhvKvAyds74E","profile-url":"contact/51","properties":{"firstname":{"value":"Brian"},"lastmodifieddate":{"value":"1562062164663"}... (Sample Contact)"}},"form-submissions":[],"identity-profiles":[{"vid":51,"saved-at-timestamp":1562062156216,"deleted-changed-timestamp":0,"identities":[{"type":"EMAIL","value":"bh@hubspot.com","timestamp":1562062155964,"is-primary":true},{"type":"LEAD_GUID","value":"01ea9f38-d05d-4636-ab15-022341569922","timestamp":1562062156213}]}],"merge-audits":[]}],"has-more":false,"vid-offset":51}

---------------------

Please guide or share best way to get data from HubSpot database.

Thanks in advance.