Use Airflow to schedule email for Looker dashboard error

[jchen-163302086]

[LookerSDK]Got some errors after adding more email recipients while it was working if sending to myself.

here are the error message in log:

[2022-12-14 18:04:22,544] {{logging_mixin.py:104}} INFO - Looker SDK 4.0 initialized successfully.
[2022-12-14 18:04:22,546] {{requests_transport.py:72}} INFO - POST(https://taskrabbit.looker.com:19999/api/4.0/login)
[2022-12-14 18:04:22,984] {{requests_transport.py:72}} INFO - POST(https://taskrabbit.looker.com:19999/api/4.0/scheduled_plans/run_once)
[2022-12-14 18:04:23,838] {{taskinstance.py:1482}} ERROR - Task failed with exception
Traceback (most recent call last):
  File "/usr/local/lib/python3.7/site-packages/airflow/models/taskinstance.py", line 1138, in _run_raw_task
    self._prepare_and_execute_task_with_callbacks(context, task)
  File "/usr/local/lib/python3.7/site-packages/airflow/models/taskinstance.py", line 1311, in _prepare_and_execute_task_with_callbacks
    result = self._execute_task(context, task_copy)
  File "/usr/local/lib/python3.7/site-packages/airflow/models/taskinstance.py", line 1341, in _execute_task
    result = task_copy.execute(context=context)
  File "/usr/local/lib/python3.7/site-packages/airflow/operators/python.py", line 117, in execute
    return_value = self.execute_callable()
  File "/usr/local/lib/python3.7/site-packages/airflow/operators/python.py", line 128, in execute_callable
    return self.python_callable(*self.op_args, **self.op_kwargs)
  File "/usr/local/airflow/dags/new_daily_email_data_check_dag.py", line 177, in daily_email_sending
    type = "email")]))
  File "/usr/local/airflow/.local/lib/python3.7/site-packages/looker_sdk/sdk/api40/methods.py", line 9542, in scheduled_plan_run_once
    transport_options=transport_options,
  File "/usr/local/airflow/.local/lib/python3.7/site-packages/looker_sdk/rtl/api_methods.py", line 174, in post
    return self._return(response, structure)
  File "/usr/local/airflow/.local/lib/python3.7/site-packages/looker_sdk/rtl/api_methods.py", line 87, in _return
    raise error.SDKError(response.value.decode(encoding=encoding))
looker_sdk.error.SDKError: {"message":"An error has occurred.","documentation_url":"https://docs.looker.com/r/err/4.0/500/post/scheduled_plans/run_once"}

Any help will be greatly appreciated!