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 PowerB...
Need Help
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