Preprocessor working but user attribut not update

[Yeya]

Hi team,

On a user import from a workday connector (soap)

I would like to update the user custom attribut 1 and 2 with the following request in the preprocessor :

"UPDATE NEWUSERDATA LEFT JOIN CURRENTUSERS ON NEWUSERDATA.USERNAME = CURRENTUSERS.USERNAME SET NEWUSERDATA.statuskey = IF( NEWUSERDATA.customproperty2 = 1, 1, NEWUSERDATA.statuskey )",

"UPDATE NEWUSERDATA LEFT JOIN CURRENTUSERS ON NEWUSERDATA.USERNAME = CURRENTUSERS.USERNAME SET NEWUSERDATA.customproperty1 = IF( NEWUSERDATA.statuskey = 1, 'Onboarded', 'Terminated' );"

In the log view it's working as expected

Proceed to Import for records - > [ville, Regular, null, Gael, Gael, xxx,xxx,xxx,FR_GROUPxx,xx, gl.c@mail.com, gl.c@mail.com, null, FRA, Cxx, gl.c@mail.com, Gx Cxxx, xxxxx, Onboarded, Ville, IT, Support, All Product l, XXX_Group, xxx, Company, Group ,Product ,Support, xxxxr, 1, null] : true

i have the data i want , but in my user the CP1 and 2 is not update.

Do you have any clues to help me solve this problem?
Thanks in advance

[Yeya · Accepted solution]

Sorry it's working now : 

Solution :

i forgot to put the Customproperty in the Table index current users

"TABLEINDEXES": {

        "CURRENTUSERS": [

            "USERNAME",

            "LASTNAME",

            "CUSTOMPROPERTY1",

            "CUSTOMPROPERTY2",

            "DISPLAYNAME",

            "STATUSKEY"

        ]

    },

thanks

[rushikeshvartak]

Please share full preprocessor JSON