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:

 

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,

 

 

 

 

 

 

 

Best Answer

  • Darius
    Darius Domo Employee
    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"

Answers

  • Darius
    Darius Domo Employee
    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"
  • 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

This discussion has been closed.