📄️ SQL statements in USoft services
USoft Service Definer lets you create REST services on the basis of SQL statements.
📄️ Example: a REST service for retrieving data (SELECT)
The following step-by-step instructions are for creating a custom REST service that retrieves data on the basis of a booking ID.
📄️ Example: a REST Service for adding new data (INSERT)
In this example, you add data about a new customer to the database.
📄️ Example: a REST Service for manipulating data (UPDATE)
In this example, you change the details of a customer that already exists in the database. You can use the PUT or PATCH HTTP verbs. This help topic discusses both. For details, go to Defining REST methods).
📄️ Example: a REST Service for returning manipulated data
In the previous example, you changed the name of a customer that already exists in the database and returned HTTP status code "200 OK" as the sole response.
📄️ Example: a REST Service for deleting data (DELETE)
In this example, you drop a tour from the catalogue of existing tours that is in the database.