nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

String Function "substringBetween(String open, String close)" is returning unexpected values

Sam Sexson_v4uh1c

I'm trying to parse a webhook response to remove some brackets by utilizing the "substringBetween()" function like this:

{{webhookResponse.body.schedules.schedule.onCallUser.username.substringBetween("[","]")}}

Without the substringBetween function, the value returned is "[user]"

When I check the audit log when using the function, it appears that it's _only_ capturing the brackets as shown here:

log brackets.jpg

Am I using this function incorrectly?

Accepted answers

Simmo_9kntn7

Hi @Sam Sexson ,

Could you provide an example of the web hook payload for me (remove anything thats PII or company related). Would make it a bit easier to see what is going on.

Cheers,

Simmo

All comments

Simmo_9kntn7

Hi @Sam Sexson ,

Could you provide an example of the web hook payload for me (remove anything thats PII or company related). Would make it a bit easier to see what is going on.

Cheers,

Simmo

Sam Sexson_v4uh1c

Hi @Simmo , thank you for your time! Of course!

{
"team": {
"name": "XXXXXXXXX",
"slug": "XXXXXXXXX"
},
"schedules": [
{
"policy": {
"name": "XXXXXXXXX",
"slug": "XXXXXXXXX"
},
"schedule": [
{
"onCallUser": {
"username": "XXXXXXXXX"
},
"onCallType": "XXXXXXXXX",
"rotationName": "XXXXXXXXX",
"shiftName": "XXXXXXXXX",
"shiftRoll": "XXXXXXXXX",
"rolls": [
{
"start": "XXXXXXXXX",
"end": "XXXXXXXXX",
"onCallUser": {
"username": "XXXXXXXXX"
},
"isRoll": true
},
{
"start": "XXXXXXXXX",
"end": "XXXXXXXXX",
"onCallUser": {
"username": "XXXXXXXXX"
},
"isRoll": true
},
{
"start": "XXXXXXXXX",
"end": "XXXXXXXXX",
"onCallUser": {
"username": "XXXXXXXXX"
},
"isRoll": true
}
]
}
],
"overrides": []
}
]
}

Simmo_9kntn7

Hey @Sam Sexson ,

Sorry about the delay in getting back to you. So, what I think is going on here is that schedule is an array/list.

So, webhookResponse.body.schedules and .schedule are both referring to a list. When that happens, we apply whatever comes next to all the list elements. In your case that is .onCallUser.username.substringBetween("[","]"). And then, because its a list we render it in list format which adds those square brackets.

If you try the following:

{{webhookResponse.body.schedules.first.schedule.first.onCallUser.username}}

That might hopefully resolve your issue.

Cheers,

Simeon.

Sam Sexson_v4uh1c

@Simmo ! You are amazing!

Yes, that worked perfectly... thank you so much for your time in getting me on track! I appreciate the thorough explanation and recommended change! Works perfectly!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

automation