download

import requests
import json
import re
import time
from datetime import datetime
import websocket
from websocket import create_connection
 
# Sisense API token
apiToken = 'Bearer YOUR_API_TOKEN'

# Sisense hostname
sisenseHost = 'https://test.sisense.com'


# Retreive Droppy session token
url = sisenseHost + '/app/explore/!/token'
headers = {'content-type': 'application/x-www-form-urlencoded',
'accept': '*/*',
'accept-encoding' : 'gzip, deflate, br',
'accept-language' : 'en-US,en;q=0.9,ru;q=0.8',
'dnt' : '1',
'Authorization': apiToken,
'sec-fetch-dest' : 'empty',
'sec-fetch-mode' : 'same-origin',
'sec-fetch-site' : 'same-origin',
'user-agent' : 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.149 Safari/537.36',
'x-app': 'droppy'

}
r = requests.get(url, headers=headers)
token = r.content
token = str(token, 'utf-8')



def downloadFolder(externalPath, localPath):
	# Downloads folder content as ZIP archive
	headers = {
	'Authorization': apiToken,
	}

	if localPath[-1] != '\\':
		localPath += '\\'
	if externalPath[0] == '/':
		externalPath = externalPath[1:]

	url = '%s/app/explore/!/zip/%s'%(sisenseHost, externalPath)

	r = requests.get(url, headers=headers, allow_redirects=True)

	m = re.search('filename="(.*?)"', r.headers.get('content-disposition'))
	if m:
		filename = m.group(1)


	open(localPath+filename, 'wb').write(r.content)


def downloadFile(externalPath, localPath):
	headers = {
	'Authorization': apiToken,
	}

	if localPath[-1] != '\\':
		localPath += '\\'
	if externalPath[0] == '/':
		externalPath = externalPath[1:]

	url = '%s/app/explore/!/dl/%s'%(sisenseHost, externalPath)

	r = requests.get(url, headers=headers, allow_redirects=True)

	m = re.search('filename="(.*?)"', r.headers.get('content-disposition'))
	if m:
		filename = m.group(1)


	open(localPath+filename, 'wb').write(r.content)





def deleteObject(ws, objectPath):
	command = {"vId":0,"type":"DELETE_FILE","data":objectPath,"token":token}
	ws.send(json.dumps(command))

def renameObject(ws, oldPath, newPath):
	command = {"vId":0,"type":"RENAME","data":{"src":oldPath,"dst": newPath},"token":token}
	ws.send(json.dumps(command))


def copyObject(ws, oldPath, newPath):
	command = {"vId":0,"type":"CLIPBOARD","data":{"type":"copy","src":oldPath,"dst":newPath},"token":token}
	ws.send(json.dumps(command))

def moveObject(ws, oldPath, newPath):
	command = {"vId":0,"type":"CLIPBOARD","data":{"type":"cut","src":oldPath,"dst":newPath},"token":token}
	ws.send(json.dumps(command))

def listFolder(ws, folderPath):
	command = {"vId":0,"type":"REQUEST_UPDATE","data":folderPath,"token":token}
	ws.send(json.dumps(command))
	result = json.loads(ws.recv())

	# Following code is for pretty print folder content
	for k, v in result.get('data').items():
		val = v.split('|')
		timeModified = datetime.utcfromtimestamp(int(val[1])).strftime('%Y-%m-%d %H:%M:%S')
		if val[0] == 'f':
			print ('File %s; Modified(UTC) %s; Size %s B'%(k, timeModified, val[2]))
		elif val[0] == 'd':
			print ('Directory %s; Modified(UTC) %s; Size %s B'%(k, timeModified, val[2]))




websocket.enableTrace(False)
ws = create_connection('wss%s/app/explore/!/socket'%(sisenseHost.replace('https','')))

# Function for deleting file/folder
#deleteObject(ws, '/data/Test/wetwt.txt')
# Function for copying file/folder
#copyObject(ws, '/data/Test/asd.txt', '/data/Test/New folder/asd.txt')
# Function for moving file/folder
#moveObject(ws, '/data/Test/asd1.txt', '/data/Test/New folder/asd1.txt')
# Function for viewing folder content
# listFolder(ws, '/connectors/excel')
# Function for renaming file/folder
#renameObject(ws, '/data/Test/asd.txt', '/data/Test/asd1.txt')
# Function for downloading folder
#downloadFolder('/data/Test/New folder', r'C:\Users\vladislav.kokh\Documents')
# Function for downloading file
#downloadFile('/data/Test/New folder/assssd.txt', r'C:\Users\vladislav.kokh\Documents')