Getting data from HubSpot

[Sarathenk]

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"}... (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.

[fmarvnnt]

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

FM

[chrisbrain]

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.