Get Record

Get Record allows you to retrieve a single record from a database table using a single field to search by.

Filter

In Get Record, you'll provide the name of the field to search inside of, and the value to search for. These can come from inputs, variables, or you can manually specify a value.

field_name is the name of the field to look inside of. For example, if we wanted to search for a record with a specific ID, we'd type id here.

field_value is the value to search for in the provided field. Assuming we are searching in the id field, we would put the ID to search for here.

If you need to find a record based on multiple fields, use Query All Records instead.

You can also choose to enable a lock on the returned records here. Locking the records as part of a database transaction will prevent other function stacks from modifying the data until the lock has been released.

Output

Customizing the return

Click to edit the fields returned in the query.

Note that customizing to reduce the fields returned will not have an impact on query speed, but may help with other performance issues in your function stacks. It is always good practice to only return the fields necessary.

Return As

Change the variable name that this function will output to.

If you're using conditional steps, you can use the same variable name in multiple steps to make satisfying the conditional or outputting data in the response easier.

For example, if we are sending a specific response based on if a variable is true or false, we can set both of those outputs to the same variable, making building our response easier.

Settings

Give this function a description for easy understanding of what this function achieves.

This description will appear in the function stack, giving you easier readability for complex logic.