v1

latestOpenAPI 3.1.02026-07-243011.4 KB

list records

post/object/list

Request body

object_typestring

The name of table to fetch records

sortstring

sort criteria

pageinteger
sizestring
selectstring[]

Choose fields you want select

Response

200

statusboolean

Example response

{
  "status": true,
  "data": {
    "items": [
      {
        "id_sample_table": 1,
        "name": "Test",
        "criado_por": {
          "id_user": 2,
          "id_org": 1,
          "first_name": "Renato",
          "email": "renato.menegasso@jestor.com",
          "id_profile": 10001,
          "name": "Renato",
          "personal_email": "renato.menegasso@jestor.com"
        },
        "criado_em": "2021-03-26T20:34:05+00:00",
        "atualizado_por": 2,
        "atualizado_em": "2021-03-26T20:43:38+00:00",
        "binary_field": 1,
        "nested_field": {
          "id_colors_are_fun": 5,
          "name": "Purpose Purple",
          "criado_por": 1,
          "criado_em": "2021-03-12T10:43:05+00:00",
          "atualizado_por": 1,
          "atualizado_em": "2021-03-12T14:49:23+00:00",
          "pro_tip": "For getting things done 💪",
          "picture": "7fd2ca54223d16d92af4a36daba7b6e6.png",
          "stack": "Mobile"
        },
        "number_field": 20,
        "formula_field": 200
      }
    ],
    "total": 1
  },
  "metadata": {
    "response": "ok",
    "message": "OK"
  }
}