Fri Feb 14 2020 05:30:05 GMT+0000 (Coordinated Universal Time)

Msg: Error - sendToBigQuery
Info: ["run: sendToBigQuery",{"data Id":"869cccc6-b928-4c81-8134-68b7054baa31"},{"method":"Insert"},{"res: insertToTable":"ok"},{"res: upsertTable":"ok"},"run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update","run: bigQueryJobs_update",{"run: upsertTable":1},{"run: upsertTable":"items"},"run: upsertTable",{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:20:30.478Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"2e59a92e-1803-42a1-a4e8-12718a299f78\",\"_createdDate\":\"2020-02-14T05:20:30.692Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:20:30.692Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:21.773Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"7f593dc2-1e5b-4fbb-a51b-4531c509c38f\",\"_createdDate\":\"2020-02-14T05:21:22.115Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:22.115Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"00279865-1675-4d11-9709-eff6e5e8bacb\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:35.119Z\",\"zohoId\":\"4280752000003233001\",\"_id\":\"27e8d0b7-7a4b-41b7-9c18-bcc5428d2c0e\",\"_createdDate\":\"2020-02-14T05:21:35.301Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:35.301Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Electric Scooter 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"1341687a-2628-4b0e-8a24-dd7db1835151\",\"item\":\"10d10795-01f1-4565-9d36-b31116a48d5e\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:22:14.827Z\",\"zohoId\":\"4280752000003233049\",\"_id\":\"e35e2ac7-cc2b-41d3-b724-123c3e75eab1\",\"_createdDate\":\"2020-02-14T05:22:15.002Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:22:15.002Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"4\",\"isOk\":true,\"title\":\"Electric Scooter 4\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"07d46afe-1e84-4685-87ec-b83dc77a20f7\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-01-16T19:19:20.868Z\",\"_id\":\"12ff8807-e0cc-4af4-b1d9-856ebbf211e6\",\"_createdDate\":\"2020-01-16T19:19:21.250Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:55.564Z\",\"total\":0,\"endTime\":\"2020-01-16T19:21:51.843Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"61925fbf-8c67-4130-9ae3-a1fee327a8db\",\"passPrice\":\"6\",\"isOk\":true,\"title\":\"Tool Box\",\"room\":\"8c460d4c-50f6-4f31-bf08-1f1323b8fb2c\",\"user\":\"8c779733-ca04-4f7b-8a25-497025e5548b\",\"item\":\"ceea5db7-2715-45f8-b69a-5173ceade7b1\",\"comments\":\"Sent to Zoho\"}]","updateId":"12ff8807-e0cc-4af4-b1d9-856ebbf211e6","_id":"d9f6f962-c7ca-4047-8964-1ffbfd1d29c8"}}},{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:20:30.478Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"2e59a92e-1803-42a1-a4e8-12718a299f78\",\"_createdDate\":\"2020-02-14T05:20:30.692Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:20:30.692Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:21.773Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"7f593dc2-1e5b-4fbb-a51b-4531c509c38f\",\"_createdDate\":\"2020-02-14T05:21:22.115Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:22.115Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"00279865-1675-4d11-9709-eff6e5e8bacb\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:35.119Z\",\"zohoId\":\"4280752000003233001\",\"_id\":\"27e8d0b7-7a4b-41b7-9c18-bcc5428d2c0e\",\"_createdDate\":\"2020-02-14T05:21:35.301Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:35.301Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Electric Scooter 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"1341687a-2628-4b0e-8a24-dd7db1835151\",\"item\":\"10d10795-01f1-4565-9d36-b31116a48d5e\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:22:14.827Z\",\"zohoId\":\"4280752000003233049\",\"_id\":\"e35e2ac7-cc2b-41d3-b724-123c3e75eab1\",\"_createdDate\":\"2020-02-14T05:22:15.002Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:22:15.002Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"4\",\"isOk\":true,\"title\":\"Electric Scooter 4\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"07d46afe-1e84-4685-87ec-b83dc77a20f7\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:20:30.478Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"2e59a92e-1803-42a1-a4e8-12718a299f78\",\"_createdDate\":\"2020-02-14T05:20:30.692Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:20:30.692Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\",\"comments\":\"Sent to Zoho\"}]","updateId":"2e59a92e-1803-42a1-a4e8-12718a299f78","_id":"d9f6f962-c7ca-4047-8964-1ffbfd1d29c8"}}},{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:20:30.478Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"2e59a92e-1803-42a1-a4e8-12718a299f78\",\"_createdDate\":\"2020-02-14T05:20:30.692Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:20:30.692Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:21.773Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"7f593dc2-1e5b-4fbb-a51b-4531c509c38f\",\"_createdDate\":\"2020-02-14T05:21:22.115Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:22.115Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"00279865-1675-4d11-9709-eff6e5e8bacb\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:35.119Z\",\"zohoId\":\"4280752000003233001\",\"_id\":\"27e8d0b7-7a4b-41b7-9c18-bcc5428d2c0e\",\"_createdDate\":\"2020-02-14T05:21:35.301Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:35.301Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Electric Scooter 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"1341687a-2628-4b0e-8a24-dd7db1835151\",\"item\":\"10d10795-01f1-4565-9d36-b31116a48d5e\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:22:14.827Z\",\"zohoId\":\"4280752000003233049\",\"_id\":\"e35e2ac7-cc2b-41d3-b724-123c3e75eab1\",\"_createdDate\":\"2020-02-14T05:22:15.002Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:22:15.002Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"4\",\"isOk\":true,\"title\":\"Electric Scooter 4\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"07d46afe-1e84-4685-87ec-b83dc77a20f7\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-01-16T15:51:10.698Z\",\"_id\":\"80ec1be8-4c56-4dd8-9677-245c12276a5a\",\"_createdDate\":\"2020-01-16T15:51:10.931Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:55.563Z\",\"total\":0,\"code\":\"2323\",\"endTime\":\"2020-01-16T15:54:32.510Z\",\"rating\":5,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e3f8a229-e0a3-46b6-a813-6282f442db81\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"ee935651-2f10-49ed-a6c0-2c68b15d4034\",\"item\":\"90768c64-3592-4d29-8b86-a7584feadda9\",\"comments\":\"Sent to Zoho\"}]","updateId":"80ec1be8-4c56-4dd8-9677-245c12276a5a","_id":"d9f6f962-c7ca-4047-8964-1ffbfd1d29c8"}}},{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:20:30.478Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"2e59a92e-1803-42a1-a4e8-12718a299f78\",\"_createdDate\":\"2020-02-14T05:20:30.692Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:20:30.692Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:21.773Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"7f593dc2-1e5b-4fbb-a51b-4531c509c38f\",\"_createdDate\":\"2020-02-14T05:21:22.115Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:22.115Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"00279865-1675-4d11-9709-eff6e5e8bacb\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:35.119Z\",\"zohoId\":\"4280752000003233001\",\"_id\":\"27e8d0b7-7a4b-41b7-9c18-bcc5428d2c0e\",\"_createdDate\":\"2020-02-14T05:21:35.301Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:35.301Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Electric Scooter 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"1341687a-2628-4b0e-8a24-dd7db1835151\",\"item\":\"10d10795-01f1-4565-9d36-b31116a48d5e\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:22:14.827Z\",\"zohoId\":\"4280752000003233049\",\"_id\":\"e35e2ac7-cc2b-41d3-b724-123c3e75eab1\",\"_createdDate\":\"2020-02-14T05:22:15.002Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:22:15.002Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"4\",\"isOk\":true,\"title\":\"Electric Scooter 4\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"07d46afe-1e84-4685-87ec-b83dc77a20f7\"},{\"serial\":\"Dryer\",\"isInRoom\":false,\"startTime\":\"2020-01-16T17:55:12.361Z\",\"_id\":\"13bc20cf-3b41-4771-a7fc-f50c9f1a8e58\",\"_owner\":\"b1bbcec5-b080-44f0-8851-207337a19672\",\"_createdDate\":\"2020-01-16T17:55:14.600Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:40:55.563Z\",\"total\":10,\"code\":\"00689\",\"endTime\":\"2020-01-16T19:29:03.655Z\",\"rating\":5,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"c70cd8f1-1f75-443d-94ee-e7295edc4462\",\"passPrice\":\"10\",\"isOk\":true,\"title\":\"Dryer\",\"room\":\"b5939981-689b-4437-abdb-96171d7f303b\",\"user\":\"b1bbcec5-b080-44f0-8851-207337a19672\",\"item\":\"cc467f8d-f8d0-4552-8bf7-f81e93f149e0\",\"comments\":\"Sent to Zoho\"}]","updateId":"13bc20cf-3b41-4771-a7fc-f50c9f1a8e58","_id":"d9f6f962-c7ca-4047-8964-1ffbfd1d29c8"}}},{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:20:30.478Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"2e59a92e-1803-42a1-a4e8-12718a299f78\",\"_createdDate\":\"2020-02-14T05:20:30.692Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:20:30.692Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:21.773Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"7f593dc2-1e5b-4fbb-a51b-4531c509c38f\",\"_createdDate\":\"2020-02-14T05:21:22.115Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:22.115Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"00279865-1675-4d11-9709-eff6e5e8bacb\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:35.119Z\",\"zohoId\":\"4280752000003233001\",\"_id\":\"27e8d0b7-7a4b-41b7-9c18-bcc5428d2c0e\",\"_createdDate\":\"2020-02-14T05:21:35.301Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:35.301Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Electric Scooter 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"1341687a-2628-4b0e-8a24-dd7db1835151\",\"item\":\"10d10795-01f1-4565-9d36-b31116a48d5e\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:22:14.827Z\",\"zohoId\":\"4280752000003233049\",\"_id\":\"e35e2ac7-cc2b-41d3-b724-123c3e75eab1\",\"_createdDate\":\"2020-02-14T05:22:15.002Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:22:15.002Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"4\",\"isOk\":true,\"title\":\"Electric Scooter 4\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"07d46afe-1e84-4685-87ec-b83dc77a20f7\"},{\"serial\":\"Washer\",\"ip\":\"http://77.139.186.173:5000/washer\",\"isInRoom\":false,\"startTime\":\"2020-01-16T17:59:16.015Z\",\"_id\":\"ffeb5961-fb90-4e96-86d2-05edbc80aaba\",\"_createdDate\":\"2020-01-16T17:59:17.705Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:55.564Z\",\"total\":10,\"endTime\":\"2020-01-16T18:48:59.428Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"f073848c-a830-4a1c-9d28-1c5c026467b0\",\"passPrice\":\"10\",\"isOk\":true,\"title\":\"Washer\",\"room\":\"76199668-5950-4c41-b428-578a5c9e0b70\",\"user\":\"f19d395d-af19-4abd-bb51-6ce7c4dce707\",\"item\":\"3da7e725-ca78-4041-aeb3-3527501cb22f\",\"comments\":\"Sent to Zoho\"}]","updateId":"ffeb5961-fb90-4e96-86d2-05edbc80aaba","_id":"d9f6f962-c7ca-4047-8964-1ffbfd1d29c8"}}},{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:20:30.478Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"2e59a92e-1803-42a1-a4e8-12718a299f78\",\"_createdDate\":\"2020-02-14T05:20:30.692Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:20:30.692Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:21.773Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"7f593dc2-1e5b-4fbb-a51b-4531c509c38f\",\"_createdDate\":\"2020-02-14T05:21:22.115Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:22.115Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"00279865-1675-4d11-9709-eff6e5e8bacb\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:35.119Z\",\"zohoId\":\"4280752000003233001\",\"_id\":\"27e8d0b7-7a4b-41b7-9c18-bcc5428d2c0e\",\"_createdDate\":\"2020-02-14T05:21:35.301Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:35.301Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Electric Scooter 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"1341687a-2628-4b0e-8a24-dd7db1835151\",\"item\":\"10d10795-01f1-4565-9d36-b31116a48d5e\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:22:14.827Z\",\"zohoId\":\"4280752000003233049\",\"_id\":\"e35e2ac7-cc2b-41d3-b724-123c3e75eab1\",\"_createdDate\":\"2020-02-14T05:22:15.002Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:22:15.002Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"4\",\"isOk\":true,\"title\":\"Electric Scooter 4\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"07d46afe-1e84-4685-87ec-b83dc77a20f7\"},{\"serial\":\"TRX\",\"isInRoom\":false,\"startTime\":\"2020-01-16T16:33:55.883Z\",\"_id\":\"2512eb6f-5df4-48aa-86c8-ec42afb86516\",\"_createdDate\":\"2020-01-16T16:33:56.084Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:55.564Z\",\"total\":2,\"code\":\"00329\",\"endTime\":\"2020-01-16T16:57:39.163Z\",\"rating\":5,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"87e8e268-4104-48ab-a45c-2e4e80880927\",\"passPrice\":\"10\",\"isOk\":true,\"title\":\"TRX\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"user\":\"8cdd1b72-d485-4cbb-b549-758d26839707\",\"item\":\"7901328a-0663-4a03-a87e-44a2cfdbd249\",\"comments\":\"Sent to Zoho\"}]","updateId":"2512eb6f-5df4-48aa-86c8-ec42afb86516","_id":"d9f6f962-c7ca-4047-8964-1ffbfd1d29c8"}}},{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:20:30.478Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"2e59a92e-1803-42a1-a4e8-12718a299f78\",\"_createdDate\":\"2020-02-14T05:20:30.692Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:20:30.692Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:21.773Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"7f593dc2-1e5b-4fbb-a51b-4531c509c38f\",\"_createdDate\":\"2020-02-14T05:21:22.115Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:22.115Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"00279865-1675-4d11-9709-eff6e5e8bacb\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:35.119Z\",\"zohoId\":\"4280752000003233001\",\"_id\":\"27e8d0b7-7a4b-41b7-9c18-bcc5428d2c0e\",\"_createdDate\":\"2020-02-14T05:21:35.301Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:35.301Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Electric Scooter 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"1341687a-2628-4b0e-8a24-dd7db1835151\",\"item\":\"10d10795-01f1-4565-9d36-b31116a48d5e\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:22:14.827Z\",\"zohoId\":\"4280752000003233049\",\"_id\":\"e35e2ac7-cc2b-41d3-b724-123c3e75eab1\",\"_createdDate\":\"2020-02-14T05:22:15.002Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:22:15.002Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"4\",\"isOk\":true,\"title\":\"Electric Scooter 4\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"07d46afe-1e84-4685-87ec-b83dc77a20f7\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:35.119Z\",\"zohoId\":\"4280752000003233001\",\"_id\":\"27e8d0b7-7a4b-41b7-9c18-bcc5428d2c0e\",\"_createdDate\":\"2020-02-14T05:21:35.301Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:35.301Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Electric Scooter 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"1341687a-2628-4b0e-8a24-dd7db1835151\",\"item\":\"10d10795-01f1-4565-9d36-b31116a48d5e\",\"comments\":\"Sent to Zoho\"}]","updateId":"27e8d0b7-7a4b-41b7-9c18-bcc5428d2c0e","_id":"d9f6f962-c7ca-4047-8964-1ffbfd1d29c8"}}},{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:20:30.478Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"2e59a92e-1803-42a1-a4e8-12718a299f78\",\"_createdDate\":\"2020-02-14T05:20:30.692Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:20:30.692Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:21.773Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"7f593dc2-1e5b-4fbb-a51b-4531c509c38f\",\"_createdDate\":\"2020-02-14T05:21:22.115Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:22.115Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"00279865-1675-4d11-9709-eff6e5e8bacb\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:35.119Z\",\"zohoId\":\"4280752000003233001\",\"_id\":\"27e8d0b7-7a4b-41b7-9c18-bcc5428d2c0e\",\"_createdDate\":\"2020-02-14T05:21:35.301Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:35.301Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Electric Scooter 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"1341687a-2628-4b0e-8a24-dd7db1835151\",\"item\":\"10d10795-01f1-4565-9d36-b31116a48d5e\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:22:14.827Z\",\"zohoId\":\"4280752000003233049\",\"_id\":\"e35e2ac7-cc2b-41d3-b724-123c3e75eab1\",\"_createdDate\":\"2020-02-14T05:22:15.002Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:22:15.002Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"4\",\"isOk\":true,\"title\":\"Electric Scooter 4\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"07d46afe-1e84-4685-87ec-b83dc77a20f7\"},{\"serial\":\"Scooter 3\",\"isInRoom\":false,\"startTime\":\"2020-01-16T11:33:03.014Z\",\"_id\":\"d4641a30-9809-439c-aa3e-14388f319fa8\",\"_owner\":\"0a94287f-7968-4ad1-aaf9-e6b41b14bbf1\",\"_createdDate\":\"2020-01-16T11:33:04.077Z\",\"passDuration\":\"8\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:40:55.564Z\",\"total\":25,\"code\":\"0639\",\"endTime\":\"2020-01-16T13:48:54.936Z\",\"rating\":5,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"87b3c643-44df-4696-9fd6-ab41b28b1e1a\",\"passPrice\":\"30\",\"position\":\"3\",\"isOk\":true,\"title\":\"Scooter\",\"room\":\"662b2cbb-7848-4f71-96f8-5c1ea67adfcf\",\"user\":\"0a94287f-7968-4ad1-aaf9-e6b41b14bbf1\",\"item\":\"ed37429f-565b-4e61-9e92-9f050e364a8d\",\"comments\":\"Sent to Zoho\"}]","updateId":"d4641a30-9809-439c-aa3e-14388f319fa8","_id":"d9f6f962-c7ca-4047-8964-1ffbfd1d29c8"}}},{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:20:30.478Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"2e59a92e-1803-42a1-a4e8-12718a299f78\",\"_createdDate\":\"2020-02-14T05:20:30.692Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:20:30.692Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:21.773Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"7f593dc2-1e5b-4fbb-a51b-4531c509c38f\",\"_createdDate\":\"2020-02-14T05:21:22.115Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:22.115Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"00279865-1675-4d11-9709-eff6e5e8bacb\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:35.119Z\",\"zohoId\":\"4280752000003233001\",\"_id\":\"27e8d0b7-7a4b-41b7-9c18-bcc5428d2c0e\",\"_createdDate\":\"2020-02-14T05:21:35.301Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:35.301Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Electric Scooter 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"1341687a-2628-4b0e-8a24-dd7db1835151\",\"item\":\"10d10795-01f1-4565-9d36-b31116a48d5e\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:22:14.827Z\",\"zohoId\":\"4280752000003233049\",\"_id\":\"e35e2ac7-cc2b-41d3-b724-123c3e75eab1\",\"_createdDate\":\"2020-02-14T05:22:15.002Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:22:15.002Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"4\",\"isOk\":true,\"title\":\"Electric Scooter 4\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"07d46afe-1e84-4685-87ec-b83dc77a20f7\"},{\"serial\":\"Vacuum 1\",\"isInRoom\":false,\"startTime\":\"2020-01-16T11:58:35.742Z\",\"_id\":\"8152d095-854d-482a-a927-500111430d4b\",\"_createdDate\":\"2020-01-16T11:58:36.079Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:55.563Z\",\"total\":5,\"code\":\"00334\",\"endTime\":\"2020-01-16T12:14:03.957Z\",\"rating\":5,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"1\",\"isOk\":true,\"title\":\"Vacuum 1\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"d5079071-a6a1-45ea-878e-9873d9fc078d\",\"item\":\"3e978b61-60da-4760-a1bc-2e6c92fe9688\",\"comments\":\"Sent to Zoho\"}]","updateId":"8152d095-854d-482a-a927-500111430d4b","_id":"d9f6f962-c7ca-4047-8964-1ffbfd1d29c8"}}},{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:20:30.478Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"2e59a92e-1803-42a1-a4e8-12718a299f78\",\"_createdDate\":\"2020-02-14T05:20:30.692Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:20:30.692Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:21.773Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"7f593dc2-1e5b-4fbb-a51b-4531c509c38f\",\"_createdDate\":\"2020-02-14T05:21:22.115Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:22.115Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"00279865-1675-4d11-9709-eff6e5e8bacb\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:35.119Z\",\"zohoId\":\"4280752000003233001\",\"_id\":\"27e8d0b7-7a4b-41b7-9c18-bcc5428d2c0e\",\"_createdDate\":\"2020-02-14T05:21:35.301Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:35.301Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Electric Scooter 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"1341687a-2628-4b0e-8a24-dd7db1835151\",\"item\":\"10d10795-01f1-4565-9d36-b31116a48d5e\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:22:14.827Z\",\"zohoId\":\"4280752000003233049\",\"_id\":\"e35e2ac7-cc2b-41d3-b724-123c3e75eab1\",\"_createdDate\":\"2020-02-14T05:22:15.002Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:22:15.002Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"4\",\"isOk\":true,\"title\":\"Electric Scooter 4\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"07d46afe-1e84-4685-87ec-b83dc77a20f7\"},{\"serial\":\"Printer TAU1\",\"ip\":\"c6cdca1f-865c-4ec0-43c1-a8fead960de7\",\"isInRoom\":false,\"startTime\":\"2020-01-16T18:28:54.602Z\",\"_id\":\"8c020a24-f132-4ae6-a5c2-9e310c77c671\",\"_createdDate\":\"2020-01-16T18:28:54.945Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:40:55.564Z\",\"total\":0.1,\"files\":\"[{\\\"label\\\":\\\"דוח מס 2- 2020 ).docx\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/2ee797_4b114e245f0f430aacda2487ac939bae.docx\\\",\\\"pageCount\\\":1}]\",\"endTime\":\"2020-01-16T18:28:55.703Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"isOk\":true,\"title\":\"Printer Doorms_Lobby\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"2ee797fc-95d5-4c77-a681-911f420b9a10\",\"item\":\"569ae57a-a4ed-4645-b67c-a96da9f7a673\",\"comments\":\"Sent to Zoho\"}]","updateId":"8c020a24-f132-4ae6-a5c2-9e310c77c671","_id":"d9f6f962-c7ca-4047-8964-1ffbfd1d29c8"}}},"run: getTableSchema",{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:20:30.478Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"2e59a92e-1803-42a1-a4e8-12718a299f78\",\"_createdDate\":\"2020-02-14T05:20:30.692Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:20:30.692Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:21.773Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"7f593dc2-1e5b-4fbb-a51b-4531c509c38f\",\"_createdDate\":\"2020-02-14T05:21:22.115Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:22.115Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"00279865-1675-4d11-9709-eff6e5e8bacb\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:35.119Z\",\"zohoId\":\"4280752000003233001\",\"_id\":\"27e8d0b7-7a4b-41b7-9c18-bcc5428d2c0e\",\"_createdDate\":\"2020-02-14T05:21:35.301Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:35.301Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Electric Scooter 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"1341687a-2628-4b0e-8a24-dd7db1835151\",\"item\":\"10d10795-01f1-4565-9d36-b31116a48d5e\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:22:14.827Z\",\"zohoId\":\"4280752000003233049\",\"_id\":\"e35e2ac7-cc2b-41d3-b724-123c3e75eab1\",\"_createdDate\":\"2020-02-14T05:22:15.002Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:22:15.002Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"4\",\"isOk\":true,\"title\":\"Electric Scooter 4\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"07d46afe-1e84-4685-87ec-b83dc77a20f7\"},{\"serial\":\"Vacuum 2\",\"isInRoom\":false,\"startTime\":\"2020-01-16T19:15:00.000Z\",\"_id\":\"34bbefab-8ac6-4a52-ab53-2c7a88cde61c\",\"_createdDate\":\"2020-01-16T17:44:41.761Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:55.564Z\",\"total\":5,\"code\":\"00918\",\"endTime\":\"2020-01-16T19:44:00.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum 2\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"7f57addc-3884-4909-8296-a502c7ee9611\",\"item\":\"c830bcf2-511a-4626-a237-2e9b9312eea9\",\"comments\":\"Sent to Zoho\"}]","updateId":"34bbefab-8ac6-4a52-ab53-2c7a88cde61c","_id":"d9f6f962-c7ca-4047-8964-1ffbfd1d29c8"}}},{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:20:30.478Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"2e59a92e-1803-42a1-a4e8-12718a299f78\",\"_createdDate\":\"2020-02-14T05:20:30.692Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:20:30.692Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:21.773Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"7f593dc2-1e5b-4fbb-a51b-4531c509c38f\",\"_createdDate\":\"2020-02-14T05:21:22.115Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:22.115Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"00279865-1675-4d11-9709-eff6e5e8bacb\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:35.119Z\",\"zohoId\":\"4280752000003233001\",\"_id\":\"27e8d0b7-7a4b-41b7-9c18-bcc5428d2c0e\",\"_createdDate\":\"2020-02-14T05:21:35.301Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:35.301Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Electric Scooter 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"1341687a-2628-4b0e-8a24-dd7db1835151\",\"item\":\"10d10795-01f1-4565-9d36-b31116a48d5e\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:22:14.827Z\",\"zohoId\":\"4280752000003233049\",\"_id\":\"e35e2ac7-cc2b-41d3-b724-123c3e75eab1\",\"_createdDate\":\"2020-02-14T05:22:15.002Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:22:15.002Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"4\",\"isOk\":true,\"title\":\"Electric Scooter 4\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"07d46afe-1e84-4685-87ec-b83dc77a20f7\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:22:14.827Z\",\"zohoId\":\"4280752000003233049\",\"_id\":\"e35e2ac7-cc2b-41d3-b724-123c3e75eab1\",\"_createdDate\":\"2020-02-14T05:22:15.002Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:22:15.002Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"4\",\"isOk\":true,\"title\":\"Electric Scooter 4\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"07d46afe-1e84-4685-87ec-b83dc77a20f7\",\"comments\":\"Sent to Zoho\"}]","updateId":"e35e2ac7-cc2b-41d3-b724-123c3e75eab1","_id":"d9f6f962-c7ca-4047-8964-1ffbfd1d29c8"}}},{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:20:30.478Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"2e59a92e-1803-42a1-a4e8-12718a299f78\",\"_createdDate\":\"2020-02-14T05:20:30.692Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:20:30.692Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:21.773Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"7f593dc2-1e5b-4fbb-a51b-4531c509c38f\",\"_createdDate\":\"2020-02-14T05:21:22.115Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:22.115Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"00279865-1675-4d11-9709-eff6e5e8bacb\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:35.119Z\",\"zohoId\":\"4280752000003233001\",\"_id\":\"27e8d0b7-7a4b-41b7-9c18-bcc5428d2c0e\",\"_createdDate\":\"2020-02-14T05:21:35.301Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:35.301Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Electric Scooter 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"1341687a-2628-4b0e-8a24-dd7db1835151\",\"item\":\"10d10795-01f1-4565-9d36-b31116a48d5e\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:22:14.827Z\",\"zohoId\":\"4280752000003233049\",\"_id\":\"e35e2ac7-cc2b-41d3-b724-123c3e75eab1\",\"_createdDate\":\"2020-02-14T05:22:15.002Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:22:15.002Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"4\",\"isOk\":true,\"title\":\"Electric Scooter 4\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"07d46afe-1e84-4685-87ec-b83dc77a20f7\"},{\"serial\":\"Vacuum 3\",\"isInRoom\":false,\"startTime\":\"2020-01-16T16:08:11.541Z\",\"_id\":\"be8678ae-ec61-4bc3-822a-7598941a2a84\",\"_createdDate\":\"2020-01-16T16:08:11.740Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:55.564Z\",\"total\":5,\"code\":\"00776\",\"endTime\":\"2020-01-16T16:39:38.923Z\",\"rating\":5,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum 3\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"c2effc6a-7dbd-4fa1-b58f-8342a312dc1e\",\"item\":\"42961a91-13f4-4989-91f5-87cba7d99b0e\",\"comments\":\"Sent to Zoho\"}]","updateId":"be8678ae-ec61-4bc3-822a-7598941a2a84","_id":"d9f6f962-c7ca-4047-8964-1ffbfd1d29c8"}}},{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:20:30.478Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"2e59a92e-1803-42a1-a4e8-12718a299f78\",\"_createdDate\":\"2020-02-14T05:20:30.692Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:20:30.692Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:21.773Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"7f593dc2-1e5b-4fbb-a51b-4531c509c38f\",\"_createdDate\":\"2020-02-14T05:21:22.115Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:22.115Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"00279865-1675-4d11-9709-eff6e5e8bacb\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:35.119Z\",\"zohoId\":\"4280752000003233001\",\"_id\":\"27e8d0b7-7a4b-41b7-9c18-bcc5428d2c0e\",\"_createdDate\":\"2020-02-14T05:21:35.301Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:35.301Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Electric Scooter 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"1341687a-2628-4b0e-8a24-dd7db1835151\",\"item\":\"10d10795-01f1-4565-9d36-b31116a48d5e\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:22:14.827Z\",\"zohoId\":\"4280752000003233049\",\"_id\":\"e35e2ac7-cc2b-41d3-b724-123c3e75eab1\",\"_createdDate\":\"2020-02-14T05:22:15.002Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:22:15.002Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"4\",\"isOk\":true,\"title\":\"Electric Scooter 4\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"07d46afe-1e84-4685-87ec-b83dc77a20f7\"},{\"serial\":\"Bluetooth Speaker2\",\"isInRoom\":false,\"startTime\":\"2020-01-16T16:45:16.425Z\",\"_id\":\"a9396736-0a87-4004-afd2-4f2c91ab4d3e\",\"_createdDate\":\"2020-01-16T16:45:16.690Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:55.564Z\",\"total\":11,\"endTime\":\"2020-01-16T23:00:18.411Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"f63190a5-81cc-4f84-ba8e-b0edaf62b276\",\"passPrice\":\"6\",\"position\":\"2\",\"isOk\":true,\"title\":\"Bluetooth Speaker2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"290537e6-1b62-4008-b347-60e634dc3092\",\"item\":\"a1874147-6680-4977-a28d-8b8579b31fd9\",\"comments\":\"Sent to Zoho\"}]","updateId":"a9396736-0a87-4004-afd2-4f2c91ab4d3e","_id":"d9f6f962-c7ca-4047-8964-1ffbfd1d29c8"}}},{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:20:30.478Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"2e59a92e-1803-42a1-a4e8-12718a299f78\",\"_createdDate\":\"2020-02-14T05:20:30.692Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:20:30.692Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:21.773Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"7f593dc2-1e5b-4fbb-a51b-4531c509c38f\",\"_createdDate\":\"2020-02-14T05:21:22.115Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:22.115Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"00279865-1675-4d11-9709-eff6e5e8bacb\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:35.119Z\",\"zohoId\":\"4280752000003233001\",\"_id\":\"27e8d0b7-7a4b-41b7-9c18-bcc5428d2c0e\",\"_createdDate\":\"2020-02-14T05:21:35.301Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:35.301Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Electric Scooter 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"1341687a-2628-4b0e-8a24-dd7db1835151\",\"item\":\"10d10795-01f1-4565-9d36-b31116a48d5e\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:22:14.827Z\",\"zohoId\":\"4280752000003233049\",\"_id\":\"e35e2ac7-cc2b-41d3-b724-123c3e75eab1\",\"_createdDate\":\"2020-02-14T05:22:15.002Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:22:15.002Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"4\",\"isOk\":true,\"title\":\"Electric Scooter 4\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"07d46afe-1e84-4685-87ec-b83dc77a20f7\"},{\"serial\":\"Dryer\",\"ip\":\"http://77.139.186.173:5000/dryer\",\"isInRoom\":false,\"startTime\":\"2020-01-16T18:52:27.978Z\",\"_id\":\"920db96d-a899-49f8-8579-a40e1cd2fdc6\",\"_createdDate\":\"2020-01-16T18:52:29.777Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:55.564Z\",\"total\":10,\"endTime\":\"2020-01-16T21:43:17.710Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"c70cd8f1-1f75-443d-94ee-e7295edc4462\",\"passPrice\":\"10\",\"isOk\":true,\"title\":\"Dryer\",\"room\":\"76199668-5950-4c41-b428-578a5c9e0b70\",\"user\":\"f19d395d-af19-4abd-bb51-6ce7c4dce707\",\"item\":\"c4ac966d-4dc9-4e79-a199-d9feff8d43de\",\"comments\":\"Sent to Zoho\"}]","updateId":"920db96d-a899-49f8-8579-a40e1cd2fdc6","_id":"d9f6f962-c7ca-4047-8964-1ffbfd1d29c8"}}},{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:20:30.478Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"2e59a92e-1803-42a1-a4e8-12718a299f78\",\"_createdDate\":\"2020-02-14T05:20:30.692Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:20:30.692Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:21.773Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"7f593dc2-1e5b-4fbb-a51b-4531c509c38f\",\"_createdDate\":\"2020-02-14T05:21:22.115Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:22.115Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"00279865-1675-4d11-9709-eff6e5e8bacb\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:35.119Z\",\"zohoId\":\"4280752000003233001\",\"_id\":\"27e8d0b7-7a4b-41b7-9c18-bcc5428d2c0e\",\"_createdDate\":\"2020-02-14T05:21:35.301Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:35.301Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Electric Scooter 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"1341687a-2628-4b0e-8a24-dd7db1835151\",\"item\":\"10d10795-01f1-4565-9d36-b31116a48d5e\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:22:14.827Z\",\"zohoId\":\"4280752000003233049\",\"_id\":\"e35e2ac7-cc2b-41d3-b724-123c3e75eab1\",\"_createdDate\":\"2020-02-14T05:22:15.002Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:22:15.002Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"4\",\"isOk\":true,\"title\":\"Electric Scooter 4\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"07d46afe-1e84-4685-87ec-b83dc77a20f7\"},{\"serial\":\"Printer\",\"ip\":\"5e7c0a46-20f0-58bb-ea89-0676c2e5fbe6\",\"isInRoom\":false,\"startTime\":\"2020-01-16T14:51:48.422Z\",\"_id\":\"32ae59e6-16c2-4100-9dca-d209dd8f8477\",\"_createdDate\":\"2020-01-16T14:51:48.753Z\",\"baseTime\":30,\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T20:16:31.134Z\",\"total\":3.9,\"files\":\"[{\\\"label\\\":\\\"DBenavides - Rhone - Insights to Action Case Study - 01102020.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/9f2c41_ac01f68b5d184c95a7d70ed12a7e82eb.pdf\\\",\\\"pageCount\\\":13}]\",\"endTime\":\"2020-01-16T14:51:49.481Z\",\"rating\":5,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"isOk\":true,\"title\":\"Printer Oscar\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"51776900-9aec-477c-bc01-1ff1a264bc2e\",\"item\":\"ef9f6dd6-d547-4511-8108-22869f5522fc\",\"comments\":\"Sent to Zoho\"}]","updateId":"32ae59e6-16c2-4100-9dca-d209dd8f8477","_id":"d9f6f962-c7ca-4047-8964-1ffbfd1d29c8"}}},{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:20:30.478Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"2e59a92e-1803-42a1-a4e8-12718a299f78\",\"_createdDate\":\"2020-02-14T05:20:30.692Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:20:30.692Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:21.773Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"7f593dc2-1e5b-4fbb-a51b-4531c509c38f\",\"_createdDate\":\"2020-02-14T05:21:22.115Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:22.115Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"00279865-1675-4d11-9709-eff6e5e8bacb\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:35.119Z\",\"zohoId\":\"4280752000003233001\",\"_id\":\"27e8d0b7-7a4b-41b7-9c18-bcc5428d2c0e\",\"_createdDate\":\"2020-02-14T05:21:35.301Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:35.301Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Electric Scooter 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"1341687a-2628-4b0e-8a24-dd7db1835151\",\"item\":\"10d10795-01f1-4565-9d36-b31116a48d5e\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:22:14.827Z\",\"zohoId\":\"4280752000003233049\",\"_id\":\"e35e2ac7-cc2b-41d3-b724-123c3e75eab1\",\"_createdDate\":\"2020-02-14T05:22:15.002Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:22:15.002Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"4\",\"isOk\":true,\"title\":\"Electric Scooter 4\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"07d46afe-1e84-4685-87ec-b83dc77a20f7\"},{\"serial\":\"Window Robot 1\",\"isInRoom\":false,\"startTime\":\"2020-01-16T14:32:00.000Z\",\"_id\":\"ec980deb-b38a-4728-a9c4-c9232b92f397\",\"_createdDate\":\"2020-01-16T12:32:41.959Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:55.563Z\",\"total\":5,\"code\":\"00587\",\"endTime\":\"2020-01-16T15:00:00.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"3ef7be44-a5f8-432a-8554-e7aadd8efc4f\",\"passPrice\":\"20\",\"position\":\"1\",\"isOk\":true,\"title\":\"Window Robot 1\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"7f98a0a1-cc22-478e-aea3-3f0bef56eb3c\",\"item\":\"c1004df2-2290-4f9a-8aba-67275e05781c\",\"comments\":\"Sent to Zoho\"}]","updateId":"ec980deb-b38a-4728-a9c4-c9232b92f397","_id":"d9f6f962-c7ca-4047-8964-1ffbfd1d29c8"}}},{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:20:30.478Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"2e59a92e-1803-42a1-a4e8-12718a299f78\",\"_createdDate\":\"2020-02-14T05:20:30.692Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:20:30.692Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:21.773Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"7f593dc2-1e5b-4fbb-a51b-4531c509c38f\",\"_createdDate\":\"2020-02-14T05:21:22.115Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:22.115Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"00279865-1675-4d11-9709-eff6e5e8bacb\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:35.119Z\",\"zohoId\":\"4280752000003233001\",\"_id\":\"27e8d0b7-7a4b-41b7-9c18-bcc5428d2c0e\",\"_createdDate\":\"2020-02-14T05:21:35.301Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:35.301Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Electric Scooter 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"1341687a-2628-4b0e-8a24-dd7db1835151\",\"item\":\"10d10795-01f1-4565-9d36-b31116a48d5e\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:22:14.827Z\",\"zohoId\":\"4280752000003233049\",\"_id\":\"e35e2ac7-cc2b-41d3-b724-123c3e75eab1\",\"_createdDate\":\"2020-02-14T05:22:15.002Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:22:15.002Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"4\",\"isOk\":true,\"title\":\"Electric Scooter 4\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"07d46afe-1e84-4685-87ec-b83dc77a20f7\"},{\"serial\":\"Printer\",\"ip\":\"f5a95cff-02b6-61fe-f847-53cf4927ba54\",\"isInRoom\":false,\"startTime\":\"2020-01-16T11:01:10.953Z\",\"_id\":\"869cccc6-b928-4c81-8134-68b7054baa31\",\"_createdDate\":\"2020-01-16T11:01:11.318Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:40:55.564Z\",\"total\":0.1,\"files\":\"[{\\\"label\\\":\\\"הסכם שכר טרחה.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/d272d0_c8c0dc4da89040f0af6ece424ccc6c17.pdf\\\",\\\"pageCount\\\":1}]\",\"endTime\":\"2020-01-16T11:01:12.086Z\",\"rating\":5,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"isOk\":true,\"title\":\"Printer Levontin\",\"room\":\"69852922-a287-45c6-81b1-41be6097320d\",\"user\":\"95ccb7f0-f445-4502-a743-a3965455b8ea\",\"item\":\"d373136a-dac1-4d41-a36d-70ed4f614e38\",\"comments\":\"Sent to Zoho\"}]","updateId":"869cccc6-b928-4c81-8134-68b7054baa31","_id":"d9f6f962-c7ca-4047-8964-1ffbfd1d29c8"}}},{"res: getTableSchema":"ok"},"run: insertToTable",{"res: runBigQueryJobs":{"catch":"bigQueryJobs_update","error":{"name":"Error","errorGroup":"User","code":"WD_ITEM_DOES_NOT_EXIST"},"item":{"method":"Insert","table":"rents","data":"[{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:20:30.478Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"2e59a92e-1803-42a1-a4e8-12718a299f78\",\"_createdDate\":\"2020-02-14T05:20:30.692Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:20:30.692Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:21.773Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"7f593dc2-1e5b-4fbb-a51b-4531c509c38f\",\"_createdDate\":\"2020-02-14T05:21:22.115Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:22.115Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"00279865-1675-4d11-9709-eff6e5e8bacb\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:21:35.119Z\",\"zohoId\":\"4280752000003233001\",\"_id\":\"27e8d0b7-7a4b-41b7-9c18-bcc5428d2c0e\",\"_createdDate\":\"2020-02-14T05:21:35.301Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:21:35.301Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Electric Scooter 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"1341687a-2628-4b0e-8a24-dd7db1835151\",\"item\":\"10d10795-01f1-4565-9d36-b31116a48d5e\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T05:22:14.827Z\",\"zohoId\":\"4280752000003233049\",\"_id\":\"e35e2ac7-cc2b-41d3-b724-123c3e75eab1\",\"_createdDate\":\"2020-02-14T05:22:15.002Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T05:22:15.002Z\",\"code\":\"2323\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"4\",\"isOk\":true,\"title\":\"Electric Scooter 4\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"281d5877-4a94-4f5d-a1f5-0ad6d35437ca\",\"item\":\"07d46afe-1e84-4685-87ec-b83dc77a20f7\"},{\"serial\":\"Printer\",\"ip\":\"5e7c0a46-20f0-58bb-ea89-0676c2e5fbe6\",\"isInRoom\":false,\"startTime\":\"2020-01-16T14:54:08.294Z\",\"_id\":\"40d24f7d-5796-43a9-ad9f-473fb3fd8078\",\"_createdDate\":\"2020-01-16T14:54:08.496Z\",\"baseTime\":30,\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T20:16:31.134Z\",\"total\":7.8,\"files\":\"[{\\\"label\\\":\\\"DBenavides - Rhone - Insights to Action Case Study - 01102020.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/9f2c41_a902916330b145f2b60bd8bfd91ec63c.pdf\\\",\\\"pageCount\\\":13}]\",\"endTime\":\"2020-01-16T14:54:08.589Z\",\"rating\":4,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"isOk\":true,\"title\":\"Printer Oscar\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"51776900-9aec-477c-bc01-1ff1a264bc2e\",\"item\":\"ef9f6dd6-d547-4511-8108-22869f5522fc\",\"comments\":\"Sent to Zoho\"}]","updateId":"40d24f7d-5796-43a9-ad9f-473fb3fd8078","_id":"d9f6f962-c7ca-4047-8964-1ffbfd1d29c8"}}}]

User not available