Laravel-datatables: Unexpected get json format from download excel and pdf yajra datatables

Created on 9 Oct 2020 · 2Comments · Source: yajra/laravel-datatables

Summary of problem or feature request

I've install datatable-button, all js, and all css but still get json format not download the pdf. The data can show, just cannot download the data

Code snippet of problem

Here is it my controller

return DataTables::of(Permission::query())
            ->addIndexColumn()
            ->addColumn('actions', function ($users) {
                return ActionHelper::showUpdateDeleteButton('superadmin.permissions', $users->id);
            })
            ->rawColumns(['actions'])
            ->make(true);

Here is it the js

$('#dataTable').DataTable({
                processing: true,
                serverSide: true,
                ajax: '{!! route('superadmin.permissions.datatable') !!}',
                columns: [
                    { data: 'DT_RowIndex', name: 'DT_RowIndex' , orderable: false, searchable: false},
                    { data: 'id', name: 'id' },
                    { data: 'name', name: 'name' },
                    { data: 'created_at', name: 'created_at' },
                    { data: 'updated_at', name: 'updated_at' },
                    { data: 'actions', name: 'actions' }
                ],
                dom: 'lBfrtip',
                buttons : [
                    {extend: 'colvis', postfixButtons: [ 'colvisRestore' ] },
                    {extend:'csv'},
                    {extend: 'pdf', title:'File PDF Datatables'},
                    {extend: 'excel', title: 'File Excel Datatables'},
                    {extend:'print',title: 'Print Datatables'},
                ]
            });