Hello everyone,
I want to get a list of 3 objects inside a json file in the format bellow :
My results list contains 3 items but when I use "$..*" JSON expression to query all the items inside it returns me 34 elements as a result of a count am I missing something in the formula please ?
Best answer by cecilia-penha
Hi @grt_fi,
The path "$.d.results[*].Name" should work if you have a field "Name" within each row of the array. It is case sensitive.
You can test any Query JSON path from https://developer.nintex.com within Platforms Tools section.
As a result, you will have a collection of Names or the first Name if you configure the actions to get the first row.
Hope this helps,
^^
I just tried $.d.results[*].Name and it is returning in the query json 0 as a count of the output collection elements... Am I missing something in the query json ?
+8Hi @grt_fi,
The path "$.d.results[*].Name" should work if you have a field "Name" within each row of the array. It is case sensitive.
You can test any Query JSON path from https://developer.nintex.com within Platforms Tools section.
As a result, you will have a collection of Names or the first Name if you configure the actions to get the first row.
Hope this helps,
^^
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
