Hi @sampath18 and @gauravchandok,
Sorry I've been busy and didn't have a chance to reply earlier, I'll try to answer your questions 🙂
So are you using Preprocess queries in the modify user json filed and it is invoked during importuser json of SAV4SAV connection?Do you mind sharing sample queries you have written this requirement?
@sampath18 - yes, I'm using pre-processor supported via the MODIFYUSERDATAJSON described here and in importUserJson I'm getting the users that need updating (we can identify them as they have customproperty59='Invite' and customproperty13 is null - where Azure ID should be) . Here is the code sample:
{
"connection": "acctAuth",
"url": "https://SAVURL/ECM/api/v5/getUser",
"httpMethod": "POST",
"httpHeaders": {
"Authorization": "${access_token}",
"contentType": "application/json"
},
"httpParams": "{\"userQuery\":\"statuskey = 1 and customproperty13 is null and customproperty59='Invite'\",\"max\":\"1000\"}",
"httpContentType": "application/json",
"colsToPropsMap": {
"username": "username~#~char"
},
"userResponsePath": "userdetails",
"pagination": {
"offset": {
"offsetParam": "offset",
"batchParam": "max",
"batchSize": 1000,
"totalCountPath": "completeResponseMap.total"
}
}
}
And in MODIFYUSERJSON I have the following query where customproprety2 (azure ID that we get from the response when we're inviting users to the AAD tenant) from account is copied to users customproperty13:
{"ADDITIONALTABLES": {"USERS": "select username, userkey from users where customproperty11 is null and customproperty59='Invite'","ACCOUNTS": "select accountkey, accountid, customproperty2,endpointkey from accounts where endpointkey=8 and customproperty2 is not null","USER_ACCOUNTS": "select ua.userkey, ua.accountkey from USER_ACCOUNTS ua inner join ACCOUNTS a on ua.accountkey = a.ACCOUNTKEY where a.endpointkey=8"},"COMPUTEDCOLUMNS": ["customproperty13"],"PREPROCESSQUERIES": ["UPDATE NEWUSERDATA nu left join CURRENTUSERS cu on nu.username = cu.username inner join currentuser_accounts ua on cu.userkey=ua.userkey inner join currentaccounts a on ua.accountkey=a.accountkey set nu.customproperty13=a.customproperty2"]}
@gauravchandok now it will skip the users processed in previous import when you run this import again... right? - well yes because users that were processed don't fit in the conditions of the user query, they already have a value in customproperty13.
