I needed to pull some user data for an app that uses Intercom. While I will probably import the data using Data Factory or a function in the long term, I needed to pull some quick data in a refreshable manner to combine with other data already available in Power BI.
I faced two challenges in getting this code to work:
1. Intercom’s API uses cursor-based pagination when retrieving contacts
2. I needed this query to be refreshable in PowerBI.com so I could schedule a daily refresh.
Read on to see how Meagan solved those problems.