Validate JSON Object

root — Tue, 27 Mar 2018 19:59:49 GMT

I have the following JSON object coming from a web-service. I need to perform some validations on the object before consuming it.

I need to ensure that it contains
- RESULT_1
- RESULT_2
- RESULT_15
Set an exception/ warning if the data array is empty (like RESULT_15)

What is the best way to achieve this? I could not find any validation information I can plug into tExtractJsonFields component.

Any help is appreciated. Thank you.

{
	"RESULT_1": {
		"columns": ["col1", "col2", "col3", "col4"],
		"data": [
			["0", null, "12345", "other"],
			["1", "a", "54321", "MA"],
			["0", null, "76543", "RI"]
		]
	},
	"RESULT_2": {
		"columns": ["c1", "c2", "c3", "c4"],
		"data": [
			["", "", "1877", "9"],
			["NULL", "Yellow", "1983", "2"],
			["NULL", "Red", "1981", "0"]
		]
	},
	"RESULT_15": {
		"columns": ["c1", "c2", "c3", "c4"],
		"data": [
			
		]
	}
}

topic Validate JSON Object in Talend Studio

Validate JSON Object