MonzoAbout this query
Triggers, queries, and actions are the building blocks of Applets. Triggers tell an Applet to start, queries ask a question, and actions are its end result.
Developer info
- Description
- This query returns a list of whenever you spend money at a particular merchant, and the transaction goes through.
- API endpoint slug
- monzo.history_of_any_card_purchase_at_a_merchant
- Runtime method
- performQuery("monzo.history_of_any_card_purchase_at_a_merchant")
Query fields
Merchant name Text input
- Label
- Which merchant?
- Helper text
- Provide the name of the merchant exactly as it appears in your Monzo feed.
- Slug
- merchant_name
- Required
- true
- Can have default value
- true
Ingredients
Transaction IDA unique ID for the transaction
- Slug
- transaction_id
- Filter code
- Monzo.historyOfAnyCardPurchaseAtAMerchant.TransactionId
- Type
- String
- Example
- tx_00009WKghuWl5k7O0dkZrV
Merchant nameThe name of the merchant where you spent the money.
- Slug
- merchant_name
- Filter code
- Monzo.historyOfAnyCardPurchaseAtAMerchant.MerchantName
- Type
- String
- Example
- Starbucks
Merchant addressThe address of the merchant for this transaction.
- Slug
- merchant_address
- Filter code
- Monzo.historyOfAnyCardPurchaseAtAMerchant.MerchantAddress
- Type
- String
- Example
- Starbucks
Merchant country codeThe three-letter ISO country code of the merchant for this transaction.
- Slug
- merchant_country_code
- Filter code
- Monzo.historyOfAnyCardPurchaseAtAMerchant.MerchantCountryCode
- Type
- String
- Example
- GBR
Merchant logoThe logo image URL of the merchant for this transaction.
- Slug
- merchant_logo
- Filter code
- Monzo.historyOfAnyCardPurchaseAtAMerchant.MerchantLogo
- Type
- String
- Example
- https://www.monzo.com/logo.png
CategoryThe category you assigned this transaction to.
- Slug
- category
- Filter code
- Monzo.historyOfAnyCardPurchaseAtAMerchant.Category
- Type
- String
- Example
- General, Groceries or Entertainment
EmojiThe emoji of the transaction.
- Slug
- emoji
- Filter code
- Monzo.historyOfAnyCardPurchaseAtAMerchant.Emoji
- Type
- String
- Example
- Any emoji
NotesThe transaction's notes when the transaction was made.
- Slug
- notes
- Filter code
- Monzo.historyOfAnyCardPurchaseAtAMerchant.Notes
- Type
- String
- Example
- Flight Number BA331
Amount in account currencyThe amount you spent converted into your account's main currency.
- Slug
- amount_in_account_currency
- Filter code
- Monzo.historyOfAnyCardPurchaseAtAMerchant.AmountInAccountCurrency
- Type
- String
- Example
- 5.34
Account currency symbolThe currency code of your account's main currency.
- Slug
- account_currency_symbol
- Filter code
- Monzo.historyOfAnyCardPurchaseAtAMerchant.AccountCurrencySymbol
- Type
- String
- Example
- 5.34
Amount in local currencyThe amount you spent in the local currency.
- Slug
- amount_in_local_currency
- Filter code
- Monzo.historyOfAnyCardPurchaseAtAMerchant.AmountInLocalCurrency
- Type
- String
- Example
- 5.34
Local currency symbolThis will differ to your account's main currency symbol if you were abroad.
- Slug
- local_currency_symbol
- Filter code
- Monzo.historyOfAnyCardPurchaseAtAMerchant.LocalCurrencySymbol
- Type
- String
- Example
- $
Local currency codeThis will differ to your account's main currency code if you were abroad.
- Slug
- local_currency_code
- Filter code
- Monzo.historyOfAnyCardPurchaseAtAMerchant.LocalCurrencyCode
- Type
- String
- Example
- USD
Transaction timeThe date and time of the transaction.
- Slug
- transaction_time
- Filter code
- Monzo.historyOfAnyCardPurchaseAtAMerchant.TransactionTime
- Type
- Date with time (ISO8601)
- Example
- 2020-07-08T04:17:06.000+05:00