DOMO CLI Interface Search/Filter

user09644 · 2021-02-26T19:18:38+00:00

There was an error rendering this rich post.

I'm trying to better understand how to use the Domo CLI, and have a few questions.

-Is there a way to search for all datasets/flow/cards whose name does not follow a defined convention? Ideally, I'd like to be able to utilize regex to search for patterns. Something like "list-dataset -n TEST%"

-When executing a search, is there a way to only return certain the ids based on defined attributes in the metadata? For example, I'd like to find all datasets who haven't updated in over a month. Or all datasets who are not connected to any cards.

Essentially, I'm exploring ways to more programmatically manage and administer data governance in our instance.

Thanks!

Find more posts tagged with

Accepted answers

All comments

MarkSnodgrass

Have you looked into the Domo Stats and Domo Governance datasets in the appstore? Many of these questions can be answered with these datasets and the Domo Stats quickstart will even build the cards for you that will answer these questions for you.

user09644

I guess that I could use the Domo Stats/Governance outputs to then generate the list of ids to tie to various actions that I want to take to update/delete/move/etc objects. I'm curious what the CLI was designed for? I figured something like this would be a good utilization of the tool.

MarkSnodgrass

I don't think the CLI tool was intended to be used as a reporting tool. I believe it was created as a quick way to perform some bulk actions, such as permissions, groups, etc... Here's a link to the KB article.

https://knowledge.domo.com/Administer/Other_Administrative_Tools/Command_Line_Interface_%28CLI%29_Tool

jaeW_at_Onyx

@user09644

you could use list-dataflows and output to a csv. then use any other scripting tool (python for example) to continue the automation process.

@MarkSnodgrass is correct, the CLI is mostly a wrapper for interacting with the APIs, the querying and automation part is the next mile which you'll pick up with Python, Node server or some other scripting environment.

here's a similar ish example using PyDomo (python sdk)

https://www.youtube.com/watch?v=oT5NipvWK1o