| home > API > [/cell/values] > |
| request url |
https://[SERVER]:[PORT]/cell/values[?PARAMETER1=value[&...]] |
| short description |
Shows the values of cube cells |
| long description |
|
| parameters |
| name |
type |
description |
| database |
identifier |
Identifier of the database |
| name_database |
string |
Name of the database. Used only if database parameter is omitted. |
| cube |
identifier |
Identifier of the cube |
| name_cube |
string |
Name of the cube. Used only if cube parameter is omitted. |
| paths |
path |
Colon separated list of paths. Each path is a comma separated list of element identifiers. |
| name_paths |
npath |
Colon separated list of paths. Each path is a comma separated list of element names. Used only if paths parameter is omitted. |
| show_rule |
boolean |
If 1, then additional information about the cell value is returned, in case the value originates from an enterprise rule. |
| show_lock_info |
boolean |
If 1, then additional information about the cell lock is returned. |
| properties |
identifier |
Comma separated list of cell property ids. |
| sid |
string |
Session identifier for a server connection. Use the /server/login request to get a valid session identifier. |
|
| result |
| # |
name |
type |
description |
| 0 |
type |
integer |
Type of the value (1=NUMERIC, 2=STRING, 99=ERROR) |
| 1 |
exists/error |
integer |
1 if value exists. In case of an error the error code. |
| 2 |
value |
double/string |
Value of the cell. In case of an error the error message |
| 3 |
rule |
identifier |
Identifier of the rule, this cell values originates from or empty. Only available if show_rule is 1. |
| 4 |
lock_info |
identifier |
Lock info (0 - cell is not locked, 1 - cell is locked by user wich sent request, 2 - cell is locked by another user). Only available if show_lock_info is 1. |
| 5 |
property_values |
double/string |
Values of specified cell properties. |
|
| examples |
| description |
| Show values of cells "0,0,0,0,0,0" and "1,0,0,0,0,0" |
| Show values of cells "0,2,0" and "1,2,0" including their system cell properties #_Rights(0), FormatString(1) and CellNote(2) |
|
| further information |
|