☰

WF QFX Statement Downloader

Automatically download QFX statements from WF

// ==UserScript==
// @name         WF QFX Statement Downloader
// @namespace    Violentmonkey Scripts
// @license      MIT
// @version      1.1
// @description  Automatically download QFX statements from WF
// @match        https://*.wellsfargo.com/*
// @grant        GM_download
// @grant        GM_xmlhttpRequest
// ==/UserScript==
(function () {
'use strict';

// src/common.ts
async function getWindowProperty(property, POLL_INTERVAL) {
  return new Promise((resolve) => {
    const check = setInterval(() => {
      const el = property(window.unsafeWindow);
      if (el) {
        clearInterval(check);
        resolve(el);
      }
    }, POLL_INTERVAL);
  });
}
function formatDateMMsDDsYYYY(date) {
  return `${(date.getMonth() + 1).toString().padStart(2, "0")}/${date.getDate().toString().padStart(2, "0")}/${date.getFullYear()}`;
}
function getDateRange(today, endOnBusiness = false) {
  let date = new Date(today);
  if (endOnBusiness) {
    if (date.getDay() === 0) {
      date.setDate(date.getDate() - 2);
    } else if (date.getDay() === 6) {
      date.setDate(date.getDate() - 1);
    } else {
      date.setDate(date.getDate() - 1);
      if (date.getDay() === 0) {
        date.setDate(date.getDate() - 2);
      } else if (date.getDay() === 6) {
        date.setDate(date.getDate() - 1);
      }
    }
  }
  let start;
  if (date.getMonth() >= 2) {
    start = new Date(date.getFullYear(), 0, 1);
  } else {
    start = new Date(date.getFullYear() - 1, 6, 1);
  }
  return [start, date];
}
function GM_xmlhttpRequest_promise(pack) {
  return new Promise((resolve, reject) => {
    GM_xmlhttpRequest({ ...pack, onload: resolve, onerror: reject });
  });
}
async function easyRequest({ url, method, payload, headers }) {
  function helper() {
    if (method === "GET") {
      const U = new URL(url);
      payload?.forEach((value, key) => U.searchParams.append(decodeURIComponent(key), decodeURIComponent(value)));
      return GM_xmlhttpRequest_promise({ method: "GET", url: U.toString(), headers });
    } else if (method === "POST.url") {
      return GM_xmlhttpRequest_promise({
        method: "POST",
        url,
        data: payload?.toString(),
        headers: { "Content-Type": "application/x-www-form-urlencoded", ...headers }
      });
    } else if (method === "POST.form") {
      const formData = new FormData;
      payload?.forEach((value, key) => formData.append(decodeURIComponent(key), decodeURIComponent(value)));
      return GM_xmlhttpRequest_promise({ method: "POST", url, data: formData, headers });
    } else if (method === "POST.json") {
      const _headers = new Map(Object.entries(headers || {}));
      if (!(_headers.get("Content-Type") || _headers.has("content-type"))) {
        _headers.set("Content-Type", "application/json");
      }
      return GM_xmlhttpRequest_promise({
        method: "POST",
        url,
        data: JSON.stringify(payload),
        headers: Object.fromEntries(_headers)
      });
    }
    throw new Error(`Unsupported method: ${method}`);
  }
  const { status, responseText } = await helper();
  if (status !== 200) {
    throw new Error(`Request failed: ${status} ${responseText}`);
  }
  return responseText;
}
async function easyDownload({ content, name, saveAs = true }) {
  let type;
  if (name.endsWith(".qfx"))
    type = "application/x-qfx";
  else if (name.endsWith(".csv"))
    type = "text/csv";
  else
    type = "application/octet-stream";
  await GM_download_promise({
    url: URL.createObjectURL(new Blob([content.trim()], { type })),
    name,
    saveAs
  });
}
function GM_download_promise(option) {
  const { url, name, saveAs } = option;
  return new Promise((resolve, reject) => {
    GM_download({ url, name, saveAs, onload: resolve, onerror: reject });
  });
}
function trimAccountName(name) {
  return name.trim().replace(/[\s-.]+/g, "").replace(/[\u2122\u00AE\u00A9]/g, "");
}

// src/wf/lib.ts
var BANK_ID = "wf";
var LOGGER_prefix = `[${BANK_ID} Downloader]`;
var POLL_INTERVAL = 500;
async function fireDownloadProcess() {
  const urls = await getWindowProperty((window2) => window2._wfPayload?.applicationData?.downloadAccountActivity?.urls, POLL_INTERVAL);
  const accounts = await getWindowProperty((window2) => window2._wfPayload?.applicationData?.downloadAccountActivity?.downloadAccountInfo?.allEligibleAccounts, POLL_INTERVAL);
  for (let i = 0;i < Math.min(urls.length, accounts.length); i++) {
    const urlObject = urls[i];
    const accountObject = accounts[i];
    console.log(`${LOGGER_prefix} Pair ${i}:`, { url: urlObject, account: accountObject });
    const url = urlObject["url"];
    const accountName = accountObject["displayName"];
    const accountId = accountObject["id"];
    const [payload, endDate] = await routine(accountId);
    const content = await easyRequest({
      method: "POST.form",
      url: `https://connect.secure.wellsfargo.com/services${url}`,
      payload
    });
    await easyDownload({
      content,
      name: `${BANK_ID}_${trimAccountName(accountName)}_${endDate}_YTD.qfx`,
      saveAs: true
    });
    console.log(`${LOGGER_prefix} File download`);
  }
}
async function routine(accountId) {
  const payload = new URLSearchParams;
  const [startDate, endDate] = getDateRange(new Date);
  payload.append("accountId", accountId);
  payload.append("fromDate", formatDateMMsDDsYYYY(startDate));
  payload.append("toDate", formatDateMMsDDsYYYY(endDate));
  payload.append("fileFormat", "quicken");
  return [payload, formatDateMMsDDsYYYY(endDate)];
}

// src/wf/index.ts
try {
  fireDownloadProcess();
} catch (err) {
  console.error("[WF Downloader] Error:", err);
}


})();