Exposing a custom SQL query from SQL Server and using http params to filter the result

Hello,

first of all, what I want to do is to expose data from a external SQL Server as a REST API to be consumed by a Ruby on Rails webapp.

I have been trying Dreamfactory and so far I understand how to expose endpoints from single tables and how to filter them and stuff, but I would want to know if I can expose an endpoint based on the result of a custom SQL Query, writing it in just SQL.

On the other hand, is possible to filter the results of this custom SQL query depending on the http params sent by the client?

Hello

Have you ever tried to use stored procedures?

Hi Peter, no I haven’t, I’m pretty new to DF actually. Are Stored Procedures the way to go to do what I want? Is there any tutorial to check it out?

Thank you.

Hi,

something similar in mind?
http://www.codeproject.com/Articles/590341/Stored-Procedure-with-Sorting-Paging-and-Filtering