Skip to main content
S
shubhamy3376
Known Participant
August 24, 2023
Question

Procedure smart service

  • August 24, 2023
  • 6 replies
  • 6 views

Hi Everyone,

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

    6 replies

    shivikav3298
    shivikav3298
    Participating Frequently
    August 24, 2023

    Hi Rahul,

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

    S
    shubhamy3376Author
    Known Participant
    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
    Participating Frequently
    August 24, 2023

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

    Terms & ConditionsAccessibility statement