Query operators

The following operators are permitted when querying for sweeps in the Reconciliation API:

Operator nameSyntaxExample
Equalvariable = valuesettlementAccountIdentifier = 'GBP1'
Not equalvariable <> valuesettlementAccountIdentifier <> 'GBP1'
Less thanvariable < valuecreatedAt < '2023-01-01'
Less or equal thanvariable <= valuecreatedAt <= '2023-01-01'
Greater thanvariable > valuecreatedAt > '2023-01-01'
Greater or equal thanvariable >= valuecreatedAt >= '2023-01-01'
IN operatorvariable IN ('value1', 'value2')settlementAccountIdentifier IN ('GBP1', 'GBP2')
AND operatorvariable1 = 'value1' AND variable2 = 'value2'settlementAccountIdentifier = 'GBP1' AND createdAt >= '2023-01-01'
OR operatorvariable1 = 'value1' OR variable2 = 'value2'settlementAccountIdentifier = 'GBP1' OR settlementAccountIdentifier = 'GBP2'
Parenthesis operator(variable1 = 'value1' AND variable2 = 'value2') AND variable3 = 'value3'(createdAt >= '2023-01-01' AND createdAt <= '2023-02-01') AND settlementAccountIdentifier = 'GBP1'

πŸ“˜

DateTime format

Use the DateTime format 2023-01-01T00:00:00 in your query operators. Date format is also supported (e.g. 2023-01-01).