How do I prevent HubSpot Connector from using Internal Values?
When connecting to data in HubSpot, all of my data reads as HubSpot Internal Data values, and not the actuals names of things. To rename all of these values is nearing impossible. Please help.
Best Answers
-
Which report are you choosing with the HubSpot Connector as there are over 20 to choose from? It may be that you need to pull two different reports and then use Magic ETL to join them together so that you get the friendly names you are expecting and not just the internal IDs.
One way that can make this easier for you is to install the HubSpot Quickstart in the app store. This will create several datasets, dataflows, and cards automatically for you. You can then tweak cards that are of interest to you, or just leverage the dataflows that were created, which have already done the joining work for you.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
@CaitlynMaddox I would recommend using a dataset view to quickly rename the columns
https://domo-support.domo.com/s/article/360046074774?language=en_US#h_e5f30495-cb78-4759-ac95-0e493e0270b1
or you can send it through an ETL and rename the columns that way.If I have answered your question, please click "Yes" on my comment option.
0 -
@CaitlynMaddox To my knowledge, I don't think it's possible to replace the internal values with their corresponding labels. Usually, I have to pull another report using the HubSpot connector that shows the corresponding labels. I'll then join that with the original report in a dataset view.
0
Answers
-
Hi @CaitlynMaddox ,
Can you share a screenshot? Also which report are you using out of the Hubspot connector? I use the Deals one a lot.
John Le
You're only one dashboard away.
Click here for more video solutions:
0 -
Which report are you choosing with the HubSpot Connector as there are over 20 to choose from? It may be that you need to pull two different reports and then use Magic ETL to join them together so that you get the friendly names you are expecting and not just the internal IDs.
One way that can make this easier for you is to install the HubSpot Quickstart in the app store. This will create several datasets, dataflows, and cards automatically for you. You can then tweak cards that are of interest to you, or just leverage the dataflows that were created, which have already done the joining work for you.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
@CaitlynMaddox I would recommend using a dataset view to quickly rename the columns
https://domo-support.domo.com/s/article/360046074774?language=en_US#h_e5f30495-cb78-4759-ac95-0e493e0270b1
or you can send it through an ETL and rename the columns that way.If I have answered your question, please click "Yes" on my comment option.
0 -
@CaitlynMaddox To my knowledge, I don't think it's possible to replace the internal values with their corresponding labels. Usually, I have to pull another report using the HubSpot connector that shows the corresponding labels. I'll then join that with the original report in a dataset view.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 298 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive