Bank USD/CRC exchanges mapping to JSON

readme.md

Bank USD/CRC exchanges mapping to JSON

This script is meant to be executed against https://gee.bccr.fi.cr/IndicadoresEconomicos/Cuadros/frmConsultaTCVentanilla.aspx

It gets the table mapped into a JSON (technically, it should work with any table if you point the main function to any table, this should get you a JSON representation of it.

bank_usd_crc_mappings.js

const getHeaders = (tableRow) =>
  Array
    .from(tableRow.querySelectorAll('td'))
    .map(header => header.innerText);

const getTableRows = (tableElement) => 
  Array
    .from(
      tableElement
        .querySelectorAll('tr')
    );

const getBankDataFromRow = (headers, row) => 
  headers
    .reduce((acc = {}, header, index) => ({
      ...acc,
      [header]: row[index].innerText
    }), {});

const main = (tableElement) => {  
  const tableRows = getTableRows(tableElement);
  const headers = getHeaders(tableRows.shift());
  
  return tableRows
    // Extract all columns from the row
    .map(row => Array.from(row.querySelectorAll('td')))
    // Map each header to each column into an object
    .map(row => getBankDataFromRow(headers, row));
};

const banksTable = document.querySelector('#DG');
const jsonTable = main(banksTable);

console.log(jsonTable);