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.
⋅ 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: https://www.flexmonster.com/doc/getting-started-with-data-server-dll/.
Also, here is a step-by-step tutorial on implementing a custom parser for the Data Server: https://www.flexmonster.com/doc/implementing-custom-parser/.
Please let us know if this helps.
Kind regards,
Mykhailo
