Forum Discussion

Shahodo's avatar
Shahodo
Regular Visitor
6 years ago
Solved

Connecting Hotjar with PowerBI as a data source

I am looking for a way to connect Hotjar to PowerBI where if I get a new answer to a survey it will update the dashboard automatically, is there anyway to actually do this? via an API or any other me...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Shahodo,

    After I double-check on hotjar documents I found it only shares the user attributes related APIs for development. (the official document methods they provide 'share' and 'export' features to sharing or getting records)

    How to Share and Export Data 

    So if you want to get data from this service, you can export and get data from that file to power bi(simple way). In addition, you can try to use programming languages to simulation 'sign in' and using the export feature to get the respond CSV/xlsx files and package them as an interface or web service. (the hard way)
    Then you can simply use power bi web connector to get data from that interface/web service.

    Regards,

    Xiaoxin Sheng

mfinlay's avatar
mfinlay
Advocate II
3 years ago

FYI this is still an issue in 2022. I've been repeatedly trying to automate an extract from HotJar, but they only offer Zapier as an integration option. This is effectively chargable per survey/recording, so gets expensive very quickly.

 

We did also write our own screen-scraper to login and download the csv, but the website wasn't stable enough to use this.

 

thanks

Matt