sheets

list rows in a sheet

Read information about one or more rows and their related data.

get/sheet/{sheet}

Request

  • Base URL: https://v2.xivapi.com (the document declares no server; this is the origin it was published from)
  • URL: https://v2.xivapi.com/sheet/{sheet}
  • Auth: none declared

Path parameters

sheetstring required

Name of the sheet to read.

Query parameters

rowsstring

Rows to fetch from the sheet, as a comma-separated list. Behavior is undefined if both rows and after are provided.

limitinteger nullable

Maximum number of rows to return. To paginate, provide the last returned row to the next request's after parameter.

afterstring

Fetch rows after the specified row. Behavior is undefined if both rows and after are provided.

language'none' | 'ja' | 'en' | 'de' | 'fr' | 'chs' | 'cht' | 'kr'

Known languages supported by the game data format. NOTE: Not all languages that are supported by the format are valid for all editions of the game. For example, the global game client acknowledges the existence of chs and kr, however does not provide any data for them.

Language to use for data with no language otherwise specified in the fields filter.

schemastring

Schema that row data should be read with.

fieldsstring

A filter string for selecting fields within a row.

Filters are comprised of a comma-seperated list of field paths, i.e. a,b will select the fields a and b.

Decorators may be used to modify the way a field is read. They take the form of @decorator(arguments), i.e. field@lang(en). Currently accepted decorators:

  • @lang(<language>): Overrides the query's language for the decorated field. Allows one query to access data for multiple languages. language accepts any valid LanguageString.

  • @as(<format>): Overrides the default output format for the decorated field.

Currently accepted formats for @as:

  • raw: Prevents further processing, such as sheet relations, being performed on the decorated field. Has no effect on regular scalar fields.

  • html: Formats a string field as rich HTML. Invalid on non-string fields. Output will be a valid HTML fragment, however no stability guarantees are made over the precise markup used.

Nested fields may be selected using dot notation, i.e. a.b will select the field b contained in the struct a.

Arrays must be targeted if selecting fields within them, i.e. a[].b will select all b fields of structs within the array a, however a.b will select nothing.

Data fields to read for selected rows.

transientstring

A filter string for selecting fields within a row.

Filters are comprised of a comma-seperated list of field paths, i.e. a,b will select the fields a and b.

Decorators may be used to modify the way a field is read. They take the form of @decorator(arguments), i.e. field@lang(en). Currently accepted decorators:

  • @lang(<language>): Overrides the query's language for the decorated field. Allows one query to access data for multiple languages. language accepts any valid LanguageString.

  • @as(<format>): Overrides the default output format for the decorated field.

Currently accepted formats for @as:

  • raw: Prevents further processing, such as sheet relations, being performed on the decorated field. Has no effect on regular scalar fields.

  • html: Formats a string field as rich HTML. Invalid on non-string fields. Output will be a valid HTML fragment, however no stability guarantees are made over the precise markup used.

Nested fields may be selected using dot notation, i.e. a.b will select the field b contained in the struct a.

Arrays must be targeted if selecting fields within them, i.e. a[].b will select all b fields of structs within the array a, however a.b will select nothing.

Data fields to read for selected rows' transient row, if any is present.

Response

schemastring required

The canonical specifier for the schema used in this response.

versionstring required

The canonical specifier for the version used in this response.

Changes

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