script.js

(() => {
  const PAGE_COUNT = 25;

  const getCookie = (name) => {
    const value = `; ${document.cookie}`;
    const parts = value.split(`; ${name}=`);
    if (parts.length === 2) return parts.pop().split(";").shift();
  };

  const fetchHeaders = () => {
    return new Headers({
      authority: "api.koinly.io",
      accept: "application/json, text/plain, */*",
      "accept-language": "en-GB,en-US;q=0.9,en;q=0.8",
      "access-control-allow-credentials": "true",
      "caches-requests": "1",
      cookie: document.cookie,
      origin: "https://app.koinly.io",
      referer: "https://app.koinly.io/",
      "sec-fetch-dest": "empty",
      "sec-fetch-mode": "cors",
      "sec-fetch-site": "same-site",
      "sec-gpc": "1",
      "user-agent": navigator.userAgent,
      "x-auth-token": getCookie("API_KEY"),
      "x-portfolio-token": getCookie("PORTFOLIO_ID"),
    });
  };

  const fetchSession = async () => {
    const requestOptions = {
      method: "GET",
      headers: fetchHeaders(),
      redirect: "follow",
    };

    try {
      const response = await fetch(
        "https://api.koinly.io/api/sessions",
        requestOptions
      );
      return response.json();
    } catch (err) {
      console.error(err);
      throw new Error("Fetch session failed");
    }
  };

  const fetchPage = async (pageNumber) => {
    const requestOptions = {
      method: "GET",
      headers: fetchHeaders(),
      redirect: "follow",
    };

    try {
      const response = await fetch(
        `https://api.koinly.io/api/transactions?per_page=${PAGE_COUNT}&order=date&page=${pageNumber}`,
        requestOptions
      );
      return response.json();
    } catch (err) {
      console.error(err);
      throw new Error(`Fetch failed for page=${pageNumber}`);
    }
  };

  const getAllTransactions = async () => {
    const firstPage = await fetchPage(1);
    const totalPages = firstPage.meta.page.total_pages;
    const promises = [];
    for (let i = 2; i <= totalPages; i++) promises.push(fetchPage(i));

    const remainingPages = await Promise.all(promises);
    return [firstPage, ...remainingPages].flatMap((it) => it.transactions);
  };

  const toCSVFile = (baseCurrency, transactions) => {
    // Headings
    // Representing Koinly Spreadsheet (https://docs.google.com/spreadsheets/d/1dESkilY70aLlo18P3wqXR_PX1svNyAbkYiAk2tBPJng/edit#gid=0)
    const headings = [
      "Date",
      "Sent Amount",
      "Sent Currency",
      "From Wallet",
      "Received Amount",
      "Received Currency",
      "To Wallet",
      "Fee Amount",
      "Fee Currency",
      "Net Worth Amount",
      "Net Worth Currency",
      "Label",
      "Description",
      "TxHash",
      // EXTRA_HEADERS: Add extra headers as necessary (ensure you also update "row" below)
    ];

    const transactionRows = transactions.map((t) => {
      const row = [
        t.date,
        t.from ? t.from.amount : "",
        t.from ? t.from.currency.symbol : "",
        t.from ? t.from.wallet.name : "",
        t.to ? t.to.amount : "",
        t.to ? t.to.currency.symbol : "",
        t.to ? t.to.wallet.name : "",
        t.fee ? t.fee.amount : "",
        t.fee ? t.fee.currency.symbol : "",
        t.net_value,
        baseCurrency,
        t.type,
        t.description,
        t.txhash,
        // EXTRA_FIELDS: Add extra fields as necessary (ensure you also update "headings" above)
      ];
      return row.join(",");
    });

    const csv = [headings.join(","), ...transactionRows].join("\n");

    const hiddenElement = document.createElement("a");
    var csvData = new Blob([csv], { type: "text/csv" });
    hiddenElement.href = URL.createObjectURL(csvData);
    hiddenElement.target = "_blank";
    hiddenElement.download = "Koinly Transactions.csv";

    hiddenElement.click();
  };

  const run = async () => {
    const session = await fetchSession();
    const baseCurrency = session.portfolios[0].base_currency.symbol;
    const transactions = await getAllTransactions();
    console.log("Your Koinly Transactions\n", transactions);
    toCSVFile(baseCurrency, transactions);
  };

  run();
})();