pyDOMO Create users based on existing dataset

cedvill00 · April 2021

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

cedvill00 · May 2021

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)

GrantSmith · April 2021

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 · May 2021

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)