In Sisense Linux distribution you are able to upload files to the local environment using Droppy, which is embedded in the Sisense platform.

The script below will allow the user to upload files programmatically, using REST command. The script itself is written in Powershell.

Change the first 4 parameters

dns - The URL you use for your Sisense site

RemoteLocation - The location of the target file within Droppy

FilePath - The local location of the file from the Local Server

AUTH_TOEN - Generate a token and replace it with <token>

$dns= 'https://myhost.sisense.com'
$RemoteLocation= 'data/Test'
$FilePath = 'C:\myfolder\myfile.csv';
$AUTH_TOKEN = 'Bearer <Token>'

###############################################################
$pos = $FilePath.LastIndexOf("\")
$URL = $dns+'/app/explore/!/upload?vId=0&rename=0&to=/'+$RemoteLocation;
$filename = $FilePath.Substring($pos+1)
$fileBytes = [System.IO.File]::ReadAllBytes($FilePath);
$fileEnc = [System.Text.Encoding]::GetEncoding('UTF-8').GetString($fileBytes);
$boundary = [System.Guid]::NewGuid().ToString(); 
$LF = "`r`n";
$Headers = @{'Authorization'=$AUTH_TOKEN};

$bodyLines = ( 
 "--$boundary",
 "Content-Disposition: form-data; name=`"filename`"; filename=`"$filename`"",
 "Content-Type: application/octet-stream$LF",
 $fileEnc,
 "--$boundary--$LF" 
) -join $LF

Invoke-RestMethod -Uri $URL -Method Post -ContentType "multipart/form-data; boundary=`"$boundary`"" -headers $Headers -Body $bodyLines