Laravel -如何使用Guzzle使用外部api并将其刷新为数据库

composer require guzzlehttp/guzzle

use GuzzleHttp\Client;

class ApiController extends Controller
{
    public function fetchAndStoreData()
    {
        // 创建一个Guzzle客户端实例
        $client = new Client();

        // 发送GET请求到外部API
        $response = $client->get('https://api.example.com/data');

        // 获取响应的JSON数据
        $data = json_decode($response->getBody(), true);

        // 将数据存储到数据库中
        foreach ($data as $item) {
            DB::table('table_name')->insert([
                'column1' => $item['value1'],
                'column2' => $item['value2'],
                // 其他列...
            ]);
        }

        return 'Data fetched and stored successfully.';
    }
}