pyDOMO Create users based on existing dataset

cedvill00 · 2021-04-30T08:03:38+00:00

There was an error rendering this rich post.

cedvill00

Hi,

Im trying to automate our creation of users and assign role dynamically based on our existing dataset in DOMO.

Im new to pyDOMO and currently following samples below:

user_list = pd.read_csv('UserList.csv')

def add_user_list(ul,domo_object,invite=False):

ur = CreateUserRequest()

users_created = []

for index, row in ul.iterrows():

ur.name = row['Full Name']

ur.email = row['Email']

ur.role = row['Role']

users_created.append(domo_object.users.create(ur,invite))

return(users_created)

created_users = add_user_list(user_list,domo)

It works well and however is there a way to loop the details in dataset and not in excel file?

Im currently exploring dataset.py but I dont know how to get the values for the columns, it only returns count

https://github.com/domoinc/domo-python-sdk/blob/master/examples/dataset.py

Find more posts tagged with

Developer

Accepted answers

cedvill00

Thanks! @GrantSmith Got it working.

heres my code for reference:

#check dataset based on specified dataset_id
retrieved_dataset = domo.datasets.get(dataset_id) 
#export data retrieved to a string
csv_download = datasets.data_export(retrieved_dataset['id'], include_csv_header) 
 #transform string to dataframe
user_list = pd.read_csv(StringIO(csv_download))

#loop within the user_list and read the fields and assign to DOMO objects.
def add_user_list(ul,domo_object,invite=False):
  ur = CreateUserRequest()
  users_created = []
  for index, row in ul.iterrows():
    ur.name = row['Employee Name']
    ur.email = row['Email']
    ur.role = 'Participant'
    users_created.append(domo_object.users.create(ur,invite))
  return(users_created)
created_users = add_user_list(user_list,domo)
all_users = domo.users.list(500,0)

All comments

GrantSmith

Hi @cedvill00

You'll want to look at the ds_query method to query domo datasets:

ds_query - allows you to send a query to a data set, Domo will evaluate that query and sends the results back as a list or a tibble

This will get you a result set as a dataframe to loop over like your existing method.

Alternatively you can use ds_data_export to export an entire dataset to an in-memory string and then user pd.read_csv to convert it to a dataframe and then use your existing looping methodology. There's an example on this way in their GitHub example: https://github.com/domoinc/domo-python-sdk/blob/master/examples/dataset.py#L48

cedvill00

Thanks! @GrantSmith Got it working.

heres my code for reference:

#check dataset based on specified dataset_id
retrieved_dataset = domo.datasets.get(dataset_id) 
#export data retrieved to a string
csv_download = datasets.data_export(retrieved_dataset['id'], include_csv_header) 
 #transform string to dataframe
user_list = pd.read_csv(StringIO(csv_download))

#loop within the user_list and read the fields and assign to DOMO objects.
def add_user_list(ul,domo_object,invite=False):
  ur = CreateUserRequest()
  users_created = []
  for index, row in ul.iterrows():
    ur.name = row['Employee Name']
    ur.email = row['Email']
    ur.role = 'Participant'
    users_created.append(domo_object.users.create(ur,invite))
  return(users_created)
created_users = add_user_list(user_list,domo)
all_users = domo.users.list(500,0)

cedvill00

Hi @GrantSmith

Just want to get back here instead of posting a new question.

Maybe you know the answer.

Im trying to create a user based on our custom made role.

Now , CreateUserRequest() of domo only accepts role that are defaults eg Privilege, Admin, Participant.

When I assign a different role, a role that we created, it wont accept it.

It returns error.

GrantSmith

Have you tried passing in the id of your custom role instead of the string name?

jaeW_at_Onyx

Have you seen the content from DP21 on using PyDomo?

https://www.domo.com/domopalooza/resources/managing-users-groups-with-pydomo

https://www.domo.com/domopalooza/resources#/all/all/data-governance/all/all/2021

cedvill00

Hi @GrantSmith,

I tried passing roleid in role already, doesn't work.

I also checked the acceptable attr, it only accepts name, email and role, no roleid.

Also for any custom made roles, the names are coming as blank for the existing users (manually created).

Compared to the ones that are domo roles.

Thanks @jaeW_at_Onyx for the reference.

that is where I got the code :)