-
Notifications
You must be signed in to change notification settings - Fork 1.1k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Exposing Stored Procedures from MSSQL using loopback 4 #5101
Comments
Cross posting from #3798 (comment). You can call DataSource.execute(), something like below:
|
Thanks Diana . |
@neha2683, do you mean you want one REST API that calls 2000+ stored procedures, or 2000+ endpoints that each call one stored procedure? |
The latter one.... Procedure name and input parameters as inputs to one
Rest Api.
…On Tue, Apr 14, 2020, 9:52 PM Diana Lau ***@***.***> wrote:
@neha2683 <https://github.com/neha2683>, do you mean you want one REST
API that calls 2000+ stored procedures, or 2000+ endpoints that each call
one stored procedure?
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
<#5101 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AHGF7S7ADQCCYJ3NZWTQYALRMSESPANCNFSM4MG4RYRQ>
.
|
hello GET /_proc/{procedure_name} POST /_proc/{procedure_name} |
@neha2683, it would be something similar to what I posted in #5101 (comment). Controllers are used to expose REST APIs, so add those functions in the controller. |
@neha2683 please take a look at #3459
and https://loopback.io/doc/en/lb4/apidocs.repository.connector.execute.html |
Closing as resolved. |
Hello
Able to access the DB tables from MS SQL using loopback 4 .
Looking for options to expose only the Stored Procedures from the table , and expose them as Rest APIs . Kindly help. Thanks.
The text was updated successfully, but these errors were encountered: