Flexmonster server custom parameters

Hi Catalin,
 
Thank you for posting your question.
 
Even though it is not possible to specify custom parameters for your SQL query directly in your flexmonster-config.json file, there is a workaround that could work as required in case you need to narrow down the set of tables to select values from.
 
This approach involves defining your custom Data Server based on the already provided DLL. To start with, the customizeAPIRequest() API call can be used on the client-side to create customized requests with information about the current session/user or any other custom parameters. After this, the custom Data Server DLL can be set up in a way that the server-side returns different data set parts depending on the user info, which was passed to the server with the help of the customizeAPIRequest().
 
Feel free to check out the following GitHub sample illustrating this: https://github.com/flexmonster/flexmonster-data-server-dll
In the sample above, the request headers are customized in the DemoDataServerCore/wwwroot/js/site.js file, while the server-side parsing and corresponding data return are handled in DemoDataServerCore/Controllers/FlexmonsterAPIController.cs.
 
Please let us know if you think this approach would be helpful in your use case. If not, it would be great if you could tell us a little bit more about what exactly you are trying to achieve in general – this would help us understand the whole situation better and see whether there is a better solution we can offer.
 
Looking forward to your response.
 
Best regards,
Mykhailo

Hi Catalin,
 
How are you?
 
We were wondering if you've found our previous suggestion helpful. Were you able to achieve the desired behavior, or are there still any questions you would like to discuss?
 
We would be happy to hear your feedback.
 
Regards,
Mykhailo

Hi Catalin,
 
Hope you're doing well!
 
We are just checking in to ask whether you’ve received our previous response. Was our suggestion helpful, or do you still have anything you would like to discuss?
 
Please let us know what you think.
 
Kind regards,
Mykhailo