03/22/2023 10:56 AM
Hello,
We have a SOAP Connector and under SOAP connector when we're using ModifyUserDataJSON we are getting the following error
Error in Users Import - Error while processing data: Column count doesn't match value count at row 1 |
The ModifyUserDataJSON is as follows,
{
"ADDITIONALTABLES": {
"USERS": "SELECT username, CUSTOMPROPERTY45 from USERS WHERE USERNAME LIKE 'a36803%'"
},
"COMPUTEDCOLUMNS": [
"CUSTOMPROPERTY45"
],
"TABLEINDEXES": {
"currentusers": [
"username"
]
},
"PREPROCESSQUERIES": [
"UPDATE NEWUSERDATA LEFT JOIN CURRENTUSERS ON NEWUSERDATA.USERNAME=CURRENTUSERS.USERNAME SET NEWUSERDATA.CUSTOMPROPERTY45 = 'Licensed Status' "
]
}
and this is our UserMapping under HR_IMPORT_JSON
"USERMAPPING1": "FIRSTNAME:FirstName,LASTNAME:LastName,USERNAME:UserName,EMAIL:EmailAddress,STATUSKEY:Status"
When we remove the ModifyUserDataJSON and run the job we are able to see the updates.
Any suggestion on how we can overcome this?
Solved! Go to Solution.
03/22/2023 02:02 PM
Can you try with the below ModifyuserdataJSON
{
"ADDITIONALTABLES":{"USERS": "SELECT username, CUSTOMPROPERTY45 from USERS'"},
"COMPUTEDCOLUMNS": ["CUSTOMPROPERTY45","USERNAME"],
"TABLEINDEXES": {
"currentusers": ["username"]
},
"PREPROCESSQUERIES": ["UPDATE NEWUSERDATA SET NEWUSERDATA.CUSTOMPROPERTY45 = 'Licensed Status' where NEWUSERDATA.username like 'a36803%'"]
}
03/27/2023 04:19 AM - edited 03/27/2023 04:20 AM
In out HR_IMPORT_JSON,
I removed the 'TEMP MAPPING' that we initially had and we got it working.
Thanks for your suggestions