List every sheet the configured API key can see, grouped by tab.

Returns a tree: account -> tabs (path like "/sales") -> sheets (key = sheet_index, value = {name, type, seq}). Use this as the FIRST call when the user asks about a sheet by Chinese name — find it in the tree, then use the matching path & sheet_index for subsequent tools.

No arguments. The user doesn't need to paste a URL anymore.

Read records from a Ragic sheet.

path and sheet_index come from the sheet URL https://{server}/{account}// — e.g. for https://www.ragic.com/demo/sales/1 use path="sales", sheet_index="1".

where is a list of filter conditions. Each is an object: {"field_id": "", "op": "", "value": ""} Operators: eq, like, regex, gte, lte, gt, lt, eqeq. Same field with multiple eq/like/regex = OR; gte+lte on same field = AND range; conditions on different fields = AND. Set value to "" to match empty cells. Dates use yyyy/MM/dd.

Call ragic_filter_help() for the full cheatsheet including system field IDs.

Read one record by its Ragic node id (_ragicId in list responses).

Full-text search a sheet (Ragic fts parameter).

Create a new record. fields keys are numeric field IDs as strings.

For subtables include _subtable_<fieldId> with negative-keyed rows. See ragic_filter_help() for the subtable format and write parameters.

Requires an API key with write permission; otherwise Ragic returns 401.

Update fields of an existing record. Only the provided fields change.

check_lock defaults to true so a locked record will not be overwritten silently. Set to false to bypass (use with care).

Delete a record. Ragic does not support batch delete via this endpoint.

Approve or reject a record awaiting approval.

action must be "approve" or "reject". comment is optional response text.

Lock a record to prevent further edits.

Unlock a previously locked record.

Return the Ragic filter / write-parameter cheatsheet.

Read this once at the start of a Ragic task to understand the where syntax, system field IDs, subtable write format, and rate limits.