3 Replies Latest reply on Jul 31, 2020 7:38 AM by kiran koppula

    Json file creation using Hierarchy builder transformation

    kiran koppula New Member

      I am trying to create a json file output but each record from the relational table is created in a seperate array

       

      The Output which I want to see is

      ---------------------------------------------

      {

        "Employees": [

          {

            "userId": "224",

            "jobTitle": "manager",

            "firstName": "john",

            "lastName": "king"

          },

          {

            "userId": "123",

            "jobTitle": "clerk",

            "firstName": "jose",

            "lastName": "henning"

          }

        ]

      }

       

      I have used the above json to create the schema

       

       

      After execution of mapping the final output which I am having is

       

      {  "Employees": [

          {

            "userId": "224",

            "jobTitle": "manager",

            "firstName": "john",

            "lastName": "king"

          }

      ] }

       

      {

        "Employees": [

          {

            "userId": "123",

            "jobTitle": "clerk",

            "firstName": "jose",

            "lastName": "henning"

          } ] }

       

      What should I do to get the first output i.e. get all the records in  a single  array