Asterisk 20.8.1
With func_odbc I make an enquiry in a MariaDB and it returns a JSON string.
But the result in the dialplan the JSON is unusable because the " , " as a divider in the elements of the JSON is altered to " backslash, ". and thus not directly usable with JSON_DECODE.
I have found a workaround with the function REPLACE to get rid of the unwanted backslashes.
But I was wondering if there is away of avoiding as the JSON should be just a string and not been touched in the sql select.
-- Executing [+31850201827@testing:3] Set("PJSIP/kamtrunkpublic-00000010", "did_info={"companyID": 9000012\, "trunkname": "siptest"\, "IPaddress": "37.97.234.xx"\, "send2ip": true}") in new stack
-- Executing [+31850201827@testing:4] Set("PJSIP/kamtrunkpublic-00000010", "did_info={"companyID": 9000012, "trunkname": "siptest", "IPaddress": "37.97.234.xx", "send2ip": true}") in new stack
Thanks