Convert PDF To XLS From URL Asynchronously - PowerShell
PDF To XLS sample in PowerShell demonstrating ‘Convert PDF To XLS From URL Asynchronously’
ConvertPdfToXlsFromUrlAsynchronously.ps1
# Cloud API asynchronous "PDF To XLS" job example.
# Allows to avoid timeout errors when processing huge or scanned PDF documents.
# The authentication key (API Key).
# Get your own by registering at https://app.pdf.co
$API_KEY = "***********************************"
# Direct URL of source PDF file.
$SourceFileUrl = "https://bytescout-com.s3.amazonaws.com/files/demo-files/cloud-api/pdf-to-excel/sample.pdf"
# Comma-separated list of page indices (or ranges) to process. Leave empty for all pages. Example: '0,2-5,7-'.
$Pages = ""
# PDF document password. Leave empty for unprotected documents.
$Password = ""
# Destination XLS file name
$DestinationFile = ".\result.xls"
# (!) Make asynchronous job
$Async = $true
# Prepare URL for `PDF To XLS` API call
$query = "https://api.pdf.co/v1/pdf/convert/to/xls"
# Prepare request body (will be auto-converted to JSON by Invoke-RestMethod)
# See documentation: https://apidocs.pdf.co
$body = @{
"name" = $(Split-Path $DestinationFile -Leaf)
"password" = $Password
"pages" = $Pages
"url" = $SourceFileUrl
"async" = $Async
} | ConvertTo-Json
try {
# Execute request
$response = Invoke-WebRequest -Method Post -Headers @{ "x-api-key" = $API_KEY; "Content-Type" = "application/json" } -Body $body -Uri $query
$jsonResponse = $response.Content | ConvertFrom-Json
if ($jsonResponse.error -eq $false) {
# Asynchronous job ID
$jobId = $jsonResponse.jobId
# URL of generated XLS file that will available after the job completion
$resultFileUrl = $jsonResponse.url
# Check the job status in a loop.
do {
$statusCheckUrl = "https://api.pdf.co/v1/job/check?jobid=" + $jobId
$jsonStatus = Invoke-RestMethod -Method Get -Headers @{ "x-api-key" = $API_KEY } -Uri $statusCheckUrl
# Display timestamp and status (for demo purposes)
Write-Host "$(Get-date): $($jsonStatus.status)"
if ($jsonStatus.status -eq "success") {
# Download XLS file
Invoke-WebRequest -Headers @{ "x-api-key" = $API_KEY } -OutFile $DestinationFile -Uri $resultFileUrl
Write-Host "Generated XLS file saved as `"$($DestinationFile)`" file."
break
}
elseif ($jsonStatus.status -eq "working") {
# Pause for a few seconds
Start-Sleep -Seconds 3
}
else {
Write-Host $jsonStatus.status
break
}
}
while ($true)
}
else {
# Display service reported error
Write-Host $jsonResponse.message
}
}
catch {
# Display request error
Write-Host $_.Exception
}
run.bat
@echo off
powershell -NoProfile -ExecutionPolicy Bypass -Command "& .\ConvertPdfToXlsFromUrlAsynchronously.ps1"
echo Script finished with errorlevel=%errorlevel%
pause
PDF.co Web API: the Web API with a set of tools for documents manipulation, data conversion, data extraction, splitting and merging of documents. Includes image recognition, built-in OCR, barcode generation and barcode decoders to decode bar codes from scans, pictures and pdf.
Download Source Code (.zip)
return to the previous page explore PDF To XLS endpoint
Copyright © 2016 - 2024 PDF.co