Get Cube Columns

Modified on Thu, 19 Jun at 3:39 PM

Description:

This API is used to get cube column(s)

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

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-BF9969C51E2151A93716908939463183">

<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:getCubeColumnsRequest>

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

</cub:getCubeColumnsRequest>

</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
<ns2:dimensions>	String	Dimension column names
<ns2:measures>	String	Measure column names

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">6yyuY9qhtJng42JIkJBm8DqTtRY=</wsse:Password>

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

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

</wsse:UsernameToken>

</wsse:Security>

</SOAP-ENV:Header>

<SOAP-ENV:Body>

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

<ns2:status>

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

</ns2:status>

<ns2:cubeId>cubeId</ns2:cubeId>

<ns2:Dimensions>ProductCategory</ns2:Dimensions>

<ns2:Dimensions>State</ns2:Dimensions>

<ns2:Measures>GrossSales</ns2:Measures>

</ns2:getCubeColumnsResponse>

</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-raw '<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-BF9969C51E2151A93716908939463183">

<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:getCubeColumnsRequest>

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

</cub:getCubeColumnsRequest>

</soapenv:Body>

</soapenv:Envelope>'

Attachments (1)

json

getCubeColum....json
2.46 KB