Hi, I want to execute a SQL query, is there any function like executestoredprocedure that is used to execute an sp?
I am trying to run a SQL query through the process model and trying to see the result of that query, so is there a way how to get the result of that select statement?
Can anyone please help?
Discussion posts and replies are publicly visible
Yes we have a smart service for that https://docs.appian.com/suite/help/22.3/Execute_Stored_Procedure_Smart_Service.html
If you want to query using SP https://docs.appian.com/suite/help/22.1/fnc_system_a_executestoredprocedureforquery.html
No i dont want to query using SP
Hi,
You can run your query but your output will be exported in the Excel sheet.For this you can use "Export SQL To Excel" smart service.Thank You.
And then you can use that excel anywhere in the system you want.
Why you are not using the cloud database or Appian query directly?
Can you explain what your use case is that you can't use the standard Query Entity query?
In any case, you could always look into the Query Database Smart Service, though I personally really dislike it and only use it when absolutely necessary (which is very rarely, in my experience).