PDF.co Web API - PDF To Excel API - JavaScript - Convert PDF To XLSX From Uploaded File (Node.js) - Async API - ByteScout

PDF.co Web API – PDF To Excel API – JavaScript – Convert PDF To XLSX From Uploaded File (Node.js) – Async API

  • Home
  • /
  • Articles
  • /
  • PDF.co Web API – PDF To Excel API – JavaScript – Convert PDF To XLSX From Uploaded File (Node.js) – Async API

PDF.co Web API – PDF To Excel API – JavaScript – Convert PDF To XLSX From Uploaded File (Node.js) – Async API

ConvertPdfToXlsxFromUploadedFile.js

[javascript]
/*jshint esversion: 6 */

var https = require(“https”);
var path = require(“path”);
var fs = require(“fs”);

// `request` module is required for file upload.
// Use “npm install request” command to install.
var request = require(“request”);

// The authentication key (API Key).
// Get your own by registering at https://app.pdf.co/documentation/api
const API_KEY = “***********************************”;

// Source PDF file
const SourceFile = “./sample.pdf”;
// Comma-separated list of page indices (or ranges) to process. Leave empty for all pages. Example: ‘0,2-5,7-‘.
const Pages = “”;
// PDF document password. Leave empty for unprotected documents.
const Password = “”;
// Destination XLSX file name
const DestinationFile = “./result.xlsx”;

// 1. RETRIEVE PRESIGNED URL TO UPLOAD FILE.
getPresignedUrl(API_KEY, SourceFile)
.then(([uploadUrl, uploadedFileUrl]) => {
// 2. UPLOAD THE FILE TO CLOUD.
uploadFile(API_KEY, SourceFile, uploadUrl)
.then(() => {
// 3. CONVERT UPLOADED PDF FILE TO XLSX
convertPdfToXlsx(API_KEY, uploadedFileUrl, Password, Pages, DestinationFile);
})
.catch(e => {
console.log(e);
});
})
.catch(e => {
console.log(e);
});

function getPresignedUrl(apiKey, localFile) {
return new Promise(resolve => {
// Prepare request to `Get Presigned URL` API endpoint
let queryPath = `/v1/file/upload/get-presigned-url?contenttype=application/octet-stream&name=${path.basename(SourceFile)}`;
let reqOptions = {
host: “api.pdf.co”,
path: encodeURI(queryPath),
headers: { “x-api-key”: API_KEY }
};
// Send request
https.get(reqOptions, (response) => {
response.on(“data”, (d) => {
let data = JSON.parse(d);
if (data.error == false) {
// Return presigned url we received
resolve([data.presignedUrl, data.url]);
}
else {
// Service reported error
console.log(“getPresignedUrl(): ” + data.message);
}
});
})
.on(“error”, (e) => {
// Request error
console.log(“getPresignedUrl(): ” + e);
});
});
}

function uploadFile(apiKey, localFile, uploadUrl) {
return new Promise(resolve => {
fs.readFile(SourceFile, (err, data) => {
request({
method: “PUT”,
url: uploadUrl,
body: data,
headers: {
“Content-Type”: “application/octet-stream”
}
}, (err, res, body) => {
if (!err) {
resolve();
}
else {
console.log(“uploadFile() request error: ” + e);
}
});
});
});
}

function convertPdfToXlsx(apiKey, uploadedFileUrl, password, pages, destinationFile) {
// Prepare request to `PDF To XLSX` API endpoint
var queryPath = `/v1/pdf/convert/to/xlsx?name=${path.basename(destinationFile)}&password=${password}&pages=${pages}&url=${uploadedFileUrl}&async=True`;
let reqOptions = {
host: “api.pdf.co”,
path: encodeURI(queryPath),
method: “GET”,
headers: { “x-api-key”: API_KEY }
};
// Send request
https.get(reqOptions, (response) => {
response.on(“data”, (d) => {
response.setEncoding(“utf8”);
// Parse JSON response
let data = JSON.parse(d);
if (data.error == false) {
checkIfJobIsCompleted(data.jobId, data.url, destinationFile);
}
else {
// Service reported error
console.log(“convertPdfToXlsx(): ” + data.message);
}
});
})
.on(“error”, (e) => {
// Request error
console.log(“convertPdfToXlsx(): ” + e);
});
}

function checkIfJobIsCompleted(jobId, resultFileUrl, destinationFile) {
let queryPath = `/v1/job/check?jobid=${jobId}`;
let reqOptions = {
host: “api.pdf.co”,
path: encodeURI(queryPath),
method: “GET”,
headers: { “x-api-key”: API_KEY }
};

https.get(reqOptions, (response) => {
response.on(“data”, (d) => {
response.setEncoding(“utf8”);
// Parse JSON response
let data = JSON.parse(d);
if (data.Status == “InProgress”) {
// Check again after 2 seconds
setTimeout(function(){ checkIfJobIsCompleted(jobId, resultFileUrl, destinationFile);}, 2000);
}
else if (data.Status == “Finished”) {
// Download XLSX file
var file = fs.createWriteStream(destinationFile);
https.get(resultFileUrl, (response2) => {
response2.pipe(file)
.on(“close”, () => {
console.log(`Generated XLSX file saved as “${destinationFile}” file.`);
});
});
}
else {
console.log(`Operation ended with status: “${data.Status}”.`);
}
})
});
}

[/javascript]


  Click here to get your Free Trial version of the SDK

Tutorials:

prev
next