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...
Using the API we can retrieve the descriptions the users write in the elasticube for tables and columns.Edit the following:1. Type username, password, server2. Update the oid with the desired model you would like to run the script against. Script can...
It is possible to modify the cookie expiration period and by that to determine how for how long the user will remained logged in when checking the "Remember Me". When a user logs in to Sisense and does not check the “Remember Me” check-box a session...
There are various ways to send API call commands in Sisense, the two basic common ways we use today are: Admin UI Swagger interfacePostman Another common way we could encounter, is the need of assistance in using cURL commands. How to extract C...
Introduction:In order to invoke the Sisense API from Postman or from an external application you first need access to an API token.In order to do this you need to make a POST request with the username and password submitted as a URL encoded form subm...
In some cases user would like to change the source of all dashboards that are using one source to a different source. This can be a time consuming process if you have multiple dashboards.Instead of changing one dashboard at a time, there's a way to d...
In some cases, you would like to add many users in bulk.The users are often managed in a CSV file.With the following steps, you will be able to insert users from a CSV file by converting the CSV file to a JSON format and run it with an API through th...
Question: Is it possible to query for dashboards of a specific user?Answer: the right direction is with the /admin endpoint.You can use it to get the primary instances of all dashboards owned by a specific user by their username/email: For example:/a...
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 steps, you can insert users from a CSV file by converting the CSV file into a JSON format and ...
In some cases you would like to move a cube that has data security on it to a set, doing that will require recreating all of the data security from scratch. Easy solution is to take the data security from the old cube and modify it that it will wo...
Recommended Quick Links
Developers:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email community@sisense.com
