Getting Error while using Sav file using preprocessor query

[psrimanth]

Hi Team,

we are working on schema import and we created the sav file in the same sav file we are using to modify user JSON, when we are running the job getting the below error.

Error in Users Import - Exception in parsing MODIFYUSERDATAJSON: Error parsing JSON

Sav file:

#USER_NOT_IN_FILE_ACTION=NOACTION
#FILENAME=OneCard_Card_User
#DELIMITER=,
#SKIP_NUMBER_OF_LINES=1
#ZERODAYPROVISIONING=TRUE
#userReconcillationField=systemUserName
#GENERATESYSTEMUSERNAME=FALSE
#GENERATEEMAIL=FALSE
#CHECKRULES=TRUE
#MODIFYUSERDATAJSON={
"ADDITIONALTABLES": {
"USERS": "SELECT USERNAME FROM USERS"
},
"COMPUTEDCOLUMNS": [
"USERNAME","customproperty8"],
"PREPROCESSQUERIES": [
"DELETE NU FROM NEWUSERDATA NU WHERE NU.USERNAME not in ( select USERNAME from USERS)"
]
}

Please let me know if anything I am missing. it's a little bit urgent.

Thanks in Advance

[rushikeshvartak · Accepted solution]

#USER_NOT_IN_FILE_ACTION=NOACTION
#FILENAME=OneCard_Card_User
#DELIMITER=,
#SKIP_NUMBER_OF_LINES=1
#ZERODAYPROVISIONING=TRUE
#userReconcillationField=systemUserName
#GENERATESYSTEMUSERNAME=FALSE
#GENERATEEMAIL=FALSE
#CHECKRULES=TRUE
#MODIFYUSERDATAJSON={"ADDITIONALTABLES":{"USERS":"SELECT USERNAME FROM USERS"},"COMPUTEDCOLUMNS":["USERNAME","customproperty8"],"PREPROCESSQUERIES":["DELETE NU FROM NEWUSERDATA NU WHERE NU.USERNAME not in (select USERNAME from USERS)"]}