Once a Database table is selected, the API configuration box shows the 4 operations it can perform (read, write, update or delete), plus the “Custom SQL” option that is aimed to perform complex Database operations.
Now you can select one or more of the 4 main operations. When you select an operation, a new section will appear inside the API’s box. Each section has specific options for configuring that operation.
Since an operation is something performed on a Database table, all the sections show the table columns with their possible options. An option can be:
- an operation (read, write, update);
- “none”, which means that the column won’t be considered;
- “key”, which means that the column will be used as an id to identify a record.
Depending on the selected option, the column name will change colour:
Keep in mind that an API operation corresponds to a Database query so, when you configure an operation, you’re practically creating a MySQL query.