SurrealDBInstall

Summary

Retrieve multiple records from a SurrealDB table using specified record IDs, optionally specifying the table and database context, and controlling behavior for missing tables.

Inputs

• Table — The SurrealDB table name to query (e.g., "person", "product"). If empty, the table name will be extracted from the provided record IDs automatically.
• Record IDs (required) — A comma-separated list of record IDs to fetch. Can include table prefixes (e.g., "person:john", "product:abc123"). If the Table input is empty, the operation uses the table part from each record ID.
• Options.Namespace — Optional namespace override for this operation instead of the default credential's namespace.
• Options.Database — Optional database override for this operation instead of the default credential's database.
• Options.Treat Missing Table As Empty Result — If enabled, returns an empty result instead of an error when the target table does not exist, preserving older SurrealDB behavior.
• Connection Pooling — Configure connection pooling settings to optimize connection reuse and performance during the operation.

Output shape

a list of records matching the provided record IDs

Returns records in the same order as the requested IDs. If the table does not exist and the Treat Missing Table As Empty Result option is false, the operation fails with an error. Supports automatic table extraction from record IDs if the Table is not supplied.

Links

• n8n community nodes installation guide