Adding and Removing Users from Datasets in Workflows

ssf24

I'm trying to change the the dataset owners of a list of datasets from their original owner to a single output owner. I have all the inputs on a flat file but and will use the loop over template but need help on the function to add dataset owners itself.

Do i create a dataset variable off of the dataset name or the dataset ID? Seems to be ID since that is unique, but there is no guidance there. When assigning a new user, do I use the user name or user ID? Can I add groups as owners instead of individual users?

Jtamedrano

addOwnsersToDataset seems to only supports user ids. The issue with removePersonFromDataset seems to be an issue with the package itself and an issue will be logged. Regarding support for groups, group support will need to be added to the Domo Package.

If you are in need of a quicker solution for group and are comfortable writing a code engine function, I would advise creating a custom package to add the group of your choice to a dataset. This would require an api call from the package.

POST - api/data/v2/datasources/{dataset_id}/responsibleUsers

Body - {responsibleGroupId: {group_id}}

I will pass along the suggestion for group support for dataset management.

Jtamedrano

You should use the dataset id and user id in your workflow. A group id can be assigned to a dataset, but use caution using a workflow to assign a group, especially if a function is expecting a user id.

ssf24

Thank you for the response. When adding a new owner, I am able to run this but only by selecting a person from a drop-down of Domo user names. When I try to define a variable with the group_id, the addOwnersToDataset package crashes and won't even allow me to define with a variable. It seems to allow for a list variable, but for the sake of this workflow, I'm trying to change owners to a single user or group id.

When using the removePersonFromDataset package and defining the user_id as a person, the workflow fails and leaves me with a long error code. Any suggestions?

Jtamedrano

addOwnsersToDataset seems to only supports user ids. The issue with removePersonFromDataset seems to be an issue with the package itself and an issue will be logged. Regarding support for groups, group support will need to be added to the Domo Package.

If you are in need of a quicker solution for group and are comfortable writing a code engine function, I would advise creating a custom package to add the group of your choice to a dataset. This would require an api call from the package.

POST - api/data/v2/datasources/{dataset_id}/responsibleUsers

Body - {responsibleGroupId: {group_id}}

I will pass along the suggestion for group support for dataset management.

ssf24

I can work around needing to assign a user rather than a group. What is the timeframe for resolving the package error from removePersonFromDataset (or Revoke DataSet Access which has the same issue)?

Jtamedrano

We have begun patching issues with removePersonFromData and implementing group support. The updates will be in the Domo DataSet Package 3.2.0. If you don't see this package or continue to have issues with the package, reach out to support.

ssf24

We've had a breakthrough here. The removePersonFromData function is failing because it can't remove the primary dataset owner, which is what I'm attempting to do. It can only remove co-owners. Our remedy is that we are going to assign a new primary owner in batches of 50 as that is the max. Then we will be able to remove the remaining co-owners and users.