Set Cube Permission

Modified on Thu, 19 Jun at 3:56 PM

Description:

This API will set permission to the cube.

API Endpoint:

/ws/CubeManagementService

Method:

POST

Header:

Field	Value
SOAPAction	/ws/CubeManagementService.wsdl

Request:

XML Element	Type	Value
<wsse:Username>	String	Smarten username
<wsse:Password>	String	Smarten user password
<cub:cubeId>	String	Smarten cube id, you can access it from Smarten Menu – Data – Dataset
<cub:dataAccessPermissionId>	Integer	Data access permission Id
<cub:columnName>		Dataset Column Name
<cub:conditionalOperator>		Operator eg.=. >, < etc.
<cub:values>		Data value
<cub:roleName>		Role Name
<cub:userName>		Username

Request Example:

<soapenv:Envelope xmlns:cub="http://www.elegantjbi.com/ws/CubeManagement" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

<soapenv:Header>

<wsse:Security soapenv:mustUnderstand="1" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">

<wsse:UsernameToken wsu:Id="UsernameToken-3DEE6A556597661AFF16911485492661">

<wsse:Username>username</wsse:Username>

<wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">password</wsse:Password>

</wsse:UsernameToken>

</wsse:Security>

</soapenv:Header>

<soapenv:Body>

<cub:setCubeDataPermissionRequest>

<cub:cubeId>cubeId</cub:cubeId>

<cub:permissions>

<cub:dataAccessPermissionId>permissionId</cub:dataAccessPermissionId>

<cub:condition>

<cub:columnName>columnName</cub:columnName>

<cub:conditionalOperator>operator</cub:conditionalOperator>

<cub:values>values</cub:values>

</cub:condition>

<cub:roles>

<cub:roleName>rolename</cub:roleName>

<cub:read>true</cub:read>

</cub:roles>

<cub:users>

<cub:userName>userName</cub:userName>

<cub:read>true</cub:read>

</cub:users>

</cub:permissions>

</cub:setCubeDataPermissionRequest>

</soapenv:Body>

</soapenv:Envelope>

Response:

Return a response with SOAP XML as object.

XML Element	Type	Value
<ns2:statusCode>	String	Return the API status response

Response Example:

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">

<SOAP-ENV:Header>

<wsse:Security xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" SOAP-ENV:mustUnderstand="1">

<wsse:UsernameToken xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" wsu:Id="XWSSGID-1750054569219-704418677">

<wsse:Username>user</wsse:Username>

<wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordDigest">kWSnlq/f/vYvtwIom+vMBH5NyOk=</wsse:Password>

<wsse:Nonce EncodingType="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-soap-message-security-1.0#Base64Binary">6mK+k0qnzko1uhEzUHR35IDP</wsse:Nonce>

<wsu:Created>2025-06-19T07:47:49.921Z</wsu:Created>

</wsse:UsernameToken>

</wsse:Security>

</SOAP-ENV:Header>

<SOAP-ENV:Body>

<ns2:setCubeDataPermissionResponse xmlns:ns2="http://www.elegantjbi.com/ws/CubeManagement">

<ns2:status>

<ns2:statusCode>Success</ns2:statusCode>

</ns2:status>

</ns2:setCubeDataPermissionResponse>

</SOAP-ENV:Body>

</SOAP-ENV:Envelope>

Postman Example:

You can import the example below into Postman.

curl --location 'http://<SMARTENURL>/smarten/ws/CubeManagementService?=null' \

--header 'Content-Type: text/xml' \

--data '<soapenv:Envelope xmlns:cub="http://www.elegantjbi.com/ws/CubeManagement" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

<soapenv:Header>

<wsse:UsernameToken wsu:Id="UsernameToken-3DEE6A556597661AFF16911485492661">

<wsse:Username>bhavika</wsse:Username>

<wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">bhavika</wsse:Password>

</wsse:UsernameToken>

</wsse:Security>

</soapenv:Header>

<soapenv:Body>

<cub:setCubeDataPermissionRequest>

<cub:cubeId>cubeId</cub:cubeId>

<cub:permissions>

<cub:dataAccessPermissionId>0</cub:dataAccessPermissionId>

<cub:condition>

<cub:columnName>columnName</cub:columnName>

<cub:conditionalOperator>=</cub:conditionalOperator>

<cub:values>values</cub:values>

</cub:condition>

<cub:roles>

<cub:roleName>roleName</cub:roleName>

<cub:read>true</cub:read>

</cub:roles>

<cub:users>

<cub:userName>username</cub:userName>

<cub:read>true</cub:read>

</cub:users>

</cub:permissions>

</cub:setCubeDataPermissionRequest>

</soapenv:Body>

</soapenv:Envelope>'

Attachments (1)

json

setCubePermi....json
472 Bytes