Skip to main content
Nintex Community Menu Bar
Solved

Multiple Cols From a Sql Call

  • January 21, 2020
  • 1 reply
  • 19 views

In SP nintex there seems to be a way to retrieve multiple colums from a sql query. However with the cloud version there is only a singular column allowed:

6220i705E5FFFEB8076A7.png

 

Am I missing something obvious? Alternatively is it possible to call an API (i can write a wrapper around the db) or do I retrieve all of the cols needed in a comma seperated single field and then split it?

Best answer by butlerj

Hi Arch,

 

This currently is not doable in NWC, however there is a UserVoice topic that is open for voting, and it would be great if you could add your votes to it!

 

https://nintex.uservoice.com/forums/430063-5-nintex-workflow-cloud/suggestions/30942226-nwc-sql-queries-retrieve-multiple-columns

1 reply

butlerj
Nintex Employee
Forum|alt.badge.img+20
  • Nintex Employee
  • Answer
  • February 26, 2020

Hi Arch,

 

This currently is not doable in NWC, however there is a UserVoice topic that is open for voting, and it would be great if you could add your votes to it!

 

https://nintex.uservoice.com/forums/430063-5-nintex-workflow-cloud/suggestions/30942226-nwc-sql-queries-retrieve-multiple-columns