Solved

JSON Query

  • 21 October 2022
  • 3 replies
  • 158 views
G

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 ?

icon

Best answer by cecilia-penha 24 October 2022, 10:38

View original

3 replies

E
Badge +6

Hi.


Try this tool.  


JSONPath Finder and Evaluator


It helped me a lot.


Ed


 

G

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 ?

    • cecilia-penha
    Userlevel 3
    Badge +8

    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


    View our Community Site Map

    Nintex Community Sitemap
    Terms & ConditionsCookie settings