This article will cover two methods you can use to connect Python to the Elasticube. Method 1: Using ODBCMethod 2: Using the REST API Method 1: Connect to the EC with ODBC Download Sisense ODBC This method will require you to download the ODBC ...
On article Uploading Files Locally Using Rest (Linux) we saw examples of how to automate the upload of files to File Management. This article describe methods to automate the management of files on File Manager. Compatible with Linux Version <= L...
Download: Post Message Introduction The following forum post explains how to log your users out of Sisense from your native application. Purpose Single sign-on (SSO) systems enable your users to authenticate themselves in your online services and th...
Sharing a dashboard by using the REST API is very useful in case you need to automate the sharing process.However, in order to do so more than one API call is required, and not using them all in the right order will result in an unsuccessful share.Sh...
This script creates a word-document of the given dashboard IDs. This document includes dashboard name and Widget name,description and image. Config settings.yml Edit settings.yml with your information ! Be carefull running this script. It searche...
The following Python script allows exporting dashboard data to CSV files. The script will export each widget to a separate CSV file. This new version of the script uses Sisense's REST API an eliminates the direct connection to the mongodb. Important:...
In some cases you would like to add many users manually and in bulk, and won't want to go through the process of entering one at a time. With the following python app you will be able to insert users from a CSV by just running it. Steps: Download th...
Using the code from this article, a user can detect whether or not an ElastiCube is currently building, and refresh if the ElastiCube is not building. More importantly, the code in this article can be used as a framework for utilizing REST API functi...
»»» Sisense Verison 7.1 and below: UPDATED 6/10/2016 ««« »»» Sisense Verison 7.2 and above: UPDATED 2/22/2019 ««« Introduction This Python script will demonstrate using the REST API for sharing dashboards and folders. There are two versions of this ...
Introduction A sample code to demonstrate adding shares using the Sisense API in .NET. The programs flow is a follows: Retrieve the authentication token using:Retrieve userID using:Retrieve the current shares for the dashboard using:Share the dashb...
Here is a python script to that describes how to manage users with sisense api:What you need: rest api key token (not relevant for v6.5+, need to use /api/v1/authentication/login) admin credentialspython installedimport time import json import urllib...
Indicator styles are modified by an API and the reference for making such changes can be found here, within the Javascript API documentation on our developer site:https://developers.sisense.com/display/API2/JavaScript+API+Reference#JavaScriptAPIRefer...
Using Pythonimport librariesimport pandas as pd import json Open the JSON Smodel / downloaded model from API.You may also use the API to hit the Get Elasticube JSON endpointwith open('response.json') as json_file: data = json.load(json_file)Make a...
Sometimes, for example when adding a new admin user, you might want to share all of the dashboards in the system with that user. In order to do that, you can use the following Python script: import requests import time import json user_name = 'omer....
IntroductionThis script exports to CSV a complete list of your ElastiCube servers, ElastiCubes, tables, fields, and field data types.Prerequisites Tested in Python 3.6. Requires Sisense 7.1+.Python Packages Requests JSON PandasSteps1. Download and un...
The new Pivot 2 (in Linux deployments) has a powerful API to select and edit cells using a widget script. You can use CSS & HTML to enrich your pivot widgets. In this example we'll use a star based product rating. Have the URLs to your images ready,...
Introduction This post detail how to retrieve data from Sisense Elasticubes to results in JSON format, using the Sisense provided APIs. The solution consists of 4 stages: Creation of one or more ElastiCubesCreation of the desired widget/sObtaini...
Recommended Quick Links
Developers:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email community@sisense.com
