Is there a built-in tools to display JSON string in beautify or readable format ?

(1) Share

Report

Posted on by Ken Manhattan

542

Hi guys,

I have a field string contain JSON format, but it is in plain format of 1 long line, something like '{/Currency/:/USD/,/DataAreaId/:/USMF/,/PONumber/:/WEB-000110/,/PurchaseOrderDeliveryDateStr/:/20/11/2023/,/PurchLineList/:[{/ItemId/:/SAMPLE-7/,/PurchPrice/:100.0,/PurchQty/:1.0]}'

Is there a tools or probably a display control (viewer) so when I display this field on a form, it will make more readable, with indention, linebreak, etc

Thanks

All responses (3)

Answers (1)

Martin Dráb 232,968 Most Valuable Professional on at

Like (0)

Report

Is there a built-in tools to display JSON string in beautify or readable format ?

Note that my answer, unlike the verified Kevin's answer, allows passing JSON from F&O. That makes it much more useful, in my opinion. I just want to make sure that you didn't overlook this feature.
Verified answer

Kevin Xia Microsoft Employee on at

Like (2)

Report

Is there a built-in tools to display JSON string in beautify or readable format ?

Hi,

After my search, I didn't find such a built-in tool, you can use online tools on the Internet to convert json strings, or write scripts to convert json strings. For example, this online URL provides a free JSON format service: Best JSON Formatter and JSON Validator: Online JSON Formatter.

Best regards,

Kevin
Suggested answer

Martin Dráb 232,968 Most Valuable Professional on at

Like (0)

Report

Is there a built-in tools to display JSON string in beautify or readable format ?

No, F&O doesn't come with a control with such a visualization of JSON string.

A simple workaround may be providing a button that will take the JSON string and pass it to an external JSON viewer. Here is an example.