type, plus an optional format. The type tells fileAI what to look for and decides how the value comes back from GET /v1/files/{fileId}/values. Pick the narrowest type that fits: an enum beats a free-text string when the answer is one of a known set.
Types
Other
format values on string fields are latitude and longitude.
How values come back
numberandintegervalues are JSON numbers. Grouped text such as"199,612.89"is read as199612.89.- Every other scalar value is a string, including
boolean("true"or"false"). - An empty value is
null. - A number or table cell whose value is
0also comes back asnull. If your system needs to tell zero from empty, treatnullon anumberfield as “no value or zero”.
Tables
Alist field is a table. Its items define the columns, and each column has its own type. In the values response, rows are in valueArray: an array of rows, each row an array of cells.
list:
Tables over 100 rows are truncated unless you pass
includeFullTableData=true. To change a cell, use PATCH /v1/files/{fileId}/values with cells. See Correct a value.
Enums
Anenum field lists its allowed values in enumValues. fileAI returns one of them as a string.
Field properties
These properties appear on each field inGET /v1/schemas and can be set with PATCH /v1/files/schema:
Related
AI Schemas
Define fields and read values.
Extraction prompts
Write descriptions that extract reliably.