Azure Block Blob PowerShell Script Creating 0 B files

Question

I'm new to Azure Blob Storage and I've written a PowerShell script for uploading SQL Server backup files from a given folder to my Azure Container. When I execute it a file is appearing in Azure but it's 0 Bytes in size. Here's my code:

#Finds newest .bak file in folder
$dir = "I:\Backup\*.bak"
$latest = Get-ChildItem -Path $dir | Sort-Object LastAccessTime -Descending | Select-Object -First 1

#Get the File-Name without path
$name = (Get-Item $latest).Name

#The target URL wit SAS Token
$uri = "https://*****.blob.core.windows.net/sapprodback/$($name)?***My SAS Token is here***"

#Define required Headers
$headers = @{
'x-ms-blob-type' = 'BlockBlob'
}

#Upload File...
Invoke-RestMethod -Uri $uri -Method Put -Headers $headers -InFile $latest

What am I missing?

where is $file defined? should it be $latest?

ewokx
– ewokx

2020-07-16 06:31:42 +00:00
Commented Jul 16, 2020 at 6:31 — ewokx
– ewokx, Commented Jul 16, 2020 at 6:31
Good point. Let me update my code. $file should be $latest

alcor8
– alcor8

2020-07-16 06:52:50 +00:00
Commented Jul 16, 2020 at 6:52 — alcor8
– alcor8, Commented Jul 16, 2020 at 6:52

alcor8 · Accepted Answer · 2020-07-16 07:16:54Z

0

I figured it out thanks for ewong's comment. My -InFile didn't have the full file path. I created another variable and concatenated it to my $latest.name and it worked.

#Finds newest .bak file in folder
$dir = "I:\Backup\*.bak"
$dir2 = "I:\Backup\"
$latest = Get-ChildItem -Path $dir | Sort-Object LastAccessTime -Descending | Select-Object -First 1

#Get the File-Name without path
$name = (Get-Item $latest).Name
$file = $dir2 + $name

#The target URL wit SAS Token
$uri = "https://*****.blob.core.windows.net/sapprodback/$($name)?***My SAS Token is here***"

#Define required Headers
$headers = @{
'x-ms-blob-type' = 'BlockBlob'
}

#Upload File...
Invoke-RestMethod -Uri $uri -Method Put -Headers $headers -InFile $file

answered Jul 16, 2020 at 7:16

alcor8

3831 gold badge3 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Azure Block Blob PowerShell Script Creating 0 B files

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related