Ability to Edit Virtual Dataset Jobs

The ability to edit virtual dataset jobs would help a lot when working between production and sandbox environments. We would like to group our virtual dataset jobs by data domain, to help make sure we don't end up with duplicate datasets in our production environment. However if we create a new dataset we currently cannot add it to an existing virtual dataset job, and this increases our risk of duplication.
Comments
-
Absolutely - duplication is daunting.
0 -
I was playing around in the Product APIs and found that editing Virtual DataSet jobs is possible via the API, just not the UI.
1. Get the applications (different toolkits):GET https://<your_instance>.domo.com/api/executor/v1/applications
2. Use the application ID for the Virtual DataSets to get all the jobs:
GET https://<your_instance>.domo.com/api/executor/v2/applications/<application_id>/jobs?limit=100&offset=0
3. Get the job you want to update:
GET https://<your_instance>.domo.com/api/executor/v1/applications/<application_id>/jobs/<job_id>4. Update the job:
PUT https://<your_instance.domo.com/api/executor/v1/applications/<application_id>/jobs/<job_id>
For the body, use the response from the get job endpoint, but remove the properties executionState and shareState, and add or modify the objects in the array executionPayload.sharingRequests. You can find the filterGroupId by using the following endpoint:
GET https://<your_instance>.domo.com/api/query/v1/data-control/<dataset_id>/filter-groups?options=load_associations,include_open_policy,load_filters,sort
Authentication to the Product APIs is explained at the bottom of this page:Was this comment helpful? Click Agree or Like below.
Did this comment solve your problem? Accept it as the solution!0 -
@alexis_lundberg - @MichelleCCameronMYO - @brycec
Apologies for what might seem like silly questions, but I'm trying to get a solid understanding of our customers and their usage of virtualized datasets, along with any gaps they might have:
Do you use Governance Toolkit for your virtualized datasets? If not, what method do you use set them up? Brycec, I notice you're leveraging APIs, is that the only way you manage virtualized datasets?And for a thought experiment - If you imagine you're a Domo employee, and were tasked with creating the virutalized datasets feature - how would you design them? What would the user experience be? What are the biggest customer problems you would solve with virtualized datasets and how? Where would they live? Or any other things that jump out to you as you think of this.
Cadell Falconer
Principal Product Manager0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 307 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 112 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 790 Beast Mode
- 78 App Studio
- 43 Variables
- 745 Automate
- 187 Apps
- 475 APIs & Domo Developer
- 67 Workflows
- 16 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 139 Manage
- 136 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive