nodeJs

var parser = require('xml2json-light');
const mysql = require('mysql');
const https = require('https');
const express = require('express')
const app = express()
const bodyparser = require('body-parser');

app.use(bodyparser.json());
const port = 3000

const db = mysql.createConnection({
    host : 'localhost',
    user : 'mario',
    password : 'mario',
    database : 'mario'

  });

app.listen(port, () => console.log(`Example app listening on port ${port}!`))

app.get('/', function(req, res) {

https.get('https://gw.polcan.pl/edi/rest/TServerMethodsExport/Cennik2XML/B23D4F63-8DB0-4153-B745-2B34F79C73EC', function(resp) {
  let data = '';


  resp.on('data', (chunk) => {
    data += chunk;
  });


  resp.on('end', () => {

    var xml = data;
    var json = parser.xml2json(xml);

    for (var myObj in json){

     for (i = 0; i < 10; i++) {
     var t = json[myObj].Produkt[i];

     DbInsert(t.EAN);

     }
    console.log("Dane pobrane i zapisane");
    }


  });

}).on("error", (err) => {
  console.log("Error: " + err.message);
})

});




function DbInsert(ean) {
  var ean;
  const queryString = "INSERT INTO employee(EAN) VALUES (?)";

  db.query(queryString, [ean], (err, results, fields) => {
    if (err) {
      console.log("Bład " + err)
    }
  })
}