Mandatory attribute check in user import REST connection

[parthaghosh]

Hello Team,

We have a REST connection for user import from successfactor. Need to check few mandatory attributes for NULL and EMPTY string.
the MODIFYUSERDATAJSON is not working. in some condition its not importing any record, some condition its importing all.

DELETE from NEWUSERDATA where customproperty29 is null - Importing all

DELETE from NEWUSERDATA where customproperty29 is null or customproperty29 ='' - importing none

DELETE NU.* FROM NEWUSERDATA NU WHERE NU.customproperty29 IS NULL or NU.customproperty29 ='' - importing none.

can anyone advise, what should be a correct query to filder out the records with missing mandatory data,

regards,

partha

[sudeshjaiswal]

Hello @parthaghosh,

Please provide the values for cp29 and whats does it says in log.
Are you able to pass the null value via postman?

Thanks.

[rushikeshvartak · Accepted solution]

DELETE FROM NEWUSERDATA WHERE customproperty29 IS NULL OR TRIM(customproperty29) = '';

[parthaghosh]

Thank Rushikesh and Sudesh for your responses. The issue was caused due to banlk spaces in few mandatory fields. Now its resolved.