Handling Multiple 'null values

[aditya_gupta41]

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. for all the null values, i need to pass value ‘0000-00-00’. The challenge which i am facing is this is dynamic. sometimes there are overall 28 fields ending with ‘_DATE’ and sometimes its more than 100.

[
  {
  "DEPRECIATIONAREAS": [
      {
        "ASSET": "00005000xxxx",
        "DEP_UNITS": 0,
        "O_START_DATE": "2006-09-01",
        "S_START_DATE": null,
        "INTEREST_START_DATE": null,
        "READINESS": "2006-08-31",
        "INDEX": "",
        "AGE_INDEX": "",
        "VAR_DEP_PORTION": 0.0000,
        "SCRAPVALUE": 0.0000,
		}
		]
	"POSTINGINFORMATION": [
      {
        "ASSET": "000050009142",
        "SUBNUMBER": "0000",
        "CAP_DATE": "2006-08-31",
        "DEACT_DATE": null,
        "INITIAL_ACQ": "2006-08-31",
        "INITIAL_ACQ_YR": 2006,
        "INITIAL_ACQ_PRD": 11,
        "PLRET_DATE": null,
        "PO_DATE": null,
        "CAP_KEY": ""
		}
		]
		}
		]

Can someone provide me a solution for this?

Thanks in Advance

[j_angelevski]

It didn’t because the first and second data source that you posted are completely different.
I updated my expression ( the only issue is that with the previous source, the data was on the root level, but on the new source, the data is within the “data” object ), please refer to the expression below:

{}.extend(...$data.entries().map(val => {[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]} )))}))

Here is the result:

[
   {
      "data":{
         "TIMEDEPENDENTDATA":[
            {
               "ASSET":"000050",
               "SUBNUMBER":"0000",
               "FROM_DATE":"1900-01-01",
               "TO_DATE":"9999-12-31",
               "W_DATE":"0000-00-00",
               "X_DATE":"0000-00-00"
            }
         ],
         "SELECTIONCRITERIA":[
            {
               "PARAMETER":"GENERALDATA",
               "FIELD":"ASSET",
               "SIGN":"I",
               "OPTION":"E",
               "LOW":"00005000",
               "HIGH":""
            }
         ],
         "REALESTATE":[
            
         ],
         "POSTINGINFORMATION":[
            {
               "ASSET":"0000502",
               "SUBNUMBER":"0000",
               "C_DATE":"2006-08-31",
               "DEACT_DATE":"0000-00-00",
               "PLRET_DATE":"0000-00-00",
               "PO_DATE":"0000-00-00",
               "CAP_KEY":""
            }
         ],
         "NETWORTHVAL":[
            
         ],
         "INVENTORY":[
            {
               "ASSET":"000050",
               "SUBNUMBER":"0000",
               "V_DATE":"0000-00-00",
               "W_DATE":"0000-00-00"
            }
         ],
         "INSURANCE":[
            
         ]
      }
   }
]

[aditya_gupta41]

Hi,

This still shows error:

Also, the $data is an object and inside that there are multiple arrays.

[j_angelevski]

I think the data that you are sharing and the data that you are working with are completely different. I suggest you to share the actual data that you are working with and if there is some sensitive information just replace it with “X” or something else, because what we need is the actual format of the data.

[aditya_gupta41]

Here is the json file. This is the actual output format.
mapping_SAP output output0.zip (1.6 KB)

[j_angelevski]

Okay, I can see that the last property is an object not an array, that’s why it is failing. I am referring to “EH_RETURN” in your data. Removing that object, the expression works. I will update my expression and give you a solution where it checks whether the property is an object or array, this was unexpected.