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=Y
Parameters 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=U
Use 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=7500
Query on everything but one value:
/v2/3d?amount!=7500
Less than and equal to:
/v2/3d?amount<=7500
Greater than and equal to:
/v2/3d?amount>=7500
Range of values within/outside specified bounds:
/v2/3d?amount<=7600&amount>=7500
Multiple parameters:
/v2/3d?amount=7600¤cy_code=AUD
Limit the number of results:
/v2/3d?_limit=50
Sort results in descending order:
/v2/3d?_sort=-amount
Sort results in ascending order:
/v2/3d?_sort=amount
Query operators
Operator | Description |
---|---|
= | equal |
! | not equal |
< | less than and equal to |
> | greater than and equal to |
~ | pattern matching |
>&< | multiple arguments search |