a!buttonWidget to execute various functions

Certified Associate Developer

Hello, 

When I press a button right now it generates a excel file but I want at the same time to generate the excel file and also execute stored procedure, is there such a way, with one click of the button ?

a!buttonArrayLayout(
a!buttonWidget(
label: "Excel",
saveInto: {
a!exportDataStoreEntityToExcel(
entity: cons!BBO_OpportunitiesReportExcelDataStore,
documentName: "Excel Export " & now(),
saveInFolder: cons!BBO_ReportsFolderPointer,
onSuccess: a!save(
local!exportDocId,
fv!newDocument,
),
/*This displays an error if there is an issue executing the the save*/
onError: a!save(
local!errorMessage,
"Error Exporting File to Excel"
)
),
a!save(
local!staussave,
true
),
}
)
)

And this is the stored procedute code: 

executestoredprocedure(
dataSourceName: "jdbc/Appian",
procedureName: "deleteOppExcelData"
),

  Discussion posts and replies are publicly visible