Retrieve values from JSON - regex syntax for whitespaces?

Mitch Dale

Hey @Product,

I'm trying to use a regex expression to find a specific object in a JSON body. Is there a specific language/regex model (I don't know the proper terminology) that is used for json paths?

The reason I ask is, I'm trying to make the whitespaces more flexible when trying to find an object. If it were a normal regular expression using the 'Compare/Extract/Replace using a Regex Expression' WA, I'd use \s* so that the specific number of whitespaces between words won't affect the search.

However with the Retrieve values from JSON WA, this particular identifier doesn't work

Mitch Dale

@Product I think I might have figured it out - it seems like you have to add an extra \ before the \s

\\s* seems to work - can someone confirm this? And if that's the case, will other common regex identifiers work for JSON paths? e.g. \d, \D, etc

Dylan

@Mitch Dale, we have updated our documentation around this. When using regex escapes like \s, \d, or \w, you must escape the backslash inside JSONPath strings. For example, use \\s instead of \s. If the JSONPath is itself stored inside JSON, the backslashes must be escaped again for JSON encoding.