Pentaho Data Integration: Rows to Json Output

  11 Nov 2014

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:

comments powered by Disqus