Get Row by Values

Lookup a row in a database by up to 5 column values.

What does it do?#

The Get Row by Values block accepts 5 values to filter a database row by, a row must match all values provided in the specified columns for it to be returned.

×

Inputs

Database Required#

Provide the name of the database to use for this block.

Example: my_database

Column Required#

Provide the name of a column in the selected database.

Example: my_column

Value Required#

Provide a value to look up in the selected database/column.

Example: Example value!

Column 2#

Provide the name of a column in the selected database.

Example: my_column

Value 2#

Provide a value to look up in the selected database/column.

Example: Example value!

Column 3#

Provide the name of a column in the selected database.

Example: my_column

Value 3#

Provide a value to look up in the selected database/column.

Example: Example value!

Column 4#

Provide the name of a column in the selected database.

Example: my_column

Value 4#

Provide a value to look up in the selected database/column.

Example: Example value!

Column 5#

Provide the name of a column in the selected database.

Example: my_column

Value 5#

Provide a value to look up in the selected database/column.

Example: Example value!

Outputs

Row Found#

A boolean that is either true or false depending on if a row was found that met the conditions.

Example: true

Row ID#

The row ID of the retrieved row, blank if no row could be found.

Example: abcdef12-3456-7890-abcd-ef1234567890

Created At (Unix)#

The Unix timestamp of when the row was created.

Example: 1731886315

Updated At (Unix)#

The Unix timestamp of the last time the row was updated.

Example: 1731886315