Database requests are functions that interact with the database. They allow you to manipulate the data from the different database tables in your workspace.
The database request functions are:
โQuery All Records - Retrieves all records from the database. But also, you can have full control over the queried data with filtering, joins, aggregates, response customization, and much more.
โGet Record - Retrieves a single record based on a field look up.
โHas Record- Returns whether a record exists or not based on field look up.
โEdit Record-Updates a record based on a field look up.
โDelete Record- Deletes a record based on a field look up.
โAdd Record - Adds a new record to the database.
โAdd or Edit Record-Looks for a record based on a field look up. If the record does not exist, it will add a new record. If the record does exist, it will update the existing record.
โDatabase Transaction- Allows you to group functions together that you want to execute only if each function is successfully executed. Typically used with two or more functions that are mission critical.
โClear All Records - Permanently clears all the records from a database table.