Forum Discussion

rk239911's avatar
rk239911
Frequent Visitor
3 years ago

Integrating Intercom ChatBot into PowerBI

Is there a way to integrate Intercom ChatBot into PowerBI? Not sure if the API and token are needed?

I was trying a work-around by using ChatBot -> Python and then hopefully migrating that to PowerBI but was hoping there was a more direct connection. Any assistance would be greatly appreciated!!

 

PS. it does look like a similar question was asked from 2016 and there was a response 6/30/22 but I am not looking for a third party tool for integration. Hopefully there is another solution?

2016 link:

https://community.powerbi.com/t5/Power-Query/Load-data-from-Intercom-io/td-p/19690

Need Help

4 Replies

    • rk239911's avatar
      rk239911
      Frequent Visitor
      3 years ago

      So I attempted integrating intercom using the APIs by using the Get data > From Web. but was getting errors because of the credintials needed. I couldn't find an easy way to connect the 2 platforms directly. That being said! What ended up working for me is using python to export the json file and integrating that file into Power BI

      import requests
      import json
      from requests.auth import HTTPBasicAuth
      token = 'XXX'
      ID = 'XXX'
      datax = requests.get('https://api.intercom.io/contacts', auth = HTTPBasicAuth(token, ID)) ## pulling in contacts data
      jsonString = datax.json()
      jsonFile = open("datax.json", "w")
      jsonFile.write(json.dumps(jsonString))
      jsonFile.close()

      there certaintly could be a more optimal solution.. I just didn't have any luck with alternatives