Database

Reads rows of a table

The newest rows first, unless a column to sort by is named. Each row is a list of values in the order of the columns. A text longer than 2000 characters is cut and sent as { "text": …, "length": … }, bytes as { "blob": length }, and an integer beyond what JavaScript holds exactly as text.

get/lambdas/{privateKey}/database/tables/{table}

Request

  • Base URL: https://genhttp.dev/api/v1
  • URL: https://genhttp.dev/api/v1/lambdas/{privateKey}/database/tables/{table}
  • Auth: none declared

Path parameters

privateKeystring required

The editor key of the lambda. Holding it is what allows the call.

tablestring required

The name of the table or view, encoded as one segment

Query parameters

orderstring

A column to sort by; left out, the order the rows were written in

offsetinteger

How many rows to skip

limitinteger

How many rows to answer with, 1 to 200

descendingboolean

Whether the order is reversed - newest, or highest, first - which it is unless this is false

Response

A page of rows

Tablestring

The name of the table

Totalinteger

How many rows the table holds

Offsetinteger

How many rows were skipped

Limitinteger

How many rows were asked for at most

Orderstring nullable

The column the rows are sorted by; absent for the order they were written in

Descendingboolean

Whether the order is reversed: newest, or highest, first

Changes

No recorded changes to this operation across all 1 revision of this API.