Skip to main content
Known Participant
Aug 24, 2023 7:17 AM UTC
Question

Procedure smart service

Hi Everyone,

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

    6 replies

    shivikav3298
    Participating Frequently
    Aug 24, 2023 8:23 AM UTC

    Hi Rahul,

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

    Known Participant
    Aug 24, 2023 9:54 AM UTC

    [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
    Participating Frequently
    Aug 24, 2023 10:05 AM UTC

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