Delete Record allows you to delete a record from a database table based on a single field look up.
Finding the record to be deleted:
- Field name: This is the name of the field (column) in your database table that you want to find the record by. Field name will be defaulted to the ID field but you can open the dropdown selector to choose from the list of different fields in the database table.
- Field value: This how you find the record based on the value of the field name. The field value is typically an input but can also come from things like a variable or the authenticated user ID.
In this example, we will find and delete a record based on the ID field, the value will be from the input product_id.
There is no response for the Delete Record function because the record is being deleted. On a successful run, the return variable will have a null value.
There is no response when you delete a record. The return variable will be null.
Settings allow you to include a description for the function that will be displayed in the function stack,