Automating job creation in Workbench

loganherzog
loganherzog βšͺ️

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!

Answers

  • GrantSmith
    GrantSmith Indiana πŸ”΄

    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
    jaeW_at_Onyx Budapest / Portland, OR 🟀

    @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
    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.