4 files changed, 185 insertions, 0 deletions
diff --git a/tap_google_sheets/schemas/file_metadata.json b/tap_google_sheets/schemas/file_metadata.json
new file mode 100644
index 0000000..25c19c4
--- /dev/null
+++ b/tap_google_sheets/schemas/file_metadata.json
@@ -0,0 +1,44 @@
+{
+  "type": "object",
+  "additionalProperties": false,
+  "properties": {
+    "id": {
+      "type": ["null", "string"]
+    },
+    "name": {
+      "type": ["null", "string"]
+    },
+    "version": {
+      "type": ["null", "integer"]
+    },
+    "createdTime": {
+      "type": ["null", "string"],
+      "format": "date-time"
+    },
+    "modifiedTime": {
+      "type": ["null", "string"],
+      "format": "date-time"
+    },
+    "teamDriveId": {
+      "type": ["null", "string"]
+    },
+    "driveId": {
+      "type": ["null", "string"]
+    },
+    "lastModifyingUser": {
+      "type": ["null", "object"],
+      "additionalProperties": false,
+      "properties": {
+        "kind": {
+          "type": ["null", "integer"]
+        },
+        "displayName": {
+          "type": ["null", "string"]
+        },
+        "emailAdress": {
+          "type": ["null", "string"]
+        }
+      }
+    }
+  }
+}
diff --git a/tap_google_sheets/schemas/sheet_metadata.json b/tap_google_sheets/schemas/sheet_metadata.json
new file mode 100644
index 0000000..c3f2ac2
--- /dev/null
+++ b/tap_google_sheets/schemas/sheet_metadata.json
@@ -0,0 +1,89 @@
+{
+  "type": "object",
+  "additionalProperties": false,
+  "properties": {
+    "spreadsheetId": {
+      "type": ["null", "string"]
+    },
+    "sheetId": {
+      "type": ["null", "integer"]
+    },
+    "title": {
+      "type": ["null", "string"]
+    },
+    "index": {
+      "type": ["null", "integer"]
+    },
+    "sheetType": {
+      "type": ["null", "string"]
+    },
+    "sheetUrl": {
+      "type": ["null", "string"]
+    },
+    "gridProperties": {
+      "type": ["null", "object"],
+      "additionalProperties": false,
+      "properties": {
+        "rowCount": {
+          "type": ["null", "integer"]
+        },
+        "columnCount": {
+          "type": ["null", "integer"]
+        },
+        "frozenRowCount": {
+          "type": ["null", "integer"]
+        },
+        "frozenColumnCount": {
+          "type": ["null", "integer"]
+        }
+      }
+    },
+    "columns": {
+      "anyOf": [
+        {
+          "type": "array",
+          "items": {
+            "type": ["null", "object"],
+            "additionalProperties": false,
+            "properties": {
+              "columnIndex": {
+                "type": ["null", "integer"]
+              },
+              "columnLetter": {
+                "type": ["null", "string"]
+              },
+              "columnName": {
+                "type": ["null", "string"]
+              },
+              "columnType": {
+                "type": ["null", "string"]
+              },
+              "columnSkipped": {
+                "type": ["null", "boolean"]
+              },
+              "type": {
+                "anyOf": [
+                  {
+                    "type": "array",
+                    "items": {
+                      "type": "string"
+                    }
+                  },
+                  {
+                    "type": "null"
+                  }
+                ]
+              },
+              "format": {
+                "type": ["null", "string"]
+              }
+            }
+          }
+        },
+        {
+          "type": "null"
+        }
+      ]
+    }
+  }
+}
diff --git a/tap_google_sheets/schemas/sheets_loaded.json b/tap_google_sheets/schemas/sheets_loaded.json
new file mode 100644
index 0000000..12f967a
--- /dev/null
+++ b/tap_google_sheets/schemas/sheets_loaded.json
@@ -0,0 +1,22 @@
+{
+  "type": "object",
+  "additionalProperties": false,
+  "properties": {
+    "spreadsheetId": {
+      "type": ["null", "string"]
+    },
+    "sheetId": {
+      "type": ["null", "integer"]
+    },
+    "sheetTitle": {
+      "type": ["null", "string"]
+    },
+    "loadDate": {
+      "type": ["null", "string"],
+      "format": "date-time"
+    },
+    "lastRowNumber": {
+      "type": ["null", "integer"]
+    }
+  }
+}
diff --git a/tap_google_sheets/schemas/spreadsheet_metadata.json b/tap_google_sheets/schemas/spreadsheet_metadata.json
new file mode 100644
index 0000000..852cb76
--- /dev/null
+++ b/tap_google_sheets/schemas/spreadsheet_metadata.json
@@ -0,0 +1,30 @@
+{
+  "type": "object",
+  "additionalProperties": false,
+  "properties": {
+    "spreadsheetId": {
+      "type": ["null", "string"]
+    },
+    "properties": {
+      "type": ["null", "object"],
+      "additionalProperties": false,
+      "properties": {
+        "title": {
+          "type": ["null", "string"]
+        },
+        "locale": {
+          "type": ["null", "string"]
+        },
+        "autoRecalc": {
+          "type": ["null", "string"]
+        },
+        "timeZone": {
+          "type": ["null", "string"]
+        }
+      }
+    },
+    "spreadsheetUrl": {
+      "type": ["null", "string"]
+    }
+  }
+}

