Build and host and API in 15 minutes? Crazy? No, really! REST APIs are pretty much everywhere. They are the standard method to expose databases to clients and knowing how to develop a REST API is a necessity at all layers of the stack. By using one of the many public APIs out there, you can expand the functionality of your application or enrich it with the necessary data. But what if you have created your own unique functionality that you want to share with the community? The answer is to create your own API. I’m going to show you how to do this in , a low-code development tool for IT pros. Linx Let's Get Started This tutorial will demonstrate how to build a minimally viable REST Web service integrated with a SQL Database using Linx to both build (Linx Designer) and host the web service (Linx Application Server). The REST web service will involve an operation related to the creation of a ‘user’ record in the database. What is Linx? Linx enables the rapid development and deployment of back-end applications like APIs, integrations and automations. Developers design and debug solutions in a familiar procedural style using a drag and drop interface with access to 1000s of ready made functions. Solutions are deployed with one click to servers running in the cloud or on-premise. Prerequisites This tutorial assumes: Basic understanding of REST Web services A database instance and some basic familiarity with SQL Linx Application Designer (download ) here An active Linx Application Server* Web service request tool (e.g. Postman) *The Linx application Server is available on a trial basis. Linx Solution Specification The sample application will contain a REST Web service containing a single operation. The operation will execute a custom process flow which results in a submitted ‘user’ being added to a database and the results returned in the response. API Specification The REST WebService will contain a single ‘AddUser’ operation. The ‘AddUser’ operation involves a POST request made to the ‘/users’ endpoint. HTTP Request A JSON request body is submitted containing a ‘user’ object. Request Body { : , : , : , : , : } "username" "string" "firstname" "string" "lastname" "string" "password" "string" "email" "string" A JSON response body is then returned containing a ‘user’ object. Response Body { : , : , : , : , : } "id" 0 "username" "string" "firstname" "string" "lastname" "string" "email" "string" NOTE: For the purpose of this demonstration - creating a minimally viable REST API - I will only be creating a single operation and will not be applying any security to the operation. Extending the API functionality and adding security is simple enough. Database Specification Here is a SQL database containing a [User] table consisting of the following fields: [ID] – Primary Key [Username] – Username of user [Password] - Password (encrypted) [FirstName] - First name of user [LastName] - Last name of user [email] - email of user The ‘user’ details that are submitted with the request will be added to this table. The newly generated ID and additional fields of the new record will then be returned. You can use the sample SQL below to create the table: SQL CREATE TABLE [dbo].[User]( [ID] [int] IDENTITY( , ) NOT NULL, [Username] [varchar]( ) NOT NULL, [Password] [varchar]( ) NOT NULL, [FirstName] [varchar]( ) NULL, [LastName] [varchar]( ) NULL, [email] [varchar]( ) NULL, CONSTRAINT [PK_User] PRIMARY KEY (ID) ) 1 1 50 50 50 50 50 Create the Linx Application Creating a REST Web service and adding custom functionality with Linx involves the following broad stages: Creating a new solution Adding Plugins (functionality) Create custom logic flow Configure REST Web service and Operations Link custom logic to REST operations Debug & deploy Creating a New Solution To create a new Linx solution is easy - with just a single click, the base skeleton of the application is created for you. Your solution is created with a blank ‘process’ and you can add as many processes and services as you require. Plugin Configuration Linx is based upon a architecture. To build the application, I require functionality related to the following areas: plugin REST Web Services (to generate a REST API) Encryption (for the user’s password) Database integration (executes a query against a database instance and returns any results) Plugins contain types, functions, and services; which are higher-level components that reduce complex programming functionality into simple visual elements. For example, the File plugin contains functions relating to file operations such as writing and reading files (TextFileWrite, TextFileRead, CopyFile etc) as well as automated services such as Directory monitoring (DirectoryWatch). Create custom logic flow The custom logic flow will result in a ‘user’ object being added to a database and the results returned. To start, create a single process which will take in an input parameter of a ‘user’ object. The ‘ ’ ‘ will then be encrypted and added to the database along with the rest of the user’s details. The newly created record details will then be returned from the database and will be set as the result of the process. user.password Once this process has been built, it will then link to the REST endpoint operation. Building a custom process Configure a ‘user’ Custom Type. Configure the ‘user’ Custom Type to be an input and output of the process. Add an Encrypt function to encrypt the ‘user.password’. Connect to the database and execute SQL function that will insert the ‘user’ object and the encrypted password into the database. Add a SetValue function to return the user’s details as the output of the process. Configure a ‘user’ Custom Type To create a ‘user’ object to use in the application you can create a Custom Type. Custom Types are customizable objects containing basic types (integers, string etc) as well as nested objects. These Custom Types are automatically stored as JSON format and can be converted into a number of other formats using Linx functions. To create a Custom Type, simply select the option from the menu bar. Create a ‘user’ custom type with the following fields to resemble the [user] table in the database. With the ‘user’ Custom Type, you can Set it as the input and output type of the process that adds the user details to the database. Set it as the format of the request body and response body of the operation. Configure process input and output By default, a single process is created when a new solution is created, The default name of ‘Process’ can be easily changed by editing the ‘name’ property. in this case, it has been renamed ‘AddUserToDatabase’. Set the ‘user’ Custom Type as the input and the output of the ‘AddUserToDatabase’ process by using the field editor in the properties. Encrypt password To encrypt the incoming user’s password using a passphrase, drag on the ‘Encrypt’ function from the cryptography plugin onto the ‘AddUserToDatabase’ process. Linx will automatically validate the properties for errors and indicate that there are required properties that need to be configured. All the available data objects that are in scope of the process are available for selection. It is important to reference which data object is going to be encrypted and supply a passphrase or key depending on the algorithm chosen. In this case it will be the input ‘user’ password. The result of the ‘Encrypt’ function will be a base64 encoded string that can be used when inserting the user details into the database. Configure database connection and SQL Select the ExecuteSQL function from the Database plugin to connect your database instance. Using the built-in connection editor, you can easily add a ‘connection string’ property which will allow access to your database instance. Optional: By storing the Database connection string as a setting, you can access the value from anywhere in the solution. The advantage of this is that you can have a single property source and reference this for multiple service or function properties. Once connected, add the SQL that will insert the details passed in from the user object and return the results. Using the SQL editor, you can use the built-in query generator to create an INSERT statement template for the [user] table. Set the process output The ‘user’ has been inserted into the database and the new details returned from the query. You can set the output ‘user’ of the process equal to the ‘user’ returned from the database. To do this, simply use a SetValue function which allows you to assign the output of the ‘AddUserToDatabase’ process. By now, you should have a custom process that: Configure REST Web Service and Operations Takes in a ‘user’ object Inserts the details into a database Returns the updated details Next, you can expose this functionality by linking the relevant custom logic to a specific REST operation which is contained in the REST host service. To do this; Add a SimpleRESTHost service to your Solution Configure properties and operation Link your custom process to the operation Debug and test Deploy Add a SimpleRESTHost service to your Solution To add and initiate a SimpleRESTHost service to your solution, drag the ‘SimpleRESTHost’ service from the REST Plugin. This will create the base skeleton for the REST service. Configure properties and operation. First configure the Base URI, this is where the REST service will be hosted on. Next, create the operations needed for the REST service by expanding the ‘Operations’ property wizard. Here you can quickly define operations, endpoints and parameters. In this case I want to: Create an ‘AddUser’ operation (Name) Configure the endpoint path to be ‘/users’ (Path) Configure this operation as a POST method For the request body, configure the operation to have a request body of a ‘user’ object that you created earlier For the response body, it will also be a ‘user’ object For the demo, you can bypass any security Click save to create your AddUser operation. Linx will provide all the necessary input and output structures in place. Linking your custom process to the operation You now have a Custom process REST Operation To link the two, in the ‘AddUser’ operation, drag in the ‘AddUserToDatabase’ process. This will mean that when the ‘AddUsers’ operation is executed, it will execute the ‘AddUserToDatabase’ custom sub-process. However, you first need to configure the inputs for the ‘AddUserToDatabase’ custom process to reference the ‘user’ passed in with the request body. Do so by simply referencing the input request body: Finally, you can set the response body of the operation equal to the output returned from the ‘AddUserToDatabase’, which is done as follows: SQL expression Debug and test The Linx IDE allows you to debug your operations in order to simulate the run time functionality. To debug, initialize the debugger on the ‘AddUser’ operation. In the ‘Debug Values’ panel, input test data for the ‘request body’ property. By adding a ‘breakpoint’ to the ‘AddUserToDatabase’ operation, you can step through and pause on each function in the logic flow and see their runtime values. Next, step into the ‘AddUserToDatabase’ process which will where you should see that the request body is then assigned as the input.user to the ‘AddUserToDatabase’ You can see the encrypted string as the output of the ‘Encrypt’ function. The ‘user’ is inserted into the database and the new details are returned from the ExecuteSQL function. If you step over until you return to the parent operation, you can see the ‘AddUserToDatabase’ process has returned a ‘user’. Finally, you can see the operation’s response body being set to the values returned from the ‘AddUserToDatabase’ process. Deploy With the functionality of the REST service tested, you are ready for deployment. This is done by simply clicking the ‘deploy’ button, directly from the IDE. Linx Applications require a Linx Application Server to run. Deploy your Linx Applications directly from the Linx Designer - in the cloud or on-premise - to host and run your application. Once deployed, and since it's the first time the application is uploaded, you will need to ‘start’ the service. Once activated, the SimpleRESTHost service can begin to make requests against the API. The Linx Server: Testing with POSTMAN To test, make a request to the ‘/users’ endpoint to add some user details to the database. In the database I currently have a [User] table with no records. When a request is made to the Linx REST web service, details passed in with the request will be added to the database and an auto-generated ID along with the inserted details will be returned in the response. Using Postman, you can setup a ‘POST request made to your REST service endpoint. In the database a new record has been added along with an auto-generated ID. In the response body you can see this ID as well as the user details returned with some having text manipulation being performed. { : , : , : , : , : , : } "id" 5 "username" "linx" "password" "" "firstanme" "LinxDemo" "lastname" "TEST" "email" "support@linx.software" You’re done! An end to end example fo building an API using Linx. Watch this tutorial in a video format:
