Automating job creation in Workbench

loganherzog · 2021-05-11T15:29:17+00:00

There was an error rendering this rich post.

Hi all,

When my company opens new stores, there is a standard practice of creating 4 new particular jobs in Workbench. Am I able to utilize the Workbench SDK to do this? I cannot find any examples of using the SDK for something like this, and would appreciate any help.

Thanks!

Find more posts tagged with

Accepted answers

All comments

GrantSmith

Hi @loganherzog

You can't utilize the Workbench SDK (I'm assuming you mean the wb.exe executable) to automatically ingest jobs. You can use the UI to import jobs that were previously exported however you'd need to make sure your IDs are unique otherwise you might have two jobs overwriting the same dataset. You could utilize a scripting language (like Python) to automatically create the file in the JSON format it expects but you'd need to make sure that you've got the output dataset unset. You'd then need to go into the UI and create / tie the WB job to the dataset. You might be able to utilize the Domo API / Pydomo SDK to automatically create a new dataset , get the ID and then use that in your JSON file generation.

jaeW_at_Onyx

@loganherzog , thinking it through, is there a strong reason to set up 4 new jobs for one store? could you not just append more data to an existing dataset?

loganherzog

@jaeW_at_Onyx they are QuickBooks jobs meant to generate different accounting reports.

Thank you @GrantSmith , it sounds like what I'm trying to do isn't exactly accomplishable.