Database Connection Stored Procedures

[rrsummer]

Are we able to do this with Saviynt DB connections? 
{
"CreateAccountQry": [
"DECLARE @ddate datetime
SET @ddate = getdate()
DECLARE @return_value int
EXEC @return_value = [dbo].[<stored procedure>]

I've been getting a "Error parsing JSON" when the task is trying to provision for the users account. If so, do you have any examples of it working? The documentation often is for very simple database connections.

[pruthvi_t]

Hi @rrsummer .

Greetings,

Please refer to the below sample json where the stored procedure is being called in createaccount json.

{

"CreateAccountQry": [
"call <stored procedure name>('${task.accountName}','${user.firstname}','${user.lastname}','${user.email} ','1','${user.title}','','','${user.phonenumber}','','${user.city}','','','${user.country}','${user.owner}')"
]

}

Here, the stored procedure name is being called and the parameters that are defined at stored procedure are being sent in the call. Hope this helps.

Thanks,