Hi everyone,
I'm trying to set the CUSTOMER of Users during their import.
I'm successfully being able to retrieve the respective customerkey, but I'm not able to set it using the MODIFYUSERDATAJSON as seen here:
{
"ADDITIONALTABLES": {
"USERS": "SELECT <... REDACTED ...> companyName,customer FROM USERS",
"CUSTOMER": "select CUSTOMERKEY, CUSTOMERNAME from CUSTOMER"
},
"COMPUTEDCOLUMNS": [
"customer"
],
"PREPROCESSQUERIES": [
<... REDACTED ...>
"UPDATE NEWUSERDATA SET CUSTOMER=(select CURRENTCUSTOMER.CUSTOMERKEY from CURRENTCUSTOMER where CURRENTCUSTOMER.CUSTOMERNAME=NEWUSERDATA.companyName)"
]
}I tested the later part of the equation, by setting a customproperty instead of CUSTOMER, and it calculates the correct customerkey.
I also assigned the User that is executing the import job the required permissions in one of its SAV Roles - See f1.png
Any clue where I can take a closer look?
The logs are not helping much either. They only show messages like
Customer Not found for entry : [User Data]
Cheers 🙂
