FilamentF
Filament•2y ago
Lucky0

External API CRUD in Filament

I am using "https://github.com/kawax/laravel-google-sheets" and "https://github.com/calebporzio/sushi". At the moment I can fetch the data from google sheets.
I followed these two source "https://laraveldaily.com/post/filament-load-table-data-from-3rd-party-api" and "https://filamentphp.com/community/how-to-consume-an-external-api-with-filament-tables". I could not find any other reference for update, create and delete. Is it possible to do this in filament? do I need to create custom livewire class?

currently I have this for retrieving the data from google sheets

namespace App\Models\Sheets;

use Revolution\Google\Sheets\Facades\Sheets;
use Illuminate\Database\Eloquent\Model;
use Sushi\Sushi;

class User extends Model
{
    use Sushi;

    protected $guarded = [
        'id',
    ];

    public function getRows(): array
    {
        $rows = Sheets::spreadsheet(config('google.sheets_api'))->sheet('sheet1')->get();

        $header = $rows->pull(0);
        $values = Sheets::collection(header: $header, rows: $rows);

        $data = array_values($values->map(function ($row) {
            return collect($row)->mapWithKeys(function ($value, $key) {
                if (in_array($key, ['id', 'age'])) {
                    return [$key => intval($value)];
                }
                return [$key => $value];
            });
        })->toArray());

        return $data;
    }

}
Was this page helpful?