Get spreadsheet
- OpenAPI 3.1.0 document: https://api.rollstack.com/public/v1/openapi.json
- The whole reference in Markdown: https://docs.rollstack.com/llms-full.txt
- An index of the reference: https://docs.rollstack.com/llms.txt
GET https://api.rollstack.com/public/v1/spreadsheets/{id}
A Google Sheets or Excel file the user added in the app, with its sheets, read with the user's own Google or Microsoft account. Fails with user-missing-oauth when the user hasn't connected that account in the app. Find the file's id with searchSpreadsheets, then add a range of one of its sheets to a report with addReportDatasheets by the sheet's id.
Requires the connections:read scope.
Operation ID: getSpreadsheet.
Path parameters
id(string, required): The spreadsheet whose sheets to list, by itsidfromsearchSpreadsheets. This is Rollstack's identifier, not the file's id in Google Drive, OneDrive or SharePoint. It must be one of your own spreadsheets in Rollstack: another member's spreadsheet returns404, as does an Excel file stored in Google Drive.
Response 200
Success
application/json
id(string, required): Unique identifier for the spreadsheet in Rollstack, not the file's id in Google Drive, OneDrive or SharePoint. Pass it asidtogetSpreadsheetto list its sheets, and asspreadsheetIdtoaddReportDatasheets.name(string, required): The spreadsheet's name, as it was when the file was added to Rollstack: renaming the file afterwards in Google Sheets or Excel doesn't change it here.searchSpreadsheetsmatchesqueryagainst it.type(string, required): Which app the spreadsheet belongs to, and so which of your accounts Rollstack reads it with.GoogleSheetis a Google Sheets file, read with your Google account.MicrosoftExcelis an Excel workbook in OneDrive or SharePoint, read with your Microsoft account. Excel files stored in Google Drive aren't available through the API. One ofGoogleSheet,MicrosoftExcel.url(string, required): Link that opens the spreadsheet in Google Sheets or in Excel for the web, for example to check it's the right file before you add it to a report.sheets(array of object, required): The sheets (tabs) in the spreadsheet as they are now in Google Sheets or Excel, hidden ones included. Pass a sheet'sidassheetIdtoaddReportDatasheetsto add a range of its cells to a report.id(string, required): Unique identifier for the sheet within the spreadsheet. Pass it assheetIdtoaddReportDatasheets, with the spreadsheet'sidasspreadsheetIdand the cells to read asrange. In Google Sheets, it is the number aftergid=in the sheet's URL.title(string, required): The sheet's name, as shown on its tab in Google Sheets or Excel.