Filtering and Searching
Filters can be used to interact with any object. Objects can be queried by appending parameters to
the query string of the URL.
So to get a list of all pares_status = Y in threeds authentication with AUD currency, having an amount equal to or greater than 20,
we would use the following URL:
/v2/3d?_limit=10&amount>=212¤cy_code=AUD&authentication.pares_status=YParameters with multiple values are also supported. So for example, to query pares_status = Y and pares_status = U,
you would use the following URL:
/v2/3d?authentication.pares_status=Y&authentication.pares_status=UUse the following syntax to query objects based on parameters and values - in this example querying threeds authentication by the amount.
Query on one value:
/v2/3d?amount=7500Query on everything but one value:
/v2/3d?amount!=7500Less than and equal to:
/v2/3d?amount<=7500Greater than and equal to:
/v2/3d?amount>=7500Range of values within/outside specified bounds:
/v2/3d?amount<=7600&amount>=7500Multiple parameters:
/v2/3d?amount=7600¤cy_code=AUDLimit the number of results:
/v2/3d?_limit=50Sort results in descending order:
/v2/3d?_sort=-amountSort results in ascending order:
/v2/3d?_sort=amountQuery operators
| Operator | Description |
|---|---|
| = | equal |
| ! | not equal |
| < | less than and equal to |
| > | greater than and equal to |
| ~ | pattern matching |
| >&< | multiple arguments search |