## Stream a table's new rows over SSE `GET /v1/subgraphs/{name}/{table}/stream` Server-Sent Events of rows as they are indexed. Starts at the table's newest row and sends only rows after it; `since` replays from a block height first, then keeps tailing. The server polls every 1.5 seconds, sends each matching row in `_id` order, and sends a `ping` event after 20 idle seconds. Column filters and `_search` apply; `_limit`, `_sort`, `_order` and `_fields` are checked but have no effect, and rows always come back whole. Nothing is stored between connections, and `Last-Event-ID` is not read: to resume, reconnect with `since`. ### Path parameters | Name | Type | Description | | --- | --- | --- | | `name` | string, required | Subgraph name, as deployed (the `name` in its definition). | | `table` | string, required | Table name, one of the keys of the definition's `schema`. `GET /v1/subgraphs/{name}` lists them. | ### Query parameters | Name | Type | Description | | --- | --- | --- | | `since` | integer | Block height to replay from: rows with `_block_height` at or above it, then the live tail. A value that is not a number is ignored. With nothing at or above it yet, the stream tails live. | | `_search` | string | Case-insensitive contains match across every column marked `search: true` in the definition, ORed. 400 on a table with no searchable column. | | `filters` | object | Column filters, one query param each, ANDed. Any table column or system column (`_id`, `_block_height`, `_tx_id`, `_created_at`) works. `col=value` is equality; `col.op=value` applies an operator, one of `gte`, `lte`, `gt`, `lt`, `neq`, `like`, `in`, `notIn`. `like` is a case-insensitive contains match. `in` and `notIn` take a comma-separated list. An unknown column is 400 `INVALID_COLUMN`; an unknown operator, or the misplaced form `col=op.value`, is 400 `VALIDATION_ERROR`. Bare `limit`, `offset`, `sort`, `order`, `fields` and `search` are 400: control params take a leading underscore. | ### Responses - `200` An open event stream. Each row arrives as one message: `id` is the row's `_id`, `data` is the row as JSON, in the same shape as the row list. Idle keepalives are `event: ping` with empty data. - `400` A parameter, filter, cursor or body field was refused; `code` says which - `401` This bind requires the instance token, and it was missing or wrong - `404` No readable subgraph by that name (`SUBGRAPH_NOT_FOUND`), or it has no such table (`TABLE_NOT_FOUND`) - `429` Hosted only: rate limited; retry after `Retry-After` seconds. Self-hosted reads are not rate limited ### Example ```bash curl -G https://api.secondlayer.tools/v1/subgraphs/{name}/{table}/stream \ -H "Authorization: Bearer $SECONDLAYER_API_KEY" \ -d since=9048900 \ -d filters=[object Object] ```