Shared

Shared

Shared

Pagination Links

PaginationLinksobject

Links to use for pagination

ShowShow

selfstring

URL of this page

formaturi

nextstring

optional

URL of the next page, if any

formaturi

prevstring

optional

URL of the previous page, if any

formaturi

Result Set

ResultSetobject

Result of executing an SQL statement.

ShowShow

columnsarray of 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 of 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 of array of 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 OR number

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

UnionMember0string

UnionMember1number

User

Userobject

User object

ShowShow

idstring

The ID of this user

formatuuid

biostring

The user’s biography, if they have provided one

linksobject

Hide ParametersShow Parameters

selfstring

URL of this user on this API

formaturi

profileImageUrlstring

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

usernamestring

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

Val

Valobject

A Val

ShowShow

idstring

The id of the val

formatuuid

authorobject

Hide ParametersShow Parameters

idstring

formatuuid

usernamestring

createdAtstring

formatdate-time

descriptionstring

imageUrlstring

The URL of this val's image

linksobject

Hide ParametersShow Parameters

htmlstring

The URL of this resource on Val Town

formaturi

selfstring

The URL of this resource on this API

formaturi

namestring

privacyenum

"public" OR "unlisted" OR "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"