Hi,
I’m trying to set up a event action. I call a REST endpoint from my event action.
I try to format my POSTed message as json. How can invalid characters, like {} “, in my data be handled? Is there a function for escaping texts?
Thank you!
+22Hi
curly braces don’t need to escape in json payload. Double quotes can be escaped with \. do you have an example message with invalid characters?
Cheers!
Damith
+1Hi
the body defined for my POST looks like this,
{"tasknr" :"&OLD:TASK_SEQ", "descr" : "&NEW:DESCRIPTION"}
If description contains double quotes then the json is not valid I suppose. Is there a function I can use to escape NEW:DESCRIPTION?
+22Have you tried the Oracle REPLACE function
Eg:
select REPLACE ('My text with "doublequotes"', '"', '\"') from dual
Haven’t tested below but hope it works :)
json_ := '{"tasknr" :"&OLD:TASK_SEQ", "descr" : "' || REPLACE(&NEW:DESCRIPTION, '"', '\"') || '"}';
/Damith
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.