Available fields

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
txn = {
    "account_balance": 0,
    "account_id": "acc_00004OgDFR7Oo2tQFFaWBG",
    "amount": -510,
    "attachments": [],
    "can_be_excluded_from_breakdown": true,
    "can_be_made_subscription": true,
    "can_split_the_bill": true,
    "category": "eating_out",
    "counterparty": {},
    "created": "2018-09-10T11:59:23.813Z",
    "currency": "GBP",
    "dedupe_id": "mclifecycle:mclifecycle_00009aZlrmbP0ixoaJkiTB:MASTERCARD_AUTH:mcauthmsg_00009aZlrmHuBD9eLKkhhx",
    "description": "STARBUCKS              LONDON        GBR",
    "fees": {},
    "id": "tx_00009aZlrp45fAqFEK9Bfo",
    "include_in_spending": true,
    "international": null,
    "is_load": false,
    "labels": null,
    "local_amount": -510,
    "local_currency": "GBP",
    "merchant": {
        "address": {
            "address": "2 Churchill Place",
            "approximate": false,
            "city": "London",
            "country": "GBR",
            "formatted": "2 Churchill Place, London E14 5RB, United Kingdom",
            "latitude": 51.5043996985776,
            "longitude": -0.01540090131948196,
            "postcode": "E14 5RB",
            "region": "Greater London",
            "short_formatted": "2 Churchill Place, London E14 5RB",
            "zoom_level": 17
        },
        "atm": false,
        "category": "eating_out",
        "created": "2016-01-25T10:14:22.788Z",
        "disable_feedback": false,
        "emoji": "\u2615",
        "group_id": "grp_000092JZipPBL5RiNNjDXd",
        "id": "merch_000094VnkNMIPRRJz8o4gr",
        "logo": "https://mondo-logo-cache.appspot.com/twitter/starbucks/?size=large",
        "metadata": {
            "created_for_merchant": "merch_000092JZipOTNjH5szZZ7B",
            "created_for_transaction": "tx_000094VnkN87GAPgMAf41R",
            "foursquare_category": "Coffee Shop",
            "foursquare_category_icon": "https://ss3.4sqi.net/img/categories_v2/food/coffeeshop_88.png",
            "foursquare_id": "",
            "foursquare_website": "",
            "google_places_icon": "https://maps.gstatic.com/mapfiles/place_api/icons/cafe-71.png",
            "google_places_id": "ChIJfxWzfLACdkgR2yzBWJloG90",
            "google_places_name": "Starbucks Coffee",
            "suggested_name": "Starbucks Coffee",
            "suggested_tags": "#food #coffee",
            "twitter_id": "starbucks",
            "website": "http://www.starbucks.nl/"
        },
        "name": "Starbucks",
        "online": false,
        "updated": "2016-01-29T14:43:01.375Z"
    },
    "metadata": {
        "ledger_insertion_id": "entryset_00009aZlrnFoaTA2OUgPpp",
        "mastercard_auth_message_id": "mcauthmsg_00009aZlrmHuBD9eLKkhhx",
        "mastercard_lifecycle_id": "mclifecycle_00009aZlrmbP0ixoaJkiTB",
        "notes": "#coffee"
    },
    "notes": "#coffee",
    "originator": false,
    "scheme": "mastercard",
    "settled": "2018-09-11T09:12:16.149Z",
    "updated": "2018-10-03T01:37:15.515Z",
    "user_id": "user_00009JWKBDg1wtEcz69lKp"
}

Examples

#coffee: txn[‘merchant’][‘name’] in (‘Starbucks’, ‘Costa Coffee’)

#usa2018: txn[‘merchant’][‘address’][‘country’] = ‘USA’ and txn[‘merchant’][‘online’] == False