Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 33 Next »

ElastiCubes

Metadata
GET/elasticubes/metadata
 Returns a list of ElastiCubes with metadata, including the ElastiCube name, ElastiCube ID, the server address (URL), and the database name.

Parameters

ParameterDescriptionData Type
q

A query that returns all ElastiCubes beginning with the value. For example, a value of 'sa' will return ElastiCubes called 'Sample Ecommerce', 'Sample Lead generation' etc.

string
sortByThe order in which the ElastiCubes appear in the response (natural, title, lastupdatetime, createtime)string

Check property types

Response
 [
  {
    "title": "string",
    "id": "ObjectId",
    "address": "string",
    "database": "string"
  }
]

Properties

PropertyDescription
titleThe name of the ElastiCube.
idThe ID of the ElastiCube.
addressThe ElastiCube server address
databaseThe name of the database

Error Status Codes

HTTP Status CodeReason
403forbidden
GET/elasticubes/metadata/{elasticube}
 Returns metadata for an ElastiCube by ElastiCube name. Metadata includes the ElastiCube name, ElasticCube ID, server address, and database name.

Parameters

Parameter
Value
Description
Data Type
elasticubemandatoryThe ElastiCube's name.string
Response
 {
  "title": "string",
  "id": "objectId",
  "address": "string",
  "database": "string"
}

Check property types

Properties

Property
Description
titleThe name of the ElastiCube.
idThe ID of the ElastiCube.
addressThe ElastiCube server address.
databaseThe name of the database.

Error Status Codes

HTTP Status Code
Reason
400invalid elasticube identifier
403forbidden
GET

/elasticubes/metadata/{elasticube}/fields

 Returns fields included in a specific ElastiCube.

Parameters

Parameter
Value
Description
Data Type
elasticubemandatoryThe name of the EllastiCubestring
q Enter a specific query to return only fields that include the query string.string
offset Defines how many items to skip before returning the results. For example, to return results from value #101 onward, enter a value of ‘100’.int
count 

Limits the result set to a defined number of results. Enter 0 (zero) or leave blank not to limit.

int

Fill in and check property types

Response
[
  {
    "id": "",
    "type": "",
    "dimtype": "",
    "title": "string",
    "table": "string",
    "column": "string",
    "merged": bool,
    "indexed": bool
  },
]

Properties

PropertyDescription
id???
typeThe type of field, ???
dimtypeThe type of dimension, for example: text, date-time, etc.
titleThe field name.
tableThe table name.
columnThe column name.

Error Status Codes

HTTP Status Code
Reason
400invalid ElastiCube identifier
403forbidden
GET

/elasticubes/{elasticube}/Sql

 Executes an SQL statement to extract data from an ElastiCube.

Parameters

Parameter
Value
Description
Data Type
elasticube The name of the ElastiCubestring
offset 

Defines how many items to skip before returning the results. For example, to return results from value #101 onward, enter a value of ‘100’.

int
count 

Limits the result set to a defined number of results. Enter 0 (zero) or leave blank not to limit.

int
format Results format ???string
query The SQL statement to execute.string
Response
 

Response doesn't work - how can we 'get' SQL?

Error Status Codes

HTTP Status Code
Reason
400invalid elasticube identifier
403forbidden
GET/elasticubes/
 Returns ElastiCubes with their server and ElastiCube details.

Returns ElastiCubes with their server and ElastiCube details.

Parameters

Parameter
Value
Description
Data Type
q A query that returns all ElastiCubes beginning with the value. For example, a value of 'sa' will return ElastiCubes called 'Sample Ecommerce', 'Sample Lead generation', etc.string
offset Defines how many items to skip before returning the results. For example, to return results from value #101 onward, enter a value of ‘100’.int
count 

Limits the result set to a defined number of results. Enter 0 (zero) or leave blank not to limit.

int
direction The sort direction of the results.string
withPermissions Include ElastiCube permissions what do the numbers in the response mean?bool

Property types

Response
[
  {
    "address": "string",
    "cubes": [],
    "permissionsSummary": int
  }
]

Properties

PropertyDescription
addressThe ElastiCube address.
cubesAn array that includes metadata for each ElastiCube.
createdUtcExplain the format
databaseNameThe name of the database.
lastBuiltUtcExplain the format
permissionsSummary???
sizeInMbThe size of the ElastiCube in MB.
statusExplain the numbers
titleThe name of the ElastiCube.
permissionsSummary???

Error Status Codes

HTTP Status Code
Reason
403forbidden
GET/elasticubes/servers
 Returns the ElastiCube servers with the following metadata: server address and permissions. ???

Parameters

Parameter
Value
Description
Data Type
q Enter a search query to return results containing the querystring
offset Offset the result set ???int
count Limit the result set to a defined number of results in which order?int
direction The sort direction.string
withPermissions 

Include ElastiCube permissions what do the numbers in the response mean?

bool

Property types

Response
[
  {
    "address": "string",
    "permissionsSummary": int
  }
]

Properties

PropertyDescription
addressThe ElastiCube address.
permissionsSummary???

Error Status Codes

HTTP Status Code
Reason
403forbidden
GET/elasticubes/servers/{server}
 Returns all the ElastiCubes by server.

Parameters

Parameter
Value
Description
Data Type
serverMandatoryThe server addressstring
q 

A query that returns all ElastiCubes beginning with the value. For example, a value of 'sa' will return ElastiCubes called 'Sample Ecommerce', 'Sample Lead generation' etc.

string
offset Defines how many items to skip before returning the results. For example, to return results from value #101 onward, enter a value of ‘100’.int
count 

Limits the result set to a defined number of results. Enter 0 (zero) or leave blank not to limit.

int
orderBy Orders the results by field name. You can add multiple sort fields separated by a comma delimiter ','string
direction The sort direction.string

Property types

Response
[
  {
    "createdUtc": "dateTime",
    "databaseName": "aCountries",
    "lastBuiltUtc": "Datetime",
    "permissionsSummary": 1,
    "sizeInMb": 0.9777,
    "status": 2,
    "title": "string"
  }
]

Properties

PropertyDescription
createdUtcExplain format
databaseNameThe name of the database.
lastBuiltUtcExplain format
permissionsSummary???
sizeInMbThe size of the ElastiCube in MB.
status???
titleThe name of the ElastiCubes.

Error Status Codes

HTTP Status Code
Reason
403forbidden
GET/elasticubes/servers/{server}/simple
 Returns ElastiCube metadata by entering the server name/address/IP and database name.

Parameters

Parameter
Value
Description
Data Type
servermandatoryThe ElastiCube's server address (name/address/IP)string
elasticubemandatoryEnter a specific ElastiCube ID to return the results for that ElastiCube only.string
Response
 

What is this response?

Error Status Codes

HTTP Status Code
Reason
403forbidden
GET/elasticubes/servers/{server}/status
 Returns the status of each ElastiCube in the selected server.

Parameters

Parameter
Value
Description
Data Type
servermandatoryThe ElastiCube's server addressstring
q Enter a search query to return results containing the querystring
offset Defines how many items to skip before returning the results. For example, to return results from value #101 onward, enter a value of ‘100’.int
count 

Limits the result set to a defined number of results. Enter 0 (zero) or leave blank not to limit.

int
orderBy 

Orders the results by field name. You can add multiple sort fields separated by a comma delimiter ','

string
direction The sort direction.string

Property types

Response
[
  {
    "status": int,
    "title": "string"
  },
]

Properties

PropertyDescription
status

The status of the ElastiCube:

1 - stopped

2 - running

4 - faulted

8 - being deleted

16 - currently restarting

32 - wrong version

64 - the ElastiCube is down because it is 32 bit data on a 64 bit codebase

128 - the ElastiCube is down because it is 64 bit data on a 32 bit codebase

256 - locked

512 - the ElastiCube or its child is currently in a build process.

1024 - the ElastiCube is starting, but not yet running.

2048 - the ElastiCube is in a build process.

4096 - trying to import a BigData ElastiCube on a non-BigData server

8192 - trying to import a non-BigData ElastiCube on a BigData server

16384 - Building is finished, now post indexing is running

32768 - the ElastiCube is being stopped but its executable is still running

65536 - this ElastiCube is in the process of cancelling an in-progress build

titleThe name of the ElastiCube.

Error Status Codes

HTTP Status Code
Reason
403forbidden
GET/elasticubes/{server}/{elasticube}/datasecurity
 Returns the data security rules set up for the ElastiCube. Click here to learn more.

Parameters

Parameter
Value
Description
Data Type
servermandatoryThe ElastiCube's server addressstring
elasticubemandatoryThe name of the ElastiCubestring
Response
 [
  {
    "_id": "objectId",
    "allMembers": bool,
    "column": "string",
    "cubeId": "objectId",
    "datatype": "text",
    "members": [],
    "server": "LocalHost",
    "shares": [
      {
        "type": "default"
      }
    ],
    "table": "string"
  }
]

Properties

PropertyDescription
_Id???
allMembers???
columnThe column name in the table.
cubeId???
datatype???
members???
serverThe name of the ElastiCube server.
sharestype - ???
table???

Error Status Codes

HTTP Status Code
Reason
400invalid elastiCube identifier
403forbidden
GET/elasticubes/{server}/{cube}/{user}/datasecurity
 Returns data security for a specific user in a specific ElastiCube.

Parameters

Parameter
Value
Description
Data Type
servermandatoryThe ElastiCube's server addressstring
cubemandatoryThe ElastiCube's namestring
usermandatoryThe user's ID or username.string

Property types

Response
[
  {
    "_id": "objectId",
    "allMembers": bool,
    "column": "String",
    "cubeId": "objectId",
    "datatype": "int",
    "members": [],
    "server": "string",
    "shares": [
      {
        "type": "default"
      }
    ],
    "table": "string"
  }
]

Properties

PropertyDescription
idThe user's unique ID.
allMembers???
column???
cubeIdThe unique ID of the ElastiCube.
datatype???
members???
serverThe ElastiCube server address.
sharestype ???
table???

Error Status Codes

HTTP Status Code
Reason
400invalid elastiCube identifier
403forbidden
GET/elasticubes/{server}/{elasticube}/datasecurity/{table}/{column}
 Returns ElastiCube data security for a column in a table in the ElastiCube.

Parameters

Parameter
Value
Description
Data Type
servermandatoryThe ElastiCube's server address.string
elasticubemandatoryThe name of the ElastiCubestring
tablemandatoryThe name of the table in the ElastiCubestring
columnmandatoryThe name of the column in the tablestring
Response
 

Response didn't work

Error Status Codes

HTTP Status Code
Reason
400invalid ElastiCube identifier
403forbidden
GET/elasticubes/{server}/{elasticube}/permissions
 Returns all authentication records for the given ElastiCube.

Parameters

Parameter
Value
Description
Data Type
servermandatoryThe ElastiCube's server address.string
elasticubemandatoryThe name or ID of the ElastiCubestring
Response
{
  "server": "string",
  "title": "string",
  "shares": [
    {
      "permission": "string",
      "partyId": "string",
      "type": "string",
	  "shareId": "objectId",
      "permission": null,
      "rule": "view"
    }
  ]
}

Model schema is missing details (shareId, permission, rule), plus types

Properties

PropertyDescription
inherited???
serverThe ElastiCube's server address.
titleThe name of the ElastiCube.
shares

An array containing the different permissions. Each permission is an ACL (access control level) object.

partyid - The ID of the party (either a user or user group)

type -  type of party (user or user group)

shareId -

permission - level of permission (read , write, admin). Only read is currently supported.

rule -

Error Status Codes

HTTP Status Code
Reason
400invalid server
400invalid cube ID
403forbidden
Actions
POST/elasticubes/{server}/{elasticube}/start
 Start the ElastiCube Server

Parameters

Parameter
Value
Description
Data Type
server The ElastiCube's server address.string
elasticube The name or ID of the ElastiCube.string

Error Status Codes

HTTP Status Code
Reason
400invalid server
400invalid elasticube
403forbidden
POST/elasticubes/{server}/{elasticube}/stop
 Stop the ElastiCube Server

Parameters

Parameter
Value
Description
Data Type
server The ElastiCube's server address.string
elasticube The name of the ElastiCube.string

Error Status Codes

HTTP Status Code
Reason
400invalid server
400invalid ElastiCube
403forbidden
POST/elasticubes/{server}/{elasticube}/restart
 Restarts the ElastiCube server.

Parameters

Parameter
Value
Description
Data Type
server 

The server address of the ElastiCube.

string
elasticube elasticube namestring

Error Status Codes

HTTP Status Code
Reason
400invalid server
400invalid elasticube
403forbidden
POST/elasticubes/{server}/{elasticube}/startBuild
 Starts the build process for an ElastiCube, with the option to select the type of build.

Parameters

