KalEl
Novice

O365 Execute SQL - Multiple Columns

Jump to solution

My SQL query returns multiple columns , how do we configure them in Nintex o365 Execute SQl Action ? i am aware this can be done by specifying column names in on premise version. Want to know how to do it on O365.

Tags (2)
0 Kudos
Reply
1 Reply
butlerj
Community Manager
Community Manager

Re: O365 Execute SQL - Multiple Columns

Jump to solution

Hi @KalEl, currently the Execute SQL action for O365 does not support retrieving more than one column at a time. The best way to get around this is with a couple different Execute SQL actions, each grabing the different column values. Depending on how you then want to interact with that data, you could then either join collections, or query the XML for the values that you need in the workflow.

0 Kudos
Reply