Json Properties

Task Factory ›› Data Flow Components ›› Sources ›› Rest ››
Parent Previous Next


Json Properties Configuration



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

  Output Columns -  In this window, users can add and remove columns, define their name, token path (defined within the raw data), data type, length, precision, scale, and code page.  


Using Wildcards (*)


The Rest Source 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",

               }

                               ]

               }

       ]

}


Important Note

Columns that use DT_STR and DT_WSTR will return empty string values when the data returns no value. Columns that contain other datatypes will convert the empty string values to NULL.