ApiOnCloud Tools

Logo of ApiOnCloud

JSON Editing Tools

Enter a JSON in the text-box on the left and then click on one of the buttons to see the result in the text box on the right


How to use this online JSON Tool / Editor?

Step 1 - Paste the JSON string in the text area labeled 'Input JSON'.

Step 2 - Press one of the buttons at the top to edit/transform the JSON string.

Step 3 - View the transformed JSON in the text area labeled 'Output JSON'.

Both input and output JSON text areas area labeled.
'Input JSON' will be on the left of the 'Output JSON' on larger screens. 'Input JSON' will be above 'Output JSON' on smaller screens (for example smart phones).

Description of edit functions available in this JSON tool

Format JSON (Prettify)

Press this button to format the JSON string. The formatted/prettified JSON string will be displayed in the TextArea 2. The formatted JSON string will have only one JSON key/value on each line. Nicely formatted JSON string is great for reading.

Linearize JSON (Minify)

Press this button to remove all formatting/indentations from the JSON string, if any. The transformed JSON string will be displayed in the TextArea 2.

Clear all JSON values

Press this button to clear/erase all values in the JSON. The resulting JSON string will be displayed in the TextArea 2. This is a great feature if you are planning to use the same JSON with completely different values. Press the button once and all values are erased/cleared, saving you from erasing/clearing each value in the JSON individually.

- String values (values in quotes) are replaced with an empty String

- Number values are replaced with a Zero (0)

- Boolean True is replaced with False. Boolean False remains False

Show String fields only

Press this button if you are interested in viewing fields with String values only. The resulting JSON will be shown in TextArea 2 containing only String fields. All Number and Boolean fields will be removed but Objects and Arrays in the JSON will be retained.

Show Number fields only

Press this button if you are interested in viewing fields with Number values only. The resulting JSON will be shown in TextArea 2 containing only Number fields. All String and Boolean fields will be removed but Objects and Arrays in the JSON will be retained.

Show Boolean fields only

Press this button if you are interested in viewing fields with Booleans values only. The resulting JSON will be shown in TextArea 2 containing only Boolean fields. All String and Number fields will be removed but Objects and Arrays in the JSON will be retained

Show Objects & Arrays only

Press this button if your goal is to understand/view the structure of the JSON. The output of this edit function will be shown in TextArea 2. This edit function will remove all String, Number and Boolean key & value pairs from the input JSON. This is great when the goal is to understand the parent, child and sibling relationships between objects in a JSON.

Remove All String Fields

String values often account for the majority of fields in a JSON, making it difficult to view Numbers, Booleans, Arrays and Objects close together in a large JSON. Filter out all the String values from the JSON by pressing this button.

Remove All Number Fields

Press this button to remove all the Number values from the input JSON. The resulting JSON will be shown in TextArea 2 and will contain all the String and Boolean values, Object(s) and any Arrays from the original input JSON.

Remove All Boolean Fields

Press this button to remove all the Boolean values from the input JSON. The resulting JSON will be shown in TextArea 2 and will contain all the String and Number values, Object(s) and any Arrays from the original input JSON.

Remove All Objects & Arrays

Press this button to extract all key/value pairs from the input JSON. Extracted key/value pair will be shown as a flat list (no hierarchy, objects and arrays). Each extracted key/value pair will be separated by a colon and double quotes will be removed.

Clear Specified Field Value(s)

Press this button after entering one or more JSON Keys in the textbox provided above the buttons in this section. You can enter one or more JSON Keys in the textbox. If you have entered more than one JSON Key in the textbox then use a Comma (,) to separate the JSON Keys. Use this edit function for scenarios where the objective is to erase/clear values of a subset of Keys, the data-type of the values being erased does not have to the same. For example, if the input JSON contains 10 different Keys with String values, 10 different Keys with Number values and 10 different Keys with Boolean values then any combination of Keys can be entered in the textbox. The edit function will erase/clear the value of all instances of the specified Keys found in the input JSON.

What to expect after pressing this button?

- String value(s) will be replaced by an empty String (two consecutive double quotes without any space between them).

- Number value(s) will be replaced by Zero (0).

- Boolean value(s) will be changed to false.

- Array(s) will be replaced by an empty array, any object(s), key/value pairs in it will be removed.

- Object(s) will be replaced by an empty object, any key/value pairs, arrays in it will be removed.

Show Specified Field(s) Only

Pressing this button will remove all the key/values pairs from the input JSON including Objects and Arrays except for those Keys which are specified in the textbox. Enter one or more JSON keys in the textbox before pressing this button. If more than one Key is specified in the textbox then the Keys must be separated by Comma (,).

Remove Specified Field(s)

Press this button to remove specific key/value pairs from the input JSON. Keys to be removed can be specified in the textbox provided. If more than one Key needs to be removed then keys should be separated by a Comma (,). Object, Array, String, Number and Boolean values can be removed from the input JSON using this edit function.

Extract Value of Specified Field(s)

Press this button if the objective is to extract all the values of one of more Keys in the input JSON and list them in plain-text format. If there are more than one instances of the specified key then the values of those keys will be listed as comma separated values. Use the textbox provided above the button to specify the key(s) before pressing the button. If more than one key is specified then use a Comma (,) to separate each key from the next one.

Copyright 2021 - 2024, App ApiOnCloud, LLC. All Rights Reserved