Integrating Intercom ChatBot into PowerBI

[rk239911]

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

[lbendlin]

I would think that the API is the most promising way to do that.  Have you tried it?

REST APIs (intercom.com)

[rk239911]

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

[lbendlin]

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

[rk239911]

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.