Records

These blocks read and write your tables, and run a read-only SQL query when you need something the record blocks can’t express. This page documents 7 blocks. For how flows work, see Flows and the flow editor. Values in settings can use templates such as {{ input.id }} and {{ steps.load.output.email }}; see Block reference overview.

​

SQL query

Key: db.query Runs a parameterised read-only SQL query on the project database. Continues to: next

​

Transaction

Key: db.transaction Applies several resource writes atomically. Continues to: next

​

Create record

Key: resource.create Creates a record. Continues to: next

​

Delete record

Key: resource.delete Deletes a record. Continues to: next

​

Get record

Key: resource.get Loads one record; follows missing when it does not exist. Continues to: next, missing (follow the one that applies)

​

List records

Key: resource.list Lists records of a resource. Continues to: next

​

Update record

Key: resource.update Updates fields of a record; follows missing when it does not exist. Continues to: next, missing (follow the one that applies)