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 method?

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

6 Replies

    • Shahodo's avatar
      Shahodo
      Regular Visitor
      6 years ago

      Hi Anonymous ,

       

      I appreciate your help! However, Hotjar's API doesn't allow data extraction and is used only to send user attributes. If you tried this method; did it work? 

       

      Any other solutions? 

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        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

  • julienvdc's avatar
    julienvdc
    Helper III
    4 years ago

    Hey Shahodo I am also looking for this setup... Have you managed to achieve what you were looking for in the end? Would you mind sharing your work?

  • 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