Calling Store Procedure via Script

@andrin you can try using executestoredprocedure function inside Web API httpResponse

Hi aloks178 thanks for your help, will try it first.

Hi @aloks178 ,

I'm trying to execute Stored procedure with param and it still failed,
Can you tell me how to do it.

local!spData: executestoredprocedure(
dataSourceName: "jdbc/Appian",
procedureName: "getallflatTable",
inputs :{15}
)

#### Result
{
"success" : true,
"error" : "",
"parameters" : { },
"result" : [ [ ] ]
}

Hi,
It solved using this script
local!spData: executestoredprocedure(
dataSourceName: "jdbc/Appian",
procedureName: "getallflatTable",
inputs :{{name: "premi", value: 15}}
)

@andrin happy to see that it worked.. :)