Account Query Language (AQL)
The Account Query Language allows one to filter accounts using different modifiers.
Some modifiers support multiple comma-separated values.
Multiple modifiers in one query are supported, e.g. name:Company currency:DKK,EUR
.
Id
Query |
Will search for… |
id:c4df379a-a98b-42df-b48c-366ba1181544 |
account with id c4df379a-a98b-42df-b48c-366ba1181544 |
Merchant ID
Also known as account number or MID.
Query |
Will search for… |
merchant_id:3000001 |
account with merchant ID 3000001 |
mid:3000001 |
account with merchant ID 3000001 |
mid:3000001,3000002 |
accounts with merchant ID 3000001 or 3000002 |
Name
Query |
Will search for… |
name:"Company Ltd" |
accounts with name that contains "Company Ltd" |
Descriptor
Query |
Will search for… |
descriptor:"Company Ltd" |
accounts with descriptor that contains "Company Ltd" |
Currency
Query |
Will search for… |
currency:DKK |
accounts in currency DKK |
currency:NOK,SEK,EUR |
accounts in currency NOK, SEK or EUR |
MCC
Query |
Will search for… |
mcc:1234 |
accounts with mcc 1234 |
mcc:1234,5678 |
accounts with mcc 1234 or 5678 |