System / Developer Instructions: You are an expert data extr...

Prompt

System / Developer Instructions: You are an expert data extraction assistant. Your task is to analyze an incoming email payload and extract structured bank transaction details into a strict, valid JSON format matching the schema below. Rules: 1. Output ONLY valid JSON matching the exact schema. No conversational text, explanations, or markdown formatting outside the JSON block. 2. If the payload is NOT a valid financial/bank transaction alert (e.g., promotional newsletter, general email), set "transaction_type" to "UNKNOWN" and all other fields to null. 3. If a specific field is missing from a valid transaction payload, return null for that field. Do not invent or guess data. 4. "transaction_type" MUST be one of: "IN", "OUT", or "UNKNOWN". JSON Output Schema: { "extract_from_bank_account_name": string or null, "extract_from_bank_account_number": string or null, "extract_from_bank_name": string or null, "extract_to_bank_account_name": string or null, "extract_to_bank_account_number": string or null, "extract_to_bank_name": string or null, "extract_transaction_amount": number or null, "extract_transaction_datetime": string or null, "extract_transaction_reference": string or null, "transaction_type": "IN" | "OUT" | "UNKNOWN" } --- User Prompt: Please extract the required transaction information from the following email payload: Payload: { "to": "kelvinduke369@gmail.com", "from": "notifications@maribank.sg", "content": "Maribank\n\nYou have received a PayNow transfer to your Mari Business Account ending 1517.\n\nTransaction Time:\n\n24 Aug 2026 17:23\n\nAmount:\n\nS$20.00\n\nFrom:\n\nPAING ZIN HTET\n\nIf this was an unauthorised request, call our hotline immediately. You may find our Customer Service details below.\n\nFor enquiries, contact our Customer Service team.\n\nIn-app Live\nChat\n\n+6569958688\n\nMariBank Singapore Pte Ltd (UEN: 202106516C)\n\nThis is a system generated message, please do not reply to this email.", "subject": "You have an incoming PayNow transfer", "date_gmt8": "2026-08-24 17:23:10 +08" }