đź‘‹ Use this site to provide feedback and ideas for all Nintex Products. See our post on Nintex Community "Welcome to Nintex Ideas" for more details on Nintex Ideas, how an idea is handled by our product teams and more!
If you have questions about Nintex Ideas, please contact ideas@nintex.com
If you require support, please visit Nintex Customer Central
If you have a sales inquiry, please contact sales@nintex.com
It would be great if I could perform a lookup against a Nintex Data table variable without having to run a query every time.
For example, let's say I query my table for records meeting some criteria. The ONLY way for me to obtain a value from that data lookup is to loop through it. So, you can find yourself looping through that Data Lookup just to find the data you need, then exit.
What I would love is a way to do a lookup.
Pull Table into Workflow using the existing Query Action
Perform some Lookup - Retrieve value from a specified column, by searching a specified column
This would work the same way as a List Lookup in RPA LE/Foxtrot.
For more information, here is how I was able to get around this limitation:
1. Run a RegEx on the 'Rows' from a table
Operation = Replace
Pattern = (?<=\[|,)"(?=\{)|(?<=\})"(?=,|\])|\\(?=")
Replacement Text = an empty variable
Store first result = rowJSON variable
2. Query JSON
JSON Source= rowsJSON variable
JSONPath = $[?(@.apiNameOfTheFieldSearching == 'valueToSearch')].apiFieldNameToReturn