Can I use string functions in my alert trigger action template? (I want to replace backslashes)

Question

When my alert is triggered, I'm posting the volume label to an HTTPS endpoint as JSON.

But my volume labels have backslashes in them, and my POST is failing.

Is there a .replace string function that I can use to strip out the backslashes?

Thanks~!

PS: Right now, this is what my variable looks like:

${N=SwisEntity;M=Caption}

But that outputs as "G:\ Label:Data E8C0F579" , and as mentioned, that "\" character breaks my JSON that I'm posting to my endpoint.

ctech291 · Accepted Answer

This is what I put into my JSON: ${SQL: SELECT REPLACE(Caption, '\', '\') FROM Volumes WHERE VolumeID = ${VolumeID}}