Precision Loss With Dataset APIs
Hi folks, I'm hoping to get some pointers on getting precise decimal data while using the Dataset export API.
I ran a request to retrieve data for a dataset on my domo instance using the API docs and was able to get my file downloaded onto my notebook. However I'm noticing that the decimal fields seem to only be returning with 2 rounding digits. As a result I'm getting significantly less data when aggregating up for reporting. This is only happening to my metrics reporting in decimals - I'm able to get a match when the data type is integer or reporting in whole numbers.
I'm not seeing the same issue when I use the same dataset to create a card on Domo or when I manually export the data, and it's reporting the accurate figure for decimals.
Is there any workaround for this?
Best Answer
-
In your export, it might be affected by how you have configured the API, or how the data is stored in Domo's dataset. In the Admin > Toolkit there's a schema management tool for adjusting the data structure of a dataset. You may also consider using something like Python to perform your export. I use Python to export my data using scheduled tasks.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Answers
-
In your export, it might be affected by how you have configured the API, or how the data is stored in Domo's dataset. In the Admin > Toolkit there's a schema management tool for adjusting the data structure of a dataset. You may also consider using something like Python to perform your export. I use Python to export my data using scheduled tasks.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 559 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 574 Beast Mode
- 12 App Studio
- 28 Variables
- 582 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 26 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 355 Distribute
- 94 Domo Everywhere
- 259 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 89 Community Announcements
- 4.8K Archive