menu

Querying Tables

POST /api/table/{table_id}/records/query

Parameters

name type description
search string optional search string for partial matches
filters array optional array of filter conditions (see below)
fields array optional array of field id's to include
order_by string optional field id to order by
order_dir string optional direction to order by (ASC or DESC)
limit integer maximum number of records to return - max 1000
offset integer offset into the result set

Filters

The filters parameter is an array of the following keys:

name type description
field string field id
compare string compare function (see below)
value string value to match on

Compare functions

name description
EQ equal to
NE not equal to
LT less than
LE less than or equal to
GT greater than
GE greater than or equal to
C contains
NC not contains

Example

$ curl -X POST "https://infolobby.com/api/table/123/records/query"
    -H "Authorization: Bearer YOUR_ACCESS_TOKEN"
    -H "Content-Type: application/json"
    -d '{"filters":[{"field":"name","compare":"C","value":"foo"}],"fields":["name","age"]}'

Sample Response

[
  {
    "item_id": 1,
    "name": "foo",
    "age": 21
  },
  {
    "item_id": 2,
    "name": "foobar",
    "age": 22
  }
]

Notes

If you're not sure of a table's ID, you can get it from the developer tab in the table settings in InfoLobby.

If you need hints on what the id's of the fields are, make a request to:

GET /api/table/{table_id}/get

And have a look at the appFields array in the response.

InfoLobby © 2024 Globi Web Solutions