Search spreadsheets
- 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
The Google Sheets and Excel files the user added in the app whose name holds any word of query, in any case, most words first, at most 50. Rollstack can't search the user's whole Google Drive or OneDrive: for another file, ask the user to add it in the app. Confirm the file with the user, then list its sheets with getSpreadsheet.
Requires the connections:read scope.
Operation ID: searchSpreadsheets.
Query parameters
query(string): Words to search for in names, separated by spaces: a dashboard, table, model or spreadsheet is returned when its name contains any of them, case-insensitively, a table's full name with its database and schema. If omitted, results aren't filtered by name. At most 50 results are returned either way. Example:revenue.
Response 200
Success
application/json: array of object
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.