Fri Feb 14 2020 05:30:04 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"}}}]

User not available