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.

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
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
Unquote Strings

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

Default: true

bool

Outputs

ProductDetailsPossible Types
Result

The value produced by the node operation.

Primary Output

Vec<String>