Get Records out of DataSet

I can access the DataSet using the DataSet API.

 

How do I get the data from the DataSet? Do I have to perform the CSV export?

I hope not, I just want to iterate over the data in the DataSet.

 

Here is my code:

 

ATSDomoCredentials domoCredentials = new ATSDomoCredentials();
DataSetClient dsClient = domoCredentials.domoClient.dataSetClient();
DataSet memberDataInDOMO = dsClient.get(DataSets.DATA_SET_ID)

System.out.println(memberDataInDOMO);

 

This code only provides info about the DataSet, columns names, number of rows, etc...:

 

name='SF', description='', rows=16199, columns=272, schema=Schema{columns=[Column{type=STRING, name='id'}, Column{type=STRING, name='NPINumber'},

 

How can I get the actual data?

Comments

  • Is anyone able to help out with this request?

  • Darius
    Darius Domo Employee

    Hello user08782,

     

    Data can be exported using the API, but all data returned is in a CSV format. Here is our reference for exporting data using the API:

     

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

     

    If you wish to do something else with the data, you can expand your script to parse the data from a CSV format into something else. Does this answer your question? If not, please provide additional information and any references in our documentation that you are using. 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"
This discussion has been closed.