Escaping a single quote in WebHook JSON
I have a Web Hook that is sending JSON data to an end point external to Quickbase. If I embed an escaped single quote in one of the fields it works fine:
{
"ComplaintSummary" : "This works fine w...
Forum Discussion
I was able to sort this out by creating the Formula-Text field as follows:
// single quotes and double quotes must be "escaped" so they don't interfere with the JSON data formatting
var Text DOUBLEQUOTE = "\"";
var Text SINGLEQUOTE = "'";
var Text ESCAPEDSINGLEQUOTE = "\\'";
var Text ESCAPEDDOUBLEQUOTE = "\\\"";
var Text ENCODEDFORSINGLEQUOTE = SearchAndReplace([Complaint Summary], $SINGLEQUOTE, $ESCAPEDSINGLEQUOTE);
SearchAndReplace($ENCODEDFORSINGLEQUOTE, $DOUBLEQUOTE, $ESCAPEDDOUBLEQUOTE)
Now, the web hook is able to transmit data with any pattern of inline single or double quotes.
------------------------------
Rick Putnam
------------------------------
// single quotes and double quotes must be "escaped" so they don't interfere with the JSON data formatting
var Text DOUBLEQUOTE = "\"";
var Text SINGLEQUOTE = "'";
var Text ESCAPEDSINGLEQUOTE = "\\'";
var Text ESCAPEDDOUBLEQUOTE = "\\\"";
var Text ENCODEDFORSINGLEQUOTE = SearchAndReplace([Complaint Summary], $SINGLEQUOTE, $ESCAPEDSINGLEQUOTE);
SearchAndReplace($ENCODEDFORSINGLEQUOTE, $DOUBLEQUOTE, $ESCAPEDDOUBLEQUOTE)
Now, the web hook is able to transmit data with any pattern of inline single or double quotes.
------------------------------
Rick Putnam
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendThx for Posting!
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------