Hi,

I tried for serveral days to upload a workbook with PS to Tableau 9.3 Server.

While all other rest queries like auth. and querying work fine, this one does not.

I don't know what's the problem. I tried several different methods but even this one without using .net to build the body does not work.

[String]$mimeType = [System.Web.MimeMapping]::GetMimeMapping("C:\Users\bla\Desktop\test.twb")
Write-Host $mimeType
[Byte[]]$buffer=[System.IO.File]::ReadAllBytes("C:\Users\bla\Desktop\test.twb")
[System.Text.Encoding]$enc=[System.Text.Encoding]::GetEncoding("ISO-8859-1")
[String]$strBody =("--BOUNDARY"+"Alpha"+"`r`n")
$strBody+=("Content-Disposition: name=`"request_payload`"`r`nContent-Type: text/xml`r`n`r`n"+$tmpXML.InnerXml.ToString()+"`r`n")
$strBody+=("--BOUNDARY"+"Alpha"+"`r`n")
$strBody+=("Content-Disposition: name=`"tableau_workbook`"; filename=`"test.twb`"`r`nContent-Type: application/octet-stream`r`n`r`n"+($enc.GetString($buffer))+"`r`n")
$strBody+=("--BOUNDARY"+"Alpha--")
write-host $strBody

Invoke-RestMethod -Uri ("https://tableauServerURL/api/2.2/sites/$($guidSiteID.ToString())/workbooks?workbookType=twb") -Method Post -Body $strBody -Headers $headers

The resulting body is as follows:

--BOUNDARYAlpha

Content-Disposition: name="request_payload"

Content-Type: text/xml

<tsRequest><workbook name="TEST NAME"><project id="a8c4e137-28f8-4018-958d-eb5327f67796" /></workbook></tsRequest>

--BOUNDARYAlpha

Content-Disposition: name="tableau_workbook"; filename="test.twb"

Content-Type: application/octet-stream

Start content of twb file

<?xml version='1.0' encoding='utf-8' ?>

<!-- build 9300.16.0315.0125                                -->

<workbook source-build='9.3.0 (9300.16.0315.0125)' source-platform='win' version='9.3' xmlns:user='http://www.tableausoftware.com/xml/user'>

Further content of twb file

--BOUNDARYAlpha--

I receive an error 500. Any idea what the problem is?

Thanks

KR

Peter