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.
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
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.