Run widget
Executes the widget’s stored SQL with the board’s filter defaults, overridden by any filter_values supplied here. Results are cached briefly per widget, filter set and row limit; editing the widget invalidates its cache. Safe and side-effect free despite being a POST. Render a whole board by calling this once per widget.
Path parameters
Headers
Request
Maximum rows returned. Optional — omit it for the default of 1000. A LIMIT inside your SQL can narrow the result further but never widens it past this. The result reports truncated when this cut the result short.
Response
Column metadata in result order; position N describes position N of every row
Row values as positional arrays aligned 1:1 with columns, not keyed objects
Number of rows in rows, which is not the total matched when truncated
True when the result was cut short by row_limit