Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: JSON Output without 'Json bloc name'

  1. #1
    Join Date
    May 2011
    Posts
    14

    Default JSON Output without 'Json bloc name'

    Hi, I've tried every options I can for JSON Output, but I still can't get the (seemingly simple) JSON output I'm looking for.

    Input Rows:
    id = book13
    title = Unlucky For Some
    author = Bingo Man

    JSON Output:
    outputValue = {"":[{"id":"book13","author":"Bingo Man","title":"Unlucky For Some"}]}

    JSON Output (WANTED):
    outputValue = [{"id":"book13","author":"Bingo Man","title":"Unlucky For Some"}]

    This Pentaho doc.:
    http://wiki.pentaho.com/display/EAI/JSON+output
    ...seems to indicate that leaving 'Json bloc name' empty means it ignored and I'd get something like what I want above, but I still get the empty string at the start. Is this a bug that it's not ignored, or am I trying to achieve the simple but impossible?

    Thanks... AJ
    Name:  scratch.jpg
Views: 336
Size:  11.9 KB
    Attached Images Attached Images  

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    The documentation reflects the latest changes to version 5 without saying so.

    In my version 4.4 I configure JSON Output to emit a field and follow it with a JSON Input step accessing $.blocname to get the result you want.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    May 2007
    Posts
    128

    Default

    Bumping this - are we saying the docs are incorrect? I don't want a "bloc name" on my JSON...

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.