Skip to content
  • Auto
  • Light
  • Dark
Get Started

Shared

Shared

Shared

Pagination Links
PaginationLinks

Links to use for pagination

ShowShow
Result Set
ResultSet

Result of executing an SQL statement.

ShowShow
columnsarray
Array<string>

Names of columns.

Names of columns can be defined using the AS keyword in SQL:

SELECT author AS author, COUNT(*) AS count FROM books GROUP BY author
columnTypesarray
Array<string>

Types of columns.

The types are currently shown for types declared in a SQL table. For column types of function calls, for example, an empty string is returned.

rowsarray
Array<Array<unknown>>

Rows produced by the statement.

rowsAffectednumber

Number of rows that were affected by an UPDATE, INSERT or DELETE operation.

This value is not specified for other SQL statements.

lastInsertRowidunion
optional
string | number | null

ROWID of the last inserted row.

This value is not specified if the SQL statement was not an INSERT or if the table was not a ROWID table.

Hide ParametersShow Parameters
string
number
User
User

User object

ShowShow
idstring

The ID of this user

formatuuid
biounion
string | null

The user’s biography, if they have provided one

profileImageUrlunion
string | null

URL that points to the user’s profile image, if one exists

formaturi
urlstring

URL of this user’s profile on Val Town’s website

formaturi
usernameunion
string | null

The user’s handle that they chose for themselves. Does not include the @ symbol

Val
Val

A Val

ShowShow
idstring

The id of the val

formatuuid
authoridstringusernameunionAuthor
Hide ParametersShow Parameters
idstring
formatuuid
usernameunion
string | null
createdAtstring
formatdate-time
descriptionunion
string | null
imageUrlunion
string | null

The URL of this val's image

namestring
privacyunion
"public" | "unlisted" | "private"

This resource's privacy setting. Unlisted resources do not appear on profile pages or elsewhere, but you can link to them.

Hide ParametersShow Parameters
"public"
"unlisted"
"private"