BuildRowsetFromJson with a Complex JSON Sample

%%[
SET @json = '{"menu": {  
  "id": "file",  
  "value": "File",  
  "popup": {  
    "menuitem": [  
      {"value": "New", "onclick": "CreateDoc(a)"},  
      {"value": "Open", "onclick": "OpenDoc(b)"},  
      {"value": "Save", "onclick": "SaveDoc(c)"}  
    ]  
  }  
}}'

SET @rows = BuildRowsetFromJson(@json, '$.menu.popup.menuitem[*]', 1)
]%%
<table border=1>
  <tr><th>name</th><th>email</th></tr>
%%[FOR @i = 1 TO Rowcount(@rows) DO]%%
  <tr>
%%[FOR @c = 1 TO 2 DO]%%
    <td>%%=Field(Row(@rows,@i),@c)=%%</td>
%%[NEXT @c]%%
  </tr>
%%[NEXT @i]%%
</table>