XanoInstall

Summary

Search rows in a specified table with optional filtering and pagination

Inputs

• workspace (required) — Workspace Name or ID; choose from list or specify via expression
• table (required) — Table Name or ID; depends on selected workspace
• page — Page number to fetch; defaults to 1
• per_page — Number of records per page; defaults to 10
• sortby (required) — Field to sort by; choose from table fields or specify via expression
• sortOrder — Sort direction, asc or desc; defaults to desc
• searchItemsJson — JSON array of objects representing rows to search; field names must match schema

Output shape

a list of row objects returned by the search query

May include pagination metadata; errors are propagated as usual

Examples

Example 1: Search Customers table for records matching a query

workspace=MyWorkspace, table=Customers, sortby=id, sortOrder=asc, page=1, per_page=20

Example 2: Search Orders with a JSON filter on a specific field

workspace=Default, table=Orders, searchItemsJson=[{"status":"completed"}]

Example 3: Iterate through paginated results for a large table

workspace=Acme, table=Products, page=2, per_page=50, sortby=name, sortOrder=asc