> ## Documentation Index > Fetch the complete documentation index at: https://synthbrew.com/docs/llms.txt > Use this file to discover all available pages before exploring further. # List Runtime Records > Returns paginated records for a table inside a source. Supports field projection, sorting, filters, and relation population. For backward compatibility, unknown top-level query keys are treated as equality filters. ## OpenAPI ````yaml GET /runtime/{sourceId}/{table} openapi: 3.1.0 info: title: Synthbrew API description: Runtime CRUD and public v1 management endpoints for Synthbrew resources. version: 1.0.0 servers: - url: https://api.synthbrew.com/api description: Production security: - sourceApiKey: [] tags: - name: Runtime description: Public runtime CRUD operations authenticated with source API keys - name: Public v1 Projects description: Team-scoped project management endpoints authenticated with team API keys - name: Public v1 Schemas description: Schema management endpoints scoped to projects accessible by the API key - name: Public v1 Sources description: >- Source management and generation endpoints scoped to projects accessible by the API key paths: /runtime/{sourceId}/{table}: get: tags: - Runtime summary: List records from a source table description: >- Returns paginated records for a table inside a source. Supports field projection, sorting, filters, and relation population. For backward compatibility, unknown top-level query keys are treated as equality filters. operationId: listRuntimeRecords parameters: - $ref: '#/components/parameters/SourceId' - $ref: '#/components/parameters/Table' - name: limit in: query required: false schema: type: integer minimum: 1 maximum: 500 default: 50 description: >- Maximum number of rows returned per page. Use with offset for pagination. - name: offset in: query required: false schema: type: integer minimum: 0 default: 0 description: >- Number of rows to skip before returning results. Useful for page-based pagination. - name: fields in: query required: false schema: type: string description: >- Comma-separated list of top-level fields to include in each returned row. Example: id,total,status - name: sort in: query required: false schema: type: string description: >- Comma-separated sort tokens in :asc|desc format. Example: created_at:desc,id:asc. Sorts are applied left-to-right. - name: populate in: query required: false schema: type: string description: >- Comma-separated relation field IDs to populate. Example: customer_id. Populated data is returned under _populated.. - name: filters.. in: query required: false allowReserved: true schema: type: string description: >- Dynamic filter key pattern. Example: filters.status.$eq=paid, filters.total.$gte=50, filters.id.$in=1,2,3, filters.note.$null=true. Operators: $eq, $ne, $gt, $gte, $lt, $lte, $in, $notIn, $contains, $containsi, $startsWith, $endsWith, $null. - name: populate..fields in: query required: false allowReserved: true schema: type: string description: >- Specify fields returned for a populated relation. Example: populate.customer_id.fields=id,name responses: '200': description: Paginated runtime rows content: application/json: schema: $ref: '#/components/schemas/RuntimeListResponse' examples: default: value: data: - id: 1 customer_id: 1 status: paid total: 100.5 _populated: customer_id: id: 1 name: Alice pagination: limit: 10 offset: 0 count: 1 total: 4 '400': $ref: '#/components/responses/BadRequest' '401': $ref: '#/components/responses/Unauthorized' '403': $ref: '#/components/responses/Forbidden' '404': $ref: '#/components/responses/NotFound' '500': $ref: '#/components/responses/InternalServerError' components: parameters: SourceId: name: sourceId in: path required: true description: >- Source UUID. For runtime endpoints this identifies the source backing the table; for public v1 it identifies the source resource inside the project. schema: type: string format: uuid example: 11111111-1111-1111-1111-111111111111 Table: name: table in: path required: true description: >- Runtime table identifier (usually the schema entity ID used in Synthbrew). schema: type: string example: orders schemas: RuntimeListResponse: type: object required: - data - pagination description: Paginated runtime table result. properties: data: type: array items: $ref: '#/components/schemas/RuntimeRecord' pagination: $ref: '#/components/schemas/Pagination' RuntimeRecord: type: object description: Dynamic runtime row. Shape depends on the source schema/table. additionalProperties: true Pagination: type: object required: - limit - offset - count - total properties: limit: type: integer description: Requested page size. offset: type: integer description: Requested row offset. count: type: integer description: Number of rows returned in this response page. total: type: integer description: Total rows matching the query across all pages. ErrorResponse: type: object required: - error properties: error: type: string description: Human-readable error summary. responses: BadRequest: description: Validation or query error content: application/json: schema: $ref: '#/components/schemas/ErrorResponse' Unauthorized: description: Missing or invalid source API key content: application/json: schema: $ref: '#/components/schemas/ErrorResponse' examples: missingKey: value: error: API key required invalidKey: value: error: Invalid API key Forbidden: description: API key does not grant access to the requested source content: application/json: schema: $ref: '#/components/schemas/ErrorResponse' NotFound: description: Source, table, or record not found content: application/json: schema: $ref: '#/components/schemas/ErrorResponse' InternalServerError: description: Internal server error content: application/json: schema: $ref: '#/components/schemas/ErrorResponse' securitySchemes: sourceApiKey: type: apiKey in: header name: x-api-key description: Source API key created under /api/sources/:sourceId/api-keys ````