Query JSON All

Extracts every matched value from a JSON string using a path expression (see that parameter's description for its syntax). A list of zero or more resultant strings is produced. The [] path accessor is used to read more than one value.

Each item carries a type attribute holding the matched value's JSON type ("string", "number", "bool", "null", "object", or "array").

This is useful in conjunction with the nodes: • Index Elements: access the Nth query result. • String to Number: convert numeric query results to numbers. • String ValueEquals: convert "true", "false", or "null" query results to bools.

Interface

Inputs

ParameterDetailsPossible Types
JSON

The JSON string to extract values from.

Primary Input

String[]
String
Path

Determines which contained values to extract from within the JSON.

The path syntax is like JavaScript's accessor syntax that follows an array/object value. It also supports negative indexing to count backwards from the end. Additionally, [] accesses all array and object values instead of just one.

Examples:

Use [2] or [-1] to get the last value, and [1] or [-2] for the middle value, of ["a", "b", "c"].

Use .size or ["size"] to get the size property of { "size": 10 }. The latter form is required if the key contains spaces or special characters like ["this key with spaces!"].

Use chained accessors like .fonts[0].name to query deeper.

Use the [] accessor to query all elements, like .fonts[].weights[] to get every weight of every font.

Default: ""

String[]
String
Unquote Strings

Strips the surrounding double quotes from string values, returning the raw text. Other types are never wrapped in quotes.

Default: true

bool[]
bool

Outputs

ProductDetailsPossible Types
Result

The value produced by the node operation.

Primary Output

String[]