cancel
Showing results for 
Search instead for 
Did you mean: 

Row level data security using Rest API

rahuldhomane
8 - Cloud Apps
8 - Cloud Apps

I want to fix row level data security using REST API for all the elastic cubes I would be creating. Can someone help me with the exact parameters and REST API request that I need to use?

3 REPLIES 3

irismaessen
9 - Travel Pro
9 - Travel Pro

If you are using elasticubes, the API request is {baseurl}/api/elasticubes/datasecurity to set data security on multiple cubes, or {baseurl}/api/elasticubes/{server}/{elasticube}/datasecurity for a single cube.

I would check the REST API documentation within your Sisense instance for an example of what the request should look like. To find the above, you should be looking in the the 0.9 version of the REST API.

I am getting the following error message with the below post request:

----Error---
 
"status": "error",
 
"message": "[object Object]"
}

 

--------Request------

[
 {
    "column": "CLIENT_ID",
    "shares": [
      {
 "party": "rahul.dhomane",      
 "type": "user"
      }
    ],
    "table": "s01_a_n_se_ratig_y_clien.txt",
    "allMembers": null,
    "datatype": "text",
    "members": [
      "0653"
    ],
    "exclusionary": false
  }
]

I've only ever personally used these APIs with the ids of groups as values for "party". Perhaps you need the id of the user instead of the name?