Currently the PDI Json Output step only allows you to create a fairly flat Json structure, but this was fine for this specific use case:
For my Pentaho Sparkl Project Bissol Table Data Editor (available via the Pentaho Marketplace on the BA Server) I needed some way to convert rows to Json and send a stringified version of it to the frontend.
We can use the Json Output step for this:
By default the output Nr rows in a block value is set to 1:
… which basically works on a row by row basis. The output is something like this:
Not quite what I had in mind … I just wanted one output. To achieve this, you can just set Nr rows in a block to 0:
… and all your rows will be flattened to one output element: