Configuring the tExtractJSONFields component

About this task

The tExtractJSONFields component lets you get more readable data so you can easily filter them using the tFilterRow component.

Select Built-In as Property Type and Schema.
Click [...] next to Edit schema.
The INVALID_STATUS column has been added to the input schema. You can rename the column in the output schema.
Select JsonPath and the API version 2.1.0.
Enter the wildcard * in the Loop Jsonpath query field to select all elements.
Select INVALID_STATUS from the JSON Field drop-down list.
Define the JSON query in the Mapping table.
The columns in the schema are listed in the Column field of the Mapping table.
In the Json query column of the Mapping table, enter executionResults[0].status for Status.
executionResults[0].status is the path to status where [0] represents the execution details of the first rule. If you need the execution details of the second rule, use [1], of the third rule, use [2] and so on. This makes easier to filter the data using the tFilterRow component.

Example
The INVALID_STATUS is: [{"executionResults":[{"ruleName":"ScholarshipProgram_Else","inputColumn":["EffectiveOn","Code","Program"],"status":"Invalid"}]}].
tExtractJSONFields transforms it into Invalid.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!