diff options
author | Jeff Huth <jeff.huth@bytecode.io> | 2019-11-13 17:12:54 -0800 |
---|---|---|
committer | Jeff Huth <jeff.huth@bytecode.io> | 2019-11-13 17:12:54 -0800 |
commit | 66bc495f76684fc0de611643e7c464bd46203125 (patch) | |
tree | bcce43e347fb451c58ed2095bd2d3a424b6ea3a9 | |
parent | 89643ba6fa98db82efd3246805ef801a8bfb5c81 (diff) | |
download | tap-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.md | 7 | ||||
-rw-r--r-- | state.json.example | 4 | ||||
-rw-r--r-- | tap_google_sheets/streams.py | 3 |
3 files changed, 7 insertions, 7 deletions
@@ -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 | } |