Nested JSON Iterate Using BFO

Mon Jul 04 2022 08:14:49 GMT+0000 (Coordinated Universal Time)

Saved by @mdfaizi

<#assign use =record.custbody1?eval>
    
    <#assign user ={
  "name" : {"ur":"fz","hi":"value"},"game":{"ur":"fz","hi":"value"}
 
}  >
      
<#list use?keys as prop>
  <#assign nsjson =use[prop]>
  <#list nsjson?keys as x>
    ${nsjson[x].employee}
</#list>
  </#list>

Nested JSON which is getting iterated by above code. { "Kashmira Mungale": { "0": { "employee": "Kashmira Mungale", "item": "ST Item", "quantity": "8", "rate": "200", "amount": "1600" }, "7": { "employee": "Kashmira Mungale", "item": "ST Item", "quantity": "7", "rate": "200", "amount": "1400" } }, "Ajay Singh": { "0": { "employee": "Ajay Singh", "item": "ST Item", "quantity": "5", "rate": "0", "amount": "0" }, "17": { "employee": "Ajay Singh", "item": "ST Item", "quantity": "7", "rate": "130", "amount": "910" }, "36": { "employee": "Ajay Singh", "item": "ST Item", "quantity": "4", "rate": "50", "amount": "200" }, "37": { "employee": "Ajay Singh", "item": "ST Item", "quantity": "6", "rate": "50", "amount": "300" } } }