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

user08873

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:

 

GET https://api.domo.com/v1/datasets/317970a1-6a6e-4f70-8e09-44cf5f34cf44/data?includeHeader=true&fileName=data-dump.csv

Accept: text/csv

Authorization: bearer <your-valid-oauth-access-token>

 

https://developer.domo.com/docs/dataset-api-reference/dataset#Export%20data%20from%20DataSet

 

 Thanks,

 

 

 

 

 

 

 

Darius

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

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!

user08873

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