Set user attribute as NULL via Saviynt REST API - updateUser

[Sivagami]

Hi Team,

I'm trying to use update user API to set certain customproperty value of user table to NULL - https://documenter.getpostman.com/view/1797923/TVsvi7G2#5e6acb36-5804-4301-bda3-9cf3ba14c402

Instead of mapping null sent in rest API to NULL for the column value in DB, the system is updating it to string value null

When trying to update it as blank value via API, user customproperty is updated as blank value as well & not NULL

I want the attribute to be set as NULL via API. Please confirm how to pass the value in API so that the specific user attribute is set as NULL in DB.

-Siva

[rushikeshvartak]

‘NULL’

[Sivagami]

@rushikeshvartak - This will set string value NULL as column value

[dgandhi]

What is the issue you see when you pass Cp7 as "" in the postman from API call?

Internally in MySQL it will stored as NULL and can be retrieved from SQL query using like  CP7 =''

Thanks

[Sivagami]

@dgandhi - CP7=NULL and CP7='' are not same. Since API updates CP7='' in DB, in all the rules or condition I need to add condition as CP7=''. So everywhere 2 conditions needs to be added CP7='' or CP7 is NULL to trigger needed rules as update from other source maps CP7 properly to NULL in DB.