Flatfile

Permanently delete one to 100 explicitly identified records from one Flatfile sheet. This action never performs an unfiltered delete. Flatfile hooks are disabled, so these deletions do not trigger hook-driven workflows.

Get detailed status, outcome, result, and diagnostic information for one Flatfile asynchronous job.

Get one sheet's field configuration and record counts before reading or writing records.

Get safe metadata for one Flatfile space without exposing transient access credentials or token-bearing guest links.

Insert one or more rows into a Flatfile sheet using simple field-key to value objects. Returns Flatfile's success receipt and commit ID, not created record IDs. Use List Records separately when later work requires IDs; only attribute matches that are unambiguous for caller-controlled unique values. Hooks are disabled for this mutation.

List Flatfile environments visible to the connected environment secret key and return the IDs needed to find spaces.

Discover import or export files and their processing status, optionally within a Flatfile space.

Find asynchronous Flatfile jobs by environment, space, workbook, file, or parent job and inspect progress at a glance.

Read one page of records from a Flatfile sheet, optionally filtering by validity, field, record ID, search value, or FFQL expression.

Find Flatfile spaces by environment, text, namespace, archive state, or template status.

List workbooks, optionally within a space, with their nested sheets so an agent can continue to sheet and record tasks.

Update one or more existing Flatfile records by ID using simple field-key to value objects. Flatfile hooks are disabled, so these updates do not trigger hook-driven workflows.