Dick Thiot has made his mvAPI C# application available to the multivalue community. It is available for download on GitHub at https://github.com/dthiot/mvAPI.
It allows a multivalue developer to provide data from a multivalue database to a web page. The solution requires the BlueFinity’s mv.NET product to provide the access to the Multivalue database.
The mvAPI solution handles the HTTP POST and GET requests to call a BASIC subroutine with the ability to pass data to the BASIC subroutine. The solution then will wait for data from the subroutine to return to the webpage.
I created a simple test case using our ForeMost ERP application. It is an Open Order Dashboard. The webpage makes use of some JavaScript libraries to display the data in a table with some additional features.
The BASIC subroutine is very simple. It reads data from our database and formats the data as a JSON string to return to the webpage to be displayed. The webpage calls the BASIC subroutine by using an AJAX call. The returned data is displayed using the jQuery DataTable javascript library to display the data.
The Open Orders are now available to any web browser connecting to the Open Order webpage. The web page can be used for any display of data in a tabular format. There are only a few lines of JavaScript that need to be modified to display data from a different BASIC subroutine.
Many thanks to Dick Thiot of Maverick Systems to make this wonderful C# solution to the multivalue community!
Contact Ashwood Computer, Inc. if you would like to get a copy of the webpage we developed.