Task String - JSON Filter
The JSON filter Task runs a JSONPath or JQ query against JSON from a file or a value, and writes the result to the output of the Task.
JQ filter manual: https://stedolan.github.io/jq/manual/
The Main settings, Flow, On error, Conditions and TimeOut tabs are the same for every Task; see Job - Tasks.
JSON filter tab

- Credentials: the Credential used to read the file when File is selected. Select a Credential in the combo box, or click the settings button to open Manage credentials
- File (default): the full path of a JSON file. Click the file button to browse for it
- Variable/Value: the JSON as text or as a Variable. Click the Variable button to insert a Variable
- PreFormatting: formatting applied to the JSON before it is filtered:
- "None" (default): no formatting
- "Single line": the JSON on one line
- "Indented": the JSON indented
- JSONPath (default) or JQ: the filter engine
- The filter expression field below the engine: the JSONPath expression or the JQ program. Click the button next to it to open the JSON browser, which shows the input as a tree and lets you select a path. The button is available once a file or a value is entered. The JSON browser also opens a bare JSON value, such as a single number, string or boolean, with every PreFormatting option
Output tab

The Output tab applies to "JSONPath" only; it is hidden when "JQ" is selected. A JQ program writes its own result.
- Include value path: writes the JSONPath location of each value before the value. Applies to "MultiValue"
- Name value separator: the separator between the path and the value, "Colon" by default: "None", "Blankspace", "Colon", "Equal", "Tab", "Cr", "CrLf" or "Lf". Available when Include value path is checked
- Value qualifier: an optional character around each value: none, a double quote (
") or a single quote ('). Applies to "MultiValue" - Output value type: how the matches are written:
- "SingleValue" (default): the first match only
- "MultiValue": every match, separated by Value separator
- "JSONObject": a single match as JSON, or several matches as a JSON array
- Value separator: the separator between matches for "MultiValue", "CrLf" by default: "Comma", "Cr", "CrLf", "Lf", "CommaWithCr", "CommaWithCrLf", "CommaWithLf", "Pipe", "SemiColon", "Tab" or "None"
Output and errors
warning
If a JSONPath expression matches nothing, the output is empty, and the Task reports success. To treat an empty result as an error, add an error condition on the On error tab; see Task - On Error.
If the input is empty or not valid JSON, or a JQ program fails, the Task fails.