Skip to main content

Hello everyone,

 

I want to get a list of 3 objects inside a json file in the format bellow :

26862iD2A73D45B7E8FDA8.png

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 ?

Hi.



Try this tool.  



JSONPath Finder and Evaluator



It helped me a lot.



Ed



 


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 ?


  • 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,



    ^^


  • Reply