Click HERE to see how Saviynt Intelligence is transforming the industry. |
03/20/2024 08:44 AM
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
Solved! Go to Solution.
03/21/2024 02:38 AM - edited 03/21/2024 09:49 PM
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.
03/21/2024 08:01 PM
DELETE FROM NEWUSERDATA WHERE customproperty29 IS NULL OR TRIM(customproperty29) = '';
03/22/2024 01:14 AM
Thank Rushikesh and Sudesh for your responses. The issue was caused due to banlk spaces in few mandatory fields. Now its resolved.