Skip to main content

Search spreadsheets

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 as id to getSpreadsheet to list its sheets, and as spreadsheetId to addReportDatasheets.
  • 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. searchSpreadsheets matches query against it.
  • type (string, required): Which app the spreadsheet belongs to, and so which of your accounts Rollstack reads it with. GoogleSheet is a Google Sheets file, read with your Google account. MicrosoftExcel is 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 of GoogleSheet, 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.