question How to check if JSON content is null (or empty)? in Support Questions

How to check if JSON content is null (or empty)?

rosa_negra — Wed, 07 Aug 2019 15:26:43 GMT

HI All,

does anybody know how to check if the content of the file is null or empty? (JSON for example)?

Thanks,

Nera

Re: How to check if JSON content is null (or empty)?

justenji — Wed, 07 Aug 2019 15:46:10 GMT

Hi @Rosa Negra

I only have experience concerning JSON.

In my opinion it depends what the content looks like.

If the content of an empty JSON is [ ] the flowfile disappears when I do a SplitJson with JsonPath Expression value $.

If the content looks like this [ { } ] I check with RouteOnContent on this (^\[\{\}\]) and filter the file out.

Re: How to check if JSON content is null (or empty)?

rosa_negra — Sat, 17 Aug 2019 23:18:04 GMT

@ Justen my JSON file is being converted to null (file size iz 4bytes) after wrong JOLT is applied.

So, when I open the JSON it's litterally 'null'. There are no brackets.. just null.

Re: How to check if JSON content is null (or empty)?

justenji — Wed, 07 Aug 2019 15:55:05 GMT

@Rosa Negra
In this case I would use RouteOnContent to check null and maybe additionally check filesize to be on the safe side.

Re: How to check if JSON content is null (or empty)?

rosa_negra — Sat, 17 Aug 2019 23:17:56 GMT

@ Justen i believe this is the answer:

Thanks!

Re: How to check if JSON content is null (or empty)?

rosa_negra — Sat, 17 Aug 2019 23:17:48 GMT

@Justen Thanks!

Re: How to check if JSON content is null (or empty)?

ask_bill_brooks — Thu, 08 Aug 2019 01:53:52 GMT

The above question and the entire response thread below were originally posted in the Community Help track. On Wed Aug 7 18:53 UTC 2019, a member of the HCC moderation staff moved it to the Data Ingestion & Streaming track. The Community Help Track is intended for questions about using the HCC site itself.

Re: How to check if JSON content is null (or empty)?

krunal_lathiya — Mon, 17 Aug 2020 10:30:06 GMT

To check null in JavaScript, use triple equals operator(===) or Object is() method. If you want to use Object.is() method then you two arguments.

1) Pass your variable value with a null value.

2) The null value itself.

To find the difference between null and undefined, use the triple equality operator or Object is() method.

To loosely check if the variable is null, use a double equality operator(==). The double equality operator can not tell the difference between null and undefined, so it counts as same. So if you want to strict check, then don't use a double equality operator. It will lead to misconclusion.