Forum Discussion
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...
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
there certaintly could be a more optimal solution.. I just didn't have any luck with alternatives
How do you acquire your token? Via another API call?
You should be able to get this done in Power Query via a regular GET call to Web.Contents - PowerQuery M | Microsoft Learn
Token was aquired via developers.intercom
https://developers.intercom.com/building-apps/docs/authentication-types
but I did not try via Power Query - that may be another option.