How to filter Data to be displayed in an api call

@princeoo7 if you want to transform the output of a query before presenting it to the view, then you should look at API Resources

https://laravel.com/docs/8.x/eloquent-resources#introduction

This will allow you to prepare the output for your json.

eg:

<?php

namespace App\Http\Resources;

use Illuminate\Http\Resources\Json\JsonResource;

class User extends JsonResource
{
    /**
     * Transform the resource into an array.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return array
     */
    public function toArray($request)
    {
        return [
            'id' => $this->id,
            'name' => $this->name,
            'email' => $this->email,
            'created_at' => $this->created_at,
            'updated_at' => $this->updated_at,
        ];
    }
}

see https://laravel.com/docs/8.x/eloquent-resources#concept-overview

so in your case, your toArray method may look like:

 public function toArray($request)
    {
        return [
            'id' => $this->id,
            'title' => $this->title,
            'slug' => $this->slug,
            'created_at' => $this->created_at,
            'updated_at' => $this->updated_at,
	    'attributes' => $this->attributes
        ];
    }

Can you make an example based on my code ?

I got this when I tried to do the given:

Exception
Property [id] does not exist on this collection instance. 

I added below then I got the output but only one record:

public function toArray($request)
    {
        // return parent::toArray($request);
        return [
            "id" => $this[0]->id,
            "title" => $this[0]->title,
            "slug" => $this[0]->slug,
            "attributes" => $this[0]->attributes,
            "created_at" => $this[0]->created_at,
            "updated_at" => $this[0]->updated_at,
        ];
    }

How I called it in my controller:

public function index(Request $request) {
        return new ProductResource(Product::latest()->limit(2)->get());
    }

UPDATE:

got it working with below code:

public function index(Request $request) {
        return ProductResource::collection(Product::latest()->limit(2)->get());
    }

and removing the key form the return in resources.

Now the issue is in ProductAttributeResource where I am not able to access attribute_values.

return [
            "name" => $this->name,
            "value" => $this->attribute_values->value,
        ];

@princeoo7 you'll probably have to create a resource collection for those too.

or

 $this->attribute_values()->pluck('value'),

// not sure if you need the brackets on attribute_values() here or not. please let me know which works and i'll update my message

@automica I am getting null as that is also a relationship based value.

but if I do return parent::toArray($request) in ProductAttributeResource I get the below answer:

0	
- name	"color"
- attribute_values	
- value	"#b82e1c, #e8d984, #148bc4, #fbc33a, #0f6c54"

if I do :

return [
            "name" => $this->name,
            "value" => $this->attribute_values,
        ];

I get below output:

0	
name	"color"
value	null

so the value is null for $this->attribute_values.

Now If I do :

"value" => ProductAttributeValue::where("id", $this->id)->first()->value,

Then only I get the desired output:

{"data":[{"id":1,"title":"Enim illo aut.","slug":"enim-illo-aut.","attributes":[{"name":"color","value":"#b82e1c, #e8d984, #148bc4, #fbc33a, #0f6c54"},{"name":"size","value":"6, 7, 8, 9, 10, 11, 12"},{"name":"brand","value":"34"},{"name":"description","value":"Sit totam quos nobis sed. Sit nulla accusamus laudantium voluptatibus error. Autem deserunt aspernatur ex et saepe. Minima reiciendis repellendus et molestiae."}],"created_at":"2020-10-12T10:55:34.000000Z","updated_at":"2020-10-12T10:55:34.000000Z"},{"id":2,"title":"Necessitatibus delectus.","slug":"necessitatibus-delectus.","attributes":[{"name":"color","value":"#ba94e8, #64a995, #71daa4, #28086a, #5963fe"},{"name":"size","value":"6, 7, 8, 9, 10, 11, 12"}],"created_at":"2020-10-12T10:55:34.000000Z","updated_at":"2020-10-12T10:55:34.000000Z"}]}

is their a better way to do this ?

@princeoo7 your relationship is attributeValues so

$this->attributeValues->value;

should return some results

yes I forgot about that ;)

@princeoo7 is that working now?

@automica no it only gives me {} as output for values attribute.

But I got it working as below after posting the above line here :P

$this->attributeValues->value,

@princeoo7 cool. I've updated my answer to reflect what you've done, just incase anyone else is following along.