Why integer data is returned as string in Postman

Question

I'm using Postman to test my APIs and I get the following response:

{
 "Message": "Drinks loaded successfully.",
 "Status": true,
 "InnerData": [
     {
         "id": 1,
         "place_id": "25",
         "drink_type": "1",
         "drink_amount": "2",
         "device_id": "1",
         "created_at": "2018-03-09 14:22:27",
         "updated_at": "2018-03-09 14:22:27"
     }
 ]
}

In my datbase the drink_type, place_id, drink_amount, device_id are all integers but I receive them as strings, what is wrong with them?

Here is my code used to return this data:

public function loadDrinks(Request $request){
    $place_id = $request->place_id;
    $device_id = $request->device_id;

    $drinks = \App\DrinksOrdered::where(['place_id' => $place_id, 'device_id' => $device_id])->get();
    $resp = new \App\Http\Helpers\ServiceResponse;
    $resp->Message = "Drinks loaded successfully.";
    $resp->Status = true;
    $resp->InnerData = $drinks;
    return response()->json($resp, 200);
}

<?php namespace App; use Illuminate\Database\Eloquent\Model; class DrinksOrdered extends Model { protected $fillable = ['place_id','device_id','drink_type','drink_amount']; } — Rami
– Rami, Commented Mar 9, 2018 at 15:00
Check out this laravel.com/docs/5.6/eloquent-mutators#attribute-casting — Rafael Berro
– Rafael Berro, Commented Mar 9, 2018 at 15:00

online Thomas · Accepted Answer · 2018-03-09 14:59:37Z

2

https://laravel.com/docs/5.6/eloquent-mutators#attribute-casting

Add this to your model to specify the data type:

 protected $casts = [
     'drink_type' => 'int',
     'place_id' => 'int'
 ];

answered Mar 9, 2018 at 14:59

online Thomas

9,4887 gold badges52 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rafael Berro · Accepted Answer · 2018-03-09 15:01:53Z

The $casts property on your model provides a convenient method of converting attributes to common data types. The $casts property should be an array where the key is the name of the attribute being cast and the value is the type you wish to cast the column to. The supported cast types are: integer, real, float, double, string, boolean, object, array, collection, date, datetime, and timestamp.

This is from the offical documentation, try something like this:

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class DrinksOrdered extends Model
{
    /**
     * The attributes that should be cast to native types.
     *
     * @var array
     */
    protected $casts = [
        'drink_type' => 'int',
        'place_id' => 'int',
    ];
}

Collectives™ on Stack Overflow

Why integer data is returned as string in Postman

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related