how to access time stamp in api controller for pivot table

As the title for the question says, How can i access the timestamp for a pivot table.

My model for user:

public function histories() {
        return $this->belongsToMany(UserFeed::class, 'histories')->withTimestamps();
    }

API Call controller :

$records = Auth::user()
            	->histories()
		->latest()
		->paginate(config("app.rec_limit"));

But I cannot either see the pivot table nor the timestamp data for the records been fetched !

what I get is only history records and nothing else.

Level 88

The data should be available under the pivot key of the History model.

@foreach ($records as $record)

    {{ $record->pivot->created_at }}

@endforeach

If you want to convert these fields to Carbon objects automatically, you can create a pivot model. You can read more about it here: https://laravel.com/docs/8.x/eloquent-relationships#defining-custom-intermediate-table-models

1 like

Level 3

I clearly said I need it in api controller so the data needs to be part of api json output

anyways the issue is solved.

Please or to participate in this conversation.