disable_users_by_email.py

import argparse
import csv

import looker_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")


def disable_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)


def parse_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=",")

    for line in csv_reader:
        for user in sdk.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()