I have been failing repeatedly trying to create a Scripted Field that will break out nested JSON values as separate columns. (They are fields that indicate whether web traffic comes from a bot or spider) What am I missing?
The message looks like:
My code to true and return the first JSON object was:
> if (doc['message'].value != null) AND (doc['message.spiderOrRobot'].value != null) > return doc['message.spiderOrRobot'].value; > return '';
This column is always present, but is often NULL. I've tried writing in exceptions to handle it, but I keep getting failed shards.
I tried to follow this post's lead, but no luck yet: Scripted field conditionals failing (5 of 15 shards failed)