# %pip install --upgrade domolibraryTutorial Update Users
Python
DomoJupyter
DomoUser
# import domolibrary
# domolibrary.__version__0. Get Sample Data and generate auth object
import csv
import pandas as pd
with open("dataset.csv", "r", encoding="utf-8-sig") as file:
csv_reader = csv.DictReader(file)
data = [row for row in csv_reader]
for obj in data:
obj.update(
{
"email": obj["email"].replace(" ", ""),
"manager_email": obj["manager_email"].replace(" ", ""),
},
) # clean sample dataset so email is a valid email
pd.DataFrame(data)[0:5]| Role | FranchiseID | StoreID | EmpID | manager_email | ||
|---|---|---|---|---|---|---|
| 0 | CEO1@fz.com | CEO | 0 | 0 | 1 | jae@datacrew.space |
| 1 | Owner2@fz.com | Owner | 1 | 2 | 2 | CEO1@fz.com |
| 2 | RestaurantManager3@fz.com | Restaurant Manager | 1 | 24 | 3 | Owner2@fz.com |
| 3 | RestaurantManager4@fz.com | Restaurant Manager | 1 | 7 | 4 | Owner2@fz.com |
| 4 | RestaurantManager5@fz.com | Restaurant Manager | 1 | 11 | 5 | Owner2@fz.com |
import os
import domolibrary.client.DomoAuth as dmda
token_auth = dmda.DomoTokenAuth(
domo_instance=os.environ['DOMO_INSTANCE'],
domo_access_token=os.environ["DOMO_ACCESS_TOKEN"],
)1. Create Custom Attributes in Domo Instance Config
User attributes, will be custom properties that we can manage and use to create dynamic pdp policies and groups
- First we parse the CSV to identify new properties to create
properties_to_create = list(
set(
[
key
for obj in data
for key in obj.keys()
if key.lower() not in ["email", "manager_email", "empid", "role"]
]
)
)
properties_to_create['StoreID', 'FranchiseID']import domolibrary.client.DomoAuth as dmda
import domolibrary.classes.DomoInstanceConfig as dmic
import domolibrary.classes.DomoInstanceConfig_UserAttribute as dmua
import domolibrary.utils.chunk_execution as ce
from typing import List
async def upsert_property(domo_config, property_name: str):
"""will create a custom property in Domo"""
return await domo_config.UserAttributes.upsert(
attribute_id=f"fz{property_name}",
name=property_name,
description="FZ_POC",
debug_api=False,
debug_prn=False,
)
async def upsert_properties(
property_ls: List[str], auth: dmda.DomoAuth # list of property names to create
):
"""will create a list of custom properties from a provided list of property names"""
domo_config = dmic.DomoInstanceConfig(auth=auth)
return await ce.gather_with_concurrency(
*[upsert_property(domo_config, property_name) for property_name in property_ls],
n=10,
)
await upsert_properties(properties_to_create, auth=token_auth)[UserAttribute(id='fzStoreID', name='StoreID', description='FZ_POC', issuer_type=<UserAttributes_IssuerType.CUSTOM: 'customer-defined'>, customer_id='mmmm-0012-0200', value_type='STRING', validator='ANY_VALUE', validator_configuration=None, security_voter='FULL_VIS_ADMIN_IDP', custom=True),
UserAttribute(id='fzFranchiseID', name='FranchiseID', description='FZ_POC', issuer_type=<UserAttributes_IssuerType.CUSTOM: 'customer-defined'>, customer_id='mmmm-0012-0200', value_type='STRING', validator='ANY_VALUE', validator_configuration=None, security_voter='FULL_VIS_ADMIN_IDP', custom=True)]validate that custom properties have been created
- The
DomoInstanceConfigclass has a propertyuser_attributesthat can be used to interact with all user attributes (including standard Domo Attributes, IDP created attributes, and custom attributes)
async def get_custom_properties(
auth: dmda.DomoAuth, prop_prefix: str, return_all: bool = False
):
domo_config = dmic.DomoInstanceConfig(auth=auth)
props = await domo_config.UserAttributes.get()
if return_all:
return props
return [prop for prop in props if prop.id.startswith(prop_prefix)]
await get_custom_properties(auth=token_auth, prop_prefix="fz", return_all=False)[UserAttribute(id='fzManagerEmail', name='ManagerEmail', description='FZ_POC', issuer_type=<UserAttributes_IssuerType.CUSTOM: 'customer-defined'>, customer_id='mmmm-0012-0200', value_type='STRING', validator='ANY_VALUE', validator_configuration=None, security_voter='FULL_VIS_ADMIN_IDP', custom=True),
UserAttribute(id='fzFranchiseID', name='FranchiseID', description='FZ_POC', issuer_type=<UserAttributes_IssuerType.CUSTOM: 'customer-defined'>, customer_id='mmmm-0012-0200', value_type='STRING', validator='ANY_VALUE', validator_configuration=None, security_voter='FULL_VIS_ADMIN_IDP', custom=True),
UserAttribute(id='fzStoreID', name='StoreID', description='FZ_POC', issuer_type=<UserAttributes_IssuerType.CUSTOM: 'customer-defined'>, customer_id='mmmm-0012-0200', value_type='STRING', validator='ANY_VALUE', validator_configuration=None, security_voter='FULL_VIS_ADMIN_IDP', custom=True)]2. Extend User Properties
- the UserProperty_Type enum from domolibrary has a list of standard user properties.
- extend the
UserProperty_Typeenum with the newly created user attributes
NOTE: UserProperty_Type and the idea of a custom attribute are duplicate and in a later implementation of DomoLibrary might be rolled into one class.
For the time being, first you create the custom property, then you use UserProperty to update the DomoUser class
# %pip install aenumfrom domolibrary.classes.DomoUser import UserProperty, UserProperty_Type
from pprint import pprint
# predefined properties we can update
# if a custom property hasn't been added we'll extended it with the aenum library
pprint(
{
"pedefined_properties": [
{member.name: member.value} for member in UserProperty_Type
]
}
){'pedefined_properties': [{'display_name': 'displayName'},
{'email_address': 'emailAddress'},
{'phone_number': 'phoneNumber'},
{'title': 'title'},
{'department': 'department'},
{'web_landing_page': 'webLandingPage'},
{'web_mobile_landing_page': 'webMobileLandingPage'},
{'role_id': 'roleId'},
{'employee_id': 'employeeId'},
{'employee_number': 'employeeNumber'},
{'hire_date': 'hireDate'},
{'reports_to': 'reportsTo'}]}from aenum import extend_enum # use aenum to extend an existing enum
if "fzFranchiseID" not in UserProperty_Type.__members__:
extend_enum(UserProperty_Type, "fzFranchiseID", "fzFranchiseID")
if "fzStoreID" not in UserProperty_Type.__members__:
extend_enum(UserProperty_Type, "fzStoreID", "fzStoreID")
# validate properties have been extended
pprint(
{
"pedefined_properties": [
{member.name: member.value} for member in UserProperty_Type
]
}
){'pedefined_properties': [{'display_name': 'displayName'},
{'email_address': 'emailAddress'},
{'phone_number': 'phoneNumber'},
{'title': 'title'},
{'department': 'department'},
{'web_landing_page': 'webLandingPage'},
{'web_mobile_landing_page': 'webMobileLandingPage'},
{'role_id': 'roleId'},
{'employee_id': 'employeeId'},
{'employee_number': 'employeeNumber'},
{'hire_date': 'hireDate'},
{'reports_to': 'reportsTo'},
{'fzFranchiseID': 'fzFranchiseID'},
{'fzStoreID': 'fzStoreID'}]}At this point the custom properties should have been added to the UserProperty_Type enum and can be used to upgrade domousers
test_user = data[0]
test_user{'email': 'CEO1@fz.com',
'Role': 'CEO',
'FranchiseID': '0',
'StoreID': '0',
'EmpID': '1',
'manager_email': 'jae@datacrew.space'}import domolibrary.classes.DomoUser as dmdu
async def create_user_property(
franchise_id, store_id, employee_id, manager_email, auth: dmda.DomoAuth
):
"""creates a property that can be passed to DomoUser class to update a property in Domo"""
manager = await dmdu.DomoUsers.by_email(
email_ls=[manager_email], only_allow_one=False, auth=auth
)
manager = manager[0]
print(manager.email_address)
assert manager
return [
UserProperty(UserProperty_Type.fzFranchiseID, franchise_id),
UserProperty(UserProperty_Type.fzStoreID, store_id),
UserProperty(UserProperty_Type.employee_number, employee_id),
UserProperty(UserProperty_Type.reports_to, manager.id),
]
test_property = await create_user_property(
franchise_id=test_user["FranchiseID"],
store_id=test_user["StoreID"],
employee_id=test_user["EmpID"],
manager_email=test_user["manager_email"],
auth=token_auth,
)
[prop.to_json() for prop in test_property]jae@datacrew.space[{'key': 'fzFranchiseID', 'values': ['0']},
{'key': 'fzStoreID', 'values': ['0']},
{'key': 'employeeNumber', 'values': ['1']},
{'key': 'reportsTo', 'values': ['1893952720']}]3. create / upsert users with custom properties
- first we will create the user then update the properties
import domolibrary.classes.DomoUser as dmdu
import asyncio
async def upsert_user(
email,
role_id,
franchise_id,
store_id,
employee_id,
manager_email,
auth: dmda.DomoAuth,
display_name=None,
):
"""upsert a user by email, then updates properties franchise_id and role_id"""
domo_user = await dmdu.DomoUsers.upsert_user(
email_address=email,
display_name=display_name or f"fz_{email}",
role_id=role_id,
auth=auth,
debug_api=False,
)
property_ls = await create_user_property(
franchise_id=franchise_id,
store_id=store_id,
employee_id=employee_id,
manager_email=manager_email,
auth=auth,
)
try:
await asyncio.sleep(4)
await domo_user.update_properties(property_ls)
except Exception as e:
print(e)
return domo_user
print(test_user)
print("\n")
domo_user = await upsert_user(
email=test_user["email"],
role_id=5,
franchise_id=test_user["FranchiseID"],
store_id=test_user["StoreID"],
employee_id=test_user["EmpID"],
manager_email=test_user["manager_email"],
auth=token_auth,
)
## this view of the user will not reflect the updated attribtues, as the get_by_id() API does not retrieve custom attributes
# instead you have to use the Query API to search the datacenter for full details
pprint(domo_user){'email': 'CEO1@fz.com', 'Role': 'CEO', 'FranchiseID': '0', 'StoreID': '0', 'EmpID': '1', 'manager_email': 'jae@datacrew.space'}
jae@datacrew.space
DomoUser(id='1957334859',
display_name='fz_CEO1@fz.com',
email_address='CEO1@fz.com',
role_id=5,
department=None,
title=None,
avatar_key='/api/content/v1/avatar/USER/1957334859',
phone_number=None,
web_landing_page=None,
web_mobile_landing_page=None,
employee_id=None,
employee_number='1',
hire_date=None,
reports_to='1893952720',
publisher_domain=None,
subscriber_domain=None,
virtual_user_id=None,
created_dt=datetime.datetime(2024, 1, 3, 5, 7, 13),
last_activity_dt=datetime.datetime(2024, 1, 22, 20, 41, 41, 579000),
custom_attributes={},
role=DomoRole(id=5,
name='Social',
description='Access limited to social features',
is_system_role=True,
is_default_role=None,
grants=[],
membership_ls=[]),
domo_api_clients=None,
domo_access_tokens=None)await ce.gather_with_concurrency(
*[
upsert_user(
email=user_obj["email"],
role_id=5,
franchise_id=user_obj["FranchiseID"],
store_id=user_obj["StoreID"],
employee_id=user_obj["EmpID"],
manager_email=user_obj["manager_email"],
auth=token_auth,
)
for user_obj in data
],
n=10
)CEO1@fz.com
Owner2@fz.com
jae@datacrew.space
Owner2@fz.com
Owner2@fz.com
Owner7@fz.com
Owner2@fz.com
Owner7@fz.com
Owner7@fz.com
CEO1@fz.com
Owner12@fz.com
Owner7@fz.com
CEO1@fz.com
Owner12@fz.com
Owner12@fz.com
Owner12@fz.com
Owner12@fz.com[DomoUser(id='1957334859', display_name='fz_CEO1@fz.com', email_address='CEO1@fz.com', role_id=5, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/1957334859', phone_number=None, web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number='1', hire_date=None, reports_to='1893952720', publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2024, 1, 3, 5, 7, 13), last_activity_dt=datetime.datetime(2024, 1, 22, 20, 41, 41, 579000), custom_attributes={}, role=DomoRole(id=5, name='Social', description='Access limited to social features', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None),
DomoUser(id='370513898', display_name='fz_Owner2@fz.com', email_address='Owner2@fz.com', role_id=5, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/370513898', phone_number=None, web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number='2', hire_date=None, reports_to='1957334859', publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2024, 1, 3, 5, 7, 13), last_activity_dt=datetime.datetime(2024, 1, 22, 20, 41, 53, 492000), custom_attributes={}, role=DomoRole(id=5, name='Social', description='Access limited to social features', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None),
DomoUser(id='67322960', display_name='fz_RestaurantManager3@fz.com', email_address='RestaurantManager3@fz.com', role_id=5, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/67322960', phone_number=None, web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number='3', hire_date=None, reports_to='370513898', publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2024, 1, 3, 5, 32, 49), last_activity_dt=datetime.datetime(2024, 1, 22, 20, 42, 49, 985000), custom_attributes={}, role=DomoRole(id=5, name='Social', description='Access limited to social features', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None),
DomoUser(id='1908234603', display_name='fz_RestaurantManager4@fz.com', email_address='RestaurantManager4@fz.com', role_id=5, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/1908234603', phone_number=None, web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number='4', hire_date=None, reports_to='370513898', publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2024, 1, 3, 5, 32, 49), last_activity_dt=datetime.datetime(2024, 1, 22, 20, 42, 55, 552000), custom_attributes={}, role=DomoRole(id=5, name='Social', description='Access limited to social features', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None),
DomoUser(id='1545439064', display_name='fz_RestaurantManager5@fz.com', email_address='RestaurantManager5@fz.com', role_id=5, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/1545439064', phone_number=None, web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number='5', hire_date=None, reports_to='370513898', publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2024, 1, 3, 5, 32, 49), last_activity_dt=datetime.datetime(2024, 1, 22, 20, 43, 1, 915000), custom_attributes={}, role=DomoRole(id=5, name='Social', description='Access limited to social features', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None),
DomoUser(id='1653650421', display_name='fz_RestaurantManager6@fz.com', email_address='RestaurantManager6@fz.com', role_id=5, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/1653650421', phone_number=None, web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number='6', hire_date=None, reports_to='370513898', publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2024, 1, 3, 5, 32, 49), last_activity_dt=datetime.datetime(2024, 1, 22, 20, 43, 8, 208000), custom_attributes={}, role=DomoRole(id=5, name='Social', description='Access limited to social features', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None),
DomoUser(id='582688310', display_name='fz_Owner7@fz.com', email_address='Owner7@fz.com', role_id=5, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/582688310', phone_number=None, web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number='7', hire_date=None, reports_to='1957334859', publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2024, 1, 3, 5, 7, 14), last_activity_dt=datetime.datetime(2024, 1, 22, 20, 41, 59, 976000), custom_attributes={}, role=DomoRole(id=5, name='Social', description='Access limited to social features', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None),
DomoUser(id='470456174', display_name='fz_RestaurantManager8@fz.com', email_address='RestaurantManager8@fz.com', role_id=5, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/470456174', phone_number=None, web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number='8', hire_date=None, reports_to='582688310', publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2024, 1, 3, 5, 32, 50), last_activity_dt=datetime.datetime(2024, 1, 22, 20, 43, 13, 696000), custom_attributes={}, role=DomoRole(id=5, name='Social', description='Access limited to social features', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None),
DomoUser(id='2017773233', display_name='fz_RestaurantManager9@fz.com', email_address='RestaurantManager9@fz.com', role_id=5, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/2017773233', phone_number=None, web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number='9', hire_date=None, reports_to='582688310', publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2024, 1, 3, 5, 32, 51), last_activity_dt=datetime.datetime(2024, 1, 22, 20, 43, 20, 708000), custom_attributes={}, role=DomoRole(id=5, name='Social', description='Access limited to social features', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None),
DomoUser(id='1835516806', display_name='fz_RestaurantManager10@fz.com', email_address='RestaurantManager10@fz.com', role_id=5, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/1835516806', phone_number=None, web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number='10', hire_date=None, reports_to='582688310', publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2024, 1, 3, 5, 32, 51), last_activity_dt=datetime.datetime(2024, 1, 22, 20, 42, 7, 589000), custom_attributes={}, role=DomoRole(id=5, name='Social', description='Access limited to social features', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None),
DomoUser(id='857242114', display_name='fz_RestaurantManager11@fz.com', email_address='RestaurantManager11@fz.com', role_id=5, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/857242114', phone_number=None, web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number='11', hire_date=None, reports_to='582688310', publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2024, 1, 3, 5, 32, 51), last_activity_dt=datetime.datetime(2024, 1, 22, 20, 42, 12, 995000), custom_attributes={}, role=DomoRole(id=5, name='Social', description='Access limited to social features', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None),
DomoUser(id='1967686990', display_name='fz_Owner12@fz.com', email_address='Owner12@fz.com', role_id=5, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/1967686990', phone_number=None, web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number='12', hire_date=None, reports_to='1957334859', publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2024, 1, 3, 5, 7, 14), last_activity_dt=datetime.datetime(2024, 1, 22, 20, 41, 47, 704000), custom_attributes={}, role=DomoRole(id=5, name='Social', description='Access limited to social features', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None),
DomoUser(id='694066152', display_name='fz_RestaurantManager13@fz.com', email_address='RestaurantManager13@fz.com', role_id=5, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/694066152', phone_number=None, web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number='13', hire_date=None, reports_to='1967686990', publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2024, 1, 3, 5, 32, 51), last_activity_dt=datetime.datetime(2024, 1, 22, 20, 42, 19, 676000), custom_attributes={}, role=DomoRole(id=5, name='Social', description='Access limited to social features', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None),
DomoUser(id='1009228622', display_name='fz_RestaurantManager14@fz.com', email_address='RestaurantManager14@fz.com', role_id=5, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/1009228622', phone_number=None, web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number='14', hire_date=None, reports_to='1967686990', publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2024, 1, 3, 5, 32, 52), last_activity_dt=datetime.datetime(2024, 1, 22, 20, 42, 26, 290000), custom_attributes={}, role=DomoRole(id=5, name='Social', description='Access limited to social features', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None),
DomoUser(id='1831527649', display_name='fz_RestaurantManager15@fz.com', email_address='RestaurantManager15@fz.com', role_id=5, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/1831527649', phone_number=None, web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number='15', hire_date=None, reports_to='1967686990', publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2024, 1, 3, 5, 32, 52), last_activity_dt=datetime.datetime(2024, 1, 22, 20, 42, 32, 99000), custom_attributes={}, role=DomoRole(id=5, name='Social', description='Access limited to social features', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None),
DomoUser(id='1571557745', display_name='fz_RestaurantManager16@fz.com', email_address='RestaurantManager16@fz.com', role_id=5, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/1571557745', phone_number=None, web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number='16', hire_date=None, reports_to='1967686990', publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2024, 1, 3, 5, 32, 52), last_activity_dt=datetime.datetime(2024, 1, 22, 20, 42, 38, 419000), custom_attributes={}, role=DomoRole(id=5, name='Social', description='Access limited to social features', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None),
DomoUser(id='1957552134', display_name='fz_RestaurantManager17@fz.com', email_address='RestaurantManager17@fz.com', role_id=5, department=None, title=None, avatar_key='/api/content/v1/avatar/USER/1957552134', phone_number=None, web_landing_page=None, web_mobile_landing_page=None, employee_id=None, employee_number='17', hire_date=None, reports_to='1967686990', publisher_domain=None, subscriber_domain=None, virtual_user_id=None, created_dt=datetime.datetime(2024, 1, 3, 5, 32, 52), last_activity_dt=datetime.datetime(2024, 1, 22, 20, 42, 44, 791000), custom_attributes={}, role=DomoRole(id=5, name='Social', description='Access limited to social features', is_system_role=True, is_default_role=None, grants=[], membership_ls=[]), domo_api_clients=None, domo_access_tokens=None)]for user_obj in data:
print(user_obj)
await upsert_user(
email=user_obj["email"],
role_id=5,
franchise_id=user_obj["FranchiseID"],
store_id=user_obj["StoreID"],
employee_id=user_obj["EmpID"],
manager_email=user_obj["manager_email"],
auth=token_auth,
){'email': 'CEO1@fz.com', 'Role': 'CEO', 'FranchiseID': '0', 'StoreID': '0', 'EmpID': '1', 'manager_email': 'jae@datacrew.space'}
jae@datacrew.space
{'email': 'Owner2@fz.com', 'Role': 'Owner', 'FranchiseID': '1', 'StoreID': '2', 'EmpID': '2', 'manager_email': 'CEO1@fz.com'}
CEO1@fz.com
{'email': 'RestaurantManager3@fz.com', 'Role': 'Restaurant Manager', 'FranchiseID': '1', 'StoreID': '24', 'EmpID': '3', 'manager_email': 'Owner2@fz.com'}
Owner2@fz.com
{'email': 'RestaurantManager4@fz.com', 'Role': 'Restaurant Manager', 'FranchiseID': '1', 'StoreID': '7', 'EmpID': '4', 'manager_email': 'Owner2@fz.com'}
Owner2@fz.com
{'email': 'RestaurantManager5@fz.com', 'Role': 'Restaurant Manager', 'FranchiseID': '1', 'StoreID': '11', 'EmpID': '5', 'manager_email': 'Owner2@fz.com'}
Owner2@fz.com
{'email': 'RestaurantManager6@fz.com', 'Role': 'Restaurant Manager', 'FranchiseID': '1', 'StoreID': '8', 'EmpID': '6', 'manager_email': 'Owner2@fz.com'}
Owner2@fz.com
{'email': 'Owner7@fz.com', 'Role': 'Owner', 'FranchiseID': '2', 'StoreID': '', 'EmpID': '7', 'manager_email': 'CEO1@fz.com'}
CEO1@fz.com
{'email': 'RestaurantManager8@fz.com', 'Role': 'Restaurant Manager', 'FranchiseID': '2', 'StoreID': '35', 'EmpID': '8', 'manager_email': 'Owner7@fz.com'}
Owner7@fz.com
{'email': 'RestaurantManager9@fz.com', 'Role': 'Restaurant Manager', 'FranchiseID': '2', 'StoreID': '9', 'EmpID': '9', 'manager_email': 'Owner7@fz.com'}
Owner7@fz.com
{'email': 'RestaurantManager10@fz.com', 'Role': 'Restaurant Manager', 'FranchiseID': '2', 'StoreID': '4', 'EmpID': '10', 'manager_email': 'Owner7@fz.com'}
Owner7@fz.com
{'email': 'RestaurantManager11@fz.com', 'Role': 'Restaurant Manager', 'FranchiseID': '2', 'StoreID': '27', 'EmpID': '11', 'manager_email': 'Owner7@fz.com'}
Owner7@fz.com
{'email': 'Owner12@fz.com', 'Role': 'Owner', 'FranchiseID': '3', 'StoreID': '', 'EmpID': '12', 'manager_email': 'CEO1@fz.com'}
CEO1@fz.com
{'email': 'RestaurantManager13@fz.com', 'Role': 'Restaurant Manager', 'FranchiseID': '3', 'StoreID': '50', 'EmpID': '13', 'manager_email': 'Owner12@fz.com'}
Owner12@fz.com
{'email': 'RestaurantManager14@fz.com', 'Role': 'Restaurant Manager', 'FranchiseID': '3', 'StoreID': '64', 'EmpID': '14', 'manager_email': 'Owner12@fz.com'}
Owner12@fz.com
{'email': 'RestaurantManager15@fz.com', 'Role': 'Restaurant Manager', 'FranchiseID': '3', 'StoreID': '29', 'EmpID': '15', 'manager_email': 'Owner12@fz.com'}
Owner12@fz.com
{'email': 'RestaurantManager16@fz.com', 'Role': 'Restaurant Manager', 'FranchiseID': '3', 'StoreID': '22', 'EmpID': '16', 'manager_email': 'Owner12@fz.com'}
Owner12@fz.com
{'email': 'RestaurantManager17@fz.com', 'Role': 'Restaurant Manager', 'FranchiseID': '3', 'StoreID': '18', 'EmpID': '17', 'manager_email': 'Owner12@fz.com'}
Owner12@fz.com