Domo API: Is it possible to get a json response when getting dataset's data ?

Hi Everyone,
I'm using Domo API to extract a dataset from Domo. It seems that the default response for "GET https://api.domo.com/v1/datasets/{DATASET_ID}/data" is a TEXT/CSV format.
I was trying "Accept: application/json" but I get an error. Looking at the documentation is something like this:
Accept: text/csv
Authorization: bearer <your-valid-oauth-access-token>
https://developer.domo.com/docs/dataset-api-reference/dataset#Export%20data%20from%20DataSet
Thanks,
Best Answer
-
Hello user08873,
Based on the way data is processed by our API, dataset exports are only available in a csv/text format. To convert the data to a json format you could use a parser in your script, but this would fall outside of the functionality of the API. There are many resources you can find online about parsing csv data to json, however, so this is not entirely out of the question if you are comfortable expanding your script beyond our API. Thank you!
Darius Rose
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Answers
-
Hello user08873,
Based on the way data is processed by our API, dataset exports are only available in a csv/text format. To convert the data to a json format you could use a parser in your script, but this would fall outside of the functionality of the API. There are many resources you can find online about parsing csv data to json, however, so this is not entirely out of the question if you are comfortable expanding your script beyond our API. Thank you!
Darius Rose
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Thanks Darious,
I just was wondering if it was possible to extract in json format. Text/CSV will do the trick for now.
Cheers,
Jose
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 666 Datasets
- 120 SQL DataFlows
- 2.3K Magic ETL
- 827 Beast Mode
- Visualize
- 2.6K Charting
- 90 App Studio
- 46 Variables
- Automate
- 198 Apps
- 489 APIs & Domo Developer
- 97 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 118 Domo Everywhere
- 284 Scheduled Reports
- 11 Software Integrations
- Manage
- 145 Governance & Security
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 117 Community Announcements
- 5K Archive