Recreate the BuildRowsetFromJson Documentation Usage Example

BuildRowsetFromJson Documentation Sample

%%[
SET @json = '{"Flights": [{"Origin": "IND","Dest": "NYC","Price": 100.0},{"Origin": "IND","Dest": "LAX","Price": 200.0},{"Origin": "IND","Dest": "SEA","Price": 500.0,"PerBagSurcharge": 25}]}'
SET @rows = BuildRowsetFromJson(@json, '$.Flights[*]', 1)
]%%
<table border=1>
  <tr><th>Origin</th><th>Dest</th><th>Price</th><th>PerBag Surcharge</th></tr>
%%[FOR @i = 1 TO Rowcount(@rows) DO]%%
  <tr>
%%[FOR @c = 1 TO 4 DO]%%
    <td>%%=Field(Row(@rows,@i),@c)=%%</td>
%%[NEXT @c]%%
  </tr>
%%[NEXT @i]%%
</table>