Powershell Import-CSV from SharePoint

Question

Is there a way to import a CSV from a Website and use it in PowerShell? With the Import-Csv Cmdlet I get this error:

$FilePath = "http://sharepoint.com/mydocuments/serverlist.csv"
$serverList = Import-Csv $FilePath -Delimiter ";"


Import-Csv : Cannot find drive. A drive with the name 'http' does not exist.
At line:2 char:15
+ $serverList = Import-Csv $FilePath -Delimiter ";"
+               ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : ObjectNotFound: (http:String) [Import-Csv], DriveNotFoundException
    + FullyQualifiedErrorId : DriveNotFound,Microsoft.PowerShell.Commands.ImportCsvCommand

Raf · Accepted Answer · 2014-06-19 09:31:50Z

2

Download the CSV first:

$FilePath = "http://sharepoint.com/mydocuments/serverlist.csv"
$localPath = "C:\temp\serverlist.csv"
$wc = New-Object System.Net.Webclient
$wc.DownloadFile($FilePath, $localPath)
$serverList = Import-Csv $localPath -Delimiter ";"

answered Jun 19, 2014 at 9:31

Raf

10.2k1 gold badge34 silver badges42 bronze badges

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

Comments

Rhys Donaubauer · Accepted Answer · 2021-03-15 22:09:30Z

0

Try this (Make sure you add your headers if you don't already have them or remove header option if you do):

#Create an array 
$serverList= @()
#Create URL Variable
$FilePath= "http://sharepoint.com/mydocuments/serverlist.csv"
#ImportData from URL and use convert-FromCSV into Array
$serverList = (Invoke-WebRequest $FilePath).content | ConvertFrom-Csv -Delim ';' -Header 'header1','header2'

edited Mar 15, 2021 at 22:09

answered Mar 15, 2021 at 22:04

Rhys Donaubauer

11 bronze badge

Collectives™ on Stack Overflow

Powershell Import-CSV from SharePoint

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related