Skip to main content
Nintex Community Menu Bar
Solved

JSON Query

  • October 21, 2022
  • 3 replies
  • 250 views

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 ?

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,


    ^^

  • View original
    Translate

    Forum|alt.badge.img+6
    • Rookie
    • October 21, 2022

    Hi.


    Try this tool.  


    JSONPath Finder and Evaluator


    It helped me a lot.


    Ed


     

    Translate

    • October 22, 2022

    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 ?

  • Translate

    cecilia-penha
    Nintex Employee
    Forum|alt.badge.img+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,


    ^^

  • Translate

    Reply


    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie Settings