Execute SQL Action: Results in XML in bad format

  • 12 November 2019
  • 1 reply
  • 16 views
varo2812

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):

 

5533i23BADD8D3F5F1F67.png

My properties of the SQL Action are the follow: 

 

5534iF2527FBA5D810F89.png

Does anyone know if it is possible to get all the columns at the first time in a correct format?

1 reply

V
Userlevel 3
Badge +9
This looks like 2 bugs and you should open a case with Nintex.

1) It dropped all the open tags like the following:
<item>
<Codigo>
<Precio>

2) looks like it's doing carriage return, line feed column delimiters

The XML value in the Collection/Dictionary should have been:
<item><Codigo>1</Codigo><Precio>435.22</Precio></item>

When you execute the statement in SQL Management Studio do you get this output something like this?
Codigo Precio
---------- ---------
1 435.22

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings