topic Re: Check JSON for empty values in Talend Studio

Check JSON for empty values

root — Fri, 23 Mar 2018 19:16:03 GMT

How can I validate if the JSON object is not empty? Currently, I am processing the data[] array and it is inserting values in DB. If its a blank, then, it inserts a NULL. How can I achieve this?

Correct JSON:

{
	"RESULT_1": {
		"data": [
			["0", null, "12345", "other"],
			["1", "a", "54321", "MA"],
			["0", null, "76543", "RI"]
		]
	}
}

Empty JSON:

{
	"RESULT_1": {
		"data": [		]
	}
}

Thanks!

Re: Check JSON for empty values

Anonymous — Thu, 29 Mar 2018 09:48:02 GMT

Hello,

Have you tried to replace your empty/null field with "Null" string?

Such as:

output_row.output = input_row.output.replaceAll(",\"[a-zA-Z][a-zA-Z]*\":\\[\\]", "Null"); in tJavaRow.

Best regards

Sabrina

Re: Check JSON for empty values

root — Mon, 02 Apr 2018 13:58:51 GMT

@xdshi:
Thanks for your reply. So, this will essentially check [] and if it does not contain anything, mark it null?

Re: Check JSON for empty values

Anonymous — Tue, 03 Apr 2018 03:53:37 GMT

Hello,

It will check empty values in your JSON file.

Best regards

Sabrina

Re: Check JSON for empty values

root — Fri, 06 Apr 2018 16:44:31 GMT

Thank you!