Substring function in JSON

[hareeshreddyk]

Hi team,

I tried to add the substring function in CreateaccountJSON REST connector to get the desired output, But not able to get it.

tried to substring the value of arsTasks.accountName = abc.[1234567]

Requirement is to substring the value from dot '.' from the value of arsTasks.accountName

\"username\": \"${requestAccessAttributes.get('ACCOUNTTYPE') == 'Service Account'? arsTasks.accountName.toString()?.substring(arsTasks.accountName.indexOf('.',arsTasks.accountName.indexOf']')).toLowerCase() : user.customproperty1.toLowerCase()}\"

the above one is not working, requesting for the working format.

[rushikeshvartak]

"username": "${requestAccessAttributes.get('ACCOUNTTYPE') == 'Service Account' ? arsTasks.accountName.toString()?.substring(arsTasks.accountName.indexOf('.') + 1).toLowerCase() : user.customproperty1.toLowerCase()}"

[hareeshreddyk]

Hi @rushikeshvartak  thanks for that,

But its getting the values after dot".".

Eg: [1234567]

Required to get the values prefix of dot ".'

Eg: abc

arsTasks.accountName = abc.[1234567]

[rushikeshvartak · Accepted solution]

"username": "${requestAccessAttributes.get('ACCOUNTTYPE') == 'Service Account' ? arsTasks.accountName.toString()?.substring(0, arsTasks.accountName.indexOf('.')).toLowerCase() : user.customproperty1.toLowerCase()}"