AnsweredAssumed Answered

Split JSON File on multiple Fields

Question asked by blake.lassiter285843 on Jul 13, 2016
Latest reply on Jul 14, 2016 by Pavan_Sirasanambedu

When the output of an operation produces a JSON file that has multiple arrays of objects, can they be split on each object in each array? If a split is not appropriate, what would be the correct way to do this? I just want to capture the values from the JSON file in a flat file, preferably. Also, I would like to only output certain fields, which I believe, would require a mapping. I have no need for the types for the array or object to be saved, just the type and value of the fields.

 

For example, given one document:

 

"signers": [

    {

      "tabs": {

        "signHereTabs": [

          {

            "name": "Sign Here",

            "value": "1.0",

            "font": "calibri"

          }

        ],

        "dateSignedTabs": [

          {

            "name": "Date Signed",

            "value": "2016-07-13T15:18:21.0000000Z",

            "font": "Calibri"

          }

        ],

"textTabs": [

          {

            "name": "Street Address",

            "value": "123 mockingbird lane",

            "font": "Calibri"

          },

          {

            "name": "City",

            "value": "city",

            "font": "Calibri"

          }

   ]

}

 

can I produce 4 separate files: (note font is not included)

1)

name: "Sign Here"

value: "1.0"

2)

name: "Date Signed"

value: "2016-07-13T15:18:21.0000000Z"

3)

name: "Street Address"

value: "123 mockingbird lane"

4)

name: "City"

value: "city"

Outcomes