More query params for ListDatasets

sebastian_galindo

Endpoint: https://api.domo.com/v1/datasets (GET)

As a data engineer, I am trying to programmatically list multiple datasets using specific parameters. When I use the UI, I have multiple filters such as Last Run, Type, Owned by, etc. However, the datasets API only supports 'namelike.'

It would be awesome if we can use the same filters that we have in the UI via API.

DomoDork

Hi @sebastian_galindo

There is an undocumented API endpoint you can hit to search/query datasets based on various criteria. I dont have a working example, but if you click on Data in the UI, right click to open the Inspector, go to network and spy on traffic, you will see that Domo hits the following API whenever you add a filter to search for specific criteria:

xxx.domo.com/api/search/v1/query

You can also take note of the payload Domo sends when hitting this API. You can use it to better understand what data you need to send to this endpoint to get the results your looking for. In my environment it looks like this:

I hope this helps!

ellibot

@sebastian_galindo take a look at this product API: https://documenter.getpostman.com/view/5049119/UyxbppB2#cd86f68d-fb2a-476b-a153-3e329e3d61c2

sebastian_galindo

@ellibot Thanks for your suggestion but it seems that I cannot generate a token for full authentication. I am using my client id and secret, is there something else I need to do to access this API?

ellibot

@sebastian_galindo since this is a product API (not a public API), you will need to authenticate with either a session token or developer token. Here’s a tutorial video on how to do that:

https://youtu.be/Qy0aXeJWSlI?si=IqSS8ywmyY8nnmDw