Skip to main content
Nintex Community Menu Bar

Collection after Query List

  • May 25, 2020
  • 3 replies
  • 74 views

After using the Query List Action I get the result with this format. {"Id":2447,"ID":2447}

Is there an action to parse it?

How should I use it?

 

 

3 replies

SimonMuntz
Nintex Employee
Forum|alt.badge.img+23
  • Nintex Employee
  • May 25, 2020
HI,

Use the For Each action to easily work on a collection variable.

Forum|alt.badge.img+4
  • May 27, 2020

nico
Forum|alt.badge.img+10
  • Rookie
  • May 28, 2020

In you query list action, in the parameter "output type" ,you have choose "Single output", if you just want the column ID, you should choose "Seperate output per column" to simply have an collection of IDs

 

With the parameter value "Single outup" you have a collection of Dictionnaray (and the dictionnary will contains values of each column of the item).

With the parameter value "Seperate output per column" you have a collection of your column values

 

If you want to know how to parse use dictionnary have a look at this:   https://community.nintex.com/t5/Nintex-for-Office-365/Get-value-from-Collection-derived-from-Lookup-List-Query/td-p/110880