Getting data from HubSpot

Sarathenk — Thu, 23 Dec 2021 18:42:25 GMT

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.

Config 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"},"company":{"value":"HubSpot"},"lastname":{"value":"Robot (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"},"company":{"value":"HubSpot"},"lastname":{"value":"Halligan (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.

Re: Getting data from HubSpot

fmarvnnt — Mon, 24 Feb 2020 10:32:01 GMT

I hope you've solved by using the Rest connector. If yes, can you share your example?

Re: Getting data from HubSpot

chrisbrain — Tue, 10 Mar 2020 11:50:25 GMT

Hi - You could try the JsonToXmlRaw table - this should give you a URL you can use as a web connection in Qlik. You should also be able to test it out in a browser to see all the data returned.

I am not that familiar with the API but it might be that the JSON (and therefore XML it is converted to) is more hierarchical meaning that if you want to use the JsonToTable table you will also need to set the XPATH table parameter to select the data within the response to turn into a table.

topic Re: Getting data from HubSpot in Connectivity & Data Prep

Getting data from HubSpot

Re: Getting data from HubSpot

Re: Getting data from HubSpot