How I get data from an API and convert to an file.XLSX?

[Klao]

Thats it, I have to do that but I'm new programing and I'm quite of lost

const xl = require("excel4node");
const wb = new xl.Workbook();
const axios = require("axios");
const fs = require('fs');
// set url as constant
const URL = "https://restcountries.com/v3.1/all";

axios
.get(URL)
.then((response) => {
// const data = JSON.parse(response);
console.log(response);
fs.writeFileSync('countries.json', response);

})

.catch((error) => {
console.log(error);
});

 

[MeMate]

Not with pure JS.
You need something like PHP for that. I don't know what Api ur using (see the documentation of the developers if available) but usually you should be able to read from most apis by PHP call "curl". Google it.

Than you can use PHP to convert the data into a XLS. But you are as far away from what you are trying to do as the sun from our galaxy center. I don't know where to start to help you. I mean the data your API is returning is formated JSON already. But you can't write somethimg with javascript. Read yes, but not write. So you can't create an XLS File with JS. Not possible. PERIOD.

So PHP is your choice. Read a little bit about PHP and curl, try around with it and then come back to the forum (section PHP that time)

 

[BigDady]

"(snip)...as far away (snip)....... as the sun from our galaxy center.
I just love that MeMate!