Forum Discussion

Contributor

4 years ago

Solved

Handling Multiple 'null values

I am currently having this requirement where i need to handle all the null values coming in input. The common thing i noticed that all these values end with ‘_DATE’ but this is coming in an object. f...

aditya_gupta41

4 years ago

j.angelevski:

{}.extend(...$data.entries().map(val =>
	match typeof val[1] {
		"object" =>
				{
					[val[0]]: val[1].mapValues((v, k) => k.contains("_DATE") && v == null ? "0000-00-00" : v)
				},
		"array" =>
				{
					[val[0]]: val[1].map(v => {}.extend(...v.entries().map(date => date[0].contains("_DATE") && date[1] == null ? {[date[0]]: "0000-00-00"} : {[date[0]]: date[1]} )))
				}
	}
))

This works. Thanks for your help @j.angelevski

aditya_gupta41

Contributor

4 years ago

This too is getting error:

failure:

“Map type does not have a method named: map, found in: …-00-00” : v1 )). Perhaps you meant: mapKeys, mapValues"

bojanvelevski

Valued Contributor

4 years ago

Well, that means that the fields TIMEDEPENDENTDATA,SELECTIONCRITERIA, etc. are objects, not arrays like in the sample you sent.

Forum Discussion

Handling Multiple 'null values

Recent Discussions

Generate expression file from database query

Can we generate XML file in pretty print format using native snapLogic snaps?

401 error with HTTP Client and NTLM

Pagination and nextCursor in header

Javascript to promote top level lists