aboutsummaryrefslogtreecommitdiffhomepage
diff options
context:
space:
mode:
authorJeff Huth <jeff.huth@bytecode.io>2019-11-13 17:12:54 -0800
committerJeff Huth <jeff.huth@bytecode.io>2019-11-13 17:12:54 -0800
commit66bc495f76684fc0de611643e7c464bd46203125 (patch)
treebcce43e347fb451c58ed2095bd2d3a424b6ea3a9
parent89643ba6fa98db82efd3246805ef801a8bfb5c81 (diff)
downloadtap-google-sheets-66bc495f76684fc0de611643e7c464bd46203125.tar.gz
tap-google-sheets-66bc495f76684fc0de611643e7c464bd46203125.tar.zst
tap-google-sheets-66bc495f76684fc0de611643e7c464bd46203125.zip
Update streams.py and README
Update streams.py and README
-rw-r--r--README.md7
-rw-r--r--state.json.example4
-rw-r--r--tap_google_sheets/streams.py3
3 files changed, 7 insertions, 7 deletions
diff --git a/README.md b/README.md
index 6fcb0b9..5752b64 100644
--- a/README.md
+++ b/README.md
@@ -8,8 +8,8 @@ This tap:
8 8
9- Pulls raw data from the [Google Sheets v4 API](https://developers.google.com/sheets/api) 9- Pulls raw data from the [Google Sheets v4 API](https://developers.google.com/sheets/api)
10- Extracts the following endpoints: 10- Extracts the following endpoints:
11 - [Spreadsheet File](https://developers.google.com/drive/api/v3/reference/files/get) 11 - [File Metadata](https://developers.google.com/drive/api/v3/reference/files/get)
12 - [Spreadsheet Metadata, Sheets, Headers](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/get) 12 - [Spreadsheet Metadata](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/get)
13 - [Spreadsheet Values](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/get) 13 - [Spreadsheet Values](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/get)
14- For each Sheet: 14- For each Sheet:
15 - Outputs the schema for each resource (based on the column header and datatypes of first row of data) 15 - Outputs the schema for each resource (based on the column header and datatypes of first row of data)
@@ -114,8 +114,7 @@ The [**Google Sheets Setup & Authentication**](https://drive.google.com/open?id=
114 { 114 {
115 "currently_syncing": "file_metadata", 115 "currently_syncing": "file_metadata",
116 "bookmarks": { 116 "bookmarks": {
117 "file_metadata": "2019-09-27T22:34:39.000000Z", 117 "file_metadata": "2019-09-27T22:34:39.000000Z"
118 "sheets_loaded": "2019-09-27T21:55:42.000000Z"
119 } 118 }
120 } 119 }
121 ``` 120 ```
diff --git a/state.json.example b/state.json.example
index c33cc8f..a5ccda7 100644
--- a/state.json.example
+++ b/state.json.example
@@ -1,6 +1,6 @@
1{ 1{
2 "currently_syncing": "spreadsheets", 2 "currently_syncing": "file_metadata",
3 "bookmarks": { 3 "bookmarks": {
4 "file": "2019-09-27T22:34:39.000000Z" 4 "file_metadata": "2019-09-27T22:34:39.000000Z"
5 } 5 }
6} 6}
diff --git a/tap_google_sheets/streams.py b/tap_google_sheets/streams.py
index 299326a..231a41d 100644
--- a/tap_google_sheets/streams.py
+++ b/tap_google_sheets/streams.py
@@ -18,7 +18,8 @@ FILE_METADATA = {
18 "api": "files", 18 "api": "files",
19 "path": "files/{spreadsheet_id}", 19 "path": "files/{spreadsheet_id}",
20 "key_properties": ["id"], 20 "key_properties": ["id"],
21 "replication_method": "FULL_TABLE", 21 "replication_method": "INCREMENTAL",
22 "replication_keys": ["modifiedTime"],
22 "params": { 23 "params": {
23 "fields": "id,name,createdTime,modifiedTime,version,teamDriveId,driveId,lastModifyingUser" 24 "fields": "id,name,createdTime,modifiedTime,version,teamDriveId,driveId,lastModifyingUser"
24 } 25 }