diff --git a/tap_google_sheets/schemas/file_metadata.json b/tap_google_sheets/schemas/file_metadata.json new file mode 100644 index 0000000..25c19c4 --- /dev/null +++ b/tap_google_sheets/schemas/file_metadata.json
@@ -0,0 +1,44 @@
	1	{
	2	"type": "object",
	3	"additionalProperties": false,
	4	"properties": {
	5	"id": {
	6	"type": ["null", "string"]
	7	},
	8	"name": {
	9	"type": ["null", "string"]
	10	},
	11	"version": {
	12	"type": ["null", "integer"]
	13	},
	14	"createdTime": {
	15	"type": ["null", "string"],
	16	"format": "date-time"
	17	},
	18	"modifiedTime": {
	19	"type": ["null", "string"],
	20	"format": "date-time"
	21	},
	22	"teamDriveId": {
	23	"type": ["null", "string"]
	24	},
	25	"driveId": {
	26	"type": ["null", "string"]
	27	},
	28	"lastModifyingUser": {
	29	"type": ["null", "object"],
	30	"additionalProperties": false,
	31	"properties": {
	32	"kind": {
	33	"type": ["null", "integer"]
	34	},
	35	"displayName": {
	36	"type": ["null", "string"]
	37	},
	38	"emailAdress": {
	39	"type": ["null", "string"]
	40	}
	41	}
	42	}
	43	}
	44	}


diff --git a/tap_google_sheets/schemas/sheet_metadata.json b/tap_google_sheets/schemas/sheet_metadata.json new file mode 100644 index 0000000..c3f2ac2 --- /dev/null +++ b/tap_google_sheets/schemas/sheet_metadata.json
@@ -0,0 +1,89 @@
	1	{
	2	"type": "object",
	3	"additionalProperties": false,
	4	"properties": {
	5	"spreadsheetId": {
	6	"type": ["null", "string"]
	7	},
	8	"sheetId": {
	9	"type": ["null", "integer"]
	10	},
	11	"title": {
	12	"type": ["null", "string"]
	13	},
	14	"index": {
	15	"type": ["null", "integer"]
	16	},
	17	"sheetType": {
	18	"type": ["null", "string"]
	19	},
	20	"sheetUrl": {
	21	"type": ["null", "string"]
	22	},
	23	"gridProperties": {
	24	"type": ["null", "object"],
	25	"additionalProperties": false,
	26	"properties": {
	27	"rowCount": {
	28	"type": ["null", "integer"]
	29	},
	30	"columnCount": {
	31	"type": ["null", "integer"]
	32	},
	33	"frozenRowCount": {
	34	"type": ["null", "integer"]
	35	},
	36	"frozenColumnCount": {
	37	"type": ["null", "integer"]
	38	}
	39	}
	40	},
	41	"columns": {
	42	"anyOf": [
	43	{
	44	"type": "array",
	45	"items": {
	46	"type": ["null", "object"],
	47	"additionalProperties": false,
	48	"properties": {
	49	"columnIndex": {
	50	"type": ["null", "integer"]
	51	},
	52	"columnLetter": {
	53	"type": ["null", "string"]
	54	},
	55	"columnName": {
	56	"type": ["null", "string"]
	57	},
	58	"columnType": {
	59	"type": ["null", "string"]
	60	},
	61	"columnSkipped": {
	62	"type": ["null", "boolean"]
	63	},
	64	"type": {
	65	"anyOf": [
	66	{
	67	"type": "array",
	68	"items": {
	69	"type": "string"
	70	}
	71	},
	72	{
	73	"type": "null"
	74	}
	75	]
	76	},
	77	"format": {
	78	"type": ["null", "string"]
	79	}
	80	}
	81	}
	82	},
	83	{
	84	"type": "null"
	85	}
	86	]
	87	}
	88	}
	89	}


diff --git a/tap_google_sheets/schemas/sheets_loaded.json b/tap_google_sheets/schemas/sheets_loaded.json new file mode 100644 index 0000000..12f967a --- /dev/null +++ b/tap_google_sheets/schemas/sheets_loaded.json
@@ -0,0 +1,22 @@
	1	{
	2	"type": "object",
	3	"additionalProperties": false,
	4	"properties": {
	5	"spreadsheetId": {
	6	"type": ["null", "string"]
	7	},
	8	"sheetId": {
	9	"type": ["null", "integer"]
	10	},
	11	"sheetTitle": {
	12	"type": ["null", "string"]
	13	},
	14	"loadDate": {
	15	"type": ["null", "string"],
	16	"format": "date-time"
	17	},
	18	"lastRowNumber": {
	19	"type": ["null", "integer"]
	20	}
	21	}
	22	}


diff --git a/tap_google_sheets/schemas/spreadsheet_metadata.json b/tap_google_sheets/schemas/spreadsheet_metadata.json new file mode 100644 index 0000000..852cb76 --- /dev/null +++ b/tap_google_sheets/schemas/spreadsheet_metadata.json
@@ -0,0 +1,30 @@
	1	{
	2	"type": "object",
	3	"additionalProperties": false,
	4	"properties": {
	5	"spreadsheetId": {
	6	"type": ["null", "string"]
	7	},
	8	"properties": {
	9	"type": ["null", "object"],
	10	"additionalProperties": false,
	11	"properties": {
	12	"title": {
	13	"type": ["null", "string"]
	14	},
	15	"locale": {
	16	"type": ["null", "string"]
	17	},
	18	"autoRecalc": {
	19	"type": ["null", "string"]
	20	},
	21	"timeZone": {
	22	"type": ["null", "string"]
	23	}
	24	}
	25	},
	26	"spreadsheetUrl": {
	27	"type": ["null", "string"]
	28	}
	29	}
	30	}