Hi Chuck

I have been through the very same issue.

It seems that using the Powershell Invoke-RestMethod (and Invoke-WebRequest) works fine with text based requests, but does something weird when uploading a twbx, tdsx, or tde.

Therefore I used the System.New.WebClient method instead

The setup is the same as with the Invoke-RestMethod, but using the following process.

  $wc = New-Object System.Net.WebClient

  $wc.Headers.Add('X-Tableau-Auth',$headers.Values[0])

  $wc.Headers.Add('ContentLength', $request_body.Length)

  $wc.Headers.Add('Content-Type', 'multipart/mixed; boundary=6691a87289ac461bab2c945741f136e6')

  $response = $wc.UploadString($url ,'POST', $request_body)

The $request_body is of the following format

the boundary=xxxx needs to be the same as the boundary-string in the request_body

the $url is of the format "http://servername/api/2.2/sites/<siteID>/workbooks"

Hope this helps

All the best

Glen

Thanks Chuck

Thats interesting, as I could never get the Invoke-RestMethod to work (for either 'publish workbook' or 'File Upload')

Is this with workbooks that contain extracts (always failed for me) or for workbooks without extracts (no problem getting this to work)?

All the best

Glen

Can you post a code snippet of this process.

Would anyone care to share a working code snippet for uploading a simple .twb file that is using a published data source on Tableau server or point out what I could be doing wrong in my code snippet shared towards the end of this message? The file is less than 2MB in size so no need to do chunking etc.  I've tried tinkering with code I have and it just keeps throwing the following error:

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

<tsResponse xmlns="http://tableau.com/api" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://tableau.com/api http://tableau.com/api/ts-api-2.5.xsd">

    <error code="400000">

        <summary>Bad Request</summary>

        <detail>Payload is either malformed XML/JSON or incomplete</detail>

    </error>

</tsResponse>

Here is the code snippet that I'm using which also shows commented lines reflecting what other variations I've tried but still no success:

############################################################################################################################################

$TargetProjectName = "TestProject"
$Credential = Get-Credential
$TargetProjectID =
$TargetWorkbookName = "TestUpload"
$authToken = "AssumeCorrectAuthTokenIsSetHere"

#Get contents of file read in a variable
#$content = [IO.File]::ReadAllText("C:\Tableau\TestUpload.twb")
#$content = [IO.File]::ReadAllBytes("C:\Tableau\TestUpload.twb")

$content = Get-Content C:\Tableau\TestUpload.twb -Encoding Byte

$url = "https://myTableauServer.net/api/2.5/sites/$siteID/workbooks"

#Create request body
$request_body = ('--my123BoundaryStringIsThis
Content-Disposition: name="request_payload"
Content-Type: text/xml

<tsRequest>
  <workbook name="'+$TargetWorkbookName+'" showTabs="true">
    <connectionCredentials name="' + $Credential.GetNetworkCredential().UserName + '" password="'+ $Credential.GetNetworkCredential().Password + '" embed="true" />
    <project id="' + $TargetProjectID +'"/>
  </workbook>
</tsRequest>
--my123BoundaryStringIsThis
Content-Disposition: name="' + $TargetWorkbookName + '"; filename="TestUpload.twb"
Content-Type: application/octet-stream

'+$content+'
--my123BoundaryStringIsThis--')

$newHeader = New-Object “System.Collections.Generic.Dictionary[[String],[String]]”
# add X-Tableau-Auth header with our auth token
$newHeader.Add('X-Tableau-Auth', $authToken)
$newHeader.Add('ContentLength', $request_body.Length)
$newHeader.Add('Content-Type', 'multipart/mixed; boundary=my123BoundaryStringIsThis')

#$wc = New-Object System.Net.WebClient
#$wc.Headers.Add('X-Tableau-Auth',$authToken)
#$wc.Headers.Add('ContentLength', $request_body.Length)
#$wc.Headers.Add('Content-Type', 'multipart/mixed; boundary=my123BoundaryStringIsThis')

$response = Invoke-RestMethod -Uri $url -Headers $newHeader -Body $request_body -Method Post
#$response = $wc.UploadString($url ,"post", $request_body)

##########################################################################################################################