Hi, when i have a problem with null value, i use ‘get’ mehod - maybe try this one: value for Worksheet Name + '_' + $.get('date_of_this_report',' ') will solve your problem
The $.get() function is very useful but you should be extra careful when you’re using it. Example $.get(‘date_of_this_report’) will get the value of the field if the field is present in the incoming data, but if not, it will pass null as a value. The $.get('date_of_this_report',' ') will pass empty string if the field is not present, so is that what you need?
I believe the issue is in the streaming data. In one or multiple objects this field is missing. I would start from there.
Hi,
Unfortunately, this does not solve my issue.
@bojanvelevski, to answer your question, the field is always present in the incoming data and I don’t want to assign a null or pass an empty string. I replicate the pipeline this time using JSON generator. It is still throwing the same error.
