Connection JSON text manipulation function substringBefore

[darshanmandhane]

We have a requirement wherein we want to update an attribute of the connected endpoint with pre-"@" symbol of the email ID.

I tried with below syntaxes, nothing worked. Can you please suggest a right way to use substringBefore function in connection JSON.

This works:

\"Username\": \"${user?.email}\" 

None of these work:

a. \"Username\": \"${substringBefore(user?.email, '@')}\"

b. \"Username\": \"${substringBefore(user?.email, \'@\')}\"

c. \"Username\": \"${substringBefore(user?.email, "@")}\"

d. \"Username\": \"${substringBefore(user?.email, \"@\")}\"

e. \"Username\": \"${substringBefore(user?.email, @)}\"

f. \"Username\": \"${split(user?.email, "@", 1)}\"

g. \"Username\": \"${split(user?.email, "@")[0]}\"

[Raghu]

Sample can you provide result what expecting , before '@' means we have system user right use , based on that email will generate .

\"Username\": \"${user?.systemusername}\"

[rushikeshvartak · Accepted solution]

user?.email.substring(0, user?.email.indexOf('@'))

[darshanmandhane]

Thank you @rushikeshvartak, it worked!

[rushikeshvartak]

FYI it should be java functions and not String functions