Gets a list of Records contained in the table. Note that you create a database and a table in Dashboard in advance.

The default number of records that can be retrieved at one time is 20. To retrieve more than 20 records, specify the limit parameter.

Filter property can be used to narrow down the records to be retrieved. Sort property promises the order in which the records are returned. For more information, see Filter & Sort section.

ex. ) sample table

idnameproduct_typeprice
1applefruits100
2grapefruits200
3chocolatesnacks400
// request
{
        "filter": {
          "and": [
            {
              "key": "product_type",
              "operator": "equal",
              "value": "fruits"
            }
          ]
        },
        "sort": [
            {
                "key": "price",
                "direction": "descending"
            }
        ]
}

// query result
{
	"items": [
		{
		        "id": "2",
		        "name": "grape",
			"product_type": "fruits",
			"price": 200
		},
		{
		        "id": "1",
		        "name": "apple",
			"product_type": "fruits",
			"price": 100
		}
	],
	"count": 2
}
Language
URL
Click Try It! to start a request and see the response here!