Parameter
Value
Description
Data Type
serverMandatoryThe server address of the ElastiCube.string
elasticubeMandatoryThe name or ID of the ElastiCubestring
type Process Type: [None,Full,Delta,Custom,FullUpdateExisting - explain with relation to UI, what is default?string

Error Status Codes

HTTP Status Code
Reason
400invalid server
400invalid elasticube
403forbidden
POST/elasticubes/{server}/{elasticube}/stopBuild
 Stops the build process for an ElastiCube.

Parameters

Parameter
Value
Description
Data Type
serverMandatoryThe server address of the ElastiCube.string
elasticubeMandatoryThe name of the ElastiCube.string

Error Status Codes

HTTP Status Code
Reason
400invalid server
400invalid elasticube
403forbidden
POST/elasticubes/{elasticube}/jaql
 Executes a JAQL query on the ElastiCube. As an example, the following JAQL query returns total quantity by contact name.
Example JAQL
{

  "datasource": {

    "title": "Training",

    "id": "aLOCALHOST_aTRAINING",

    "address": "LocalHost",

    "database": "aTraining"

  },

  "metadata": [

    {

      "jaql": {

        "table":
"Customers",

        "column":
"ContactName",

        "dim":
"[Customers.ContactName]",

        "datatype":
"text",

        "title":
"ContactName"

      }

      

    },

    {

      "jaql": {

        "table":
"OrderDetails",

        "column": "Quantity",

        "dim":
"[OrderDetails.Quantity]",

        "datatype":
"numeric",

        "agg": "sum",

        "title": "Total
Quantity"

      }

      

    },

  

  ],

  "count": 20000,

  "offset": 0,

}

 Parameters

ParameterValueDescriptionData Type
JaqlMandatoryThe Jaql query.Jaql
elasticubeMandatoryThe name or ID of the ElastiCube.string

Error Status Codes

HTTP Status CodeReason
400invalid elasticube identifier
403forbidden
POST/elasticubes/{server}/{elasticube}/datasecurity
 Defines data security for an ElastiCube. Click here for more information.

Parameters

ParameterValueDescriptionData Type
servermandatoryThe server address of the ElastiCube.
string
elasticubemandatoryThe name of the ElastiCube.string
List[elasticubeNewDataSecurityItemCubeGiven]mandatoryThe data security object that needs to be updated.
Model Schema
[
  {
    "table": "string",
    "column": "string",
    "datatype": "string",
    "shares": [
      {
        "party": "string",
        "type": "string"
      }
    ],
    "members": [
      "string"
    ],
    "allMembers": "bool"
  }
]

 

Properties

PropertyDescription
Shares

An array containing permissions. Each permission is an ACL, which includes:

  • partyId - The ID of the party (either user or group) that this ACL relates to
  • type - type of party (group or user)
  • permission - level of permission (read , write, admin...). Only read is currently supported.
allMembers  true indicates "everything". false indicates "nothing"
 members If 'allMembers' is present (either true or false) this members array is ignored; otherwise- contains the members that this data security record is about.

Error Status Codes

HTTP Status CodeReason
404dataContext not found
403forbidden
POST/elasticubes/datasecurity
 Add new data context ???

Parameters

ParameterValueDescriptionData Type
List[elasticubeNewDataSecurityItem]mandatoryThe data security object that needs to be updated.
Model Schema
[
  {
    "server": "string",
    "elasticube": "string",
    "table": "string",
    "column": "string",
    "datatype": "string",
    "shares": [
      {
        "party": "string",
        "type": "string"
      }
    ],
    "members": [
      "string"
    ],
    "allMembers": "bool"
  }
]

Properties

PropertyDescription
servername or address?
elasticubeThe name of the ElastiCube
tableThe name of the table in the ElastiCube.
column

The name of the column in the table.

datatype???
shares

An array containing permissions. Each permission is an ACL, which includes:

partyId - The ID of the party (either user or group) that this ACL relates to.
type - type of party (group or user)
allMembers - true indicates "everything". false indicates "nothing"
members - If 'allMembers' is present (either true or false) this members array is ignored; otherwise- contains the members that this data security record is about.


Error Status Codes

HTTP Status CodeReason
404dataContext not found
403forbidden
POST/elasticubes/{server}/{elasticube}/permissions
 Defines a new permission for the given ElastiCube. Click here to learn more.

Parameters

ParameterValueDescriptionData Type
servermandatoryThe server address of the ElastiCube.string
elasticubemandatoryThe name of the ElastiCube.string
shares 

The 'shares' is an array containing the different permissions. Each permission is an ACL (access control level).

Model Schema
[
  {
    "permission": "string",
    "partyId": "string",
    "type": "string"
  }
]

Properties

PropertyDescription
permission???
partyIdThe ID of the party (either user or group) that this ACL relates to.
typeThe type of party (group or user).


Error Status Codes

HTTP Status CodeReason
400invalid server
400invalid cube ID
403forbidden
PUT/elasticubes/{server}/{elasticube}/permissions
 Updates the permissions (ACLs) for the current ElastiCube.

Parameters

ParameterValueDescriptionData Type
servermandatoryThe server address of the ElastiCube.string
elasticubemandatoryThe name of the ElastiCube.string
shares The 'shares' is an array containing the different permissions. Each permission is an ACL (access control level).
Model Schema
[
  {
    "permission": "string",
    "partyId": "string",
    "type": "string"
  }
]

Properties

PropertyDescription
permission???
partyIdThe ID of the party (either user or group) that this ACL relates to.
typeThe type of party (group or user).


Error Status Codes

HTTP Status CodeReason
400invalid server
400invalid cube ID
403forbidden
PUT/elasticubes/server/{server}/permissions
 Defines permissions for an ElastiCube server, which will be used as the default permissions for ElastiCubes without specified permissions of their own.

Parameters

ParameterValueDescriptionData Type
servermandatoryThe server address of the ElastiCube.string
shares The 'shares' is an array containing the different permissions. Each permission is an ACL (access control level).
Model Schema
[
  {
    "permission": "string",
    "partyId": "string",
    "type": "string"
  }
]

Properties

PropertyDescription
permission???
partyIdThe ID of the party (either user or group) that this ACL relates to.
typeThe type of party (group or user).

Error Status Codes

HTTP Status Code
Reason
400invalid server
403forbidden
DELETE/elasticubes/{server}/{elasticube}/datasecurity/{table}/{column}
 Deletes data context from a column in an ElastiCube table.

Parameters

Parameter
Value
Description
Data Type
servermandatoryThe server address of the ElastiCube.string
elasticubemandatoryThe name of the ElastiCube.

string

tablemandatoryThe name of the table in the ElastiCube.string
columnmandatoryThe name of the column in the table.string

Error Status Codes

HTTP Status Code
Reason
400invalid datasource identifier
403forbidden
DELETE/elasticubes/{server}/{elasticube}/permissions
 Deletes all permissions for the ElastiCube, and reverts permissions to the server defaults.

Parameters

Parameter
Value
Description
Data Type
servermandatoryThe server address of the ElastiCube.string
elasticubemandatoryThe name or ID of the ElastiCube.

string

Error Status Codes

HTTP Status Code
Reason
400invalid server
400invalid cube ID
403forbidden

Users

Metadata
GET/users
 Returns all users and related metadata.

Parameters

ParameterValueDescriptionData Type
limit Limits the result set to a defined number of resultsint
skip Defines how many items to skip before returning the results.int
search Enter a search query to return results matching the query.string
orderby Orders the results by field name. You can add multiple sort fields separated by a comma delimiter ','string
desc Defines the order of the results. True returns results in a descending order.bool
onlyAD Searches only Active Directory users.bool
groupsnames Includes the user's groups if the user belongs to one or more groups.bool
Response
[
  {
    "_id": "ObjectId",
	"active": bool,
    "userName": "string",
    "roleId": "ObjectId",
    "email": "string",
    "firstName": "string",
	"hash": "objectId",
    "lastName": "string",
    "active": "bool",
    "created": "dateTime",
    "lastUpdated": "dateTime",
	"preferences": {}
    "lastLogin": "dateTime",
	"userName": "string",
    "roleName": "super",
    "baseRoleName": "super"
  }
]

Missing responses added (hash, preferences, rolename, base role name) plus types

Error Status Codes

HTTP Status CodeReason
400invalid search
400invalid skip
403forbidden
GET/users/ad
 Searches for users in Active Directory. This function does not search for users in the Sisense repository.

Parameters

ParameterValueDescriptionData Type
limit Limits the result set to a defined number of results. Enter 0 (zero) or leave blank not to limit.int
checkExist Checks if the user exists in the database.bool
search Enter a search query to return results matching the query.string
Response
[
  {
    "_id": "ObjectId",
    "userName": "string",
    "roleId": "ObjectId",
    "email": "string",
    "firstName": "string",
    "lastName": "string",
    "active": "bool",
    "created": "dateTime",
    "lastUpdated": "dateTime",
    "lastLogin": "dateTime"
  }
]

Properties

PropertiesDescription
_idThe user's unique ID.
userNameThe user's username.
roleId???
emailThe user's email address.
firstNameThe user's first name.
lastNameThe user's last name.
active???
createdThe date on which the user was created in AD or Sisense
lastUpdatedThe user's last update.
lastLoginThe last time the user logged in.

Error Status Codes

HTTP Status CodeReason
400invalid search
400invalid skip
403forbidden
GET/users/allDirectories
 Searches for users in all directories. This function searches the Sisense repository, and if the user is not found, searches for the user in Active Directory.

Parameters

ParameterValueDescriptionData Type
limit 

Limits the result set to a defined number of results

Enter 0 (zero) or leave blank not to limit.
int
search Enter a search query to return results matching the query.string
Response
[
  {
    "_id": "ObjectId",
    "userName": "string",
    "roleId": "ObjectId",
    "email": "string",
    "firstName": "string",
    "lastName": "string",
    "active": "bool",
    "created": "dateTime",
    "lastUpdated": "dateTime",
    "lastLogin": "dateTime"
  }
]

Properties

PropertiesDescription
_idThe user's unique ID.
userNameThe user's username.
roleId???
emailThe user's email address.
firstNameThe user's first name.
lastNameThe user's last name.
active???
createdThe date on which the user was created in AD or Sisense
lastUpdatedThe user's last update.
lastLoginThe last time the user logged in.

Error Status Codes

HTTP Status CodeReason
400invalid search
400invalid skip
403forbidden
GET/users/count
 Counts users using a defined query string, and returns the number of users with the query result in their usernames.

Parameters

Parameter
Value
Description
Data Type
search Searches for users with usernames that include the query string.string

Property types

Response
{
  "collection": "string",
  "count": int
}

Properties

PropertyDescription
collection???
countThe number of users Ad and Sisense?

Error Status Codes

HTTP Status Code
Reason
400invalid search
400invalid limit
403forbidden
GET/users/{user}
 Returns metadata for a user by username or user ID.

Parameters

ParameterValueDescriptionData Type
user The user's ID or usernamestring
Response
{
  "_id": "ObjectId",
  "userName": "string",
  "roleId": "ObjectId",
  "email": "string",
  "firstName": "string",
  "lastName": "string",
  "active": "bool",
  "created": "dateTime",
  "lastUpdated": "dateTime",
  "lastLogin": "dateTime"
}

Properties

PropertiesDescription
_idThe user's unique ID.
userNameThe user's username.
roleId???
emailThe user's email address.
firstNameThe user's first name.
lastNameThe user's last name.
active???
createdThe date on which the user was created.
lastUpdatedThe user's last update.
lastLoginThe last time the user logged in.

Error Status Codes

HTTP Status CodeReason
400invalid ID
400ID not found
403forbidden
GET/users/loggedin
 Retrieves my user details.
Response
{
  "_id": "ObjectId",
  "userName": "string",
  "roleId": "ObjectId",
  "email": "string",
  "firstName": "string",
  "lastName": "string",
  "active": "bool",
  "created": "dateTime",
  "lastUpdated": "dateTime",
  "lastLogin": "dateTime",
  "preferences": {},
  "userAuth": {} 
}

Actual response includes more properties (locale preferences and manifest of permissions)

Properties

PropertiesDescription
_idThe user's unique ID.
userNameThe user's username.
roleId???
emailThe user's email address.
firstNameThe user's first name.
lastNameThe user's last name.
active???
createdThe date on which the user was created.
lastUpdatedThe user's last update.
lastLoginThe last time the user logged in.
preferencesIndicates locale preferences and anything else?
userAuth
A list of permissions for the user.

Error Status Codes

HTTP Status CodeReason
403forbidden
Actions
POST/users/simulate
 Returns the users and related metadata of a simulated operation that adds multiple users. This operation does not add users.

Parameters

ParameterValueDescriptionData Type
List[email/usernames]Mandatory
The list of user emails to add, or usernames for Active Directory mode.
[
  {
    "userName": "string",
    "roleId": "ObjectId",
    "email": "string",
    "firstName": "string",
    "lastName": "string",
    "preferences": {
      "localeId": "string"
    }
  }
]

Properties

PropertyDescription
userNameThe user's username.
roleIdThe user role (admin, designer or viewer)
emailThe user's email address.
firstNameThe user's first name.
lastNameThe user's last name.
preferencesThe user's preferred locale.


admode Enter True to simulate adding users from Active Directory.bool

Error Status Codes

HTTP Status CodeReason
400invalid input
403forbidden
POST/users
 Adds a new user.

Parameters

ParameterValueDescriptionData Type
List[user]Mandatory

The user object includes all the user information.

Model Schema

Model Schema
[
  {
    "userName": "string",
    "roleId": "ObjectId",
    "email": "string",
    "firstName": "string",
    "lastName": "string",
    "preferences": {
      "localeId": "string"
    }
  }
]

Properties

PropertyDescription
userNameThe user's username.
roleIdThe user role (admin, designer or viewer).
emailThe user's email address.
firstNameThe user's first name.
lastNameThe user's last name.
preferencesThe user's preferred locale.
notify Send notifications to the user.boolean

Error Status Codes

HTTP Status CodeReason
400invalid input
403forbidden
POST/users/ad
 Imports a user from Active Directory as a new user in Sisense.

Parameters

ParameterValueDescriptionData Type
userMandatory
The user object that needs to be added to the directory.
Model Schema
{
  "userName": "string",
  "roleId": "ObjectId",
  "email": "string",
  "firstName": "string",
  "lastName": "string",
  "preferences": {
    "localeId": "string"
  }
}

 Properties

PropertyDescription
userNameThe user's username.
roleIdThe user role (admin, designer or viewer).
emailThe user's email address.
firstNameThe user's first name.
lastNameThe user's last name.
preferencesThe user's preferred locale.


Error Status Codes

HTTP Status CodeReason
400invalid input
403forbidden
POST/users/forgetpassword
 Sends a user an email to activate or reset the user's password.

Parameters

ParameterValueDescriptionData Type
userEmailMandatory
The email of the user that requires a password reset.

Model Schema

{
  "email": "string"
}

 Properties

PropertyDescription
emailThe user's email.


Error Status Codes

HTTP Status CodeReason
403forbidden
POST/users/activate/{user}
 Activates a user by user ID or username.

Parameters

ParameterValueDescriptionData Type
userMandatory
User's ID or username

String

src The URL of the page to redirect the user after activation. string
userActivateMandatoryThe user object that needs to be updated.
Model Schema
{
  "password": "string",
  "preferences": {
    "localeId": "string"
  }
}

Properties

PropertyDescription
passwordThe user's password.
preferencesThe user's preferred locale.


Error Status Codes

HTTP Status CodeReason
400invalid input
403forbidden
POST/users/recoverpassword/{user}
 Recovers a user's password by user ID or username.

Parameters

ParameterValueDescriptionData Type
userMandatory
User's ID or username

String

src The URL of the page to redirect the user after activation.string
userActivateMandatoryThe user object that needs to be updated.
Model Schema
{
  "password": "string",
  "preferences": {
    "localeId": "string"
  }
}

Properties

PropertyDescription
passwordThe user's password.
preferencesThe user's preferred locale preference.

Error Status Codes

POST/users/delete
 Deletes the user by ID.

Parameters

Parameter
Value
Description
Data Type
list[string]Mandatory
The user object that needs to be updated.

list[string]

Error Status Codes

HTTP Status Code
Reason
400invalid ID
404ID not found
403forbidden
POST/users/validate
 Validates existing users by entering their emails.

Parameters

Parameter
Value
Description
Data Type
list[string]Mandatory
List of emails of users that require validation.

list[string]

Error Status Codes

HTTP Status Code
Reason
400invalid input
403forbidden
PUT/users/{user}
 Updates one or more user details, by user ID or username.

Parameters

ParameterValueDescriptionData Type
userMandatoryThe user's ID or username.string
userUpdateMandatoryThe user object that needs to be updated.
Model Schema
{
  "userName": "string",
  "roleId": "ObjectId",
  "email": "string",
  "firstName": "string",
  "lastName": "string",
  "preferences": {
    "localeId": "string"
  }
}

Properties

PropertyDescription
userNameThe user's username.
roleIdThe user role (admin, designer or viewer).
emailThe user's email address.
firstNameThe user's first name.
lastNameThe user's last name.
preferencesThe user's preferred locale.

Error Status Codes

HTTP Status CodeReason
400invalid ID
404ID not found
403forbidden
DELETE/users/{user}
 Deletes a user by user ID or username.

Parameters

Parameter
Value
Description
Data Type
userMandatoryThe user's ID or username.string

Error Status Codes

HTTP Status Code
Reason
400invalid ID
404ID not found
403forbidden

Groups

GET/groups
 Returns all user groups with metadata.

Parameters

ParameterValueDescriptionData Type
limit 

Limits the result set to a defined number of results. Enter 0 (zero) or leave blank not to limit.

int
skip Defines how many items to skip before returning the results. int
search Enter a search query to return results matching the query.string
dn Search for a group using an Active Directory dn as the search query. Use the semi-colon ; delimiter to search multiple groups.string
orderBy Orders the results by field name. You can add multiple sort fields separated by a comma delimiter ',' string
desc Defines the order of the results. True returns results in a descending order.boolean
onlyAD Searches only Active Directory user groups.boolean
noAD Search only for non Active Directory groups.boolean
exactMatch Searches exact matches when searching by the Active Directory dn.boolean
usersCount Counts the number of users in each group.boolean
Response
[
  {
    "_id": "ObjectId",
    "name": "string",
    "roleId": "ObjectId",
    "created": "dateTime",
    "lastUpdated": "dateTime"
  }
]

Properties

PropertiesDescription
_idThe user group's unique ID.
nameThe user group's name.
roleIdalways null ??
createdThe date and time when the group was created.
lastUpdatedThe date and time when the group was last updated.

Error Status Codes

HTTP Status CodeReason
400Invalid source
400invalid skip
403forbidden
GET/groups/ad
 Searches for groups directly in Active Directory, excluding groups created directly in Sisense.

Parameters

ParameterValueDescriptionData Type
limit 

Limits the result set to a defined number of results. Enter 0 (zero) or leave blank not to limit.

int
checkExist Check if a group exists in Active Directory, and if not, searches groups created in Sisense. boolean
search Enter a search query to return results matching the query. 
Response
[
  {
    "_id": "ObjectId",
    "name": "string",
    "roleId": "ObjectId",
    "created": "dateTime",
    "lastUpdated": "dateTime"
  }
]

Properties

PropertyDescription
_idThe user group's unique ID.
name The user group's name.
created The date and time when the group was created.
lastUpdated The date and time when the group was last updated.

Error Status Codes

HTTP Status CodeReason
400Invalid search
400invalid skip
403forbidden
GET/groups/allDirectories
 Searches for groups in all directories. This function searches groups created in Sisense, and if not found, will search in Active Directory groups.

Parameters

ParameterValueDescriptionData Type
limit 

Limits the result set to a defined number of results. Enter 0 (zero) or leave blank not to limit.

int
search Enter a search query to return results matching the query.string
usersCount Returns the number of users per group.boolean
Response
[
  {
    "_id": "ObjectId",
    "name": "string",
    "roleId": "ObjectId",
    "created": "dateTime",
    "lastUpdated": "dateTime"
  }
]

Properties

PropertyDescription
_idThe user group's unique ID.
nameThe user group's name.
roleIdnull ??
createdThe date and time when the group was created.
lastUpdatedThe date and time when the group was last updated.

Error Status Codes

HTTP Status CodeReason
400Invalid search
403forbidden
GET/groups/{group}
 Returns metadata for a group by group ID or name. Metadata includes name, role ID, created date and time, and last update date and time.

Parameters

ParameterValueDescriptionData Type
groupMandatoryThe ID or username of the groupstring
Response
{
  "_id": "ObjectId",
  "name": "string",
  "roleId": "ObjectId",
  "created": "dateTime",
  "lastUpdated": "dateTime"
}

Properties

PropertyDescription
_id The user group's unique ID.
name The user group's name.
roleId null ??
created The date and time when the group was created.
lastUpdated The date and time when the group was last updated.

Error Status Codes

HTTP Status CodeReason
400Invalid ID
404ID not found
403forbidden
GET/groups/{group}/users
 Returns a list of users in a group together with each user's metadata. Metadata includes the user's username, role ID, email, first and last names, active state, created date, last login, and last update date.

Parameters

ParameterValueDescriptionData Type
groupMandatoryThe group's ID or username.string
Response
[
  {
    "_id": "ObjectId",
    "userName": "string",
    "roleId": "ObjectId",
    "email": "string",
    "firstName": "string",
    "lastName": "string",
    "active": "bool",
    "created": "dateTime",
    "lastUpdated": "dateTime",
    "lastLogin": "dateTime"
  }
]

Properties

PropertyDescription
_idThe user's unique ID.
userNameThe user's username.
roleIdThe user role (admin, designer or viewer).
emailThe user's email.
firstNameThe user's first name.
lastNameThe user's last name.
active???
createdThe date and time when the user was created,
lastUpdatedThe date and time when the user was last updated.
lastLoginThe date and time of the user's last login.

Error Status Codes

HTTP Status CodeReason
400Invalid ID
404ID not found
403forbidden
Actions
POST/groups/byIds
 Returns a list of groups by user IDs.

Parameters

ParameterValueDescriptionData Type
List[ObjectId]MandatoryList of user IDsstring
usersCount Returns the number of users per group.Boolean
Response
[
  {
    "_id": "ObjectId",
    "name": "string",
    "roleId": "ObjectId",
    "created": "dateTime",
    "lastUpdated": "dateTime"
  }
]

Properties

PropertyDescription

_id

The user's unique ID.
nameThe user's username.
roleIdThe user role (admin, designer or viewer).
createdThe date and time when the user was created.
lastUpdatedhe date and time when the user was last updated.

Error Status Codes

HTTP Status CodeReason
400Invalid ID
404ID not found
403forbidden
POST/groups
 Adds a new Sisense user group.

Parameters

ParameterValueDescriptionData Type
List[group]MandatoryThe group object that needs to be added.
Model Schema
[
  {
    "_id": "ObjectId",
    "name": "string",
    "roleId": "ObjectId",
    "created": "dateTime",
    "lastUpdated": "dateTime"
  }
]

How can we add created, last updated if this is new? Here and below in response.

Response
{
  "_id": "ObjectId",
  "name": "string",
  "roleId": "ObjectId",
  "created": "dateTime",
  "lastUpdated": "dateTime"
}

Error Status Codes

HTTP Status CodeReason
400Invalid input
403forbidden
POST/groups/ad
 Adds a new Active Directory user group. Please note that if you add an objectSid key, then the data will not be imported again from Active Directory. It is recommended to use the Active Directory cn (common name) or name, but not both. The cn is preferred.

Parameters

ParameterValueDescriptionData Type
List[ADgroup]MandatoryThe group object that needs to be added to the collection.
Model Schema
[
  {
    "_id": "ObjectId",
    "objectSid": "array/buffer",
    "cn/name": "string",
    "dn": "string",
    "uSNChanged": "string",
    "mail": "string",
    "roleId": "ObjectId",
    "created": "dateTime",
    "lastUpdated": "dateTime"
  }
]

How can we add created, last updated if this is new? Here and below in response.

Response
[
  [
    {
      "name": "testgroupapi",
      "ad": false,
      "objectSid": "",
      "dn": "",
      "uSNChanged": "",
      "mail": "",
      "created": "2015-06-17T12:26:08.772Z",
      "lastUpdated": "2015-06-17T12:26:08.772Z",
      "_id": "55816760d68d4a302b000001"
    }
  ]
]

Above response does not match model schema

Properties

PropertyDescription
nameThe name of the new group.
adWhy is this false?

objectSid

 The Active Directory objectSid
dnThe break down of your domain including all hosts. 

created

The date and time the group was created.
lastUpdated The date and time the group was last updated.

Error Status Codes

HTTP Status CodeReason
400Invalid input
403forbidden
POST/groups/{group}/users
 Adds users to a Sisense user group.

Parameters

Parameter
Value
Description
Data Type
groupMandatoryThe group's ID or name.string
List[ADgroup]MandatoryThe IDs or usernames of the users that need to be added to the group.

List[string]

Error Status Codes

HTTP Status Code
Reason
400Invalid input
403forbidden
POST/groups/validateName
 validate a group name ???

Parameters

ParameterValueDescriptionData Type
groupMandatoryThe name of the group to validate
Model Schema
{
  "name": "string"
}

Properties

PropertyDescription
nameThe name of the user group.


Error Status Codes

HTTP Status CodeReason
400Invalid ID
404ID not found
403forbidden
PUT/groups/{group}
 Updates a group by group ID or name. What are we updating? name, role (only for AD)

Parameters

ParameterValueDescriptionData Type
groupMandatoryThe group's ID or name.

string


groupUpdateMandatoryThe group object that needs to be updated.
Model Schema
 {
  "_id": "ObjectId",
  "name": "string",
  "roleId": "ObjectId",
  "created": "dateTime",
  "lastUpdated": "dateTime"
}

Properties

PropertyDescription
_idThe group's unique ID.

name

The name of the group.

roleId

The user role (admin, designer or viewer).
createdThe date and time when the group was created.
lastUpdatedThe date and time when the group was last updated.


Error Status Codes

HTTP Status CodeReason
400Invalid ID
404ID not found
403forbidden
DELETE/groups
 Deletes multiple groups by group name or ID.

Parameters

Parameter
Value
Description
Data Type
deleteGroupMandatory

The IDs of the groups to delete.

{
  "groups": [
    null
  ],
  "deleteAdUsers""boolean"
}

Properties

PropertyDescription
groups

The groups to delete.

deleteAdUsersEnter true to delete the users of the group in addition to the group.

Error Status Codes

HTTP Status Code
Reason
400Invalid ID
404ID not found
403forbidden
DELETE/groups/{group}
 Deletes a group by group ID or name.

Parameters

Parameter
Value
Description
Data Type
groupMandatoryThe group's ID or name.

string

deleteauthors Select true if you want to delete the users of the Active Directory group.boolean

Error Status Codes

HTTP Status Code
Reason
400Invalid ID
404ID not found
403forbidden
DELETE/groups/{group}/users
 Removes users from a user group.

Parameters

Parameter
Value
Description
Data Type
groupMandatoryThe group's ID or name.

string

List[string]MandatoryThe user IDs or usernames to remove from the group.List[string]

Error Status Codes

HTTP Status Code
Reason
400Invalid input
403forbidden

Authorization

GET/auth/isauth
 Returns users that are logged in.
Response
 {
  "isAuthenticated": false
}

Properties

PropertyDescription

isAuthenticated

Indicates whether the user is logged in or not.
GET/auth/logout
 Forces the user to be logged out.

Error Status Codes

HTTP Status Code
Reason
400Invalid ID
403forbidden

Branding

Metadata
GET/branding
 Returns the current branding metadata.
Response
[
  {
    "logo": {
      "desktop": {
        "small": "path string",
        "large": "path string"
      },
      "tablet": {
        "small": "path string",
        "large": "path string"
      },
      "phone": {
        "small": "path string",
        "large": "path string"
      }
    },
    "favicon": "string",
    "pageTitle": "string",
    "loginTitle": "string",
    "loginSubtitle": "string",
    "activationTitle": "string",
    "activationSubtitle": "string",
    "contactUsText": "string",
    "copyrightText": "string",
    "homePage": "string",
    "emails": {
      "senderEmail": "string",
      "senderName": "string",
      "templates_directory": "string",
      "passwordRecoverySubject": "string",
      "newUserInviteSubject": "string",
      "shareWithNewUserSubject": "string",
      "shareWithExistingUser": "string"
    }
  }
]

Properties

PropertyDescription

logo

The paths to different logos suited for different device types.

favicon

The path to an image to replace the default Sisense logo.

pageTitle

Text to replace the default 'Sisense' title.

loginTitle

Text to replace "WELCOME TO SISENSE".

loginSubtitle

Text to replace "Sign in & start exploring".

activationTitle

Text to replace "Welcome".

activationSubtitle

Text to replace "Welcome".

contactUsText

Text to replace the default Sisense contact details.

copyrightText

Text to replace Sisense’s copyright text.

homePage

A URL that replaces the default "http://www.sisense.com".

emails

An array that includes all email branding.

"senderEmail":"[email protected]company.com",

"senderName":"sys-admin",

"templates_directory" : "/resources/branding/emails",

"passwordRecoverySubject" : "Sisense password recovery",

"newUserInviteSubject" : "Sisense account activation",

"shareWithNewUserSubject" : "A Dashboard has been shared with you:",

"shareWithExistingUserSubject" : "A Dashboard has been shared with you:"

Error Status Codes

HTTP Status CodeReason
400Invalid ID
404ID not found
403forbidden
Actions
POST/branding
 Adds new branding to your Sisense dashboards, including customized texts, logos and emails.

Parameters

ParameterValueDescriptionData Type
brandingMandatory

The branding object that needs to be added to the collection.

Model Schema
{
  "logo": {
    "desktop": {
      "small": "path string",
      "large": "path string"
    },
    "tablet": {
      "small": "path string",
      "large": "path string"
    },
    "phone": {
      "small": "path string",
      "large": "path string"
    }
  },
  "favicon": "string",
  "pageTitle": "string",
  "loginTitle": "string",
  "loginSubtitle": "string",
  "activationTitle": "string",
  "activationSubtitle": "string",
  "contactUsText": "string",
  "copyrightText": "string",
  "homePage": "string",
  "emails": {
    "senderEmail": "string",
    "senderName": "string",
    "templates_directory": "string",
    "passwordRecoverySubject": "string",
    "newUserInviteSubject": "string",
    "shareWithNewUserSubject": "string",
    "shareWithExistingUser": "string"
  }
}

Properties

PropertyDescription
logoThe paths to the logo images.
pageTitleText to replace the default 'Sisense' title.

loginTitle

Text to replace "WELCOME TO SISENSE".

loginSubtitle

Text to replace "Sign in & start exploring".

activationTitle

Text to replace "Welcome".

activationSubtitle

Text to replace "Welcome".

contactUsText

Text to replace the default Sisense contact details.

copyrightText

Text to replace Sisense’s copyright text.

homePage

A URL that replaces the default "http://www.sisense.com".

emails

An array that includes all email branding.

 


"senderEmail":"[email protected]company.com",

"senderName":"sys-admin",

"templates_directory" : "/resources/branding/emails",

"passwordRecoverySubject" : "Sisense password recovery",

"newUserInviteSubject" : "Sisense account activation",

"shareWithNewUserSubject" : "A Dashboard has been shared with you:",

"shareWithExistingUserSubject" : "A Dashboard has been shared with you:"

Error Status Codes

HTTP Status CodeReason
400Invalid input
403forbidden
DELETE/branding
 Resets the current branding to default? Is it all or nothing, or can we select items?

 

Settings

GET/settings/system 
POST/settings/system 
GET/settings/proxy 
POST/settings/proxy 
PUT/settings/proxy 
DELETE /settings/proxy 
GET/settings/security 
POST/settings/security 
GET/settings/globalization 
POST/settings/globalization 

Reporting

POST/reporting 

Roles

GET /roles 
GET/roles/{idOrName} 
POST/roles 
DELETE/roles/{idOrName} 
PUT/roles/{idOrName} 
GET/roles/{idOrName}/manifest/{path} 
DELETE/roles/{idOrName}/manifest/{path} 
PUT/roles/{idOrName}/manifest/{path} 
POST/roles/{idOrName}/manifest/{path} 

Palettes

GET/palettes 
GET/palettes/default 
POST/palettes 
PUT/palettes/{name} 
DELETE/palettes/{name} 

 

 

/elasticubes

GET /elasticubes/metadata

Returns a list of ElastiCubes with metadata, including the ElastiCube name, ElastiCube ID, the server address (URL), and the database name.

Parameters

ParameterDescriptionData Type
q

A query that returns all ElastiCubes beginning with the value. For example, a value of 'sa' will return ElastiCubes called 'Sample Ecommerce', 'Sample Lead generation' etc.

string
sortByThe order in which the ElastiCubes appear in the response (natural, title, lastupdatetime, createtime)string

Check property types

Response
 [
  {
    "title": "string",
    "id": "ObjectId",
    "address": "string",
    "database": "string"
  }
]

Properties

PropertyDescription
titleThe name of the ElastiCube.
idThe ID of the ElastiCube.
addressThe ElastiCube server address
databaseThe name of the database

Error Status Codes

HTTP Status CodeReason
403forbidden

GET /elasticubes/metadata/{elasticube}

Returns metadata for an ElastiCube by ElastiCube name. Metadata includes the ElastiCube name, ElasticCube ID, server address, and database name. 

Parameters

Parameter
Value
Description
Data Type
elasticubemandatoryThe ElastiCube's name.string

Check property types

Response
{
  "title": "string",
  "id": "objectId",
  "address": "string",
  "database": "string"
}

Properties

PropertyDescription
titleThe name of the ElastiCube.
idThe ID of the ElastiCube.
addressThe ElastiCube server address.
databaseThe name of the database.

Error Status Codes

HTTP Status Code
Reason
400invalid elasticube identifier
403forbidden

GET /elasticubes/metadata/{elasticube}/fields

Returns fields included in a specific ElastiCube. 

Parameters

Parameter
Value
Description
Data Type
elasticubemandatoryThe name of the EllastiCubestring
q Enter a specific query to return only fields that include the query string.string
offset Defines how many items to skip before returning the results. For example, to return results from value #101 onward, enter a value of ‘100’.int
count 

Limits the result set to a defined number of results. Enter 0 (zero) or leave blank not to limit.

int

Fill in and check property types

Response
[
  {
    "id": "",
    "type": "",
    "dimtype": "",
    "title": "string",
    "table": "string",
    "column": "string",
    "merged": bool,
    "indexed": bool
  },
]

Properties

PropertyDescription
id???
typeThe type of field, ???
dimtypeThe type of dimension, for example: text, date-time, etc.
titleThe field name.
tableThe table name.
columnThe column name.

Error Status Codes

HTTP Status Code
Reason
400invalid ElastiCube identifier
403forbidden

GET /elasticubes/{elasticube}/Sql

Executes an SQL statement to extract data from an ElastiCube. 

Parameters

Parameter
Value
Description
Data Type
elasticube The name of the ElastiCubestring
offset 

Defines how many items to skip before returning the results. For example, to return results from value #101 onward, enter a value of ‘100’.

int
count 

Limits the result set to a defined number of results. Enter 0 (zero) or leave blank not to limit.

int
format Results format ???string
query The SQL statement to execute.string
Response
 

Response doesn't work - how can we 'get' SQL?

Error Status Codes

HTTP Status Code
Reason
400invalid elasticube identifier
403forbidden

GET /elasticubes/

Returns ElastiCubes with their server and ElastiCube details.

Parameters

Parameter
Value
Description
Data Type
q A query that returns all ElastiCubes beginning with the value. For example, a value of 'sa' will return ElastiCubes called 'Sample Ecommerce', 'Sample Lead generation', etc.string
offset Defines how many items to skip before returning the results. For example, to return results from value #101 onward, enter a value of ‘100’.int
count 

Limits the result set to a defined number of results. Enter 0 (zero) or leave blank not to limit.

int
direction The sort direction of the results.string
withPermissions Include ElastiCube permissions what do the numbers in the response mean?bool

Property types

Response
[
  {
    "address": "string",
    "cubes": [],
    "permissionsSummary": int
  }
]

Properties

PropertyDescription
addressThe ElastiCube address.
cubesAn array that includes metadata for each ElastiCube.
createdUtcExplain the format
databaseNameThe name of the database.
lastBuiltUtcExplain the format
permissionsSummary???
sizeInMbThe size of the ElastiCube in MB.
statusExplain the numbers
titleThe name of the ElastiCube.
permissionsSummary???

Error Status Codes

HTTP Status Code
Reason
403forbidden

GET /elasticubes/servers

Returns the ElastiCube servers with the following metadata: server address and permissions???

Parameters

Parameter
Value
Description
Data Type
q Enter a search query to return results containing the querystring
offset Offset the result set ???int
count Limit the result set to a defined number of results in which order?int
direction The sort direction.string
withPermissions 

Include ElastiCube permissions what do the numbers in the response mean?

bool

Property types

Response
[
  {
    "address": "string",
    "permissionsSummary": int
  }
]

Properties

PropertyDescription
addressThe ElastiCube address.
permissionsSummary???

Error Status Codes

HTTP Status Code
Reason
403forbidden

GET /elasticubes/servers/{server}

Returns all the ElastiCubes by server. 

Parameters

Parameter
Value
Description
Data Type
serverMandatoryThe server addressstring
q 

A query that returns all ElastiCubes beginning with the value. For example, a value of 'sa' will return ElastiCubes called 'Sample Ecommerce', 'Sample Lead generation' etc.

string
offset Defines how many items to skip before returning the results. For example, to return results from value #101 onward, enter a value of ‘100’.int
count 

Limits the result set to a defined number of results. Enter 0 (zero) or leave blank not to limit.

int
orderBy Orders the results by field name. You can add multiple sort fields separated by a comma delimiter ','string
direction The sort direction.string

Property types

Response
[
  {
    "createdUtc": "dateTime",
    "databaseName": "aCountries",
    "lastBuiltUtc": "Datetime",
    "permissionsSummary": 1,
    "sizeInMb": 0.9777,
    "status": 2,
    "title": "string"
  }
]

Properties

PropertyDescription
createdUtcExplain format
databaseNameThe name of the database.
lastBuiltUtcExplain format
permissionsSummary???
sizeInMbThe size of the ElastiCube in MB.
status???
titleThe name of the ElastiCubes.

Error Status Codes

HTTP Status Code
Reason
403forbidden

GET /elasticubes/servers/{server}/simple

Returns ElastiCube metadata by entering the server name/address/IP and database name.

Parameters

Parameter
Value
Description
Data Type
servermandatoryThe ElastiCube's server address (name/address/IP)string
elasticubemandatoryEnter a specific ElastiCube ID to return the results for that ElastiCube only.string
Response
 

What is this response?

Error Status Codes

HTTP Status Code
Reason
403forbidden

GET /elasticubes/servers/{server}/status

Returns the status of each ElastiCube in the selected server. 

Parameters

Parameter
Value
Description
Data Type
servermandatoryThe ElastiCube's server addressstring
q Enter a search query to return results containing the querystring
offset Defines how many items to skip before returning the results. For example, to return results from value #101 onward, enter a value of ‘100’.int
count 

Limits the result set to a defined number of results. Enter 0 (zero) or leave blank not to limit.

int
orderBy 

Orders the results by field name. You can add multiple sort fields separated by a comma delimiter ','

string
direction The sort direction.string

Property types

Response
[
  {
    "status": int,
    "title": "string"
  },
]

Properties

PropertyDescription
status

The status of the ElastiCube:

1 - stopped

2 - running

4 - faulted

8 - being deleted

16 - currently restarting

32 - wrong version

64 - the ElastiCube is down because it is 32 bit data on a 64 bit codebase

128 - the ElastiCube is down because it is 64 bit data on a 32 bit codebase

256 - locked

512 - the ElastiCube or its child is currently in a build process.

1024 - the ElastiCube is starting, but not yet running.

2048 - the ElastiCube is in a build process.

4096 - trying to import a BigData ElastiCube on a non-BigData server

8192 - trying to import a non-BigData ElastiCube on a BigData server

16384 - Building is finished, now post indexing is running

32768 - the ElastiCube is being stopped but its executable is still running

65536 - this ElastiCube is in the process of cancelling an in-progress build

titleThe name of the ElastiCube.

Error Status Codes

HTTP Status Code
Reason
403forbidden

GET /elasticubes/{server}/{elasticube}/datasecurity

 

Returns the data security rules set up for the ElastiCube. Click here to learn more.

Parameters

Parameter
Value
Description
Data Type
servermandatoryThe ElastiCube's server addressstring
elasticubemandatoryThe name of the ElastiCubestring
Response
 [
  {
    "_id": "objectId",
    "allMembers": bool,
    "column": "string",
    "cubeId": "objectId",
    "datatype": "text",
    "members": [],
    "server": "LocalHost",
    "shares": [
      {
        "type": "default"
      }
    ],
    "table": "string"
  }
]

Properties

PropertyDescription
_Id???
allMembers???
columnThe column name in the table.
cubeId???
datatype???
members???
serverThe name of the ElastiCube server.
sharestype - ???
table???

Error Status Codes

HTTP Status Code
Reason
400invalid elastiCube identifier
403forbidden

 

 

GET /elasticubes/{server}/{cube}/{user}/datasecurity

Returns data security for a specific user in a specific ElastiCube.

Parameters

Parameter
Value
Description
Data Type
servermandatoryThe ElastiCube's server addressstring
cubemandatoryThe ElastiCube's namestring
usermandatoryThe user's ID or username.string
Property types
Response
[
  {
    "_id": "objectId",
    "allMembers": bool,
    "column": "String",
    "cubeId": "objectId",
    "datatype": "int",
    "members": [],
    "server": "string",
    "shares": [
      {
        "type": "default"
      }
    ],
    "table": "string"
  }
]

Properties

PropertyDescription
idThe user's unique ID.
allMembers???
column???
cubeIdThe unique ID of the ElastiCube.
datatype???
members???
serverThe ElastiCube server address.
sharestype ???
table???

Error Status Codes

HTTP Status Code
Reason
400invalid elastiCube identifier
403forbidden

GET /elasticubes/{server}/{elasticube}/datasecurity/{table}/{column}

Returns ElastiCube data security for a column in a table in the ElastiCube.

Parameters

Parameter
Value
Description
Data Type
servermandatoryThe ElastiCube's server address.string
elasticubemandatoryThe name of the ElastiCubestring
tablemandatoryThe name of the table in the ElastiCubestring
columnmandatoryThe name of the column in the tablestring
Response
 

Response didn't work

Error Status Codes

HTTP Status Code
Reason
400invalid ElastiCube identifier
403forbidden

GET /elasticubes/{server}/{elasticube}/permissions

Returns all authentication records for the given ElastiCube.

Parameters

Parameter
Value
Description
Data Type
servermandatoryThe ElastiCube's server address.string
elasticubemandatoryThe name or ID of the ElastiCubestring
Response
{
  "server": "string",
  "title": "string",
  "shares": [
    {
      "permission": "string",
      "partyId": "string",
      "type": "string",
	  "shareId": "objectId",
      "permission": null,
      "rule": "view"
    }
  ]
}

Model schema is missing details (shareId, permission, rule), plus types

Properties

PropertyDescription
inherited???
serverThe ElastiCube's server address.
titleThe name of the ElastiCube.
shares

An array containing the different permissions. Each permission is an ACL (access control level) object.

partyid - The ID of the party (either a user or user group)

type -  type of party (user or user group)

shareId -

permission - level of permission (read , write, admin). Only read is currently supported.

rule -

Error Status Codes

HTTP Status Code
Reason
400invalid server
400invalid cube ID
403forbidden

POST /elasticubes/{server}/{elasticube}/start

Starts the ElastiCube server.

Parameters

Parameter
Value
Description
Data Type
server The ElastiCube's server address.string
elasticube The name or ID of the ElastiCube.string

Error Status Codes

HTTP Status Code
Reason
400invalid server
400invalid elasticube
403forbidden

POST /elasticubes/{server}/{elasticube}/stop

Stops the ElastiCube server.

Parameters

Parameter
Value
Description
Data Type
server The ElastiCube's server address.string
elasticube The name of the ElastiCube.string

Error Status Codes

HTTP Status Code
Reason
400invalid server
400invalid ElastiCube
403forbidden

POST /elasticubes/{server}/{elasticube}/restart

Restarts the ElastiCube server.

Parameters

Parameter
Value
Description
Data Type
server 

The server address of the ElastiCube.

string
elasticube elasticube namestring

Error Status Codes

HTTP Status Code
Reason
400invalid server
400invalid elasticube
403forbidden

POST /elasticubes/{server}/{elasticube}/startBuild

Starts the build process for an ElastiCube, with the option to select the type of build.

Parameters

Parameter
Value
Description
Data Type
serverMandatoryThe server address of the ElastiCube.string
elasticubeMandatoryThe name or ID of the ElastiCubestring
type Process Type: [None,Full,Delta,Custom,FullUpdateExisting - explain with relation to UI, what is default?string

Error Status Codes

HTTP Status Code
Reason
400invalid server
400invalid elasticube
403forbidden

POST /elasticubes/{server}/{elasticube}/stopBuild

Stops the build process for an ElastiCube.

Parameters

Parameter
Value
Description
Data Type
serverMandatoryThe server address of the ElastiCube.string
elasticubeMandatoryThe name of the ElastiCube.string

Error Status Codes

HTTP Status Code
Reason
400invalid server
400invalid elasticube
403forbidden

 

POST /elasticubes/{elasticube}/jaql

Executes a JAQL query on the ElastiCube.

As an example, the following JAQL query returns total quantity by contact name.

Example JAQL
{

  "datasource": {

    "title": "Training",

    "id": "aLOCALHOST_aTRAINING",

    "address": "LocalHost",

    "database": "aTraining"

  },

  "metadata": [

    {

      "jaql": {

        "table":
"Customers",

        "column":
"ContactName",

        "dim":
"[Customers.ContactName]",

        "datatype":
"text",

        "title":
"ContactName"

      }

      

    },

    {

      "jaql": {

        "table":
"OrderDetails",

        "column": "Quantity",

        "dim":
"[OrderDetails.Quantity]",

        "datatype":
"numeric",

        "agg": "sum",

        "title": "Total
Quantity"

      }

      

    },

  

  ],

  "count": 20000,

  "offset": 0,

}

 Parameters

ParameterValueDescriptionData Type
JaqlMandatoryThe Jaql query.Jaql
elasticubeMandatoryThe name or ID of the ElastiCube.string

Error Status Codes

HTTP Status CodeReason
400invalid elasticube identifier
403forbidden

 

POST /elasticubes/{server}/{elasticube}/datasecurity

Defines data security for an ElastiCube. Click here for more information.

Parameters

ParameterValueDescriptionData Type
servermandatoryThe server address of the ElastiCube.
string
elasticubemandatoryThe name of the ElastiCube.string
List[elasticubeNewDataSecurityItemCubeGiven]mandatoryThe data security object that needs to be updated.
Model Schema
[
  {
    "table": "string",
    "column": "string",
    "datatype": "string",
    "shares": [
      {
        "party": "string",
        "type": "string"
      }
    ],
    "members": [
      "string"
    ],
    "allMembers": "bool"
  }
]

 

Properties

PropertyDescription
Shares

An array containing permissions. Each permission is an ACL, which includes:

  • partyId - The ID of the party (either user or group) that this ACL relates to
  • type - type of party (group or user)
  • permission - level of permission (read , write, admin...). Only read is currently supported.
allMembers  true indicates "everything". false indicates "nothing"
 members If 'allMembers' is present (either true or false) this members array is ignored; otherwise- contains the members that this data security record is about.

Error Status Codes

HTTP Status CodeReason
404dataContext not found
403forbidden

POST /elasticubes/datasecurity

Add new data context ???

Parameters

ParameterValueDescriptionData Type
List[elasticubeNewDataSecurityItem]mandatoryThe data security object that needs to be updated.
Model Schema
[
  {
    "server": "string",
    "elasticube": "string",
    "table": "string",
    "column": "string",
    "datatype": "string",
    "shares": [
      {
        "party": "string",
        "type": "string"
      }
    ],
    "members": [
      "string"
    ],
    "allMembers": "bool"
  }
]

Properties

PropertyDescription
servername or address?
elasticubeThe name of the ElastiCube
tableThe name of the table in the ElastiCube.
column

The name of the column in the table.

datatype???
shares

An array containing permissions. Each permission is an ACL, which includes:

partyId - The ID of the party (either user or group) that this ACL relates to.
type - type of party (group or user)
allMembers - true indicates "everything". false indicates "nothing"
members - If 'allMembers' is present (either true or false) this members array is ignored; otherwise- contains the members that this data security record is about.


Error Status Codes

HTTP Status CodeReason
404dataContext not found
403forbidden

POST /elasticubes/{server}/{elasticube}/permissions

Defines a new permission for the given ElastiCube. Click here to learn more.

Parameters

ParameterValueDescriptionData Type
servermandatoryThe server address of the ElastiCube.string
elasticubemandatoryThe name of the ElastiCube.string
shares 

The 'shares' is an array containing the different permissions. Each permission is an ACL (access control level).

Model Schema
[
  {
    "permission": "string",
    "partyId": "string",
    "type": "string"
  }
]

Properties

PropertyDescription
permission???
partyIdThe ID of the party (either user or group) that this ACL relates to.
typeThe type of party (group or user).


Error Status Codes

HTTP Status CodeReason
400invalid server
400invalid cube ID
403forbidden

 

PUT /elasticubes/{server}/{elasticube}/permissions

Updates the permissions (ACLs) for the current ElastiCube.

Parameters

ParameterValueDescriptionData Type
servermandatoryThe server address of the ElastiCube.string
elasticubemandatoryThe name of the ElastiCube.string
shares The 'shares' is an array containing the different permissions. Each permission is an ACL (access control level).
Model Schema
[
  {
    "permission": "string",
    "partyId": "string",
    "type": "string"
  }
]

Properties

PropertyDescription
permission???
partyIdThe ID of the party (either user or group) that this ACL relates to.
typeThe type of party (group or user).


Error Status Codes

HTTP Status CodeReason
400invalid server
400invalid cube ID
403forbidden

PUT /elasticubes/server/{server}/permissions

Defines permissions for an ElastiCube server, which will be used as the default permissions for ElastiCubes without specified permissions of their own. 

Parameters

ParameterValueDescriptionData Type
servermandatoryThe server address of the ElastiCube.string
shares The 'shares' is an array containing the different permissions. Each permission is an ACL (access control level).
Model Schema
[
  {
    "permission": "string",
    "partyId": "string",
    "type": "string"
  }
]

Properties

PropertyDescription
permission???
partyIdThe ID of the party (either user or group) that this ACL relates to.
typeThe type of party (group or user).

Error Status Codes

HTTP Status Code
Reason
400invalid server
403forbidden

DELETE /elasticubes/{server}/{elasticube}/datasecurity/{table}/{column}

Deletes data context from a column in an ElastiCube table.

Parameters

Parameter
Value
Description
Data Type
servermandatoryThe server address of the ElastiCube.string
elasticubemandatoryThe name of the ElastiCube.

string

tablemandatoryThe name of the table in the ElastiCube.string
columnmandatoryThe name of the column in the table.string

Error Status Codes

HTTP Status Code
Reason
400invalid datasource identifier
403forbidden

DELETE /elasticubes/{server}/{elasticube}/permissions

Deletes all permissions for the ElastiCube, and reverts permissions to the server defaults. 

Parameters

Parameter
Value
Description
Data Type
servermandatoryThe server address of the ElastiCube.string
elasticubemandatoryThe name or ID of the ElastiCube.

string

Error Status Codes

HTTP Status Code
Reason
400invalid server
400invalid cube ID
403forbidden

/users

GET /users

Returns all users and related metadata.

Parameters

ParameterValueDescriptionData Type
limit Limits the result set to a defined number of resultsint
skip Defines how many items to skip before returning the results.int
search Enter a search query to return results matching the query.string
orderby Orders the results by field name. You can add multiple sort fields separated by a comma delimiter ','string
desc Defines the order of the results. True returns results in a descending order.bool
onlyAD Searches only Active Directory users.bool
groupsnames Includes the user's groups if the user belongs to one or more groups.bool
Response
[
  {
    "_id": "ObjectId",
	"active": bool,
    "userName": "string",
    "roleId": "ObjectId",
    "email": "string",
    "firstName": "string",
	"hash": "objectId",
    "lastName": "string",
    "active": "bool",
    "created": "dateTime",
    "lastUpdated": "dateTime",
	"preferences": {}
    "lastLogin": "dateTime",
	"userName": "string",
    "roleName": "super",
    "baseRoleName": "super"
  }
]

Missing responses added (hash, preferences, rolename, base role name) plus types

Error Status Codes

HTTP Status CodeReason
400invalid search
400invalid skip
403forbidden

GET /users/ad

Searches for users in Active Directory. This function does not search for users in the Sisense repository.

Parameters

ParameterValueDescriptionData Type
limit Limits the result set to a defined number of results. Enter 0 (zero) or leave blank not to limit.int
checkExist Checks if the user exists in the database.bool
search Enter a search query to return results matching the query.string
Response
[
  {
    "_id": "ObjectId",
    "userName": "string",
    "roleId": "ObjectId",
    "email": "string",
    "firstName": "string",
    "lastName": "string",
    "active": "bool",
    "created": "dateTime",
    "lastUpdated": "dateTime",
    "lastLogin": "dateTime"
  }
]

Properties

PropertiesDescription
_idThe user's unique ID.
userNameThe user's username.
roleId???
emailThe user's email address.
firstNameThe user's first name.
lastNameThe user's last name.
active???
createdThe date on which the user was created in AD or Sisense
lastUpdatedThe user's last update.
lastLoginThe last time the user logged in.

Error Status Codes

HTTP Status CodeReason
400invalid search
400invalid skip
403forbidden

GET /users/allDirectories

Searches for users in all directories. This function searches the Sisense repository, and if the user is not found, searches for the user in Active Directory.

Parameters

ParameterValueDescriptionData Type
limit 

Limits the result set to a defined number of results

Enter 0 (zero) or leave blank not to limit.
int
search Enter a search query to return results matching the query.string
Response
[
  {
    "_id": "ObjectId",
    "userName": "string",
    "roleId": "ObjectId",
    "email": "string",
    "firstName": "string",
    "lastName": "string",
    "active": "bool",
    "created": "dateTime",
    "lastUpdated": "dateTime",
    "lastLogin": "dateTime"
  }
]

Properties

PropertiesDescription
_idThe user's unique ID.
userNameThe user's username.
roleId???
emailThe user's email address.
firstNameThe user's first name.
lastNameThe user's last name.
active???
createdThe date on which the user was created in AD or Sisense
lastUpdatedThe user's last update.
lastLoginThe last time the user logged in.

Error Status Codes

HTTP Status CodeReason
400invalid search
400invalid skip
403forbidden

GET /users/count

Counts users using a defined query string, and returns the number of users with the query result in their usernames. 

Parameters

Parameter
Value
Description
Data Type
search Searches for users with usernames that include the query string.string

Property types

Response
{
  "collection": "string",
  "count": int
}

Properties

PropertyDescription
collection???
countThe number of users Ad and Sisense?

Error Status Codes

HTTP Status Code
Reason
400invalid search
400invalid limit
403forbidden

GET /users/{user}

Returns metadata for a user by username or user ID. 

Parameters

ParameterValueDescriptionData Type
user The user's ID or usernamestring
Response
{
  "_id": "ObjectId",
  "userName": "string",
  "roleId": "ObjectId",
  "email": "string",
  "firstName": "string",
  "lastName": "string",
  "active": "bool",
  "created": "dateTime",
  "lastUpdated": "dateTime",
  "lastLogin": "dateTime"
}

Properties

PropertiesDescription
_idThe user's unique ID.
userNameThe user's username.
roleId???
emailThe user's email address.
firstNameThe user's first name.
lastNameThe user's last name.
active???
createdThe date on which the user was created.
lastUpdatedThe user's last update.
lastLoginThe last time the user logged in.

Error Status Codes

HTTP Status CodeReason
400invalid ID
400ID not found
403forbidden

GET /users/loggedin

Retrieves my user details. 

Response
{
  "_id": "ObjectId",
  "userName": "string",
  "roleId": "ObjectId",
  "email": "string",
  "firstName": "string",
  "lastName": "string",
  "active": "bool",
  "created": "dateTime",
  "lastUpdated": "dateTime",
  "lastLogin": "dateTime",
  "preferences": {},
  "userAuth": {} 
}

Actual response includes more properties (locale preferences and manifest of permissions)

Properties

PropertiesDescription
_idThe user's unique ID.
userNameThe user's username.
roleId???
emailThe user's email address.
firstNameThe user's first name.
lastNameThe user's last name.
active???
createdThe date on which the user was created.
lastUpdatedThe user's last update.
lastLoginThe last time the user logged in.
preferencesIndicates locale preferences and anything else?
userAuth
A list of permissions for the user.

Error Status Codes

HTTP Status CodeReason
403forbidden

POST /users/simulate

Returns the users and related metadata of a simulated operation that adds multiple users. This operation does not add users. 

Parameters

ParameterValueDescriptionData Type
List[email/usernames]Mandatory
The list of user emails to add, or usernames for Active Directory mode.
[
  {
    "userName": "string",
    "roleId": "ObjectId",
    "email": "string",
    "firstName": "string",
    "lastName": "string",
    "preferences": {
      "localeId": "string"
    }
  }
]

Properties

PropertyDescription
userNameThe user's username.
roleIdThe user role (admin, designer or viewer)
emailThe user's email address.
firstNameThe user's first name.
lastNameThe user's last name.
preferencesThe user's preferred locale.


admode Enter True to simulate adding users from Active Directory.bool

Error Status Codes

HTTP Status CodeReason
400invalid input
403forbidden

POST /users

Adds a new user. 

Parameters

ParameterValueDescriptionData Type
List[user]Mandatory

The user object includes all the user information.

Model Schema

Model Schema
[
  {
    "userName": "string",
    "roleId": "ObjectId",
    "email": "string",
    "firstName": "string",
    "lastName": "string",
    "preferences": {
      "localeId": "string"
    }
  }
]

Properties

PropertyDescription
userNameThe user's username.
roleIdThe user role (admin, designer or viewer).
emailThe user's email address.
firstNameThe user's first name.
lastNameThe user's last name.
preferencesThe user's preferred locale.
notify Send notifications to the user.boolean

Error Status Codes

HTTP Status CodeReason
400invalid input
403forbidden

POST /users/ad

Imports a user from Active Directory as a new user in Sisense. 

Parameters

ParameterValueDescriptionData Type
userMandatory
The user object that needs to be added to the directory.
Model Schema
{
  "userName": "string",
  "roleId": "ObjectId",
  "email": "string",
  "firstName": "string",
  "lastName": "string",
  "preferences": {
    "localeId": "string"
  }
}

 Properties

PropertyDescription
userName The user's username.
roleId The user role (admin, designer or viewer).
email The user's email address.
firstName The user's first name.
lastName The user's last name.
preferences The user's preferred locale.


Error Status Codes

HTTP Status CodeReason
400invalid input
403forbidden

POST /users/forgetpassword

Sends a user an email to activate or reset the user's password.

Parameters

ParameterValueDescriptionData Type
userEmailMandatory
The email of the user that requires a password reset.

Model Schema

{
  "email": "string"
}

 Properties

PropertyDescription
emailThe user's email.


Error Status Codes

HTTP Status CodeReason
403forbidden

POST /users/activate/{user}

Activates a user by user ID or username.

Parameters

ParameterValueDescriptionData Type
userMandatory
User's ID or username

String

src The URL of the page to redirect the user after activation. string
userActivateMandatoryThe user object that needs to be updated.
Model Schema
{
  "password": "string",
  "preferences": {
    "localeId": "string"
  }
}

Properties

PropertyDescription
passwordThe user's password.
preferencesThe user's preferred locale.


Error Status Codes

HTTP Status CodeReason
400invalid input
403forbidden

POST /users/recoverpassword/{user}

Recovers a user's password by user ID or username.

Parameters

ParameterValueDescriptionData Type
userMandatory
User's ID or username

String

src The URL of the page to redirect the user after activation.string
userActivateMandatoryThe user object that needs to be updated.
Model Schema
{
  "password": "string",
  "preferences": {
    "localeId": "string"
  }
}

Properties

PropertyDescription
passwordThe user's password.
preferencesThe user's preferred locale preference.

Error Status Codes

HTTP Status CodeReason
400invalid input
403forbidden

POST /users/delete

Deletes the user by ID.

Parameters

Parameter
Value
Description
Data Type
list[string]Mandatory
The user object that needs to be updated.

list[string]

Error Status Codes

HTTP Status Code
Reason
400invalid ID
404ID not found
403forbidden

POST /users/validate

Validates existing users by entering their emails.

Parameters

Parameter
Value
Description
Data Type
list[string]Mandatory
List of emails of users that require validation.

list[string]

Error Status Codes

HTTP Status Code
Reason
400invalid input
403forbidden

PUT /users/{user}

Updates one or more user details, by user ID or username.

Parameters

ParameterValueDescriptionData Type
userMandatoryThe user's ID or username.string
userUpdateMandatoryThe user object that needs to be updated.
Model Schema
{
  "userName": "string",
  "roleId": "ObjectId",
  "email": "string",
  "firstName": "string",
  "lastName": "string",
  "preferences": {
    "localeId": "string"
  }
}

Properties

PropertyDescription
userName The user's username.
roleId The user role (admin, designer or viewer).
email The user's email address.
firstName The user's first name.
lastName The user's last name.
preferences The user's preferred locale.

Error Status Codes

HTTP Status CodeReason
400invalid ID
404ID not found
403forbidden

DELETE /users/{user}

Deletes a user by user ID or username.

Parameters

Parameter
Value
Description
Data Type
userMandatoryThe user's ID or username.string

Error Status Codes

HTTP Status Code
Reason
400invalid ID
404ID not found
403forbidden

/groups

GET /groups

Returns all user groups with metadata.

Parameters

ParameterValueDescriptionData Type
limit 

Limits the result set to a defined number of results. Enter 0 (zero) or leave blank not to limit.

int
skip Defines how many items to skip before returning the results. int
search Enter a search query to return results matching the query.string
dn Search for a group using an Active Directory dn as the search query. Use the semi-colon ; delimiter to search multiple groups.string
orderBy Orders the results by field name. You can add multiple sort fields separated by a comma delimiter ',' string
desc Defines the order of the results. True returns results in a descending order.boolean
onlyAD Searches only Active Directory user groups.boolean
noAD Search only for non Active Directory groups.boolean
exactMatch Searches exact matches when searching by the Active Directory dn.boolean
usersCount Counts the number of users in each group.boolean
Response
[
  {
    "_id": "ObjectId",
    "name": "string",
    "roleId": "ObjectId",
    "created": "dateTime",
    "lastUpdated": "dateTime"
  }
]

Properties

PropertiesDescription
_idThe user group's unique ID.
nameThe user group's name.
roleIdalways null ??
createdThe date and time when the group was created.
lastUpdatedThe date and time when the group was last updated.

Error Status Codes

HTTP Status CodeReason
400Invalid source
400invalid skip
403forbidden

GET /groups/ad

Searches for groups directly in Active Directory, excluding groups created directly in Sisense.  

Parameters

ParameterValueDescriptionData Type
limit 

Limits the result set to a defined number of results. Enter 0 (zero) or leave blank not to limit.

int
checkExist Check if a group exists in Active Directory, and if not, searches groups created in Sisense. boolean
search Enter a search query to return results matching the query. 
Response
[
  {
    "_id": "ObjectId",
    "name": "string",
    "roleId": "ObjectId",
    "created": "dateTime",
    "lastUpdated": "dateTime"
  }
]

Properties

PropertyDescription
_idThe user group's unique ID.
name The user group's name.
created The date and time when the group was created.
lastUpdated The date and time when the group was last updated.

Error Status Codes

HTTP Status CodeReason
400Invalid search
400invalid skip
403forbidden

GET /groups/allDirectories

Searches for groups in all directories. This function searches groups created in Sisense, and if not found, will search in Active Directory groups.

Parameters

ParameterValueDescriptionData Type
limit 

Limits the result set to a defined number of results. Enter 0 (zero) or leave blank not to limit.

int
search Enter a search query to return results matching the query.string
usersCount Returns the number of users per group.boolean
Response
[
  {
    "_id": "ObjectId",
    "name": "string",
    "roleId": "ObjectId",
    "created": "dateTime",
    "lastUpdated": "dateTime"
  }
]

Properties

PropertyDescription
_idThe user group's unique ID.
nameThe user group's name.
roleIdnull ??
createdThe date and time when the group was created.
lastUpdatedThe date and time when the group was last updated.

Error Status Codes

HTTP Status CodeReason
400Invalid search
403forbidden

GET /groups/{group}

Returns metadata for a group by group ID or name. Metadata includes name, role ID, created date and time, and last update date and time.

Parameters

ParameterValueDescriptionData Type
groupMandatoryThe ID or username of the groupstring
Response
{
  "_id": "ObjectId",
  "name": "string",
  "roleId": "ObjectId",
  "created": "dateTime",
  "lastUpdated": "dateTime"
}

Properties

PropertyDescription
_id The user group's unique ID.
name The user group's name.
roleId null ??
created The date and time when the group was created.
lastUpdated The date and time when the group was last updated.

Error Status Codes

HTTP Status CodeReason
400Invalid ID
404ID not found
403forbidden

GET /groups/{group}/users

Returns a list of users in a group together with each user's metadata. Metadata includes the user's username, role ID, email, first and last names, active state, created date, last login, and last update date.

Parameters

ParameterValueDescriptionData Type
groupMandatoryThe group's ID or username.string
Response
[
  {
    "_id": "ObjectId",
    "userName": "string",
    "roleId": "ObjectId",
    "email": "string",
    "firstName": "string",
    "lastName": "string",
    "active": "bool",
    "created": "dateTime",
    "lastUpdated": "dateTime",
    "lastLogin": "dateTime"
  }
]

Properties

PropertyDescription
_idThe user's unique ID.
userNameThe user's username.
roleIdThe user role (admin, designer or viewer).
emailThe user's email.
firstNameThe user's first name.
lastNameThe user's last name.
active???
createdThe date and time when the user was created,
lastUpdatedThe date and time when the user was last updated.
lastLoginThe date and time of the user's last login.

Error Status Codes

HTTP Status CodeReason
400Invalid ID
404ID not found
403forbidden

POST /groups/byIds

Returns a list of groups by user IDs.

Parameters

ParameterValueDescriptionData Type
List[ObjectId]MandatoryList of user IDsstring
usersCount Returns the number of users per group.Boolean
Response
[
  {
    "_id": "ObjectId",
    "name": "string",
    "roleId": "ObjectId",
    "created": "dateTime",
    "lastUpdated": "dateTime"
  }
]

Properties

PropertyDescription

_id

The user's unique ID.
nameThe user's username.
roleIdThe user role (admin, designer or viewer).
createdThe date and time when the user was created.
lastUpdatedhe date and time when the user was last updated.

Error Status Codes

HTTP Status CodeReason
400Invalid ID
404ID not found
403forbidden

POST /groups

Adds a new Sisense user group.

Parameters

ParameterValueDescriptionData Type
List[group]MandatoryThe group object that needs to be added.
Model Schema
[
  {
    "_id": "ObjectId",
    "name": "string",
    "roleId": "ObjectId",
    "created": "dateTime",
    "lastUpdated": "dateTime"
  }
]

How can we add created, last updated if this is new? Here and below in response.

Response
{
  "_id": "ObjectId",
  "name": "string",
  "roleId": "ObjectId",
  "created": "dateTime",
  "lastUpdated": "dateTime"
}

Error Status Codes

HTTP Status CodeReason
400Invalid input
403forbidden

POST /groups/ad

Adds a new Active Directory user group.
Please note that if you add an objectSid key, then the data will not be imported again from Active Directory.
It is recommended to use the Active Directory cn (common name) or name, but not both. The cn is preferred.

Parameters

ParameterValueDescriptionData Type
List[ADgroup]MandatoryThe group object that needs to be added to the collection.
Model Schema
[
  {
    "_id": "ObjectId",
    "objectSid": "array/buffer",
    "cn/name": "string",
    "dn": "string",
    "uSNChanged": "string",
    "mail": "string",
    "roleId": "ObjectId",
    "created": "dateTime",
    "lastUpdated": "dateTime"
  }
]

How can we add created, last updated if this is new? Here and below in response.

Response
[
  [
    {
      "name": "testgroupapi",
      "ad": false,
      "objectSid": "",
      "dn": "",
      "uSNChanged": "",
      "mail": "",
      "created": "2015-06-17T12:26:08.772Z",
      "lastUpdated": "2015-06-17T12:26:08.772Z",
      "_id": "55816760d68d4a302b000001"
    }
  ]
]

Above response does not match model schema

Properties

PropertyDescription
nameThe name of the new group.
adWhy is this false?

objectSid

 The Active Directory objectSid
dnThe break down of your domain including all hosts. 

created

The date and time the group was created.
lastUpdated The date and time the group was last updated.

Error Status Codes

HTTP Status CodeReason
400Invalid input
403forbidden

POST /groups/{group}/users

Adds users to a Sisense user group.

Parameters

Parameter
Value
Description
Data Type
groupMandatoryThe group's ID or name.string
List[ADgroup]MandatoryThe IDs or usernames of the users that need to be added to the group.

List[string]

Error Status Codes

HTTP Status Code
Reason
400Invalid input
403forbidden

POST /groups/validateName

validate a group name ???

Parameters

ParameterValueDescriptionData Type
groupMandatoryThe name of the group to validate
Model Schema
{
  "name": "string"
}

Properties

PropertyDescription
nameThe name of the user group.


Error Status Codes

HTTP Status CodeReason
400Invalid ID
404ID not found
403forbidden

PUT /groups/{group}

Updates a group by group ID or name.

What are we updating? name, role (only for AD)

Parameters

ParameterValueDescriptionData Type
groupMandatoryThe group's ID or name.

string


groupUpdateMandatoryThe group object that needs to be updated.
Model Schema
 {
  "_id": "ObjectId",
  "name": "string",
  "roleId": "ObjectId",
  "created": "dateTime",
  "lastUpdated": "dateTime"
}

Properties

PropertyDescription
_idThe group's unique ID.

name

The name of the group.

roleId

The user role (admin, designer or viewer).
createdThe date and time when the group was created.
lastUpdatedThe date and time when the group was last updated.


Error Status Codes

HTTP Status CodeReason
400Invalid ID
404ID not found
403forbidden

DELETE /groups

Deletes multiple groups by group name or ID.

Parameters

Parameter
Value
Description
Data Type
deleteGroupMandatory

The IDs of the groups to delete.

{
  "groups": [
    null
  ],
  "deleteAdUsers""boolean"
}

Properties

PropertyDescription
groups

The groups to delete.

deleteAdUsersEnter true to delete the users of the group in addition to the group.

Error Status Codes

HTTP Status Code
Reason
400Invalid ID
404ID not found
403forbidden

 

DELETE /groups/{group}

Deletes a group by group ID or name.

Parameters

Parameter
Value
Description
Data Type
groupMandatoryThe group's ID or name.

string

deleteauthors Select true if you want to delete the users of the Active Directory group.boolean

Error Status Codes

HTTP Status Code
Reason
400Invalid ID
404ID not found
403forbidden

DELETE /groups/{group}/users

Removes users from a user group.

Parameters

Parameter
Value
Description
Data Type
groupMandatoryThe group's ID or name.

string

List[string]MandatoryThe user IDs or usernames to remove from the group.List[string]

Error Status Codes

HTTP Status Code
Reason
400Invalid input
403forbidden

/auth

GET /auth/isauth

Returns users that are logged in.

Response
 {
  "isAuthenticated": false
}

Properties

PropertyDescription

isAuthenticated

Indicates whether the user is logged in or not.

GET /auth/logout

Forces the user to be logged out.

Error Status Codes

HTTP Status Code
Reason
400Invalid ID
403forbidden

/branding

DELETE /branding

Resets the current branding to default? Is it all or nothing, or can we select items?

Response
[
  {
    "logo": {
      "desktop": {
        "small": "path string",
        "large": "path string"
      },
      "tablet": {
        "small": "path string",
        "large": "path string"
      },
      "phone": {
        "small": "path string",
        "large": "path string"
      }
    },
    "favicon": "string",
    "pageTitle": "string",
    "loginTitle": "string",
    "loginSubtitle": "string",
    "activationTitle": "string",
    "activationSubtitle": "string",
    "contactUsText": "string",
    "copyrightText": "string",
    "homePage": "string",
    "emails": {
      "senderEmail": "string",
      "senderName": "string",
      "templates_directory": "string",
      "passwordRecoverySubject": "string",
      "newUserInviteSubject": "string",
      "shareWithNewUserSubject": "string",
      "shareWithExistingUser": "string"
    }
  }
]

Error Status Codes

HTTP Status CodeReason
400Invalid input
404ID not found
403forbidden

GET /branding

Returns the current branding metadata.

Response
[
  {
    "logo": {
      "desktop": {
        "small": "path string",
        "large": "path string"
      },
      "tablet": {
        "small": "path string",
        "large": "path string"
      },
      "phone": {
        "small": "path string",
        "large": "path string"
      }
    },
    "favicon": "string",
    "pageTitle": "string",
    "loginTitle": "string",
    "loginSubtitle": "string",
    "activationTitle": "string",
    "activationSubtitle": "string",
    "contactUsText": "string",
    "copyrightText": "string",
    "homePage": "string",
    "emails": {
      "senderEmail": "string",
      "senderName": "string",
      "templates_directory": "string",
      "passwordRecoverySubject": "string",
      "newUserInviteSubject": "string",
      "shareWithNewUserSubject": "string",
      "shareWithExistingUser": "string"
    }
  }
]

Properties

PropertyDescription

logo

The paths to different logos suited for different device types.

favicon

The path to an image to replace the default Sisense logo.

pageTitle

Text to replace the default 'Sisense' title.

loginTitle

Text to replace "WELCOME TO SISENSE".

loginSubtitle

Text to replace "Sign in & start exploring".

activationTitle

Text to replace "Welcome".

activationSubtitle

Text to replace "Welcome".

contactUsText

Text to replace the default Sisense contact details.

copyrightText

Text to replace Sisense’s copyright text.

homePage

A URL that replaces the default "http://www.sisense.com".

emails

An array that includes all email branding.

"senderEmail":"[email protected]company.com",

"senderName":"sys-admin",

"templates_directory" : "/resources/branding/emails",

"passwordRecoverySubject" : "Sisense password recovery",

"newUserInviteSubject" : "Sisense account activation",

"shareWithNewUserSubject" : "A Dashboard has been shared with you:",

"shareWithExistingUserSubject" : "A Dashboard has been shared with you:"

Error Status Codes

HTTP Status CodeReason
400Invalid ID
404ID not found
403forbidden

POST /branding

Adds new branding to your Sisense dashboards, including customized texts, logos and emails.

Parameters

ParameterValueDescriptionData Type
brandingMandatory

The branding object that needs to be added to the collection.

Model Schema
{
  "logo": {
    "desktop": {
      "small": "path string",
      "large": "path string"
    },
    "tablet": {
      "small": "path string",
      "large": "path string"
    },
    "phone": {
      "small": "path string",
      "large": "path string"
    }
  },
  "favicon": "string",
  "pageTitle": "string",
  "loginTitle": "string",
  "loginSubtitle": "string",
  "activationTitle": "string",
  "activationSubtitle": "string",
  "contactUsText": "string",
  "copyrightText": "string",
  "homePage": "string",
  "emails": {
    "senderEmail": "string",
    "senderName": "string",
    "templates_directory": "string",
    "passwordRecoverySubject": "string",
    "newUserInviteSubject": "string",
    "shareWithNewUserSubject": "string",
    "shareWithExistingUser": "string"
  }
}

Properties

PropertyDescription
logoThe paths to the logo images.
pageTitleText to replace the default 'Sisense' title.

loginTitle

Text to replace "WELCOME TO SISENSE".

loginSubtitle

Text to replace "Sign in & start exploring".

activationTitle

Text to replace "Welcome".

activationSubtitle

Text to replace "Welcome".

contactUsText

Text to replace the default Sisense contact details.

copyrightText

Text to replace Sisense’s copyright text.

homePage

A URL that replaces the default "http://www.sisense.com".

emails

An array that includes all email branding.

 


"senderEmail":"[email protected]company.com",

"senderName":"sys-admin",

"templates_directory" : "/resources/branding/emails",

"passwordRecoverySubject" : "Sisense password recovery",

"newUserInviteSubject" : "Sisense account activation",

"shareWithNewUserSubject" : "A Dashboard has been shared with you:",

"shareWithExistingUserSubject" : "A Dashboard has been shared with you:"

Error Status Codes

HTTP Status CodeReason
400Invalid input
403forbidden

/settings

GET /settings/system

Returns system configuration settings.

Response
{
  "_id": "ObjectId",
  "alias": "string",
  "email": {
    "enabled": "bool",
    "senderEmail": "string",
    "senderName": "string"
  }
}

Properties

PropertyDescription
_idThe ElastiCube server ID.
alias this is now 'name'.??? system
webserver missing from modelIndicates whether SSL is enabled. Anything else?
email

enabled - Indicates whether emails are enabled in the server.

senderEmail - The administrator's email address.

senderName - The administrator's name.

Error Status Codes

HTTP Status CodeReason
404name not found
403fobidden

POST /settings/system

Adds or updates system settings.

Parameters

ParameterValueDescriptionData Type
systemConfigMandatorysystem configuration
Model Schema
{
  "_id": "ObjectId",
  "alias": "string",
  "email": {
    "enabled": "bool",
    "senderEmail": "string",
    "senderName": "string"
  }
}

Properties

PropertyDescription
_idThe ElastiCube server to update.
alias???
email

 

enabled - Indicates whether emails are enabled in the server.

senderEmail - The administrator's email address.

senderName - The administrator's name.


Error Status Codes

HTTP Status CodeReason
400invalid input
403forbidden

GET /settings/proxy

Returns proxy server settings in your server. This is to allow geo data (used in area and scatter map widgets) to be pulled in from external Sisense servers. 

Response
{
  "enabled": "bool",
  "ip": "string",
  "port": "int",
  "username": "string",
  "password": "string"
}

Properties

PropertyDescription
enabledIndicates whether proxy settings are enabled.
ipThe IP address of the proxy.
portThe port number of the proxy.
username

The username of the proxy.

passwordThe password required for the proxy.

POST /settings/proxy

Adds proxy server settings to your server. 

This option can be used to allow geo data (used in area and scatter map widgets), to be pulled in from external Sisense servers when such data is blocked by your organization’s proxy server.

Parameters

ParameterValueDescriptionData Type
proxyConfigMandatory

Add the following parameters:

enabled - true or false

ip - Sisense server address

port - Sisense server port

username and password - only if your proxy server requires

Model Schema
{
  "enabled": "bool",
  "ip": "string",
  "port": "int",
  "username": "string",
  "password": "string"
}

Properties

PropertyDescription
enabledIndicates whether proxy settings are enabled.
ipThe IP address of the proxy.
portThe port number of the proxy.
username

The username of the proxy.

passwordThe password of the proxy.

Error Status Codes

HTTP Status CodeReason
403forbidden
400invalid proxy

PUT /settings/proxy

Updates proxy server settings in your server. This option can be used to allow geo data (used in area and scatter map widgets), to be pulled in from external Sisense servers when such data is blocked by your organization’s proxy server.

Parameters

ParameterValueDescriptionData Type
proxyConfigMandatory

Update only the relevant settings:

enabled - true or false

ip - Sisense server address

port - Sisense server port

username and password - only if your proxy server requires

Model Schema
{
  "enabled": "bool",
  "ip": "string",
  "port": "int",
  "username": "string",
  "password": "string"
}

Properties

PropertyDescription
enabledIndicates whether proxy settings are enabled.
ipThe IP address of the proxy.
portThe port number of the proxy.
username

The username of the proxy.

passwordThe password of the proxy.


Error Status Codes

HTTP Status CodeReason
403forbidden
400invalid proxy

DELETE /settings/proxy

Deletes proxy server settings in your server.

GET /settings/security

Returns security settings. What level (cube/server/?)

Response
{
  "_id": "objectId",
  "name": "string",
  "allowAddServers": bool
}

Properties

PropertyDescription
_id???
name???
allowAddServers???

Error Status Codes

HTTP Status Code
Reason
404name not found
403forbidden

POST /settings/security

Adds/updates security settings. 

Parameters

ParameterValueDescriptionData Type
securityConfigMandatorySecurity configuration
Model Schema
{
  "_id": "ObjectId",
  "cookieExp": "int",
  "passwordRegex": "string"
}

Properties

PropertyDescription
_id???
cookieExpThe cookie expiration in days for the user's login.
passwordRegexThe password regulations.

Error Status Codes

HTTP Status CodeReason
400invalid input
403forbidden

GET /settings/globalization

Returns locale settings, including the set locale, and whether autodetect is enabled.

check types

Response
{
  "_id": "objectId",
  "name": "string",
  "localization": {
    "default": "string",
    "autoDetectEnabled": bool
  }
}

Properties

PropertyDescription
_id???
name???
localization

default - the locale, for example en-US

autoDetectEnabled - If true, then the locale will inherit the user's set locale from the browser/operating system.

POST /settings/globalization

Adds/updates globalization settings. You can change the locale or select whether the localization selection is automatically detected or not.

Parameters

ParameterValueDescriptionData Type
globalizationConfigMandatoryThe globalization configuration to edit
Model Schema
{
  "localization": {
    "default": "string",
    "autoDetectEnabled": "bool"
  }
}

Properties

PropertyDescription

default

The default locale for all users.
autoDetectEnabledIf true, then the locale will inherit the user's set locale from the browser/operating system.


Error Status Codes

HTTP Status CodeReason
403forbidden

/reporting

POST /reporting

Sends a report for an asset of type 'dashboard'. What's in the report??? didn't work

Parameters

ParameterValueDescriptionData Type
sendReportsMandatoryreporting object describing the report you want
Model Schema
{
  "assetId": "string",
  "assetType": "string",
  "recipients": [
    {
      "type": "string",
      "recipient": "string"
    }
  ]
}

Properties

PropertyDescription
assetId???
assetType???
recipients

type - ???

recipient - ???




Error Status Codes

HTTP Status CodeReason
400invalid input
403forbidden

/roles

 GET /roles

Returns all the role types and the enabled permissions per role type.

Parameters

ParameterValueDescriptionData Type
includeManifest Includes the role's manifest (list of permissions showing what's enabled/disabled).boolean
includeBaseRolesName Includes the role's base role name.boolean
compiledRoles Select True.boolean
envelop Is not in model - what does this do?boolean
Response
[
  {
    "name": "string",
    "parent": "roleIdOrName",
    "desc": "string",
    "manifest": "{}"
  }
]

Properties

PropertyDescription
nameThe name of the role.
parentDidn't see this
desc???
manifestThe list of permissions and their status (enabled or disabled for role).

Error Status Codes

HTTP Status CodeReason
403forbidden

GET /roles/{idOrName}

Returns the user role by role ID or role name.

Parameters

ParameterValueDescriptionData Type
idOrNameMandatoryThe name or ID of the rolestring
compiledRole Returns compiled role ??? with inherited parent rolesboolean
Response
{
  "name": "string",
  "parent": "roleIdOrName",
  "desc": "string",
  "manifest": "{}"
}

Properties

PropertyDescription
nameThe name of the role.
parentDidn't see this
desc???
manifestThe list of permissions and their status (enabled or disabled for role).

Error Status Codes

HTTP Status CodeReason
400invalid idOrName
404idOrName not found
403forbidden

POST /roles

Relevant for documentation or still not applicable?

DELETE /roles/{idOrName}

Deletes a user role by ID or name. Limitations regarding defaults? super/admin/consumer/contributor

Parameters

Parameter
Value
Description
Data Type
idOrNameMandatoryThe ID or name of the role that you want to delete.

string

 Error Status Codes

HTTP Status Code
Reason
400invalid idOrName
404idOrName not found
403forbidden

PUT /roles/{idOrName}

Updates a user role by role ID or name.

Parameters

 

ParameterValueDescriptionData Type
idOrNameMandatoryThe ID or name of the role.

string

roleMandatory

The updated role object should include the path to the setting you want to change and the setting. Click here to see the correct paths for different settings in the manifest.

Example:

Model Schema
{
  "name": "string",
  "parent": "roleIdOrName",
  "desc": "string",
  "manifest": "{}"
}

Properties

PropertyDescription
nameThe name of the role.
parentThe parent role.
desc???
manifestAn array with the permissions of the role.

 

Error Status Codes

HTTP Status CodeReason
400invalid idOrName
404idOrName not found
403forbidden

GET /roles/{idOrName}/manifest/{path}

Returns the permissions of a user role under a specific path in the role manifest. 

Parameter
Value
Description
Data Type
idOrNameMandatoryThe role ID or name.

string

pathMandatory

The manifest path. Click here to see paths for the different settings.

For example, /dashboards/filters will return all permissions under filters.

string
compiledRole return compiled role ???boolean

Error Status Codes

HTTP Status Code
Reason
400invalid ID or name
404ID or name not found
403forbidden

DELETE /roles/{idOrName}/manifest/{path}

Restores some or all permissions under a specific path in the role manifest. You can restore a specific permission or all permissions depending on the path.

Parameter
Value
Description
Data Type
idOrNameMandatoryThe role ID or name

string

pathMandatoryThe path to the manifest. Enter the full path of the setting you want to change, as it appears in the hierarchy. Example: dashboard/filters/modify_type. See the reference table for more settings. Enter just a slash to restore all settings.string

Error Status Codes

HTTP Status Code
Reason
400invalid idOrName
404idOrName not found
403forbidden

 

PUT /roles/{idOrName}/manifest/{path}

Updates permissions in a user role manifest by role ID or name.

Parameter
Value
Description
Data Type
idOrNameMandatoryThe role ID or name.

string

pathMandatoryThe path to the manifest. Enter the path to the setting that you want to change as it appears in the hierarchy. Do not include the setting in the path. Example: To change the ‘Create’ setting for dashboard filters, enter dashboard/filters/. For creating dashboards, enter /dashboards. See the reference table above for more settings. For a complete list of settings and their relative path, click here.string
manifestMandatoryDefines whether to enable or disable the setting. For example, to enable ‘create’, type in: {create: true}.manifest

Error Status Codes

HTTP Status Code
Reason
400invalid idOrName
404idOrName not found
403forbidden

POST /roles/{idOrName}/manifest/{path}

Updates a user role manifest by role ID or name. New manifest keys will be added, overriding the existing keys (permissions). If you update only some keys, the other keys will be reset to their default settings.

Parameters

Parameter
Value
Description
Data Type
idOrNameMandatoryThe role ID or name

string

pathMandatoryThe path to the manifest. Enter the path to the setting that you want to change as it appears in the hierarchy. Do not include the setting in the path. Example: To change the ‘Create’ setting for dashboard filters, enter dashboard/filters/. For creating dashboards, enter /dashboards. See the reference table above for more settings.string
manifestMandatoryThe updated manifest object. Defines whether to enable or disable the setting. For example, to enable ‘create’, type in: {create: true}manifest

Error Status Codes

HTTP Status Code
Reason
400invalid idOrName
404idOrName not found
403forbidden

/palettes

GET /palettes

Returns a list of available palettes in the Sisense web app.

check param types

Response
[
  {
    "_id": "objectId",
    "colors": [],
    "name": "string",
    "isDefault": bool,
    "sortOrder": int,
    "isSystem": bool
  },
 ]

Properties

PropertyDescription
_idThe unique Id of the palette
colorsA list of colors used in the palette.
nameThe name of the palette.
isDefaultIndicates whether the palette is the default palette.
sortOrder???
isSystem???

Error Status Codes 

HTTP Status Code
Reason
403forbidden

GET /palettes/default

Returns the default color palette.

check param types

Response
{
  "_id": "objectId",
  "colors": [],
  "name": "string",
  "isDefault": bool,
  "sortOrder": int,
  "isSystem": bool,
  "systemDefault": bool
}

Properties

PropertyDescription
_idThe unique Id of the palette
colorsA list of colors used in the palette.
nameThe name of the palette.
isDefaultIndicates whether the palette is the default palette.
sortOrder???
isSystem???
systemDefault???

POST /palettes

Adds a new color palette. The new palette will include colors, and its sort order in the palette drop-down list in the Sisense web app. You can also define whether the new palette will be the default palette.

Parameters

ParameterValueDescriptionData Type
paletteMandatory The new palette to add, and it's colors, sort order, and default option.
Model Schema
{
  "colors": [
    "string"
  ],
  "min": "string",
  "max": "string",
  "name": "string",
  "isDefault": "bool",
  "sortOrder": "number"
}

Properties

PropertyDescription
colors

An array that includes the colors (hexadecimal) in the palette.

Example:

"colors": [
"#779fa8",
"#bf1e1d",
"#787070"
],

 min ???
max  ???
isDefaultSelect true to make this the default palette.
sortOrderThe palette's placement in the drop-down list of palettes.

Error Status Codes

HTTP Status CodeReason
403forbidden

PUT /palettes/{name}

Updates the dashboard's color palette.

Parameters

ParameterValueDescriptionData Type
nameMandatory Palette's namestring
paletteMandatory The updated palette settings to add
Model Schema
{
  "colors": [
    "string"
  ],
  "min": "string",
  "max": "string",
  "name": "string",
  "isDefault": "bool",
  "sortOrder": "number"
}

Properties

PropertyDescription
colors

The array that includes the colors (hexadecimal) in the palette.

Example:

"colors": [
"#779fa8",
"#bf1e1d",
"#787070"
],

min???
max???
nameThe name of the palette
sort OrderThe palette's placement in the drop-down list of palettes.

Error Status Codes

HTTP Status CodeReason
403forbidden

DELETE /palettes/{name}

Deletes a color palette from the color palettes.

Parameters

Parameter
Value
Description
Data Type
nameMandatory Palette's namestring

Error Status Codes

HTTP Status Code
Reason
403forbidden

 

Search the API

  • No labels