Generate create, read, update and delete endpoints from a table.
Recorded with an earlier Twidget interface. Names, control locations and available options may differ; use the linked documentation for current guidance.
Watch tutorial (4:21)With Twidget, you can efficiently generate CRUD (Create, Read, Update, Delete) endpoints for your database tables upon their creation. This functionality is designed to streamline the development process and ensure that essential API operations are readily available.
Create a New Table:
Tick the Checkbox:
Look for the checkbox labeled "Generate CRUD Endpoints" during the table creation process.
This checkbox is ticked by default to save time and provide immediate access to key operations.
Automatic Endpoint Generation:
Upon ticking this checkbox, Twidget will generate the following endpoints for your table:
Create Endpoint: Allows adding new records to your table.
Read Endpoint: Fetches data from your table.
Update Endpoint: Updates existing records within your table.
Delete Endpoint: Removes records from your table.
After generating the CRUD endpoints, you can tailor them to your specific needs through Twidget's API view:
Review Generated Endpoints:
Access Control:
Save Changes Together
A Database Transaction groups database work so its changes complete together. If a command in the block fails, the block's changes are rolled back. Example: an order and its stock change. 1. Add Database Transaction to the workflow. 2. Inside Save changes together, add the supported commands that cr...
Database Change Triggers
Run an event automatically when a record is created, updated or deleted in a Twidget table. For example, send a welcome message after adding a customer, or refresh a summary when an order changes. Prepare the event. Create an event containing the steps you want to run. Add an Object input named `tri...
Export Data from Tables
Twidget allows you to export data from your database tables to a CSV file. This feature supports the export of both complete and filtered datasets. Here’s how you can utilize this functionality: Features. - Format: Export data in CSV format. - Data Handling: Object and list data types within your ta...
Adding Database Table Rows
In Twidget, you can easily add new entries (rows) to your database tables. This feature allows you to expand your data dynamically without the need for complex coding. This document provides a step-by-step guide on how to add rows to your database tables. Adding a New Entry to a Table. To add a new ...
Database Indexes
Indexes help Twidget find records quickly. A unique index also prevents duplicate values from being saved. Choose the right index. Use a lookup index for a field you regularly filter or sort, such as an order date. Use a unique index when a value must not appear twice, such as a membership number. A...
