# Domo API Integration: data translation issue **URL:** \ **Category:** APIs & Integrations\ **Tags:** developer-tools\ **Created:** [March 3, 2020, 12:42am UTC](https://community.hubspot.com/t/domo-api-integration-data-translation-issue/19161 "2020-03-03T00:42:46Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![RachelAP](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/rachelap/32/14279_2.png) [@RachelAP](https://community.hubspot.com/u/RachelAP)\ **Post date:** [March 3, 2020, 12:42am UTC](https://community.hubspot.com/t/domo-api-integration-data-translation-issue/19161/1 "2020-03-03T00:42:46Z")
Hello! While HubSpot has worked great for my company’s needs in organizing our sales (and more!), we are trying to integrate HS data into Domo, which has a bit more reporting power. Domo has an “automatic” API tool that others in this forum have discussed, and it’s set up just fine, but the actual data is translating too “literally.” It’s giving me URLs instead of deal/pipeline names, and UNIX/epoch timestamps in milliseconds instead of a datetime. I’ve asked Domo Support about this, but they’re very slow and generic in their answers, so I’m hoping someone here can help out. Please see the attached screenshots. ![1.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/1/19d73bb474db424b459177e1a5280c2c533ce6ee.png) We have a few HubSpot reports connected (Deals With Stages, Owners, and Deals - Recent) and working in Domo, but both our custom deal stage names and pipelines, and all the “date entered deal stage” fields are coming in as URLs and UNIX times in HubSpot, instead of our custom deal/pipeline names and datetime format. ![2.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/3/b/3b55ee5f3bdf3936092bf3cfec7c01d1ea4a622f.png) ![3.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/5/5ece81d7b5a3c511153b52d1f104b5ae20ce922b.png) ![4.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/c/cdf0a6c7ae18cf654f6e59b1aa602336951e563b.png) **What is causing this data translation, and how do we keep our user-friendly pipeline and deal stage field names?** ---
**Author:** ![WendyGoh](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/wendygoh/32/42320_2.png) [@WendyGoh](https://community.hubspot.com/u/WendyGoh)\ **Post date:** [March 3, 2020, 3:50am UTC](https://community.hubspot.com/t/domo-api-integration-data-translation-issue/19161/2 "2020-03-03T03:50:26Z")
Hey @RachelAP, The values that you’re seeing on Domo end’s are the internal value of the deal stages: ![internalid.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/c/cb2d576517ce70a64edb2cb6657a3cd01308eb9d.png) If you hover over a particular deal stage, you would be able to see the internal Id, refer the above attached screenshot. If you’d like to modify the stageId of a stage, you can update the pipeline using the [CRM Pipelines API](https://developers.hubspot.com/docs/methods/pipelines/pipelines_overview). On the HubSpot app, you’ll only see the `label` and the stageId will always appears on the backend e.g. when pulling information via endpoint. ---
**Author:** ![RachelAP](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/rachelap/32/14279_2.png) [@RachelAP](https://community.hubspot.com/u/RachelAP)\ **Post date:** [March 3, 2020, 6:23pm UTC](https://community.hubspot.com/t/domo-api-integration-data-translation-issue/19161/3 "2020-03-03T18:23:06Z")
Thanks, Wendy! Wish there was a way to see the labels instead of the internal values easily. We can re-translate them individually in Domo… all 200+ of our custom deal stages. ![16x16_smiley-mad.png.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/9/984dd4a13c875f57cf235052147b60e9ed6c626c.png) ---
**Author:** ![RachelAP](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/rachelap/32/14279_2.png) [@RachelAP](https://community.hubspot.com/u/RachelAP)\ **Post date:** [March 3, 2020, 9:21pm UTC](https://community.hubspot.com/t/domo-api-integration-data-translation-issue/19161/4 "2020-03-03T21:21:05Z")
I am still looking for a solution to **convert the timestamps from the custom hs\_date\_entered fields (in the following screenshot) to regular datetime format**. ![](https://d2qpr2jzcazej7.cloudfront.net/original/3X/2/5/25f3e8e1d9b388cfb6368bfacafc74d29dd3a38b.png) ---
**Author:** ![WendyGoh](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/wendygoh/32/42320_2.png) [@WendyGoh](https://community.hubspot.com/u/WendyGoh)\ **Post date:** [March 4, 2020, 1:52am UTC](https://community.hubspot.com/t/domo-api-integration-data-translation-issue/19161/5 "2020-03-04T01:52:47Z")
Hey @RachelAP, Researching into this, I believe you can use the MySQL function - FROM\_UNIXTIME to convert epoch time to readable human date. Here’s the thread discussion that I referenced - [Home - Domo Community Forum](https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/How-do-I-convert-Epoch-time-eg-1493157531-to-Date/td-p/22254) Let me know if this helps! ---
**Author:** ![johnelmer](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/johnelmer/32/55984_2.png) [@johnelmer](https://community.hubspot.com/u/johnelmer)\ **Post date:** [February 16, 2021, 4:35pm UTC](https://community.hubspot.com/t/domo-api-integration-data-translation-issue/19161/6 "2021-02-16T16:35:28Z")
@RachelAP @WendyGoh I know this is an older thread, but if the free Domo integration isn’t working, this paid options might solve users who have experienced problems with it: [Domo Integration with HubSpot](https://app.hubspot.com/ecosystem/2756921/marketplace/apps/marketing/analytics-data/domo-integration-216219)