JSON object validation?

Question

Laravel

There is a POST request, it contains JSON, for example

{
  "User": {
    "name": "Name",
    "lastName": "last name",
    "email": "[email protected]",
  }
}

I'm trying to write validator rules like this

public function rules()
    {
        return [
            'User.name' => 'required|max:100',
            'User.lastName' => 'required|max:100',
            'User.email' => 'required|email|max:255|unique:users',
        ];
    }

everything works fine, except for checking for uniqueness. Laravel is trying to execute a query like this:

select count(*) as aggregate from "users" where "User"."emai" = ?

And, of course, it throws an exception that the "User" table does not exist
Laravel 5.4

Answer 1

Write like this:
unique:table,column,except,idColumn