Query Database Rows

Read a page of rows from an actor database table or view.

GET https://api.rivet.dev/gateway/{actor}/inspector/database/rows

Examples

curl "https://api.rivet.dev/gateway/$ACTOR_ID/inspector/database/rows?table=users&limit=100&offset=0" \
  -H "Authorization: Bearer $INSPECTOR_TOKEN"

const endpoint = "https://api.rivet.dev";
const query = new URLSearchParams({
	table: "users",
	limit: "100",
	offset: "0",
});
const response = await fetch(
	`${endpoint}/gateway/${process.env.ACTOR_ID}/inspector/database/rows?${query}`,
	{ headers: { Authorization: `Bearer ${process.env.INSPECTOR_TOKEN}` } },
);
console.log(await response.json());
export {};

Authentication

Inspector endpoints do not accept namespace tokens. Send the actor’s inspector token as a bearer token in the Authorization header. Each actor generates its own inspector token on first start and stores it in its KV storage under the single byte 0x03. Read it through the control plane with GET /actors/{actor_id}/kv/keys/Aw==?namespace={namespace} using a namespace token; the response value is the token, base64-encoded. The dashboard does this for you.

Path Parameters

Query Parameters

Headers

Responses

200

The selected rows.

{
  "rows": [
    {}
  ]
}

401

The inspector token is missing or invalid.