import { z } from "zod";
import * as ynab from "ynab";
import { getErrorMessage } from "./errorUtils.js";
export const name = "ynab_get_transactions";
export const description = "Gets transactions from a budget with optional filters. Can filter by date range, account, category, payee, or approval status.";
export const inputSchema = {
budgetId: z.string().optional().describe("The ID of the budget (optional, defaults to YNAB_BUDGET_ID environment variable)"),
sinceDate: z.string().optional().describe("Only return transactions on or after this date (ISO format: 2024-01-01)"),
type: z.enum(["all", "uncategorized", "unapproved"]).optional().describe("Filter by transaction type. Defaults to 'all'."),
accountId: z.string().optional().describe("Filter to only transactions in this account"),
categoryId: z.string().optional().describe("Filter to only transactions in this category"),
payeeId: z.string().optional().describe("Filter to only transactions with this payee"),
limit: z.number().optional().describe("Maximum number of transactions to return (default: 100)"),
};
function getBudgetId(inputBudgetId) {
const budgetId = inputBudgetId || process.env.YNAB_BUDGET_ID || "";
if (!budgetId) {
throw new Error("No budget ID provided. Please provide a budget ID or set the YNAB_BUDGET_ID environment variable.");
}
return budgetId;
}
function mapTransactionType(type) {
switch (type) {
case "uncategorized":
return ynab.GetTransactionsTypeEnum.Uncategorized;
case "unapproved":
return ynab.GetTransactionsTypeEnum.Unapproved;
default:
return undefined;
}
}
export async function execute(input, api) {
try {
const budgetId = getBudgetId(input.budgetId);
const limit = input.limit || 100;
let rawTransactions;
// Use the appropriate API method based on filters
if (input.accountId) {
const response = await api.transactions.getTransactionsByAccount(budgetId, input.accountId, input.sinceDate, mapTransactionType(input.type));
rawTransactions = response.data.transactions;
}
else if (input.categoryId) {
const response = await api.transactions.getTransactionsByCategory(budgetId, input.categoryId, input.sinceDate, mapTransactionType(input.type));
rawTransactions = response.data.transactions;
}
else if (input.payeeId) {
const response = await api.transactions.getTransactionsByPayee(budgetId, input.payeeId, input.sinceDate, mapTransactionType(input.type));
rawTransactions = response.data.transactions;
}
else {
const response = await api.transactions.getTransactions(budgetId, input.sinceDate, mapTransactionType(input.type));
rawTransactions = response.data.transactions;
}
// Filter out deleted and apply limit
const transactions = rawTransactions
.filter((txn) => !txn.deleted)
.slice(0, limit)
.map((txn) => ({
id: txn.id,
date: txn.date,
amount: (txn.amount / 1000).toFixed(2),
memo: txn.memo,
approved: txn.approved,
cleared: txn.cleared,
account_name: txn.account_name,
payee_name: txn.payee_name,
category_name: txn.category_name,
flag_color: txn.flag_color,
transfer_account_id: txn.transfer_account_id,
}));
return {
content: [{
type: "text",
text: JSON.stringify({
transactions,
transaction_count: transactions.length,
total_available: rawTransactions.filter((t) => !t.deleted).length,
}, null, 2),
}],
};
}
catch (error) {
console.error("Error getting transactions:", error);
return {
content: [{
type: "text",
text: JSON.stringify({
success: false,
error: getErrorMessage(error),
}, null, 2),
}],
};
}
}
