Excel-like Tables for Jira – Simplified REST API Response and Data Structure

This API returns the full spreadsheet data stored on a Jira issue in a structured JSON format.

Top-Level Structure

{
  "version": "17.0.4",
  "sheetCount": 1,
  "sheets": { ... }
}

• sheetCount indicates how many sheets are present

• sheets contains the spreadsheet data

Accessing Cell Data

"data": {
  "dataTable": {
    "0": {
      "0": { "value": "ID" },
      "1": { "value": "Task" }
    },
    "1": {
      "0": { "value": 1 },
      "1": { "value": "Review request" }
    }
  }
}

Structure

• Row and column indexes are 0-based

• Indexes are returned as strings

• Only populated cells are included

dataTable → rowIndex → colIndex → value

Cell Object

{
  "value": "Review request"
}

• value contains the resolved cell value (string, number, or empty)

Comments (Optional)

"comments": [
  {
    "rowIndex": 4,
    "colIndex": 2,
    "text": "read-field Amount"
  }
]

Spreadsheet-style comments attached to specific cells.

Notes for Automation

• The API always returns the entire table

• Calculations are already resolved

• Scripts should safely handle missing rows or columns

• Most automation only needs sheets → Sheet1 → data → dataTable