Stored Procedures / Functions from Azure SQL DB


#1

Is there anything special I need to do to use the Rest API for my Azure SQL DB stored procedures and functions? I’m running version 2.1.

I have no issues with standard sql query URLs like this:

http://< server >/api/v2/< app >/_table/< table >?limit=10&api_key=< apikey >

I and see a list of stored procedures with this url

http://< server >/api/v2/< app >/_proc?as_list=true&api_key=< apikey >

…but If I try to run any functions or stored procedures with urls like these

http://< server >/api/v2/< app >/_func/< function >?param=value&api_key=< apikey >
http://< server >/api/v2/< app >/_proc/< procedure >?param=value&api_key=< apikey >

I get errors that start with this below - Full error page is online here

"error": {
"context": null,
"message": "Failed to call database stored procedure.\nSQLSTATE[HY000]: General error: 201 General SQL Server error: Check messages from the SQL Server [201] (severity 16) [(null)]",
"code": 500,
"trace": [
"0 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-sqldb/src/Resources/StoredProcedure.php(154): DreamFactory\\Core\\SqlDb\\Resources\\StoredProcedure->callProcedure('StationArtists', Array, NULL, NULL, NULL)",
"1 [internal function]: DreamFactory\\Core\\SqlDb\\Resources\\StoredProcedure->handleGET()",
"2 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(267): call_user_func(Array)",
"3 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(173): DreamFactory\\Core\\Components\\RestHandler->processRequest()",
"4 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(220): DreamFactory\\Core\\Components\\RestHandler->handleRequest(Object(DreamFactory\\Core\\Utility\\ServiceRequest), 'StationArtists')",
"5 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Services/BaseDbService.php(119): DreamFactory\\Core\\Components\\RestHandler->handleResource(Array)",
"6 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(168): DreamFactory\\Core\\Services\\BaseDbService->handleResource(Array)",
"7 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Services/BaseRestService.php(65): DreamFactory\\Core\\Components\\RestHandler->handleRequest(Object(DreamFactory\\Core\\Utility\\ServiceRequest), '_proc/StationAr...')",

#2

I’m still looking for answers about this and would appreciate any reply.

One more thing about this is that this url

http://< server >/api/v2/< app >/_proc?ids=< proc1 >&api_key=< apikey >

Returns the same list of stored procedures as this url

http://< server >/api/v2/< app >/_proc?as_list=true&api_key=< apikey >

And in both cases, it’s a list of stored procedures I cannot access with dreamfactory in any way, shape or form, without any hints about this missing functionality detailed in any of dreamfactory’s documentation.