JSON
Actions for reading, parsing, querying and validating JSON data.
The JSON folder of the Process Designer toolbox holds the actions that read JSON from text or files, query it and check it.
| Action | What it does |
|---|---|
| Extract Objects | Extracts one value or a list of values from JSON with a JSONPath query. |
| File To JSON | Reads a .json file into a JSON value. |
| Key Value | Turns a list of JSON objects into key/value pairs, or pivots them into one object. |
| String To JSON | Parses a text into a JSON object or a list of JSON values. |
| Is Valid | Checks that a text is well-formed JSON (the step fails when it is not). |
To convert between JSON and other formats, see the Converters folder: JSON To XML, XML To JSON, HTML To JSON, JSON To HTML and Object To String.