ragic_list_records
Retrieve records from a Ragic sheet using filters, sorting, pagination, and subtable support.
Instructions
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.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| info | No | ||
| path | Yes | ||
| limit | No | ||
| order | No | ||
| where | No | ||
| naming | No | FNAME | |
| offset | No | ||
| history | No | ||
| listing | No | ||
| approval | No | ||
| subtables | No | ||
| ignore_mask | No | ||
| sheet_index | Yes |