Need to send null value in date field

[aibasu]

In the connection that I am creating I need to pass enddate or termdate if they are available . Otherwise "" or " " is getting accepted when I am trying to send using Postman . But in connector I am  facing the following problem :-

• While trying to include logic for space or blank it does not work and throws error . I even tried using $null in the quotes but it does not work

{\"objectTypeAttributeId\":\"214\",\"objectAttributeValues\":[{\"value\":\"${if(user.enddate==null && user.termdate ==null){\" \"}else if(user.enddate==null){user.termDate.format('yyyy-MM-dd')}else{user.enddate.format('yyyy-MM-dd')}}\"}]}

• Without logic of space it works correctly when enddate or termdate is available 

{\"objectTypeAttributeId\":\"214\",\"objectAttributeValues\":[{\"value\":\"${if(user.enddate==null){user.termDate.format('yyyy-MM-dd')}else{user.enddate.format('yyyy-MM-dd')}}\"}]}

Can anyone please help me with this ?

[NM]

Try this @aibasu 

{\"objectTypeAttributeId\":\"214\",\"objectAttributeValues\":[{\"value\":\"${if(user.enddate==null && user.termdate ==null){\"\"}else if(user.enddate==null){user.termDate.format('yyyy-MM-dd')}else{user.enddate.format('yyyy-MM-dd')}}\"}]}

[Raghu]

@aibasu  try below

{\"objectTypeAttributeId\":\"214\",\"objectAttributeValues\":[{\"value\":\"${user.enddate == null && user.termdate == null ? '' : (user.enddate == null ? user.termDate.format('yyyy-MM-dd') : user.enddate.format('yyyy-MM-dd'))}\"}]}

[rushikeshvartak]

{
"objectTypeAttributeId": "214",
"objectAttributeValues": [
{
"value": "${if(user.enddate == null && user.termdate == null) { '' } else if(user.enddate == null) { user.termdate.format('yyyy-MM-dd') } else { user.enddate.format('yyyy-MM-dd') }}"
}
]
}

[aibasu]

Hello All , 

Thanks a lot for trying to help me with this but none of the solutions are working as expected and are throwing errors .

Thanks !

[rushikeshvartak]

What is error

Could you kindly provide a detailed snapshot of the information extracted from the logs, encompassing errors and other pertinent functionality details encountered during the execution of this process? Your assistance in furnishing this information would greatly aid in the analysis and resolution of any issues .



‼️‼️⚠️Do not upload any attachments that contain sensitive information, such as IP Addresses, URLs, Company/Employee Names, Email Addresses, etc.⚠️‼️‼️