Custom report using data from HubDB

Developer Support APIs & Integrations
1

Hello,

I’m trying to make a custom reports using data outside of hubspot.

I’ve thought use the analytics API following the recommendation of this foro to do that, but the API v3 haven’t released yet.

I saw I can create tables in HubDB, my question is, Can I use data from a HubDB table to make a custom report?

If yes, How can do it?

If no, What’s the best option to do a custom report using external data?

2

Hey @NicolasPS ,

Did you have a chance to explore the HubDB API?

Beta version here

Here is latest stable.

3

Hey @dennisedson ,

Thanks for your answer!

Yes, I saw the HubDB API, but the real question is:

Can I use data from HubDB table to generate a report in the dashboard in HubSpot? Because I can push all my data in a table un HubDB, but, I don’t want “effort” doing something that doesn’t work as I need :disappointed_face:

Thanks,

Nicolas PS

4

@NicolasPS

Yeah…to the best of my knowledge there is not a way to do this with existing HubSpot tools :sad_but_relieved_face:

You can definitely still leverage the analytics endpoints referenced above.

Maybe @christiancph has more insights into his final product :grinning_cat:

5

@dennisedson

I was thinking in create a kind of count variable using the contact’s properties in HubSpot and seach if exist an API to increment the value of that property.

Do you know if exist an API like that?

Thanks,

Nico

6

@NicolasPS

Mind detailing a bit more? You can filter and search, but I am not 100% sure that is what you are asking

So it isn’t just you and me here, going to plead with a few others to think about this.

@jpsanchez , @daveroma would love an extra set of :eyes: on this!

7

@dennisedson

Sorry! let me develop my idea… I saw in hubspot I can only generate reports using internal data (based on contacts, company, business, etc…).

So I thought, If I created a contact’s property like a count variable, I’d abel to add + 1 to this property using an API. All is because you told me HubDB hadn’t had that tool yet.

Do you know if existe an API that I can use to add values to specific contact’s property in hubspot?

Thanks,

Nico

8

YES YES!

First, you need to create the property that you want to use and make its type a number

Can do in the UI or via the API

When that exists, you can start updating using the contacts api.

Now I am really curious about what you are doing :grinning_face_with_smiling_eyes:

9

I did this to solve it:

At the beggining I create two custom propeties in HubSpot contacts, type date and number. One of them to count the SMS received, and the other catch the date when it was sended. But the problem were reporting a history with the SMS sended, because it didn’t match with the reported provided by our SMS provider, because the date propertie change every time a SMS is send.

To solve that, when our provider response with a status 200, we create an engagement type Note into the contact page, saying were a SMS senden by our workflow action. and now the reports into the dashboard in HubSpot are very close with the report provided by our SMS provider.

Thanks a lot for your support.