social

Read Google Sheet values

Read cell values from a range in a connected Google spreadsheet. Pass the spreadsheetId and range query parameters to select the data. Access requires a dt token, issued by the preview-token endpoint or provided automatically to a screen. If the stored access is no longer valid, it is refreshed automatically, and the last known result is served if the spreadsheet cannot be reached.

Notes.

  • Feed envelope: stale (and staleSince) beside data. Answers are cached at the edge for a few minutes.
get/v1/social/google-sheets/{accountId}/values

Request

  • Base URL: https://api.brixsignage.com
  • URL: https://api.brixsignage.com/v1/social/google-sheets/{accountId}/values
  • Auth: none required

Path parameters

accountIdstring required

The connected account's id (from GET /v1/social-accounts).

Query parameters

dtstring required

The app data token.

spreadsheetIdstring required

The sheet's id or URL. Only a sheet picked for this account can be read.

rangestring required

A range in A1 notation (Sheet1!A1:D20).

Response

Success.

staleboolean required

True when the provider failed and this is the last good answer.

staleSincestring

When the stale copy was fetched (only when stale).

Changes

No recorded changes to this operation across all 1 revision of this API.