pyDOMO Create users based on existing dataset

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

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)