Resources
/rest/idalko-igrid/1.0/grid/
Methods
Obtain Grid Datasource Info GET /rest/idalko-igrid/1.0/grid/{gridId}/datasource
Returns the datasource table name and the connection URL for the specified table grid
template parameters
| parameter | value | required | description |
|---|---|---|---|
| gridId | long | + | id of the TGR customfield |
available response representations:
200 (success) - application/json. Response example:
| Code Block |
|---|
{
"databaseTableName":"cwd_user",
"connectionUrl":"jdbc:h2:file:/Users/strygul/tableGrid/tgrid/target/jira/home/database/h2db"
} |
403 (forbidden). Returned if:
- the user has no permissions to get this info
- 400 (bad request). Returned if:
- the specified customfield id exists but it is not a TGE customfield
- 404 (not found). Returned if:
- customfield with the specified id does not exist
- 401 (not authorised)
- 500 (server error)
Obtain Number of Rows GET /rest/idalko-igrid/1.0/grid/{gridId}[/issue/{issueId}]/rowcount
Returns the number of rows in the specified issue
template parameters
| parameter | value | required | description |
|---|---|---|---|
| gridId | long | + | id of the TGR customfield |
| issueId | long | - | id of the issue |
available response representations:
200 (success) - application/json. Response example:
| Code Block |
|---|
{
"rowCount": 12
} |
403 (forbidden). Returned if:
- the user has no permissions to view specified issue
- 400 (bad request). Returned if:
- the specified customfield id exists but it is not a TGR customfield
- 404 (not found). Returned if:
- customfield with the specified id does not exist
- issue with the specified id does not exist
- 401 (not authorised)
- 500 (server error)
Read Grid Data GET /rest/idalko-igrid/1.0/grid/{gridId}/issue/{issueId}/[row/{rowId}]?columns&startAt&maxResults
Returns grid data for the issue
template parameters
| parameter | value | required | description |
|---|---|---|---|
| gridId | long | + | id of the TGR customfield |
| issueId | long | + | id of the issue |
| rowId | long | - | id of the row in grid. Optional. If specified, only data for this row is returned. |
query parameters
| parameter | value | required | description |
|---|---|---|---|
| columns | string | - | coma-separated list of columns as configured in the grid definition. If omitted - all columns are returned |
| startAt | integer | - | startAt pagination parameter. See pagination |
| maxResults | integer | - | maxResults pagination parameter. See pagination |
available response representations:
200 (success) - application/json. Response example:
| No Format |
|---|
/rest/idalko-igrid/1.0/grid/10301/issue/11359 |
| Code Block |
|---|
{
"startAt":0,
"maxResults":10,
"total":3,
"values":[
{
"ugroup":"jira-administrators",
"username":"admin"
},
{
"ugroup":"jira-servicedesk-users",
"username":"admin"
},
{
"ugroup":"jira-software-users",
"username":"admin"
}
]
} |
if columns are specified it could be
| No Format |
|---|
/rest/idalko-igrid/1.0/grid/10301/issue/11359?columns=username |
| Code Block |
|---|
{
"startAt":0,
"maxResults":10,
"total":3,
"values":[
{
"username":"admin"
},
{
"username":"admin"
},
{
"username":"admin"
}
]
} |
403 (forbidden). Returned if:- the user has no permissions for the specified issue
- 400 (bad request). Returned if:
invalid custom field context, i.e this issue is not applicable to the context of the specified grid
the specified customfield id exists but it is not a TGR customfield
specified column name(s) does not exist
- 404 (not found). Returned if:
- the specified issueId doesn't exist
- TGR customfield with the specified id does not exist
- 401 (not authorised)
- 500 (server error)