We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

SAV4SAV REST Connection - Error while importing users and updating CP18 to null

krecpond
New Contributor III
New Contributor III

I am trying to import users for SAV4SAV REST endpoint using a REST connection. My import user json is as follows:

{
"call": [{
"connection": "acctAuth",
"url": "https://access-qa.<<companyname>>.com/ECM/api/v5/user?q=accountExpired:0&fields=username,customproperty18&sort=username&order=desc&offset=0&max=500",
"httpMethod": "GET",
"httpContentType": "application/json",
"httpHeaders": {
"Authorization": "${access_token}"
 
},
"colsToPropsMap": {
"username": "username~#~char",
"customproperty18": "customproperty18~#~char"
}
}]
}
 
As part of the user import, I have preprocessor configured to get a list of users who have an account on another endpoint and matches CP18. These are the users for whom CP18 needs to be cleared during import.
 
{
"ADDITIONALTABLES": {
"USERS": "SELECT U.USERNAME, IFNULL(U.CUSTOMPROPERTY18,'') FROM USERS U INNER JOIN USER_ACCOUNTS UA ON U.USERKEY = UA.USERKEY INNER JOIN ACCOUNTS A ON UA.ACCOUNTKEY = A.ACCOUNTKEY WHERE A.ENDPOINTKEY IN (SELECT ENDPOINTKEY FROM ENDPOINTS WHERE ENDPOINTNAME = 'UCADMIN') AND A.STATUS NOT IN ('SUSPENDED FROM IMPORT SERVICE') AND U.CUSTOMPROPERTY18 = A.NAME AND U.USERNAME IN (SELECT NAME FROM ACCOUNTS WHERE ENDPOINTKEY IN (SELECT ENDPOINTKEY FROM ENDPOINTS WHERE ENDPOINTNAME = 'UCADMIN-PRE-AUTHORIZATION') AND STATUS NOT IN ('SUSPENDED FROM IMPORT SERVICE'))"
},
"COMPUTEDCOLUMNS": ["CUSTOMPROPERTY18"],
"TABLEINDEXES": {
"CURRENTUSERS": [
"USERNAME"
],
"NEWUSERDATA": [
"USERNAME"
]
},
 
"PREPROCESSQUERIES": [
 
"DELETE NU FROM NEWUSERDATA NU WHERE NU.CUSTOMPROPERTY18 IS NULL OR NU.CUSTOMPROPERTY18 = ''",
 
"UPDATE NEWUSERDATA NU INNER JOIN CURRENTUSERS CU ON NU.USERNAME = CU.USERNAME SET NU.CUSTOMPROPERTY18 = ''"
]
}
 
However, the job ends with the below error:
 
krecpond_0-1694205810397.png

 

The logs show the below error:

krecpond_1-1694205883318.png

 

 

krecpond_3-1694205983077.png

Any inputs on what could be wrong with the configurations?

6 REPLIES 6

rushikeshvartak
All-Star
All-Star

Try making column name small


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

krecpond
New Contributor III
New Contributor III

What column are you referring to?

Preprocessor Query 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

krecpond
New Contributor III
New Contributor III

changing to lower case did not help and see the same error in the logs.

Does every user have CP18 set. when user's customproperty18 is null API does not return column causing error.

rushikeshvartak_0-1694399085214.png

 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

SeShoSama
New Contributor
New Contributor

have you found the error? it look like you must change the CP18 format according to API respond.

"customproperty18": "Custom Property 18~#~char"

Sav4Sav API respond for attribute name is different with in the SAV Table.