Get spreadsheet

Gets information about the spreadsheet by ID

Function GetSpreadsheet(Val Token, Val Identifier) Export

Parameter	CLI option	Type	Required	Description
Token	--token	String	✔	Token
Identifier	--spreadsheet	String	✔	Spreadsheet identifier

Returns: Map Of KeyAndValue - serialized JSON response from Google

1C:Enterprise/OneScript code example

    Token      = "ya29.a0AQQ_BDTgQbn9c5rXhPK3FCakms_7oKkdIWE1CCQFnSPftb2RxvloVqnYOcnsAKhXrD0Gq8Tz2Kgn5IBXG5E25uksZfvvTtXob-jFcuj_9LZYs9La4HrcFk766...";
    Identifier = "16uPAewX6jwjTdyVlE0O8adQngnoCMbUHQ5Ek36-IPaQ";

    Result = OPI_GoogleSheets.GetSpreadsheet(Token, Identifier);

Bash

    oint gsheets GetSpreadsheet \
     --token "***" \
     --spreadsheet "1B6z_e-dcUabYF4ZB0GyymzS_-Xzguwq7NPbLpFq0jdA"

CMD/Bat

    oint gsheets GetSpreadsheet ^
     --token "***" ^
     --spreadsheet "1B6z_e-dcUabYF4ZB0GyymzS_-Xzguwq7NPbLpFq0jdA"

Result

{
 "spreadsheetId": "1B6z_e-dcUabYF4ZB0GyymzS_-Xzguwq7NPbLpFq0jdA",
 "properties": {
  "title": "TestTable",
  "locale": "ru_RU",
  "autoRecalc": "ON_CHANGE",
  "timeZone": "Etc/GMT",
  "defaultFormat": {
   "backgroundColor": {
    "red": 1,
    "green": 1,
    "blue": 1
   },
   "padding": {
    "top": 2,
    "right": 3,
    "bottom": 2,
    "left": 3
   },
   "verticalAlignment": "BOTTOM",
   "wrapStrategy": "OVERFLOW_CELL",
   "textFormat": {
    "foregroundColor": {},
    "fontFamily": "arial,sans,sans-serif",
    "fontSize": 10,
    "bold": false,
    "italic": false,
    "strikethrough": false,
    "underline": false,
    "foregroundColorStyle": {
     "rgbColor": {}
    }
   },
   "backgroundColorStyle": {
    "rgbColor": {
     "red": 1,
     "green": 1,
     "blue": 1
    }
   }
  },
  "spreadsheetTheme": {
   "primaryFontFamily": "Arial",
   "themeColors": [
    {
     "colorType": "TEXT",
     "color": {
      "rgbColor": {}
     }
    },
    {
     "colorType": "BACKGROUND",
     "color": {
      "rgbColor": {
       "red": 1,
       "green": 1,
       "blue": 1
      }
     }
    },
    {
     "colorType": "ACCENT1",
     "color": {
      "rgbColor": {
       "red": 0.25882354,
       "green": 0.52156866,
       "blue": 0.95686275
      }
     }
    },
    {
     "colorType": "ACCENT2",
     "color": {
      "rgbColor": {
       "red": 0.91764706,
       "green": 0.2627451,
       "blue": 0.20784314
      }
     }
    },
    {
     "colorType": "ACCENT3",
     "color": {
      "rgbColor": {
       "red": 0.9843137,
       "green": 0.7372549,
       "blue": 0.015686275
      }
     }
    },
    {
     "colorType": "ACCENT4",
     "color": {
      "rgbColor": {
       "red": 0.20392157,
       "green": 0.65882355,
       "blue": 0.3254902
      }
     }
    },
    {
     "colorType": "ACCENT5",
     "color": {
      "rgbColor": {
       "red": 1,
       "green": 0.42745098,
       "blue": 0.003921569
      }
     }
    },
    {
     "colorType": "ACCENT6",
     "color": {
      "rgbColor": {
       "red": 0.27450982,
       "green": 0.7411765,
       "blue": 0.7764706
      }
     }
    },
    {
     "colorType": "LINK",
     "color": {
      "rgbColor": {
       "red": 0.06666667,
       "green": 0.33333334,
       "blue": 0.8
      }
     }
    }
   ]
  }
 },
 "sheets": [
  {
   "properties": {
    "sheetId": 1878797825,
    "title": "Sheet1",
    "index": 0,
    "sheetType": "GRID",
    "gridProperties": {
     "rowCount": 1000,
     "columnCount": 26
    }
   }
  },
  {
   "properties": {
    "sheetId": 1383026001,
    "title": "Sheet2",
...