Pass List to Variable in URL String

Question

I am trying to use a variable that loops through a list of words to be used in downloading password-protected files from a URL.

sites.txt:

BOS
HFD
LGA
NYC
PHI
WWD

Powershell Script:

$sites = Get-Content C:\Users\...\sites.txt

$time = (Get-Date).ToString("yyyyMMdd")

$Username = 'hello'
$Password = 'world'
$url = "http://my.website/" + $sites + "/some.csv"

$Path = "D:\...\...\" + $sites + "/some.csv"
$WebClient = New-Object System.Net.WebClient
$WebClient.Credentials = New-Object System.Net.Networkcredential($Username, $Password)
$WebClient.DownloadFile( $url, $path )

I am getting "unexpected token" errors so, I'm assuming that I am not using the $site variable correctly in the URL string.

I wonder if it's simply that a combination of slashes and backslashes are used when the $Path variable is set? — Steve Matthews
– Steve Matthews, Commented Oct 6, 2016 at 15:30

Bob007 · Accepted Answer · 2016-10-06 15:50:12Z

1

$sites = Get-Content C:\Users\...\sites.txt
ForEach ($Site in $sites){
$url = "http://my.website/" + $Site + "/some.csv"
$Path = "D:\...\...\" + $Site + "\some.csv"
$Path
$url
}

This will pass your list into individual URL's Edited to include change to '$Path' as well.

edited Oct 6, 2016 at 15:50

answered Oct 6, 2016 at 15:45

Bob007

1091 silver badge7 bronze badges

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

Collectives™ on Stack Overflow

Pass List to Variable in URL String

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