This quickstart shows you how to create and start simple project with HTTP JSON Server and SQL Client plugins to retrieve data from SQL database via HTTP requests.
Create New Project
Edit New Project
We are editing our project in the Designer tab of the main windows. To read more, see TBA.
We are going to create simple project with HTTP JSON Server and SQL Client plugins. We are going to retrieve data from SQL Table by paramaters.
In our example the structure of SQL Table People will be the following:
Configure HTTP JSON Server plugin
As an example lets check number's parity. To do that we will have HTTP JSON Server and Python Script plugin.
This is how our plugin will look like:
Configure SQL Client plugin
Firstly download plugin from TBA. Add plugin to your project.
This is how our project will look like:
To start our project locate Project tab on the upper menu. Click Upload to save it and Start to start it.
Now you need to make HTTP request. You can use any web browser or Postman client to make this.
The url will be the following: http://localhost:20050/sql/people?eye_color=blue&age=20 where 20050 is Port, sql - ServiceName, people - Path name.
This is what you get:
To observe the logs, open Logs tab on the VeloXi.
Pick Client Plugins, select time period and click Load.
Click on the log you have and you will see your SQL Client evaluation log.
It will have Import parameters, SQL query that was executed and Export data.
You can download the whole project via this link - Get SQL Table.vxexport