Gcp/Firebase/Authentication

authenticationのjsonエクスポート

npm install -g firebase-tools
firebase login
firebase auth:export account_file.json --format=JSON --project=[project1] # json出力の場合はこちら
firebase auth:export export-users.csv --format=CSV --project=[project1] # csv出力の場合はこちら

出力ファイル例：account_file.json

{"users": [
{
  "localId": "00017f8Daqdyxxxxxxxxxxxxxxxxx",
  "lastSignedInAt": "1730288278340",
  "createdAt": "1730288278340"
},
  "localId": "zzzrCWoliwU7dxxxxxxxxxxxxxxx",
  "lastSignedInAt": "1649335001653",
  "createdAt": "1649335001653"
}]}

phpでの処理例

$json_object = json_decode($user_json, true);
$users = $json_object['users'];
$ids = array_column($users, 'createdAt'); // createdAtのキー順にする
array_multisort($ids, SORT_ASC, $users);
foreach ($users as $key => $user) {
    echo $key . " ".print_r($user,1);
    if ($key > 100) {
        break;
    }
}

参考：https://blog.yuhiisk.com/archive/2018/08/22/export-firebase-auth-csv.html