What am I missing here with what I thought would be simple parsing

Ste404

Hi there,

I have a large chunk of text that comes into an automation rule as a variable.

Part of that variable is this

text={"StarterName":"Jill Hampson","StartDate":"2025-09-19","Department":"Finance",  so on and so forth

I am just trying to create variables based on the values

the variable is called raw.

I was creating a new variable called StarterName with this

{{raw.substringBetween('"StarterName":"','"')}}

Unable to render smart values when executing this rule:

Failed to get value for raw.substringBetween('"StarterName":"','"'): {{raw.substringBetween('"StarterName":"','"')}}

What am I missing?

Tuncay Senturk _Snapbytes_

Did you try using regexp?

{{raw.match("\"StarterName\":\"(.*?)\"")}}

It should return Jill Hampson.

Or, if you want to use substringbetween  make sure your delimiters exist exactly in the raw text. 

I think the below would work

 {{raw.substringBetween('"StarterName":"','","StartDate"')}}