Bulk scheduling for datasets

ColemenWilson

We have some credentials that are no longer valid for reasons beyond our control. This is leading to 50 datasets failing every day until this is resolved. Anyone know of a way to perform a bulk action to disable all of these datasets until the credentials are fixed?

MarkSnodgrass

@ColemenWilson I wonder if you could use the Java CLI tool to change the schedule manual. That might be your closet way to do something in bulk.

ellibot

@ColemenWilson For only 50 datasets, it's probably not worth it to come up with a custom bulk scripting solution. If you find this is more of a persistent problem, yes you can definitely script against the undocumented [p]ublic APIs to change datasets to be manually updated (effectively disabling them)

You would need to send an API request to:

PUT https://{domo_instance}.com/api/data/v1/streams/{stream_id}

—data { "advancedScheduleJson": "{\"type\":\"MANUAL\",\"timezone\":\"UTC\"}"}

MarkSnodgrass

@ColemenWilson I wonder if you could use the Java CLI tool to change the schedule manual. That might be your closet way to do something in bulk.

ellibot

@ColemenWilson For only 50 datasets, it's probably not worth it to come up with a custom bulk scripting solution. If you find this is more of a persistent problem, yes you can definitely script against the undocumented [p]ublic APIs to change datasets to be manually updated (effectively disabling them)

You would need to send an API request to:

PUT https://{domo_instance}.com/api/data/v1/streams/{stream_id}

—data { "advancedScheduleJson": "{\"type\":\"MANUAL\",\"timezone\":\"UTC\"}"}