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?

[Bill Sheboy]

Hi @Ste404 

Please try using the jsonStringToObject() function.  For example:

{{jsonStringToObject(raw).StarterName}}

Kind regards,
Bill

[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"')}}