-
-
Save weipah/19bfdb14aab253e3f109 to your computer and use it in GitHub Desktop.
function Import-Portatour { | |
param ( | |
[parameter(Mandatory=$True,Position=1)] [ValidateScript({ Test-Path -PathType Leaf $_ })] [String] $FilePath, | |
[parameter(Mandatory=$False,Position=2)] [System.URI] $ResultURL | |
) | |
# CONST | |
$CODEPAGE = "iso-8859-1" # alternatives are ASCII, UTF-8 | |
# We have a REST-Endpoint | |
$RESTURL = "https://my.portatour.net/a/api/ImportCustomers/" | |
# Testing | |
$userEmail = "some.user@example.org" | |
# Read file byte-by-byte | |
$fileBin = [System.IO.File]::ReadAllBytes($FilePath) | |
# Convert byte-array to string | |
$enc = [System.Text.Encoding]::GetEncoding($CODEPAGE) | |
$fileEnc = $enc.GetString($fileBin) | |
# Read a second hardcoded file which we want to upload through the API call | |
$importConfigFileEnc = $enc.GetString([System.IO.File]::ReadAllBytes("C:\Users\xyz\Documents\WindowsPowerShell\portatour.importcfg")) | |
# Create Object for Credentials | |
$user = "Username" | |
$pass = "Passw0rd" | |
$secpasswd = ConvertTo-SecureString $pass -AsPlainText -Force | |
$cred = New-Object System.Management.Automation.PSCredential ($user, $secpasswd) | |
# We need a boundary (something random() will do best) | |
$boundary = [System.Guid]::NewGuid().ToString() | |
# Linefeed character | |
$LF = "`r`n" | |
# Build up URI for the API-call | |
$uri = $RESTURL + "?userEmail=$userEmail&mode=UpdateOrInsert" | |
# Build Body for our form-data manually since PS does not support multipart/form-data out of the box | |
$bodyLines = ( | |
"--$boundary", | |
"Content-Disposition: form-data; name=`"file`"; filename=`"Import.xlsx`"", | |
"Content-Type: application/octet-stream$LF", | |
$fileEnc, | |
"--$boundary", | |
"Content-Disposition: form-data; name=`"importConfig`"; filename=`"portatour.importcfg`"", | |
"Content-Type: application/octet-stream$LF", | |
$importConfigFileEnc, | |
"--$boundary--$LF" | |
) -join $LF | |
try { | |
# Submit form-data with Invoke-RestMethod-Cmdlet | |
Invoke-RestMethod -Uri $uri -Method Post -ContentType "multipart/form-data; boundary=`"$boundary`"" -Body $bodyLines -Credential $cred | |
} | |
# In case of emergency... | |
catch [System.Net.WebException] { | |
Write-Error( "REST-API-Call failed for '$URL': $_" ) | |
throw $_ | |
} | |
} |
Thanks, was of great help. However I did have an issue around the boundary in the header
Invoke-RestMethod -Uri $uri -Method Post -ContentType "multipart/form-data; boundary="$boundary
""
I've had to remove the quotes around $boundary for it to work
Invoke-RestMethod -Uri $uri -Method POST -ContentType "multipart/form-data; boundary=$boundary"
Thanks for sharing this gist, it definitely helped me out. This is what I came up with
$file = "c:\file.txt"
$fileName = Split-Path $File
$boundary = [guid]::NewGuid().ToString()
$fileBin = [System.IO.File]::ReadAllBytes($File)
$enc = [System.Text.Encoding]::GetEncoding("iso-8859-1")
$fileEnc = $enc.GetString($fileBin)
$bodyLines = @(
"--$boundary",
"Content-Disposition: form-data; name=`"file`"; filename=`"$filename`"",
"Content-Type: application/octet-stream$LF",
$fileEnc,
"--$boundary",
"Content-Disposition: form-data; name=`"importConfig`"; filename=`"portatour.importcfg`"",
"Content-Type: application/octet-stream$LF",
$importConfigFileEnc,
"--$boundary--$LF"
) -join $LF
$Headers = @{
'Authorization' = $LoginToken
}
$params = @{
Uri = $Uri
Body = $bodyLines
Method = 'Post'
Headers = $headers
ContentType = "multipart/form-data; boundary=$boundary"
}
Invoke-RestMethod @params
`
I still having problem with file upload, can anyone try to help me, i got this
$CurlExecutable = "C:\Delphix\curl.exe"
$CurlArguments = '-l',
$url,
'--header', """content-type: multipart/form-data""",
'--header', """Authorization: ab2aac30-91b3-4790-8fda-80970dbadf33""",
'--form', "fileFormat=@e:\Tools\Powershell\Delphix\Masking\FileFormats\BS_REC00002_CSV.FF",
'--form', "fileFormatType=DELIMITED" ,
'-s'
@(& $CurlExecutable @CurlArguments)
And thats Work, but i would like to convert it to invoke-restmethod (to get rid of curl)
really thanks, that helps me more