Stored Procedure GrantAccess Json Issue

[mahammed_raffi]

Hi Team, 

Through the createAccount JSON (DB Connector), we are creating the account in the Target DB. As soon as the createAccount process is successful, the respective stored procedure generates the ClientID and UserID as outputs, which are then stored in the database itself. 

Now, the requirement is to pass the already generated ClientID and UserID (created through createAccount) values in the GrantAccess JSON. Please let us know if you have any ideas or logic to achieve this scenario. The app team mentioned that they can update the stored procedure to provide these two values as OUT parameters. Can Saviynt accept OUT parameters?

Thanks,

Rafi

[NM]

@mahammed_raffi currently mapping response isn't supported.

[rushikeshvartak]

• Stored Procedure OUT parameters are not supported.
• Ask app team to update stored procedure such that it internally select query and find that information