Last active
March 7, 2018 00:36
-
-
Save jennybc/58b394fb0a1eda5c76403a70be6ee08e to your computer and use it in GitHub Desktop.
spreadsheets vs spreadsheets.values for first 3 rows of https://docs.google.com/spreadsheets/d/1BzfL0kZUz1TsI5zxJF1WNF01IxvC67FbOJUiiGMZ_mQ/edit#gid=1150108545
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| curl 'https://sheets.googleapis.com/v4/spreadsheets/1BzfL0kZUz1TsI5zxJF1WNF01IxvC67FbOJUiiGMZ_mQ?includeGridData=true&ranges=Africa!A1%3AF3&key=AIzaSyDXicV6oK4vR948PUAvlyr7QhkNwCoQ0cA' -H 'Accept: application/json' --compressed > spreadsheets_get.json | |
| curl 'https://sheets.googleapis.com/v4/spreadsheets/1BzfL0kZUz1TsI5zxJF1WNF01IxvC67FbOJUiiGMZ_mQ/values/Africa!A1%3AF3?key=AIzaSyDXicV6oK4vR948PUAvlyr7QhkNwCoQ0cA' -H 'Accept: application/json' --compressed > spreadsheets_values_get.json |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "spreadsheetId": "1BzfL0kZUz1TsI5zxJF1WNF01IxvC67FbOJUiiGMZ_mQ", | |
| "properties": { | |
| "title": "test-gs-gapminder", | |
| "locale": "en_US", | |
| "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 | |
| } | |
| } | |
| }, | |
| "sheets": [ | |
| { | |
| "properties": { | |
| "sheetId": 1150108545, | |
| "title": "Africa", | |
| "index": 0, | |
| "sheetType": "GRID", | |
| "gridProperties": { | |
| "rowCount": 625, | |
| "columnCount": 6 | |
| } | |
| }, | |
| "data": [ | |
| { | |
| "rowData": [ | |
| { | |
| "values": [ | |
| { | |
| "userEnteredValue": { | |
| "stringValue": "country" | |
| }, | |
| "effectiveValue": { | |
| "stringValue": "country" | |
| }, | |
| "formattedValue": "country", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "stringValue": "continent" | |
| }, | |
| "effectiveValue": { | |
| "stringValue": "continent" | |
| }, | |
| "formattedValue": "continent", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "stringValue": "year" | |
| }, | |
| "effectiveValue": { | |
| "stringValue": "year" | |
| }, | |
| "formattedValue": "year", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "stringValue": "lifeExp" | |
| }, | |
| "effectiveValue": { | |
| "stringValue": "lifeExp" | |
| }, | |
| "formattedValue": "lifeExp", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "stringValue": "pop" | |
| }, | |
| "effectiveValue": { | |
| "stringValue": "pop" | |
| }, | |
| "formattedValue": "pop", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "stringValue": "gdpPercap" | |
| }, | |
| "effectiveValue": { | |
| "stringValue": "gdpPercap" | |
| }, | |
| "formattedValue": "gdpPercap", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "values": [ | |
| { | |
| "userEnteredValue": { | |
| "stringValue": "Algeria" | |
| }, | |
| "effectiveValue": { | |
| "stringValue": "Algeria" | |
| }, | |
| "formattedValue": "Algeria", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "stringValue": "Africa" | |
| }, | |
| "effectiveValue": { | |
| "stringValue": "Africa" | |
| }, | |
| "formattedValue": "Africa", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "numberValue": 1952 | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 1952 | |
| }, | |
| "formattedValue": "1952", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "numberValue": 43.077 | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 43.077 | |
| }, | |
| "formattedValue": "43.077", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "numberValue": 9279525 | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 9279525 | |
| }, | |
| "formattedValue": "9279525", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "numberValue": 2449.0082 | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 2449.0082 | |
| }, | |
| "formattedValue": "2449.0082", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "values": [ | |
| { | |
| "userEnteredValue": { | |
| "stringValue": "Algeria" | |
| }, | |
| "effectiveValue": { | |
| "stringValue": "Algeria" | |
| }, | |
| "formattedValue": "Algeria", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "stringValue": "Africa" | |
| }, | |
| "effectiveValue": { | |
| "stringValue": "Africa" | |
| }, | |
| "formattedValue": "Africa", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "numberValue": 1957 | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 1957 | |
| }, | |
| "formattedValue": "1957", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "numberValue": 45.685 | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 45.685 | |
| }, | |
| "formattedValue": "45.685", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "numberValue": 10270856 | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 10270856 | |
| }, | |
| "formattedValue": "10270856", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "numberValue": 3013.976 | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 3013.976 | |
| }, | |
| "formattedValue": "3013.976", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| } | |
| ] | |
| } | |
| ], | |
| "rowMetadata": [ | |
| { | |
| "pixelSize": 21 | |
| }, | |
| { | |
| "pixelSize": 21 | |
| }, | |
| { | |
| "pixelSize": 21 | |
| } | |
| ], | |
| "columnMetadata": [ | |
| { | |
| "pixelSize": 100 | |
| }, | |
| { | |
| "pixelSize": 100 | |
| }, | |
| { | |
| "pixelSize": 100 | |
| }, | |
| { | |
| "pixelSize": 100 | |
| }, | |
| { | |
| "pixelSize": 100 | |
| }, | |
| { | |
| "pixelSize": 100 | |
| } | |
| ] | |
| } | |
| ] | |
| } | |
| ], | |
| "spreadsheetUrl": "https://docs.google.com/spreadsheets/d/1BzfL0kZUz1TsI5zxJF1WNF01IxvC67FbOJUiiGMZ_mQ/edit" | |
| } |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "range": "Africa!A1:F3", | |
| "majorDimension": "ROWS", | |
| "values": [ | |
| [ | |
| "country", | |
| "continent", | |
| "year", | |
| "lifeExp", | |
| "pop", | |
| "gdpPercap" | |
| ], | |
| [ | |
| "Algeria", | |
| "Africa", | |
| "1952", | |
| "43.077", | |
| "9279525", | |
| "2449.0082" | |
| ], | |
| [ | |
| "Algeria", | |
| "Africa", | |
| "1957", | |
| "45.685", | |
| "10270856", | |
| "3013.976" | |
| ] | |
| ] | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment