Home

StandardAPI Resource Interface

PATH	JSON	SQL	RESULT
/models	{}	SELECT * FROM models	[{ id: 1 }, { id: 2 }]
/models?limit=1	{ "limit": 1 }	SELECT * FROM models LIMIT 1	[{ id: 1 }]
/models?offset=1	{ "offset": 1 }	SELECT * FROM models OFFSET 1	[{ id: 2 }]
/models?order[id]=asc	{ "order": { "id": "asc" } }	SELECT * FROM models ORDER BY models.id ASC	[{ id: 1 }, { id: 2 }]
/models?order[id]=desc	{ "order": { "id": "desc" } }	SELECT * FROM models ORDER BY models.id DESC	[{ id: 2 }, { id: 1 }]
/models?order[id][asc]=nulls_first	{ "order": { "id": { "asc": "nulls_first" } } }	SELECT * FROM models ORDER BY models.id ASC NULLS FIRST	[{ id: null }, { id: 1 }]
/models?order[id][asc]=nulls_last	{ "order": { "id": { "asc": "nulls_last" } } }	SELECT * FROM models ORDER BY models.id ASC NULLS FIRST	[{ id: 1 }, { id: null }]
/models?where[id]=1	{ where: { id: 1 } }	SELECT * FROM models WHERE id = 1	[{ id: 1 }]
/models?where[id][]=1&where[id][]=2	{ where: { id: [1,2] } }	SELECT * FROM models WHERE id IN (1, 2)	[{ id: 1 }, { id: 2 }]