filterarray - Filter an Array by an Operator

Filters an array by an given comparison operator.

data
Type
array
Required
required
Array of lines with mixed values.
Minimum: 1
Example:
[
  {
    "Column1": "Germany",
    "Column2": "Apple",
    "Column3": 1,
    "Column4": true
  },
  {
    "Column1": "Germany",
    "Column2": "apple",
    "Column3": 2,
    "Column4": true
  },
  {
    "Column1": "US",
    "Column2": "Apple",
    "Column3": 3,
    "Column4": true
  }
]
queryField
Type
string
Required
required
Name of the field in data to look for critera. Case sensitive
Example:
Column3
operator
Type
string
Comparison operator. Defaults to eq
Possible values are: eq, gt, ge, lt, le, ne
Example:
eq
criteria
Type
string
Required
required
Criteria to look for must be number or string
Example:
3
ignoreCase
Type
boolean
Sets case sensitivity for operation.

Available on

Postman
Make
Zapier
Swagger
N8N
Airtable
SeaTable
Bubble
Power Automate
Workato
SAP Build