Fri Feb 14 2020 03:00:04 GMT+0000 (Coordinated Universal Time)

Msg: Error - sendToBigQuery
Info: ["run: sendToBigQuery",{"data Id":"f4aecdb6-5f8f-4622-81e9-c6f5447b8a5d"},{"method":"Insert"},{"res: getTableSchema":"ok"},"run: insertToTable","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",{"res: insertToTable":"ok"},{"res: upsertTable":"ok"},{"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-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-02-14T02:50:29.612Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:29.612Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Robot Mop 1\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:44.961Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Mop 2\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Printer TAU1\",\"ip\":\"a4f59581-f76e-b4c6-c901-a031d32a0b54\",\"isInRoom\":false,\"startTime\":\"2020-01-20T11:07:44.314Z\",\"_id\":\"b824fd9c-5ee2-43a0-9398-6a459235f537\",\"_createdDate\":\"2020-01-20T11:07:45.076Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:40:35.641Z\",\"total\":0.6,\"files\":\"[{\\\"label\\\":\\\"העצמה אישית וקבוצתית לאיחוד שלי, מרכז רותם.docx\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/6fdc68_5f5881740e3b49c4a577f9d29ba47da6.docx\\\",\\\"pageCount\\\":3}]\",\"code\":\"111\",\"endTime\":\"2020-01-20T11:07:45.843Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"isOk\":true,\"title\":\"Printer Doorms_Bike_Room\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"user\":\"b445aaf6-d9ac-478c-a459-d6fc6baa00e5\",\"item\":\"abf60330-d8b5-475c-b94d-f77f232a1719\",\"comments\":\"Sent to Zoho\"}]","updateId":"b824fd9c-5ee2-43a0-9398-6a459235f537","_id":"5a9e21f9-d94e-41c9-abb0-56d43e114bed"}}},{"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-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-02-14T02:50:29.612Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:29.612Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Robot Mop 1\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:44.961Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Mop 2\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Vacuum 1\",\"isInRoom\":false,\"startTime\":\"2020-01-20T10:22:56.655Z\",\"_id\":\"5fb73e6d-e46b-4db7-affa-e25a30d94f5c\",\"_createdDate\":\"2020-01-20T10:22:57.029Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:35.641Z\",\"total\":0,\"code\":\"00746\",\"endTime\":\"2020-01-20T10:25:12.950Z\",\"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\":\"69ec503d-5903-462d-8cde-403062dedf81\",\"item\":\"3e978b61-60da-4760-a1bc-2e6c92fe9688\",\"comments\":\"Sent to Zoho\"}]","updateId":"5fb73e6d-e46b-4db7-affa-e25a30d94f5c","_id":"5a9e21f9-d94e-41c9-abb0-56d43e114bed"}}},{"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-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-02-14T02:50:29.612Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:29.612Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Robot Mop 1\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:44.961Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Mop 2\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Vacuum 3\",\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2020-01-20T15:54:12.239Z\",\"_id\":\"5077b536-b1c2-4d96-9cd9-b5bc3af93f91\",\"_createdDate\":\"2020-01-20T15:54:12.586Z\",\"passDuration\":\"24,48\",\"price\":5,\"baseTime\":60,\"positionText\":\"\",\"baseCost\":5,\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:35.640Z\",\"total\":20,\"code\":\"\",\"endTime\":\"2020-01-21T12:00:02.609Z\",\"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":"5077b536-b1c2-4d96-9cd9-b5bc3af93f91","_id":"5a9e21f9-d94e-41c9-abb0-56d43e114bed"}}},{"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-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-02-14T02:50:29.612Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:29.612Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Robot Mop 1\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:44.961Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Mop 2\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Vacuum 3\",\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2020-01-20T11:11:00.902Z\",\"_id\":\"a6557802-9e3d-4617-970b-0ca2b4ef3c7f\",\"_createdDate\":\"2020-01-20T11:11:02.668Z\",\"passDuration\":\"4\",\"price\":5,\"baseTime\":30,\"positionText\":\"\",\"baseCost\":5,\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:35.641Z\",\"total\":5,\"code\":\"00554\",\"endTime\":\"2020-01-20T11:18:48.574Z\",\"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\":\"61d197f9-8611-4e7d-8f8d-326b5ef55298\",\"item\":\"42961a91-13f4-4989-91f5-87cba7d99b0e\",\"comments\":\"Sent to Zoho\"}]","updateId":"a6557802-9e3d-4617-970b-0ca2b4ef3c7f","_id":"5a9e21f9-d94e-41c9-abb0-56d43e114bed"}}},{"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-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-02-14T02:50:29.612Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:29.612Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Robot Mop 1\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:44.961Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Mop 2\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Vacuum 2\",\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2020-01-20T15:42:19.884Z\",\"_id\":\"33470ad9-d691-4439-a010-05d4034f2073\",\"_createdDate\":\"2020-01-20T15:42:20.368Z\",\"passDuration\":\"4\",\"price\":5,\"baseTime\":30,\"positionText\":\"\",\"baseCost\":5,\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:35.641Z\",\"total\":0,\"code\":\"00562\",\"endTime\":\"2020-01-20T15:42:36.182Z\",\"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\":\"bccbe34a-0f9b-4292-ba8f-f6973b56daef\",\"item\":\"c830bcf2-511a-4626-a237-2e9b9312eea9\",\"comments\":\"Sent to Zoho\"}]","updateId":"33470ad9-d691-4439-a010-05d4034f2073","_id":"5a9e21f9-d94e-41c9-abb0-56d43e114bed"}}},{"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-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-02-14T02:50:29.612Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:29.612Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Robot Mop 1\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:44.961Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Mop 2\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Printer2\",\"ip\":\"9a1b839b-e93a-d4ae-1421-aeec7bd94b2c\",\"isInRoom\":false,\"startTime\":\"2020-01-20T11:25:25.836Z\",\"_id\":\"bf3bdaf6-7c88-4968-9353-05d5430b1c03\",\"_createdDate\":\"2020-01-20T11:25:26.466Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:40:35.640Z\",\"files\":\"[{\\\"label\\\":\\\"Yahya Othman - CV.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/9feded_57c8901f169d4679b36bb346823d1a12.pdf\\\",\\\"pageCount\\\":3},{\\\"label\\\":\\\"Yahya Othman_AW 5 clean.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/e474e0_c64e09fd3e084b9cb543d550d5778121.pdf\\\",\\\"pageCount\\\":2}]\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"position\":\"2\",\"isOk\":true,\"title\":\"Printer2 EHS\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e474e0f5-fc67-4eb0-9020-c78444c9ddcf\",\"item\":\"a441821a-172d-4e0b-9541-c24fc4730ca0\",\"comments\":\"Sent to Zoho\"}]","updateId":"bf3bdaf6-7c88-4968-9353-05d5430b1c03","_id":"5a9e21f9-d94e-41c9-abb0-56d43e114bed"}}},{"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-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-02-14T02:50:29.612Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:29.612Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Robot Mop 1\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:44.961Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Mop 2\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Printer\",\"ip\":\"f5a95cff-02b6-61fe-f847-53cf4927ba54\",\"isInRoom\":false,\"startTime\":\"2020-01-20T10:20:03.261Z\",\"_id\":\"09210036-7fff-42f4-8330-c1b2cfd0f90d\",\"_createdDate\":\"2020-01-20T10:20:03.734Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:40:35.640Z\",\"total\":0.1,\"files\":\"[{\\\"label\\\":\\\"קבלה מונית.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/6da2b3_ae8fd568e3db4aba8c9db477481f1105.pdf\\\",\\\"pageCount\\\":1}]\",\"endTime\":\"2020-01-20T10:20:03.940Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"isOk\":true,\"title\":\"Printer Levontin\",\"room\":\"69852922-a287-45c6-81b1-41be6097320d\",\"user\":\"6da2b38e-5457-4a55-b281-e00713fc88eb\",\"item\":\"d373136a-dac1-4d41-a36d-70ed4f614e38\",\"comments\":\"Sent to Zoho\"}]","updateId":"09210036-7fff-42f4-8330-c1b2cfd0f90d","_id":"5a9e21f9-d94e-41c9-abb0-56d43e114bed"}}},{"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-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-02-14T02:50:29.612Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:29.612Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Robot Mop 1\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:44.961Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Mop 2\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Printer TAU1\",\"ip\":\"c6cdca1f-865c-4ec0-43c1-a8fead960de7\",\"isInRoom\":false,\"startTime\":\"2020-01-20T14:43:00.000Z\",\"_id\":\"a9af953e-2495-496a-9941-fcadcb22e3ab\",\"_createdDate\":\"2020-01-20T14:43:19.161Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:40:35.641Z\",\"total\":0,\"files\":\"[{\\\"label\\\":\\\"מטלה מסכמת חדו״א.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/ebc2e4_f9e32f48ca4043aa9b0836e277bb4253.pdf\\\",\\\"pageCount\\\":1}]\",\"endTime\":\"2020-01-20T14:51:46.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\":\"ebc2e421-ab1f-4580-a929-dde0340fcddf\",\"item\":\"569ae57a-a4ed-4645-b67c-a96da9f7a673\",\"comments\":\"Sent to Zoho\"}]","updateId":"a9af953e-2495-496a-9941-fcadcb22e3ab","_id":"5a9e21f9-d94e-41c9-abb0-56d43e114bed"}}},{"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-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-02-14T02:50:29.612Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:29.612Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Robot Mop 1\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:44.961Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Mop 2\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"***\",\"ip\":\"cdcdfc32-6e44-6c6f-f265-73211ca8b326\",\"isInRoom\":false,\"startTime\":\"2020-01-20T14:41:22.560Z\",\"_id\":\"2a8d80b9-4cb3-4941-b48e-c179ce57075a\",\"_createdDate\":\"2020-01-20T14:41:22.838Z\",\"passDuration\":\"-\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:40:35.640Z\",\"total\":0.1,\"files\":\"[{\\\"label\\\":\\\"pre-paid mailing label.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/0e9431_d425b66f022e4338923186dbd3b03f9d.pdf\\\",\\\"pageCount\\\":1}]\",\"endTime\":\"2020-01-20T14:41:23.039Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"passPrice\":\"-\",\"isOk\":true,\"title\":\"Printer\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"0e943113-f067-4bbd-923a-74ca49c9f251\",\"item\":\"be774ee3-9cf4-4804-b26a-5e771302f8eb\",\"comments\":\"Sent to Zoho\"}]","updateId":"2a8d80b9-4cb3-4941-b48e-c179ce57075a","_id":"5a9e21f9-d94e-41c9-abb0-56d43e114bed"}}},{"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-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-02-14T02:50:29.612Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:29.612Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Robot Mop 1\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:44.961Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Mop 2\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Printer2\",\"ip\":\"9a1b839b-e93a-d4ae-1421-aeec7bd94b2c\",\"isInRoom\":false,\"startTime\":\"2020-01-20T11:25:25.404Z\",\"_id\":\"caf3b081-39a1-4534-95e5-86df62883dec\",\"_createdDate\":\"2020-01-20T11:25:26.051Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:40:35.640Z\",\"total\":0.5,\"files\":\"[{\\\"label\\\":\\\"Yahya Othman - CV.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/9feded_57c8901f169d4679b36bb346823d1a12.pdf\\\",\\\"pageCount\\\":3},{\\\"label\\\":\\\"Yahya Othman_AW 5 clean.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/e474e0_c64e09fd3e084b9cb543d550d5778121.pdf\\\",\\\"pageCount\\\":2}]\",\"endTime\":\"2020-01-20T11:25:26.653Z\",\"rating\":1,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"position\":\"2\",\"isOk\":true,\"title\":\"Printer2 EHS\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e474e0f5-fc67-4eb0-9020-c78444c9ddcf\",\"item\":\"a441821a-172d-4e0b-9541-c24fc4730ca0\",\"comments\":\"Sent to Zoho\"}]","updateId":"caf3b081-39a1-4534-95e5-86df62883dec","_id":"5a9e21f9-d94e-41c9-abb0-56d43e114bed"}}},{"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-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-02-14T02:50:29.612Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:29.612Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Robot Mop 1\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:44.961Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Mop 2\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Printer TAU1\",\"ip\":\"c6cdca1f-865c-4ec0-43c1-a8fead960de7\",\"isInRoom\":false,\"startTime\":\"2020-01-20T14:37:06.599Z\",\"_id\":\"82c3bd15-c69f-439f-a7ba-17825df8d8b9\",\"_createdDate\":\"2020-01-20T14:37:07.161Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:40:35.640Z\",\"total\":0.3,\"files\":\"[{\\\"label\\\":\\\"מטלה מסכמת חדו״א.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/ebc2e4_e03a09bf937946769c8843538a5a47fc.pdf\\\",\\\"pageCount\\\":1}]\",\"endTime\":\"2020-01-20T14:37:07.962Z\",\"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\":\"ebc2e421-ab1f-4580-a929-dde0340fcddf\",\"item\":\"569ae57a-a4ed-4645-b67c-a96da9f7a673\",\"comments\":\"Sent to Zoho\"}]","updateId":"82c3bd15-c69f-439f-a7ba-17825df8d8b9","_id":"5a9e21f9-d94e-41c9-abb0-56d43e114bed"}}},{"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-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-02-14T02:50:29.612Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:29.612Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Robot Mop 1\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:44.961Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Mop 2\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Football\",\"isInRoom\":false,\"startTime\":\"2020-01-20T15:28:32.392Z\",\"_id\":\"42710b98-1d25-442e-ac81-cb606bcbe2a7\",\"_createdDate\":\"2020-01-20T15:28:33.009Z\",\"passDuration\":\"24,48\",\"baseTime\":\"60\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:35.641Z\",\"total\":2,\"endTime\":\"2020-01-20T15:59:50.049Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"2366dbbb-5db2-4ca8-b066-24c4b1762078\",\"passPrice\":\"10,20\",\"isOk\":true,\"title\":\"Football\",\"room\":\"79c4d41a-0294-446b-b306-b0413963c9ac\",\"user\":\"d0596b40-4327-4f68-966a-07846a491ab4\",\"item\":\"476805d7-bf0e-4793-8c57-0195f8497f0c\",\"comments\":\"Sent to Zoho\"}]","updateId":"42710b98-1d25-442e-ac81-cb606bcbe2a7","_id":"5a9e21f9-d94e-41c9-abb0-56d43e114bed"}}},{"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-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-02-14T02:50:29.612Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:29.612Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Robot Mop 1\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:44.961Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Mop 2\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Printer\",\"ip\":\"f5a95cff-02b6-61fe-f847-53cf4927ba54\",\"isInRoom\":false,\"startTime\":\"2020-01-20T10:11:55.058Z\",\"_id\":\"93df49db-5714-4b16-b6b1-de3b88f376ef\",\"_createdDate\":\"2020-01-20T10:11:55.571Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:40:35.640Z\",\"total\":0.1,\"files\":\"[{\\\"label\\\":\\\"קבלה מונית.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/6da2b3_df396df6a8af405e9760fe2d70140a10.pdf\\\",\\\"pageCount\\\":1}]\",\"endTime\":\"2020-01-20T10:11:55.757Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"isOk\":true,\"title\":\"Printer Levontin\",\"room\":\"69852922-a287-45c6-81b1-41be6097320d\",\"user\":\"6da2b38e-5457-4a55-b281-e00713fc88eb\",\"item\":\"d373136a-dac1-4d41-a36d-70ed4f614e38\",\"comments\":\"Sent to Zoho\"}]","updateId":"93df49db-5714-4b16-b6b1-de3b88f376ef","_id":"5a9e21f9-d94e-41c9-abb0-56d43e114bed"}}},{"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-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-02-14T02:50:29.612Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:29.612Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Robot Mop 1\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:44.961Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Mop 2\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Vacuum 2\",\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2020-01-20T12:13:35.948Z\",\"_id\":\"a2a05dd1-1a76-42e0-ad9e-fd5b788a727f\",\"_createdDate\":\"2020-01-20T12:13:36.451Z\",\"passDuration\":\"24,48\",\"price\":5,\"baseTime\":60,\"positionText\":\"\",\"baseCost\":5,\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:35.641Z\",\"total\":20,\"code\":\"\",\"endTime\":\"2020-01-20T15:52:53.475Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20,20\",\"position\":2,\"isOk\":true,\"title\":\"Vacuum 2\",\"room\":\"79c4d41a-0294-446b-b306-b0413963c9ac\",\"user\":\"7a8ffd14-b26c-4953-99df-07b60a1f2f6d\",\"item\":\"bb92e0d1-7c5e-4999-9510-319af5e3d34b\",\"comments\":\"Sent to Zoho\"}]","updateId":"a2a05dd1-1a76-42e0-ad9e-fd5b788a727f","_id":"5a9e21f9-d94e-41c9-abb0-56d43e114bed"}}},{"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-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-02-14T02:50:29.612Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:29.612Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Robot Mop 1\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:44.961Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Mop 2\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-02-14T02:50:29.612Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:45.009Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Mop 2\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\",\"comments\":\"Sent to Zoho\"}]","updateId":"01f5a049-4281-459e-a5e7-1695e03b6aff","_id":"5a9e21f9-d94e-41c9-abb0-56d43e114bed"}}},{"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-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-02-14T02:50:29.612Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:29.612Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Robot Mop 1\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:44.961Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Mop 2\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Vacuum 2\",\"isInRoom\":false,\"startTime\":\"2020-01-20T08:29:39.037Z\",\"_id\":\"f4aecdb6-5f8f-4622-81e9-c6f5447b8a5d\",\"_createdDate\":\"2020-01-20T08:29:39.233Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:35.641Z\",\"total\":5,\"endTime\":\"2020-01-20T08:36:37.006Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum 2\",\"room\":\"69852922-a287-45c6-81b1-41be6097320d\",\"user\":\"e8d11c29-e30e-4866-acba-8c0ec576ea92\",\"item\":\"0324bc08-69a5-4705-b280-509011f2b18f\",\"comments\":\"Sent to Zoho\"}]","updateId":"f4aecdb6-5f8f-4622-81e9-c6f5447b8a5d","_id":"5a9e21f9-d94e-41c9-abb0-56d43e114bed"}}},{"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-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-02-14T02:50:29.612Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:29.612Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Robot Mop 1\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T02:50:29.410Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"01f5a049-4281-459e-a5e7-1695e03b6aff\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T02:50:44.961Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Mop 2\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"76589d44-e7ab-48f9-a762-2335f59e03fe\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Printer TAU1\",\"ip\":\"c6cdca1f-865c-4ec0-43c1-a8fead960de7\",\"isInRoom\":false,\"startTime\":\"2020-01-20T14:31:43.404Z\",\"_id\":\"32c3ab34-d780-4727-bf17-30c321e1a2da\",\"_createdDate\":\"2020-01-20T14:31:44.055Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:40:35.641Z\",\"total\":0.3,\"files\":\"[{\\\"label\\\":\\\"מטלה מסכמת חדו״א 2.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/ebc2e4_40f694d049014f948226c9897c976979.pdf\\\",\\\"pageCount\\\":1}]\",\"endTime\":\"2020-01-20T14:31:44.960Z\",\"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\":\"ebc2e421-ab1f-4580-a929-dde0340fcddf\",\"item\":\"569ae57a-a4ed-4645-b67c-a96da9f7a673\",\"comments\":\"Sent to Zoho\"}]","updateId":"32c3ab34-d780-4727-bf17-30c321e1a2da","_id":"5a9e21f9-d94e-41c9-abb0-56d43e114bed"}}}]

User not available