How to use substring in soap connector response mapping.

[sureshchalla]

Hai,

In soap connector response mapping we want to map the first three characters of  an attribute value from the soap response .

Example: The value of location in the soap response is  'ABC#99.87.54'. Here I want to store the first three characters in customproperty15.For that i try the below syntax but it didn't work 

"ACCOUNT.CUSTOMPROPERTY15": "#CONST#${String op= (Body.Response.attr(@name=='location').value).substring(0,3); return op}~#~char",

"ACCOUNT.CUSTOMPROPERTY15": "(Body.Response.attr(@name=='location').value).substring(0,3)",

"ACCOUNT.CUSTOMPROPERTY15": "substring((Body.Response.attr(@name=='location').value), 0, 3)",

Could you please suggest me to achieve this? Or else let me know I am going wrong anywhere.

[gokul]

Hi,

I'm also facing the same issue. I have tried with the above mentioned format but still it is not working.

[SB]

Is the value getting stored in the Saviynt mapped attribute if you do not use substring function.

[gokul]

@SB - Yes, without substring it is getting stored in the mapped account customproperty.

[gokul]

@rushikeshvartak - Do you have any suggestion/solution for this issue.

Thanks!