Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-19214

JSON Input: "Is hidden filed" under Additional output field tab is not working as expected

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Urgent
    • Resolution: Fixed
    • Affects Version/s: 8.2.0.7 GA, 9.1.0 GA, 8.3.0.0, 8.3.0.22
    • Fix Version/s: 9.3.0 GA
    • Component/s: Step
    • Labels:
    • Environment:
      Windows
    • Story Points:
      0
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Sprint Team:
      Tatooine (Maint)
    • Steps to Reproduce:
      Hide

      Steps to replicate the issue:

      1. Use Pentaho Spoon 8.3 or 9.1
      2. Open the attached transformation and execute. CCL-PDI-S067601-106-L.ktr
      Show
      Steps to replicate the issue: Use Pentaho Spoon 8.3 or 9.1 Open the attached transformation and execute. CCL-PDI-S067601-106-L.ktr

      Description

      The transformation with the Json Input step having the "Is hidden field" set under the "Additional output field" tab is not working as expected.

      I have hidden .json file at the OS level(Right-click the file and select "Properties", Check "Hidden" on the properties screen)

      Actual Result:
      The value of the hidden field "hidden_field" was output as "N".

      Expected Result:
      The value of the hidden field "hidden_field" is output as "Y"

      Attaching the CCL-PDI-S067601-106-L transformation, JSON file, and text file.

      I have tested the same functionality with the Text File Input step and getting the expected result correct output

        Attachments

        1. CCL-PDI-S067601-106-L.ktr
          19 kB
        2. Hidden_field.PNG
          Hidden_field.PNG
          32 kB
        3. Hidden files.PNG
          Hidden files.PNG
          50 kB
        4. json(linux).PNG
          json(linux).PNG
          47 kB
        5. Json Input step.PNG
          Json Input step.PNG
          48 kB
        6. kakushi.json
          0.0 kB
        7. text.txt
          0.0 kB
        8. text filePNG.PNG
          text filePNG.PNG
          54 kB
        9. Text Input step.PNG
          Text Input step.PNG
          45 kB
        10. Validation_ubuntu.png
          Validation_ubuntu.png
          81 kB

          Activity

            People

            Assignee:
            gdavid Golda Thomas
            Reporter:
            mohshaik Mohamed Mujahid Shaik
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: