Axe API Client ​

In this section, we will show another tool in the Axe API ecosystem. You have a great tool the fetch data from Axe API servers.

• You will learn
• What is Axe API Client?
• How to use Axe API client?
• What is the active record pattern?

Axe API Client ​

You can always fetch data from Axe API by sending a simple HTTP request by your favorite tools such as fetch or axios.

We created another tool which is called axe-api-client that you can use. axe-api-client is a tool specified for Axe API servers, and designed on the Active Record Pattern.

You can use the Axe API Client in both frontend and backend projects.

Installation ​

You can use the following command to add axe-api-client library to your project.

$ npm install axe-api-client

Configuration ​

You can set the basic settings like the following example:

import api, { IRequest } from "axe-api-client";

api.setConfig({
  baseURL: "https://your-domain.com/api/v1",
  headers: {
    "x-my-common-header": "my-value"
  },
  params: {},
});

Inserting data ​

You can use the following example to send an insert request to an Axe API server.

const response = await api.resource("users").insert({
  name: "Karl",
  surname: "Popper",
});

$ curl \
  -d '{"name":"Karl","surname":"Popper"}' \
  -H "Content-Type: application/json" \
  -X POST https://your-domain.com/api/v1/users

{
  id: 1,
  name: "Karl",
  surname: "Popper",
}

Update ​

You can use the following example to update a record.

const response = await api.resource("users/1").update({
  name: "Karl",
  surname: "Popper",
});

$ curl \
  -d '{"name":"John","surname":"Locke"}' \
  -H "Content-Type: application/json" \
  -X PUT https://your-domain.com/api/v1/users/1

{
  id: 1,
  name: "John",
  surname: "Locke",
}

Patch ​

You can use the following example to patch a record.

const response = await api.resource("users/1").patch({
  surname: "Popper",
});

$ curl \
  -d '{"surname":"Popper"}' \
  -H "Content-Type: application/json" \
  -X PATCH https://your-domain.com/api/v1/users/1

{
  id: 1,
  name: "John",
  surname: "Popper",
}

Delete ​

You can use the following example to delete a record.

const response = await api.resource("users/1").delete();

$ curl \
  -H "Content-Type: application/json" \
  -X DELETE https://your-domain.com/api/v1/users/1

// empty-response

Find ​

You can get a single record by using the find function.

const user = await api.find("users/1");

$ curl \
  -H "Content-Type: application/json" \
  -X GET https://your-domain.com/api/v1/users/1

{
  "id": 1,
  "name": "...",
  "created_at": "2021-10-21 00:00:00",
  "updated_at": "2021-10-21 00:00:00"
}

Paginate ​

Axe API client library has advanced query features that work Axe API server perfectly.

For example, you can paginate items easily.

const response = await api.resource("users").paginate();

$ curl \
  -H "Content-Type: application/json" \
  -X GET https://your-domain.com/api/v1/users?page=1&perPage=10

{
  "data": [
    {
      "id": 1,
      "name": "...",
      "surname": "...",
      "created_at": "2021-10-21 00:00:00",
      "updated_at": "2021-10-21 00:00:00"
    }
  ],
  "pagination": {
    "total": 1,
    "lastPage": 1,
    "perPage": 10,
    "currentPage": 1,
    "from": 0,
    "to": 1
  }
}

You can use page or perPage parameters to fetch the correct page.

const response = await api
  .resource("users")
  .paginate({ page: 10, perPage: 5 });

$ curl \
  -H "Content-Type: application/json" \
  -X GET https://your-domain.com/api/v1/users?page=10&perPage=5

{
  "data": [],
  "pagination": {
    "total": 0,
    "lastPage": 0,
    "perPage": 5,
    "currentPage": 10,
    "from": 0,
    "to": 5
  }
}

Fields ​

You can select which fields should be listed.

const response = await api
  .resource("users")
  .fields("name", "surname")
  .paginate();

$ curl \
  -H "Content-Type: application/json" \
  -X GET https://your-domain.com/api/v1/users?page=1&perPage=10&fields=name,surname

{
  "data": [
    {
      "name": "...",
      "surname": "...",
    }
  ],
  "pagination": {
    "total": 1,
    "lastPage": 1,
    "perPage": 10,
    "currentPage": 1,
    "from": 0,
    "to": 1
  }
}

Sorting ​

You can sort the items by many fields.

const response = await api
  .resource("users")
  .sort("name")
  .sort("surname", "DESC")
  .sort("id", "ASC")
  .paginate();

$ curl \
  -H "Content-Type: application/json" \
  -X GET https://your-domain.com/api/v1/users?page=1&perPage=10&sort=name,-surname,id

{
  "data": [
    {
      "id": 1,
      "name": "...",
      "created_at": "2021-10-21 00:00:00",
      "updated_at": "2021-10-21 00:00:00"
    }
  ],
  "pagination": {
    "total": 1,
    "lastPage": 1,
    "perPage": 10,
    "currentPage": 1,
    "from": 0,
    "to": 1
  }
}

Where ​

You can filter items by using where*() functions. There are many different functions that you can use.

Let's start with a simple condition;

const response = await api
  .resource("users")
  .where("age", 18)
  .paginate();

SELECT * FROM users
WHERE `age` = 18;

You can add multiple conditions at the same time:

const response = await api
  .resource("users")
  .where("age", ">=", 18)
  .where("name", "Karl")
  .paginate();

SELECT * FROM users
WHERE `age` >= 18 AND `name` = 'Karl';

You can specify the logical operators by using andWhere or orWhere functions.

const response = await api
  .resource("users")
  .where("age", ">=", 18)
  .orWhere("name", "Karl")
  .andWhere("surname", "Popper")
  .paginate();

SELECT * FROM users
WHERE `age` >= 18 OR `name` = 'Karl' AND `surname` = 'Popper';

You can add multiple child conditions by passing the query function as a parameter.

const response = await api
  .resource("users")
  .where((query) => {
    return query
      .where("name", "Karl")
      .orWhere("surname", "Popper");
  })
  .where("age", ">=", 30)
  .paginate();

SELECT * FROM users
WHERE (`name` = 'Karl' OR `surname` = 'Popper') AND `age` >= 30;

Related data ​

You can fetch the related data.

const response = await api
  .resource("users")
  .with("role{title}")
  .paginate();

$ curl \
  -H "Content-Type: application/json" \
  -X GET https://your-domain.com/api/v1/users?page=1&perPage=10&with=role{title}

{
  "data": [
    {
      "id": 1,
      "name": "...",
      "role": {
        "title": "..."
      },
      "created_at": "2021-10-21 00:00:00",
      "updated_at": "2021-10-21 00:00:00"
    }
  ],
  "pagination": {
    "total": 1,
    "lastPage": 1,
    "perPage": 10,
    "currentPage": 1,
    "from": 0,
    "to": 1
  }
}

Next steps ​

In this section, we tried to explain the fundamentals of the Axe API Client.

There are many useful functions that you can use. You can check the API Reference section to learn more.

In the next section, you will learn another cool stuff: the database analyzer.