Has two parameters: Source, Options

Description

Formats the input into a valid Json value, output as a Top Query field. Can be called from the Text command to work on a Work Query field.

Options

The following Options are available, and may be space separated for valid combinations. The default used if blank is just the single value of "Array".

• WebSafe - Apply the WebSafe function to the data before applying the JSON escape encoding
• RecoverHtml - Apply the RecoverHtml function to the data before applying the JSON escape encoding
• RecoverHtmlObj - Apply the RecoverHtmlObj function to the data before applying the JSON escape encoding
• RecoveryMOX - Apply the RecoverMOX function to the data before applying the JSON escape encoding
• FixNumbers - If a valid number is found that doesn't fit JSON's number format requirements, such as .123 must be 0.123, and 0123 must be just 123, fix these numbers to match JSON's requirements. If this option is not used, such numbers will be preserved as-is in quotes

Note: Use the HttpType command with HttpType "application/json" for API calls, or to view in browser with JSON formatting.

Example

Test1 = JsonEncode$ "Encode me", ""
Test2 = JsonEncode$ ($CrLf && $Tab), ""
Test3 = JsonEncode$ ".123", ""
Test4 = JsonEncode$ ".123", "FIXNUMBERS"
Test5 = JsonEncode$ "00123", ""
Test6 = JsonEncode$ "00123", "FIXNUMBERS"

Test1 = "Encode me"
Test2 = "\r\n \t"
Test3 = ".123"
Test4 = 0.123
Test5 = "00123"
Test6 = 123