Skip to main content
S
shubhamy3376
August 24, 2023
Question

Procedure smart service

  • August 24, 2023
  • 6 replies
  • 0 views

Hi Everyone,

Is there any alternative to the executive stored procedure smart service which is depricated?

    6 replies

    shivikav3298
    shivikav3298
    August 24, 2023

    Hi Rahul,

    You can use a!executeStoredProcedureForQuery or a!executeStoredProcedureOnSave functions instead in Appian 22.1 or later.

    S
    shubhamy3376Author
    August 24, 2023

    [mention:7e3efee43ee74b04b3e3e3d1f3c4c546:e9ed411860ed4f2ba0265705b8793d05], can we use a!executeStoredProcedureOnSave function in process model script task? I cant use a!executeStoredProcedureForQuery function since the stored procedure is updating and inserting the data as well. 

    shivikav3298
    shivikav3298
    August 24, 2023

    No, we can only call it in saveInto of a component or as part of Web API.

    Terms & ConditionsAccessibility statement