JSON Composer validation rules
By default, the JSON Composer uses Minimal validation, and the job fails if a violation occurs. To customize validation, specify the action to perform when a violation occurs.
The following tables describe the validation rules and the applicable actions.
Rule | Description | Actions |
---|---|---|
Data type has illegal value | The value must conform to the value rules for the data type of the corresponding item. |
|
Trim values | Trim the white space before and after a value before performing type checking and type conversion. |
|
Output JSON elements for null values | If the data is null for one of the columns that is an element in the JSON
schema, that element that has a null value is listed in the output schema file when composed. This happens only when the JSON schema also has a null value to the corresponding element during the schema import. The input elements having null values will not be written to the generated JSON file irrespective of the validation value. |
|