disable_users_by_email.py

importargparse
importcsv

importlooker_sdk

"""
The purpose of this script is to parse a CSV file containing a list of
emails separated by line breaks. If the email in the file corresponds
to an email in the Looker instance referred to in looker.ini, that user will
be automatically disabled.
"""


sdk=looker_sdk.init40("../../looker.ini")


defdisable_user(user):
print("Disabling user "+user.email+" with id "+str(user.id))
user.is_disabled=True
sdk.update_user(user_id=user.id, body=user)


defparse_csv():
f=open(
args.filename,
"r",
# the encoding may need to be updated depending on your file,
# see https://stackoverflow.com/a/17912811
encoding="utf-8-sig",
 )
csv_reader=csv.reader(f, delimiter=",")

forlineincsv_reader:
foruserinsdk.search_users(fields="id,email", email=line[0]):
disable_user(user)


if__name__=="__main__":
parser=argparse.ArgumentParser()
parser.add_argument(
"--filename",
help="The path to the CSV file containing a list of emails to disable.",
required=True,
 )
args=parser.parse_args()
parse_csv()