my %slack_userid_to_real_name = ();
my %slack_userid_to_slack_name = ();
my %slack_userid_to_row = ();
-my %real_name_to_slack_userid = ();
$response = $ua->get('https://sheets.googleapis.com/v4/spreadsheets/' . $config::sheet_id . '?key=' . $config::gsheets_api_key . '&ranges=Slack-mapping!A5:C5000&fields=sheets/data/rowData/values/userEnteredValue',
Authorization => 'Bearer ' . $token
);
$slack_userid_to_slack_name{$slack_id} = $slack_name;
next if (!defined($real_name));
$slack_userid_to_real_name{$slack_id} = $real_name;
- $real_name_to_slack_userid{$real_name} = $slack_id;
}
# See which ones we don't have a mapping for, and look them up in Slack.