Transaction Query Language (TQL)

The Transaction Query Language allows one to filter transactions using different modifiers.

Most modifiers support multiple comma-separated values except amount, date, descriptor, tos, id, arn, reference.

Multiple modifiers in one query are supported, e.g. is:capture date:yesterday country:DK,SE.

Transaction type

query Will search for…
is:authorization authorizations
is:capture captures
is:refund refunds
is:void voids
is:credit credits
is:capture,refund captures and refunds

Status code

query Will search for…
status:approved approved transactions
status:declined declined transactions (any code that is not 20000)
status:40410 transactions with status code 40410
status:40413,40414 transactions with status code 40413 or 40414

See status codes for more information.

Amount

query Will search for…
max:200 transactions with amounts smaller than or equal to 200
min:100.50 transactions with amounts bigger than or equal to 100.50
amount:<=20 transactions with amounts smaller than or equal to 20
amount:*..20 transactions with amounts smaller than or equal to 20
amount:20..80 transactions with amounts between 20 and 80 (inclusive)
amount:100.50 transactions with the exact amount of 100.50

Currency

Query Will search for…
currency:DKK transactions in currency DKK
currency:NOK,SEK,EUR transactions in currency NOK, SEK or EUR

Date

Query Will search for…
date:today transactions that occurred today
date:yesterday transactions that occurred yesterday
date:last_week transactions that occurred last week
date:last_month transactions that occurred last month
date:last_year transactions that occurred last year
date:this_week transactions that occurred from the beginning of this week until now
date:this_month transactions that occurred from the beginning of this month until now
date:this_year transactions that occurred from the beginning of this year until now
date:>=2016-01-20 transactions that occurred after or during January 20th, 2016
date:>2016-01-20 transactions that occurred after January 20th, 2016
date:<=2016-01-20 transactions that occurred before or during January 20th, 2016
date:<2016-01-20 transactions that occurred before January 20th, 2016
date:*..2016-01-20 transactions that occurred before or during January 20th, 2016
date:2016-01-20..* transactions that occurred after or during January 20th, 2016
date:2016-01-18..2016-01-20 transactions that occurred after or during January 18th and before or during January 20th, 2016

Time

The date modifier supports ISO 8601-like formatted date and time elements.

Query Will search for…
date:<2016-01-20T13:00 transactions that occurred before 13:00:00 UTC on January 20th, 2016
date:*..2016-01-20T13:00 transactions that occurred before or at 13:00:00 UTC on January 20th, 2016
date:2016-01-19T11:00..2016-01-19T13:00 transactions that occurred after or at 11:00:00 and before or at 13:00:00 UTC on January 19th, 2016

Card

Query Will search for…
last4:1122 transactions with last4 equal to 1122
last4:1122,1234 transactions with last4 equal to 1122 or 1234
bin:411111 transactions with bin equal to 411111
bin:411111,424242 transactions with bin equal to 411111 or 424242
scheme:visa transactions made with a Visa card
scheme:mastercard transactions made with a Mastercard card
type:debit transactions made with a debit card
type:credit transactions made with a credit card
country:DE transactions made with a card issued in Germany
country:SE transactions made with a card issued in Sweden
country:DK,GB transactions made with a card issued in Denmark or United Kingdom

Text on statement

Also known as descriptor.

Query Will search for…
tos:site.com transactions with descriptor that contains site.com
descriptor:“Company Ltd” transactions with descriptor that contains “Company Ltd”

Merchant ID

Also known as account number or MID.

Query Will search for…
merchant_id:3000001 transactions made with merchant ID 3000001
mid:3000001 transactions made with merchant ID 3000001
mid:3000001,3000002 transactions made with merchant ID 3000001 or 3000002

ID, ARN, Reference

The id and arn properties can uniquely identify a transaction.

The arn property stands for Acquirer Reference Number and can be used by issuing banks to locate transactions in their systems.

The reference property is also a potential unique identifier, supplied by the merchant.

Query Will search for…
id:a51a3abe-8eee-4a92-b941-e89f18c5bf66 transaction with id a51a3abe-8eee-4a92-b941-e89f18c5bf66
arn:76874308121337230471105 transaction with arn 76874308121337230471105
reference:abc123 transactions with reference that contains abc123

Flags

Query Will search for…
flag:recurring recurring transactions
flag:r idem
flag:3dsecure transactions with attempted or full 3DSecure
flag:3ds idem
flag:3d idem
flag:fraud transactions marked as fraudulent
flag:f idem
flag:f,r recurring transactions marked as fraudulent

Fraud

Fraud information is collected from TC40/SAFE data.

Query Will search for…
fraud.date:today transactions marked as fraudulent today
fraud.date:yesterday transactions marked as fraudulent yesterday
fraud.date:last_week transactions marked as fraudulent last week
fraud.date:…1 transactions marked as fraudulent …
1
Please refer to Date modifier for all supported values.
Query Will search for…
flag:fraud transactions marked as fraudulent
flag:f idem
Open Navigation Close Navigation