Skip to main content

JSON: Extract

Extract data from a JSON object using json path syntax

Input​

JSONrequired

JSON Object you want to extract data from.

Parameters​

JSON Pathrequired

JSON path to apply on input json object. json path syntax

Value typerequired

Which type you expect to extract:

  • Text: first match, converted to plain text (strings, numbers and booleans only).
  • Integer: first match, as an integer.
  • JSON: an array containing all matches of the path, forwarded as-is.
Default value

Fallback emitted (as plain text) when the JSON path query itself errors — for example an invalid expression. Note that a valid path matching nothing is not covered: it fails the step regardless of the default. Since the fallback is always plain text, it is only useful with the Text value type.

Output​

Extracted value type

Value extracted from the given JSON in proper configured value type.