Forum Discussion

marenas's avatar
marenas
Contributor
4 years ago

Worksheet Writer - Cannot lookup a property on a null value

Hello! I am having an issue with the Worksheet Writer snap. As you can see below the Mapper snap has output value for $date_of_this_report field but when I map this to the Worksheet name, th...
SL12345's avatar
SL12345
New Contributor III
4 years ago

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

marenas's avatar
marenas
Contributor
4 years ago

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.