使用Node和Express从远程url获取csv数据

const express = require('express');
const axios = require('axios');
const csv = require('csv-parser');

const app = express();

app.get('/get-csv-data', (req, res) => {
  const url = '远程URL地址'; // 替换为实际的远程URL地址

  axios.get(url)
    .then(response => {
      const csvData = response.data;

      // 解析CSV数据
      const results = [];
      csvData
        .pipe(csv())
        .on('data', (data) => results.push(data))
        .on('end', () => {
          res.json(results);
        });
    })
    .catch(error => {
      console.error(error);
      res.status(500).send('Failed to fetch CSV data');
    });
});

const port = 3000; // 可以根据需要修改端口号
app.listen(port, () => {
  console.log(`Server is running on port ${port}`);
});