Mutating Individual Records

You can create, update, and delete individual table records using 8base’s auto-generated GraphQL mutation operations.

In the following examples, we have a table called students, which contains fields and relations like firstName, email, age.

Creating a Single Record

Create a new record using the input argument that define the records data.

Request

mutation MyMutation1 {
  createStudents(
    input: {
      firstName: "John",
      lastName: "Doe",
      email: "john.doe@example.com",
      age: 24,
      city: "2900562f-d036-486d-be98-9ebf064c27fe"
    }
  ) {
    id
    firstName
    lastName
    email
    age
    city {
      id
      nameCity
    }
  }
}

Response

{
  "data": {
    "createStudents": {
      "id": "2685ec12-a4c7-491d-a155-d0b09190993b",
      "firstName": "John",
      "lastName": "Doe",
      "email": "john.doe@example.com",
      "age": 24,
      "city": {
        "id": "2900562f-d036-486d-be98-9ebf064c27fe",
        "nameCity": "Houston"
      }
    }
  }
}

Updating a Single Record

Update a record using the id and input arguments.

Request

mutation MyMutation1 {
  updateStudents(
    id: "2685ec12-a4c7-491d-a155-d0b09190993b",
    input: {
      age: 23
    }
  ) {
    id
    firstName
    age
  }
}

Response

{
  "data": {
    "updateStudents": {
      "id": "2685ec12-a4c7-491d-a155-d0b09190993b",
      "firstName": "John",
      "age": 23
    }
  }
}

Delete a Single Record

Delete a record using the id argument.

Request

mutation MyMutation1 {
  deleteStudents(
    id: "2685ec12-a4c7-491d-a155-d0b09190993b"
  )
}

Response

{
  "data": {
    "deleteStudents": true
  }
}