Send Empty string or null value to ServiceNOW

Hi All,

We have a requirement to send empty string or blank value for END date attribute to SNOW via attribute sync. I am trying to populate empty string for Identity attribute (used for sync) using below transform which is working as expected. But the value is not getting updated in SNOW when the sync is happening.

Is this something SailPoint is failing, or SNOW is not accepting the value?

{
    "name": "",
    "type": "firstValid",
    "attributes": {
        "values": [
            {
                "type": "dateFormat",
                "attributes": {
                    "input": {
                        "type": "accountAttribute",
                        "attributes": {
                            "sourceName": "",
                            "attributeName": "INACTIVE_DATE"
                        }
                    },
                    "inputFormat": "dd-MM-yyyy",
                    "outputFormat": "yyyy-MM-dd"
                }
            },
            ""
        ],
        "ignoreErrors": true
    },
    "internal": false
}

Hello @JackSparrow

Have you checked the Sync Activity Status ? Is it successful ? If it is successful , the SNOW Attribute should be empty string , if not is not , it issue from SNOW end . If the sync event is failed , you will be able to understand the issue from SP end why it failed .

HI @sidharth_tarlapally ,

Event is getting passed. I suspect the issue is from SNOW end.

@JackSparrow

I can see the AttributeValue is treated as null but not as an emptyString . while both might lead to similar visual outcomes , they are technically different . Check if the SNOW attribute can accept null values . If Not , using a String value like “NA” instead if empty string might help .

SNOW will not accept “NA” as well as its the “date” attribute. I’ll check with SNOW team and see what values it can accept.

To me this looks like a mapping issue from staging table to sys_user table on SNow side. Probably they have not added the logic to capture null value

1 Like

Thanks @iamology, ServiceNow team is not ready to change anything from their end. We have SP architect session to discuss this. Will keep posted here.

Hi @mcheek, Is this something you can help me here