Live Sessions Data Source - HubSpot API calls

Develop, Build & Integrate APIs & Integrations
1

Hi All,

I am trying to build an API to pull session information out of HubSpot into a google sheet to create a live sessions data source for a looker dashbaord. As of now, I am only able to create an API that pulls one dimension, either Session Source or Session geolocation. When I messaged HubSpot support for suggestions on getting these two dimensions in one data source through an API, I was advised to create custom analytics views. I was going to create custom analytics views for each type of session source and then pull a geolocation sessions call with a filterId for each of the custom analytics view. This solution would have worked for me, but then I ran into the issue that custom analytics views only show data from the creation date of the view forward. I need this solution to work for pulling historical data, at least back to 2022.

Does anyone have a solution for this, using APIs or otherwise? I am willing to explore other options.

Thank you!

2

Hi @MSerra6! Welcome to the Community-- happy to have you here :blush:

Thanks for utilizing support -- let’s tag in some of our community members to see if we can get some more advice.

Hey @zach_threadint, @Phil_Vallender, @cameroncollecti do y’all have any suggestions or experience to share here?

Best,

Kennedy