Automated Bank Reconciliation API Made Effortless

{
  "message": "Login successful.",
  "user": {
    "id": "user-uuid",
    "email": "[email protected]",
    "tier": "api_global"
  },
  "token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9..."
}

{
  "missingFromBooks": [
    {
      "Date": "2024-02-15",
      "Amount": "105.99",
      "Description": "Supplier Payment"
    },
    {
      "Date": "2024-02-21",
      "Amount": "-32.50",
      "Description": "Refund Received"
    }
  ],
  "removeFromBooks": [
    {
      "Date": "2024-01-30",
      "Amount": "250.00",
      "Description": "Transfer to Savings"
    }
  ]
}

// Generate encryption key
const generateKey = async () => {
  return await window.crypto.subtle.generateKey(
    {
      name: "AES-GCM",
      length: 256
    },
    true,
    ["encrypt", "decrypt"]
  );
};

// Encrypt CSV data
const encryptData = async (data, key) => {
  const iv = window.crypto.getRandomValues(new Uint8Array(12));
  const encoder = new TextEncoder();
  const encodedData = encoder.encode(data);

  const encryptedContent = await window.crypto.subtle.encrypt(
    {
      name: "AES-GCM",
      iv: iv
    },
    key,
    encodedData
  );

  const encryptedArray = new Uint8Array(iv.length + encryptedContent.byteLength);
  encryptedArray.set(iv);
  encryptedArray.set(new Uint8Array(encryptedContent), iv.length);

  return {
    encrypted: encryptedArray,
    key: await window.crypto.subtle.exportKey("raw", key)
  };
};

// Convert ArrayBuffer to Base64
const arrayBufferToBase64 = (buffer) => {
  const bytes = new Uint8Array(buffer);
  let binary = '';
  for (let i = 0; i < bytes.length; i++) {
    binary += String.fromCharCode(bytes[i]);
  }
  return btoa(binary);
};

// Usage
const processFiles = async (bankCsvContent, bookCsvContent) => {
  const key = await generateKey();
  const encryptedBank = await encryptData(bankCsvContent, key);
  const encryptedBook = await encryptData(bookCsvContent, key);
  
  const payload = {
    bankCsv: arrayBufferToBase64(encryptedBank.encrypted),
    bookCsv: arrayBufferToBase64(encryptedBook.encrypted),
    key: arrayBufferToBase64(encryptedBank.key),
    clientId: Date.now().toString(36) + Math.random().toString(36).substring(2)
  };
  
  // Now send this payload to the API
  // ...
};

// Connect to WebSocket with client ID and token
const connectWebSocket = (clientId, token) => {
  const ws = new WebSocket(`wss://api.bankreconciler.app/ws?clientId=${clientId}&token=${token}`);
  
  ws.onopen = () => {
    console.log('WebSocket connected');
    // Send an initial ping
    ws.send(JSON.stringify({ type: 'ping' }));
  };
  
  ws.onmessage = (event) => {
    try {
      const data = JSON.parse(event.data);
      
      if (data.percentage !== undefined) {
        // Update progress UI
        updateProgressBar(data.percentage);
        updateProgressText(data.status || `Processing... ${Math.round(data.percentage)}%`);
      }
    } catch (err) {
      console.error('Failed to parse WebSocket message:', err);
    }
  };
  
  ws.onclose = () => {
    console.log('WebSocket connection closed');
  };
  
  return ws;
};