and more in a single search tool across platforms. Read the announcement here. |
08/25/2022 05:44 AM
Is there a way we can alter accounts table values while doing an account import?
account import brings a certain value as xyz@abc.net. there isn't any attribute in the end application that holds just xyz. I am trying to see if it is possible to manipulate the data while doing an account import and just store xyz in the account column.
Solved! Go to Solution.
08/25/2022 06:26 AM
You can try below syntax
"customproperty1": "#CONST#${String op= response.ROLE_ID.datavalue; String target = response.ROLE_NAME.datavalue; ret = op + \" \" + target; return ret}~#~char",
08/25/2022 08:00 AM
Whatever I give after #CONST# it is getting printed as the value like ${ ...}. What am I doing wrong?
08/25/2022 01:30 PM
Can you share syntax you are using
08/25/2022 09:42 PM - edited 08/25/2022 09:44 PM
Tried multiple ways, but the entire thing is getting stored as the value.
"#CONST#${return replace(replace(response._embedded.user.loginid,'@xyz.net',''),'@XYZ.net','');}~#~char"
"#CONST#${String name=response._embedded.user.loginid; AccName = replace(replace(name,'@xyz.net',''),'@XYZ.net',''); return AccName}~#~char"
08/26/2022 06:13 AM
any suggestions or help, please
08/26/2022 06:55 AM - edited 08/26/2022 10:17 AM
"customproperty1": "#CONST#${String op= "This is Saviynt ".replace("Saviynt", "Forum") ; return op}~#~char",
Try this example
Below
"#CONST#${String data1=response._embedded.user.loginid; ret= data1.replace('@xyz.net',''); return ret}~#~char"
08/29/2022 12:46 AM
Thank you. The problem was in the response path. I have already given it in "listField":"_embedded.user" and by just giving response.loginid it worked.