PDF.co Web API - CSV To PDF API - PowerShell - Convert CSV To PDF From Uploaded File - ByteScout

PDF.co Web API – CSV To PDF API – PowerShell – Convert CSV To PDF From Uploaded File

  • Home
  • /
  • Articles
  • /
  • PDF.co Web API – CSV To PDF API – PowerShell – Convert CSV To PDF From Uploaded File

PDF.co Web API – CSV To PDF API – PowerShell – Convert CSV To PDF From Uploaded File

ConvertCsvToPdfFromUploadedFile.ps1

[powershell]
# The authentication key (API Key).
# Get your own by registering at https://app.pdf.co/documentation/api
$API_KEY = “***********************************”

# Source CSV file
$SourceFile = “.\sample.csv”
# Destination PDF file name
$DestinationFile = “.\result.pdf”

# 1. RETRIEVE THE PRESIGNED URL TO UPLOAD THE FILE.
# * If you already have a direct file URL, skip to the step 3.

# Prepare URL for `Get Presigned URL` API call
$query = “https://api.pdf.co/v1/file/upload/get-presigned-url?contenttype=application/octet-stream&name=” + `
[System.IO.Path]::GetFileName($SourceFile)
$query = [System.Uri]::EscapeUriString($query)

try {
# Execute request
$jsonResponse = Invoke-RestMethod -Method Get -Headers @{ “x-api-key” = $API_KEY } -Uri $query

if ($jsonResponse.error -eq $false) {
# Get URL to use for the file upload
$uploadUrl = $jsonResponse.presignedUrl
# Get URL of uploaded file to use with later API calls
$uploadedFileUrl = $jsonResponse.url

# 2. UPLOAD THE FILE TO CLOUD.

$r = Invoke-WebRequest -Method Put -Headers @{ “x-api-key” = $API_KEY; “content-type” = “application/octet-stream” } -InFile $SourceFile -Uri $uploadUrl

if ($r.StatusCode -eq 200) {

# 3. CONVERT UPLOADED CSV FILE TO PDF

# Prepare URL for `CSV To PDF` API call
$query = “https://api.pdf.co/v1/pdf/convert/from/csv?name=$(Split-Path $DestinationFile -Leaf)&url=$($uploadedFileUrl)”
$query = [System.Uri]::EscapeUriString($query)

# Execute request
$jsonResponse = Invoke-RestMethod -Method Get -Headers @{ “x-api-key” = $API_KEY } -Uri $query

if ($jsonResponse.error -eq $false) {
# Get URL of generated PDF file
$resultFileUrl = $jsonResponse.url;

# Download PDF file
Invoke-WebRequest -Headers @{ “x-api-key” = $API_KEY } -OutFile $DestinationFile -Uri $resultFileUrl

Write-Host “Generated PDF file saved as `”$($DestinationFile)`” file.”
}
else {
# Display service reported error
Write-Host $jsonResponse.message
}
}
else {
# Display request error status
Write-Host $r.StatusCode + ” ” + $r.StatusDescription
}
}
else {
# Display service reported error
Write-Host $jsonResponse.message
}
}
catch {
# Display request error
Write-Host $_.Exception
}

[/powershell]

run.bat

[text]
@echo off

powershell -NoProfile -ExecutionPolicy Bypass -Command “& .\ConvertCsvToPdfFromUploadedFile.ps1”
echo Script finished with errorlevel=%errorlevel%

pause
[/text]


  Click here to get your Free Trial version of the SDK

Tutorials:

prev
next