I am using Execute SQL Action in Nintex Workflow and I need to get some data from an SQL database in Azure (it is a test database at the moment).
This action only allows me to get one column per query and I need more than one column to be retrieved. If I store the "Results in XML" in a collection or a dictionary variable, it always shows me the XML in an incorrect way (attached image):
My properties of the SQL Action are the follow:
Does anyone know if it is possible to get all the columns at the first time in a correct format?