Built-in tool
Search nested data
Search nested structures for items matching a condition on a deep field, then extract values from a path.
Freeno per-call chargeNo API key needed
Endpoint
Parameters
| Name | Type | Required | Note |
|---|---|---|---|
| itemsrepeating-group · required | repeating-group | required | Add one or more data sources. Supports variable references and expressions. |
| searchPathstring · required | string | required | Dot-notation path to the value to match on. Use [] to traverse arrays. Example: |
| conditionstring · required | string | required | One of: |
| matchValuestring · required if condition is equals or not-equals or contains or starts-with or ends-with | string | required if condition is equals or not-equals or contains or starts-with or ends-with | Not required when condition is exists or does not exist. Example: |
| extractPathstring · optional | string | optional | Path to extract from matching items. Leave blank to return the full matched item. Example: |
| deduplicateResultsboolean · optional | boolean | optional | Remove duplicate values from the output. |
Response schema
{
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"required": [
"success"
],
"properties": {
"count": {
"type": "number",
"description": "Number of items in the result (populated for array results and the count action)."
},
"error": {
"type": "string"
},
"result": {
"description": "Transformed result. Type depends on the action: array, object, scalar, or number."
},
"success": {
"type": "boolean"
}
},
"additionalProperties": false
}
