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

Msg: Error - sendToBigQuery
Info: ["run: sendToBigQuery",{"data Id":"816d7b7b-4540-460b-84e0-52001cd2b20d"},{"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-14T01:19:40.618Z\",\"zohoId\":\"4280752000001355501\",\"_id\":\"3bb17bc8-937a-47ea-8eb1-e891f2c2cefd\",\"_createdDate\":\"2020-02-14T01:19:40.972Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T01:19:40.972Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Vacuum Cleaner 1\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"1f661aa8-a204-489f-8cba-dfc5fe877d55\",\"item\":\"81bfdb1e-09ea-4b53-aaad-7b2263be8e1f\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T01:19:40.618Z\",\"zohoId\":\"4280752000001353488\",\"_id\":\"3bb17bc8-937a-47ea-8eb1-e891f2c2cefd\",\"_createdDate\":\"2019-10-29T22:24:03.595Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T01:19:50.883Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum Cleaner 2\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"1f661aa8-a204-489f-8cba-dfc5fe877d55\",\"item\":\"c1e5bd0a-2dc0-45e7-bf21-306c718b25c0\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T00:42:35.375Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"4e4d58f4-5981-4fd5-9f30-891362ba6c55\",\"_createdDate\":\"2020-02-14T00:42:35.610Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T00:45:03.180Z\",\"code\":\"2323\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"b949caec-9c3a-4575-919b-f2586d8e76ad\",\"comments\":\"Sent to Zoho\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\",\"endTime\":\"2020-02-14T01:25:15.172Z\",\"total\":4},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T00:43:08.672Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"5b09b524-09aa-48a2-9817-839821b92d86\",\"_createdDate\":\"2020-02-14T00:43:08.911Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T00:45:03.180Z\",\"code\":\"2323\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"f4c35f25-aacb-4206-9e7f-3bd4edeff14e\",\"comments\":\"Sent to Zoho\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\",\"endTime\":\"2020-02-14T01:25:21.641Z\",\"total\":4},{\"serial\":\"Printer TAU1\",\"ip\":\"c6cdca1f-865c-4ec0-43c1-a8fead960de7\",\"isInRoom\":false,\"startTime\":\"2020-01-23T14:15:19.254Z\",\"_id\":\"47df6cba-bb95-45c2-8fc0-cdfde5fc31f2\",\"_createdDate\":\"2020-01-23T14:15:19.689Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:40:26.450Z\",\"total\":2.1,\"files\":\"[{\\\"label\\\":\\\"דף נוסחאות המרת אנרגיה - 2012.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/14983e_e97eb8238304472fa827e47c101bb083.pdf\\\",\\\"pageCount\\\":7}]\",\"endTime\":\"2020-01-23T14:15:20.355Z\",\"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\":\"6c033053-0c2a-4699-bd4f-1ef2578b940e\",\"item\":\"569ae57a-a4ed-4645-b67c-a96da9f7a673\",\"comments\":\"Sent to Zoho\"}]","updateId":"47df6cba-bb95-45c2-8fc0-cdfde5fc31f2","_id":"ecaf24cf-82d8-4e24-aeb4-fe1a1f580e1c"}}},{"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-14T01:19:40.618Z\",\"zohoId\":\"4280752000001355501\",\"_id\":\"3bb17bc8-937a-47ea-8eb1-e891f2c2cefd\",\"_createdDate\":\"2020-02-14T01:19:40.972Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T01:19:40.972Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Vacuum Cleaner 1\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"1f661aa8-a204-489f-8cba-dfc5fe877d55\",\"item\":\"81bfdb1e-09ea-4b53-aaad-7b2263be8e1f\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T01:19:40.618Z\",\"zohoId\":\"4280752000001353488\",\"_id\":\"3bb17bc8-937a-47ea-8eb1-e891f2c2cefd\",\"_createdDate\":\"2019-10-29T22:24:03.595Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T01:19:50.883Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum Cleaner 2\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"1f661aa8-a204-489f-8cba-dfc5fe877d55\",\"item\":\"c1e5bd0a-2dc0-45e7-bf21-306c718b25c0\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T00:42:35.375Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"4e4d58f4-5981-4fd5-9f30-891362ba6c55\",\"_createdDate\":\"2020-02-14T00:42:35.610Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T00:45:03.180Z\",\"code\":\"2323\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"b949caec-9c3a-4575-919b-f2586d8e76ad\",\"comments\":\"Sent to Zoho\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\",\"endTime\":\"2020-02-14T01:25:15.172Z\",\"total\":4},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T00:43:08.672Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"5b09b524-09aa-48a2-9817-839821b92d86\",\"_createdDate\":\"2020-02-14T00:43:08.911Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T00:45:03.180Z\",\"code\":\"2323\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"f4c35f25-aacb-4206-9e7f-3bd4edeff14e\",\"comments\":\"Sent to Zoho\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\",\"endTime\":\"2020-02-14T01:25:21.641Z\",\"total\":4},{\"serial\":\"Vacuum 3\",\"isInRoom\":false,\"startTime\":\"2020-01-23T13:03:39.079Z\",\"_id\":\"0a2d33ba-9560-4568-8877-94eab6d64480\",\"_createdDate\":\"2020-01-23T13:03:39.347Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:26.450Z\",\"total\":5,\"code\":\"00472\",\"endTime\":\"2020-01-23T13:15:09.780Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum 3\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"user\":\"796c0094-0ccb-4a59-94b9-f9fde78f5927\",\"item\":\"d1c25ee5-6f31-401b-9cdb-ddfc7661998d\",\"comments\":\"Sent to Zoho\"}]","updateId":"0a2d33ba-9560-4568-8877-94eab6d64480","_id":"ecaf24cf-82d8-4e24-aeb4-fe1a1f580e1c"}}},{"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-14T01:19:40.618Z\",\"zohoId\":\"4280752000001355501\",\"_id\":\"3bb17bc8-937a-47ea-8eb1-e891f2c2cefd\",\"_createdDate\":\"2020-02-14T01:19:40.972Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T01:19:40.972Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Vacuum Cleaner 1\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"1f661aa8-a204-489f-8cba-dfc5fe877d55\",\"item\":\"81bfdb1e-09ea-4b53-aaad-7b2263be8e1f\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T01:19:40.618Z\",\"zohoId\":\"4280752000001353488\",\"_id\":\"3bb17bc8-937a-47ea-8eb1-e891f2c2cefd\",\"_createdDate\":\"2019-10-29T22:24:03.595Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T01:19:50.883Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum Cleaner 2\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"1f661aa8-a204-489f-8cba-dfc5fe877d55\",\"item\":\"c1e5bd0a-2dc0-45e7-bf21-306c718b25c0\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T00:42:35.375Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"4e4d58f4-5981-4fd5-9f30-891362ba6c55\",\"_createdDate\":\"2020-02-14T00:42:35.610Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T00:45:03.180Z\",\"code\":\"2323\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"b949caec-9c3a-4575-919b-f2586d8e76ad\",\"comments\":\"Sent to Zoho\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\",\"endTime\":\"2020-02-14T01:25:15.172Z\",\"total\":4},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T00:43:08.672Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"5b09b524-09aa-48a2-9817-839821b92d86\",\"_createdDate\":\"2020-02-14T00:43:08.911Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T00:45:03.180Z\",\"code\":\"2323\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"f4c35f25-aacb-4206-9e7f-3bd4edeff14e\",\"comments\":\"Sent to Zoho\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\",\"endTime\":\"2020-02-14T01:25:21.641Z\",\"total\":4},{\"serial\":\"***\",\"ip\":\"cdcdfc32-6e44-6c6f-f265-73211ca8b326\",\"isInRoom\":false,\"startTime\":\"2020-01-23T13:43:05.881Z\",\"_id\":\"3183ca42-b002-4cf1-b5b5-66fa380b3551\",\"_createdDate\":\"2020-01-23T13:43:06.356Z\",\"passDuration\":\"-\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:40:26.450Z\",\"total\":0.2,\"files\":\"[{\\\"label\\\":\\\"shipping.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/9add67_39cccc8eb30e48868f354b5e43fe5130.pdf\\\",\\\"pageCount\\\":2}]\",\"endTime\":\"2020-01-23T13:43:07.214Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"passPrice\":\"-\",\"isOk\":true,\"title\":\"Printer\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"9add673a-9b59-4afe-a168-4617a3c82a55\",\"item\":\"be774ee3-9cf4-4804-b26a-5e771302f8eb\",\"comments\":\"Sent to Zoho\"}]","updateId":"3183ca42-b002-4cf1-b5b5-66fa380b3551","_id":"ecaf24cf-82d8-4e24-aeb4-fe1a1f580e1c"}}},"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-14T01:19:40.618Z\",\"zohoId\":\"4280752000001355501\",\"_id\":\"3bb17bc8-937a-47ea-8eb1-e891f2c2cefd\",\"_createdDate\":\"2020-02-14T01:19:40.972Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T01:19:40.972Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Vacuum Cleaner 1\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"1f661aa8-a204-489f-8cba-dfc5fe877d55\",\"item\":\"81bfdb1e-09ea-4b53-aaad-7b2263be8e1f\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T01:19:40.618Z\",\"zohoId\":\"4280752000001353488\",\"_id\":\"3bb17bc8-937a-47ea-8eb1-e891f2c2cefd\",\"_createdDate\":\"2019-10-29T22:24:03.595Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T01:19:50.883Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum Cleaner 2\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"1f661aa8-a204-489f-8cba-dfc5fe877d55\",\"item\":\"c1e5bd0a-2dc0-45e7-bf21-306c718b25c0\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T00:42:35.375Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"4e4d58f4-5981-4fd5-9f30-891362ba6c55\",\"_createdDate\":\"2020-02-14T00:42:35.610Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T00:45:03.180Z\",\"code\":\"2323\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"b949caec-9c3a-4575-919b-f2586d8e76ad\",\"comments\":\"Sent to Zoho\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\",\"endTime\":\"2020-02-14T01:25:15.172Z\",\"total\":4},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T00:43:08.672Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"5b09b524-09aa-48a2-9817-839821b92d86\",\"_createdDate\":\"2020-02-14T00:43:08.911Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T00:45:03.180Z\",\"code\":\"2323\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"f4c35f25-aacb-4206-9e7f-3bd4edeff14e\",\"comments\":\"Sent to Zoho\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\",\"endTime\":\"2020-02-14T01:25:21.641Z\",\"total\":4},{\"serial\":\"Printer TAU1\",\"ip\":\"c6cdca1f-865c-4ec0-43c1-a8fead960de7\",\"isInRoom\":false,\"startTime\":\"2020-01-23T12:47:17.448Z\",\"_id\":\"908b6c8e-704c-499b-bc1e-b3b802b24138\",\"_createdDate\":\"2020-01-23T12:47:17.987Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:40:26.450Z\",\"total\":0.1,\"files\":\"[{\\\"label\\\":\\\"אוניברסיטת ת_א - מידע אישי לתלמידים - Page 1.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/f6fc07_da6e914be29745cfa33499026841e452.pdf\\\",\\\"pageCount\\\":1}]\",\"endTime\":\"2020-01-23T12:47:18.720Z\",\"rating\":5,\"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\":\"f6fc0789-b5d6-41df-b2eb-3abafd29fb60\",\"item\":\"569ae57a-a4ed-4645-b67c-a96da9f7a673\",\"comments\":\"Sent to Zoho\"}]","updateId":"908b6c8e-704c-499b-bc1e-b3b802b24138","_id":"ecaf24cf-82d8-4e24-aeb4-fe1a1f580e1c"}}},{"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-14T01:19:40.618Z\",\"zohoId\":\"4280752000001355501\",\"_id\":\"3bb17bc8-937a-47ea-8eb1-e891f2c2cefd\",\"_createdDate\":\"2020-02-14T01:19:40.972Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T01:19:40.972Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Vacuum Cleaner 1\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"1f661aa8-a204-489f-8cba-dfc5fe877d55\",\"item\":\"81bfdb1e-09ea-4b53-aaad-7b2263be8e1f\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T01:19:40.618Z\",\"zohoId\":\"4280752000001353488\",\"_id\":\"3bb17bc8-937a-47ea-8eb1-e891f2c2cefd\",\"_createdDate\":\"2019-10-29T22:24:03.595Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T01:19:50.883Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum Cleaner 2\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"1f661aa8-a204-489f-8cba-dfc5fe877d55\",\"item\":\"c1e5bd0a-2dc0-45e7-bf21-306c718b25c0\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T00:42:35.375Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"4e4d58f4-5981-4fd5-9f30-891362ba6c55\",\"_createdDate\":\"2020-02-14T00:42:35.610Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T00:45:03.180Z\",\"code\":\"2323\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"b949caec-9c3a-4575-919b-f2586d8e76ad\",\"comments\":\"Sent to Zoho\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\",\"endTime\":\"2020-02-14T01:25:15.172Z\",\"total\":4},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T00:43:08.672Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"5b09b524-09aa-48a2-9817-839821b92d86\",\"_createdDate\":\"2020-02-14T00:43:08.911Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T00:45:03.180Z\",\"code\":\"2323\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"f4c35f25-aacb-4206-9e7f-3bd4edeff14e\",\"comments\":\"Sent to Zoho\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\",\"endTime\":\"2020-02-14T01:25:21.641Z\",\"total\":4},{\"serial\":\"Washer\",\"ip\":\"http://77.139.186.173:5000/washer\",\"isInRoom\":false,\"startTime\":\"2020-01-23T14:34:38.264Z\",\"_id\":\"6c195bb3-27cf-4d09-a315-679f567ebb2d\",\"_createdDate\":\"2020-01-23T14:34:40.083Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:26.450Z\",\"total\":10,\"endTime\":\"2020-01-23T15:28:05.699Z\",\"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":"6c195bb3-27cf-4d09-a315-679f567ebb2d","_id":"ecaf24cf-82d8-4e24-aeb4-fe1a1f580e1c"}}},{"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-14T01:19:40.618Z\",\"zohoId\":\"4280752000001355501\",\"_id\":\"3bb17bc8-937a-47ea-8eb1-e891f2c2cefd\",\"_createdDate\":\"2020-02-14T01:19:40.972Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T01:19:40.972Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Vacuum Cleaner 1\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"1f661aa8-a204-489f-8cba-dfc5fe877d55\",\"item\":\"81bfdb1e-09ea-4b53-aaad-7b2263be8e1f\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T01:19:40.618Z\",\"zohoId\":\"4280752000001353488\",\"_id\":\"3bb17bc8-937a-47ea-8eb1-e891f2c2cefd\",\"_createdDate\":\"2019-10-29T22:24:03.595Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T01:19:50.883Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum Cleaner 2\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"1f661aa8-a204-489f-8cba-dfc5fe877d55\",\"item\":\"c1e5bd0a-2dc0-45e7-bf21-306c718b25c0\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T00:42:35.375Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"4e4d58f4-5981-4fd5-9f30-891362ba6c55\",\"_createdDate\":\"2020-02-14T00:42:35.610Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T00:45:03.180Z\",\"code\":\"2323\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"b949caec-9c3a-4575-919b-f2586d8e76ad\",\"comments\":\"Sent to Zoho\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\",\"endTime\":\"2020-02-14T01:25:15.172Z\",\"total\":4},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T00:43:08.672Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"5b09b524-09aa-48a2-9817-839821b92d86\",\"_createdDate\":\"2020-02-14T00:43:08.911Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T00:45:03.180Z\",\"code\":\"2323\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"f4c35f25-aacb-4206-9e7f-3bd4edeff14e\",\"comments\":\"Sent to Zoho\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\",\"endTime\":\"2020-02-14T01:25:21.641Z\",\"total\":4},{\"serial\":\"Printer TAU1\",\"ip\":\"c6cdca1f-865c-4ec0-43c1-a8fead960de7\",\"isInRoom\":false,\"startTime\":\"2020-01-23T15:07:29.600Z\",\"_id\":\"aebb43c5-a502-45b6-86f3-6f40df8cc225\",\"_createdDate\":\"2020-01-23T15:07:29.870Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:40:26.450Z\",\"total\":0.7,\"files\":\"[{\\\"label\\\":\\\"The science of biodiveristy _6269889c8e871c00954a55401f428eef.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/0a9979_71e4c911aaa74350b2c777382b3e9bf3.pdf\\\",\\\"pageCount\\\":7}]\",\"endTime\":\"2020-01-23T15:07:29.998Z\",\"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\":\"0a99794a-c303-411c-8100-20df144ada71\",\"item\":\"569ae57a-a4ed-4645-b67c-a96da9f7a673\",\"comments\":\"Sent to Zoho\"}]","updateId":"aebb43c5-a502-45b6-86f3-6f40df8cc225","_id":"ecaf24cf-82d8-4e24-aeb4-fe1a1f580e1c"}}},{"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-14T01:19:40.618Z\",\"zohoId\":\"4280752000001355501\",\"_id\":\"3bb17bc8-937a-47ea-8eb1-e891f2c2cefd\",\"_createdDate\":\"2020-02-14T01:19:40.972Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T01:19:40.972Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Vacuum Cleaner 1\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"1f661aa8-a204-489f-8cba-dfc5fe877d55\",\"item\":\"81bfdb1e-09ea-4b53-aaad-7b2263be8e1f\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T01:19:40.618Z\",\"zohoId\":\"4280752000001353488\",\"_id\":\"3bb17bc8-937a-47ea-8eb1-e891f2c2cefd\",\"_createdDate\":\"2019-10-29T22:24:03.595Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T01:19:50.883Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum Cleaner 2\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"1f661aa8-a204-489f-8cba-dfc5fe877d55\",\"item\":\"c1e5bd0a-2dc0-45e7-bf21-306c718b25c0\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T00:42:35.375Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"4e4d58f4-5981-4fd5-9f30-891362ba6c55\",\"_createdDate\":\"2020-02-14T00:42:35.610Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T00:45:03.180Z\",\"code\":\"2323\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"b949caec-9c3a-4575-919b-f2586d8e76ad\",\"comments\":\"Sent to Zoho\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\",\"endTime\":\"2020-02-14T01:25:15.172Z\",\"total\":4},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T00:43:08.672Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"5b09b524-09aa-48a2-9817-839821b92d86\",\"_createdDate\":\"2020-02-14T00:43:08.911Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T00:45:03.180Z\",\"code\":\"2323\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"f4c35f25-aacb-4206-9e7f-3bd4edeff14e\",\"comments\":\"Sent to Zoho\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\",\"endTime\":\"2020-02-14T01:25:21.641Z\",\"total\":4},{\"serial\":\"Printer TAU1\",\"ip\":\"c6cdca1f-865c-4ec0-43c1-a8fead960de7\",\"isInRoom\":false,\"startTime\":\"2020-01-23T09:04:49.668Z\",\"_id\":\"d1dd8409-f98a-4d69-819d-e0597ef9290f\",\"_createdDate\":\"2020-01-23T09:04:49.984Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:40:26.450Z\",\"total\":1.5,\"files\":\"[{\\\"label\\\":\\\"pre.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/7de66c_16aedab5da3b4532bdf60be49cf5c36c.pdf\\\",\\\"pageCount\\\":6},{\\\"label\\\":\\\"sum.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/7de66c_c517a2e96e9a418687c238134feb9c4c.pdf\\\",\\\"pageCount\\\":9}]\",\"endTime\":\"2020-01-23T09:04:50.604Z\",\"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\":\"7de66c11-28ca-4af4-9f85-9a2031389c68\",\"item\":\"569ae57a-a4ed-4645-b67c-a96da9f7a673\",\"comments\":\"Sent to Zoho\"}]","updateId":"d1dd8409-f98a-4d69-819d-e0597ef9290f","_id":"ecaf24cf-82d8-4e24-aeb4-fe1a1f580e1c"}}},{"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-14T01:19:40.618Z\",\"zohoId\":\"4280752000001355501\",\"_id\":\"3bb17bc8-937a-47ea-8eb1-e891f2c2cefd\",\"_createdDate\":\"2020-02-14T01:19:40.972Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T01:19:40.972Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Vacuum Cleaner 1\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"1f661aa8-a204-489f-8cba-dfc5fe877d55\",\"item\":\"81bfdb1e-09ea-4b53-aaad-7b2263be8e1f\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T01:19:40.618Z\",\"zohoId\":\"4280752000001353488\",\"_id\":\"3bb17bc8-937a-47ea-8eb1-e891f2c2cefd\",\"_createdDate\":\"2019-10-29T22:24:03.595Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T01:19:50.883Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum Cleaner 2\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"1f661aa8-a204-489f-8cba-dfc5fe877d55\",\"item\":\"c1e5bd0a-2dc0-45e7-bf21-306c718b25c0\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T00:42:35.375Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"4e4d58f4-5981-4fd5-9f30-891362ba6c55\",\"_createdDate\":\"2020-02-14T00:42:35.610Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T00:45:03.180Z\",\"code\":\"2323\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"b949caec-9c3a-4575-919b-f2586d8e76ad\",\"comments\":\"Sent to Zoho\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\",\"endTime\":\"2020-02-14T01:25:15.172Z\",\"total\":4},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T00:43:08.672Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"5b09b524-09aa-48a2-9817-839821b92d86\",\"_createdDate\":\"2020-02-14T00:43:08.911Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T00:45:03.180Z\",\"code\":\"2323\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"f4c35f25-aacb-4206-9e7f-3bd4edeff14e\",\"comments\":\"Sent to Zoho\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\",\"endTime\":\"2020-02-14T01:25:21.641Z\",\"total\":4},{\"serial\":\"Drill 2\",\"isInRoom\":false,\"startTime\":\"2020-01-23T11:18:00.236Z\",\"_id\":\"d50952af-31d1-4900-ab80-12355f37b0df\",\"_createdDate\":\"2020-01-23T11:18:00.452Z\",\"passDuration\":\"24,48\",\"baseTime\":\"60\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:26.451Z\",\"total\":2,\"endTime\":\"2020-01-23T11:31:53.475Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b78358e8-9a04-4096-b540-3bb33f63c978\",\"passPrice\":\"10,10\",\"position\":\"2\",\"isOk\":true,\"title\":\"Drill 2\",\"room\":\"79c4d41a-0294-446b-b306-b0413963c9ac\",\"user\":\"1dbe217b-a242-44ec-81cc-fda9efc66247\",\"item\":\"9a644e41-a472-43c7-9dc5-00d2e43053a7\",\"comments\":\"Sent to Zoho\"}]","updateId":"d50952af-31d1-4900-ab80-12355f37b0df","_id":"ecaf24cf-82d8-4e24-aeb4-fe1a1f580e1c"}}},{"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-14T01:19:40.618Z\",\"zohoId\":\"4280752000001355501\",\"_id\":\"3bb17bc8-937a-47ea-8eb1-e891f2c2cefd\",\"_createdDate\":\"2020-02-14T01:19:40.972Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T01:19:40.972Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Vacuum Cleaner 1\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"1f661aa8-a204-489f-8cba-dfc5fe877d55\",\"item\":\"81bfdb1e-09ea-4b53-aaad-7b2263be8e1f\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T01:19:40.618Z\",\"zohoId\":\"4280752000001353488\",\"_id\":\"3bb17bc8-937a-47ea-8eb1-e891f2c2cefd\",\"_createdDate\":\"2019-10-29T22:24:03.595Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T01:19:50.883Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum Cleaner 2\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"1f661aa8-a204-489f-8cba-dfc5fe877d55\",\"item\":\"c1e5bd0a-2dc0-45e7-bf21-306c718b25c0\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T00:42:35.375Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"4e4d58f4-5981-4fd5-9f30-891362ba6c55\",\"_createdDate\":\"2020-02-14T00:42:35.610Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T00:45:03.180Z\",\"code\":\"2323\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"b949caec-9c3a-4575-919b-f2586d8e76ad\",\"comments\":\"Sent to Zoho\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\",\"endTime\":\"2020-02-14T01:25:15.172Z\",\"total\":4},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T00:43:08.672Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"5b09b524-09aa-48a2-9817-839821b92d86\",\"_createdDate\":\"2020-02-14T00:43:08.911Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T00:45:03.180Z\",\"code\":\"2323\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"f4c35f25-aacb-4206-9e7f-3bd4edeff14e\",\"comments\":\"Sent to Zoho\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\",\"endTime\":\"2020-02-14T01:25:21.641Z\",\"total\":4},{\"serial\":\"Steamer\",\"isInRoom\":false,\"startTime\":\"2020-01-23T13:12:00.000Z\",\"_id\":\"96765041-d2d3-46cd-b9ea-fd54e73ba327\",\"_createdDate\":\"2020-01-23T11:12:58.860Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:26.450Z\",\"total\":5,\"code\":\"00580\",\"endTime\":\"2020-01-23T13:27:00.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b822bee5-3e86-441d-8a36-4e5db5baed6f\",\"passPrice\":\"20\",\"isOk\":true,\"title\":\"Steamery\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"69ec503d-5903-462d-8cde-403062dedf81\",\"item\":\"f457cee4-bfba-4b10-a4ee-2deac9665d3b\",\"comments\":\"Sent to Zoho\"}]","updateId":"96765041-d2d3-46cd-b9ea-fd54e73ba327","_id":"ecaf24cf-82d8-4e24-aeb4-fe1a1f580e1c"}}},{"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-14T01:19:40.618Z\",\"zohoId\":\"4280752000001355501\",\"_id\":\"3bb17bc8-937a-47ea-8eb1-e891f2c2cefd\",\"_createdDate\":\"2020-02-14T01:19:40.972Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T01:19:40.972Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Vacuum Cleaner 1\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"1f661aa8-a204-489f-8cba-dfc5fe877d55\",\"item\":\"81bfdb1e-09ea-4b53-aaad-7b2263be8e1f\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T01:19:40.618Z\",\"zohoId\":\"4280752000001353488\",\"_id\":\"3bb17bc8-937a-47ea-8eb1-e891f2c2cefd\",\"_createdDate\":\"2019-10-29T22:24:03.595Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T01:19:50.883Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum Cleaner 2\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"1f661aa8-a204-489f-8cba-dfc5fe877d55\",\"item\":\"c1e5bd0a-2dc0-45e7-bf21-306c718b25c0\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T00:42:35.375Z\",\"zohoId\":\"4280752000003233033\",\"_id\":\"4e4d58f4-5981-4fd5-9f30-891362ba6c55\",\"_createdDate\":\"2020-02-14T00:42:35.610Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T00:45:03.180Z\",\"code\":\"2323\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Electric Scooter 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"b949caec-9c3a-4575-919b-f2586d8e76ad\",\"comments\":\"Sent to Zoho\",\"item\":\"22c3233e-85a1-493e-8f81-9cb3fc4934f5\",\"endTime\":\"2020-02-14T01:25:15.172Z\",\"total\":4},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T00:43:08.672Z\",\"zohoId\":\"4280752000003233017\",\"_id\":\"5b09b524-09aa-48a2-9817-839821b92d86\",\"_createdDate\":\"2020-02-14T00:43:08.911Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T00:45:03.180Z\",\"code\":\"2323\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b3503ff6-e1e9-43ab-9650-37e71584c164\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Electric Scooter 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"f4c35f25-aacb-4206-9e7f-3bd4edeff14e\",\"comments\":\"Sent to Zoho\",\"item\":\"ca58b5ce-d805-4f66-bda4-5ad509f36eeb\",\"endTime\":\"2020-02-14T01:25:21.641Z\",\"total\":4},{\"serial\":\"Vacuum 3\",\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2020-01-23T09:05:00.061Z\",\"_id\":\"308d34be-8901-46c4-a0db-27a518d45349\",\"_createdDate\":\"2020-01-23T09:05:00.471Z\",\"passDuration\":\"24,48\",\"price\":5,\"baseTime\":60,\"positionText\":\"\",\"baseCost\":5,\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:26.450Z\",\"total\":0,\"code\":\"\",\"endTime\":\"2020-01-23T09:07:39.177Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20,20\",\"position\":3,\"isOk\":true,\"title\":\"Vacuum 3\",\"room\":\"79c4d41a-0294-446b-b306-b0413963c9ac\",\"user\":\"7a8ffd14-b26c-4953-99df-07b60a1f2f6d\",\"item\":\"a334f789-be41-450a-80b4-7bf60649fc8c\",\"comments\":\"Sent to Zoho\"}]","updateId":"308d34be-8901-46c4-a0db-27a518d45349","_id":"ecaf24cf-82d8-4e24-aeb4-fe1a1f580e1c"}}}]

User not available