Get Free Trial

Views and Stored Procedures

Erik Lacson asked on April 29, 2021

I’m trying to call a view or a stored procedure as the query string in the Flexmonster Data Server json config file. When I point to the data server API, it would only retrieve the column names from the view or a stored procedure, but not the data. Is there a proper way of using views or stored procedure? My straight SQL query is too long an complex to put inside the JSON config file.

1 answer

Mykhailo Halaida Mykhailo Halaida Flexmonster April 30, 2021

Hi Erik,
Thank you for posting your question.
It seems like a reasonable solution for you would involve referring to the Data Server as to a DLL.
This approach allows you to customize the Data Server to suit your needs better. You can, for example, implement your own parser in a way that processes the results of your stored procedures – this is not available in the default Data Server, distributed as a ready-to-run .exe file.
For more info on Flexmonster Data Server as a DLL check out the following documentation page:
Also, here is a step-by-step tutorial on implementing a custom parser for the Data Server:
Please let us know if this helps.
Kind regards,

Please login or Register to Submit Answer