Json

Parent Previous Next


Unpack Data Transform - Json Configuration



 Root Json Path - Json queries can return multiple levels, therefore, this field Identifies the root to be used.

 Unpacked Data Columns - Users can create, remove, and configure the name, index (zero-based), data type, length, precision, and scale of the columns being extracted or unpacked.


Using Wildcards (*)


The Unpack Data Transform allows for wildcards when arrays are returned. Example:
Using the Json Results below, the Root Json Path would be results[0].appInventory[*]. This information tells the component to use the array found at position "0." Because some child arrays do not have an object name, a wildcard or * can be used to return all child array objects.


{

   "results": [

       {

           "appInventory": [

               {

                   "name": "Sample name 1",

                   "identifier": "123",

               },

               {

                   "name": "Sample name 2",

                   "identifier": "456",

               },

               {

                   "name": "Sample name 3",

                   "identifier": "789",

               }

                               ]

               }

       ]

}