Thu Feb 13 2020 23:15:05 GMT+0000 (Coordinated Universal Time)

Msg: Error - sendToBigQuery
Info: ["run: sendToBigQuery",{"data Id":"4427d430-3977-43cc-8d8e-7a8cc37bb5d2"},{"method":"Insert"},"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: 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-01-26T16:26:58.000Z\",\"_id\":\"f343ff96-980e-48ff-a2e5-17212fa99c8d\",\"_createdDate\":\"2020-01-26T16:26:59.181Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:00:01.601Z\",\"total\":null,\"endTime\":\"2020-01-26T16:27:40.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"c9653637-a4a4-4697-9a07-d24ec6dcb693\",\"passPrice\":\"12\",\"isOk\":true,\"title\":\"REI\",\"room\":\"3aa51b21-0757-46b7-841c-7288a72cff1c\",\"user\":\"b5b1410f-3259-48df-8e70-2f5ac55d571c\",\"comments\":\"Sent to Zoho\",\"item\":\"801c8b38-857c-456e-86b0-de7082710a1c\",\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003657460\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-01-26T16:10:47.000Z\",\"_id\":\"8fc488b3-b736-4aac-918f-f6f97e98fb86\",\"_createdDate\":\"2020-01-26T16:10:47.739Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:00:01.601Z\",\"total\":\"6\",\"code\":\"2323\",\"endTime\":\"2020-01-26T17:25:13.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e3f8a229-e0a3-46b6-a813-6282f442db81\",\"passPrice\":\"12\",\"position\":\"4\",\"isOk\":true,\"title\":\"Electric Scooter 4\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"337e7062-27fd-4430-9979-b03d2c485927\",\"comments\":\"Sent to Zoho\",\"item\":\"2e2e3a91-e6bf-4389-9d87-771b3d09c912\",\"rating\":null,\"rentZohoId\":\"4280752000003652479\"},{\"serial\":\"Printer1\",\"ip\":\"fabb36f8-7c44-ecb0-09dc-59b4d4b6a5cd\",\"isInRoom\":false,\"startTime\":\"2020-01-26T16:26:58.000Z\",\"_id\":\"abc7b45f-8f35-4850-8b7b-ffcda54e1f86\",\"_createdDate\":\"2020-01-26T16:26:59.091Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-13T23:00:01.601Z\",\"total\":\"0.3\",\"files\":\"[{\\\"label\\\":\\\"AAAA.docx\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/7f176c_45f73130b6514affa3a35803b7df858b.docx\\\",\\\"pageCount\\\":1}]\",\"endTime\":\"2020-01-26T16:26:59.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"position\":\"1\",\"isOk\":true,\"title\":\"Printer1 EHS\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"2b5ac9fc-cf28-44a0-adbb-d25504c25182\",\"comments\":\"Sent to Zoho\",\"item\":\"f09a60f2-b63d-4e2d-bd97-7d83d2b9a9f2\",\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003658516\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-01-26T17:05:42.000Z\",\"_id\":\"45bc630d-6e5d-4be0-8b23-d125c9e14855\",\"_createdDate\":\"2020-01-26T17:05:42.792Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:00:01.601Z\",\"total\":null,\"endTime\":\"2020-01-26T17:09:27.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b5e02ca1-4536-47ba-ae5c-e06f56f1b87c\",\"passPrice\":\"12\",\"isOk\":true,\"title\":\"Steamer\",\"room\":\"3aa51b21-0757-46b7-841c-7288a72cff1c\",\"user\":\"b5b1410f-3259-48df-8e70-2f5ac55d571c\",\"comments\":\"Sent to Zoho\",\"item\":\"a40bad66-c825-4460-9c88-eac671d8c1d1\",\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003652477\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T21:24:38.000Z\",\"zohoId\":\"4280752000001364745\",\"_id\":\"0bdfb427-5d61-4c4e-8173-58993c54a2df\",\"_createdDate\":\"2020-02-13T21:24:39.208Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"rentZohoId\":\"4280752000003645367\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T21:30:01.884Z\",\"total\":8,\"code\":null,\"endTime\":\"2020-02-13T23:06:05.377Z\",\"rating\":null,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"374cb43e-f3fd-40ce-bc5c-88deb49ad2d8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Vacuum 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"2ed2ac80-7637-46de-936a-9eb9fe51df66\",\"comments\":\"Sent to Zoho\",\"item\":\"552db4d6-efbb-4157-80a7-4821714d5bd4\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T23:07:00.917Z\",\"zohoId\":\"4280752000001353558\",\"_id\":\"0b4ff67a-72fa-4ba0-b686-cf4884f6fca2\",\"_createdDate\":\"2020-02-13T23:07:01.139Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:07:01.139Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b28e3aa1-6fc9-43ef-9d58-cec6a62c5d9b\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Robot Mop 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"03ec12c6-dab2-4091-b8cb-92217c9be6f4\",\"item\":\"85487031-221f-4522-be58-2f465cffed6c\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T23:07:00.000Z\",\"zohoId\":\"4280752000001353558\",\"_id\":\"0b4ff67a-72fa-4ba0-b686-cf4884f6fca2\",\"_createdDate\":\"2020-02-13T23:07:01.139Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:07:01.139Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b28e3aa1-6fc9-43ef-9d58-cec6a62c5d9b\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Robot Mop 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"03ec12c6-dab2-4091-b8cb-92217c9be6f4\",\"item\":\"85487031-221f-4522-be58-2f465cffed6c\",\"endTime\":null,\"total\":null,\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003650428\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T22:57:28.000Z\",\"zohoId\":\"4280752000001355593\",\"_id\":\"133f6907-69be-4b25-97c0-d36a19fd4d7f\",\"_createdDate\":\"2020-02-13T22:57:28.382Z\",\"passDuration\":\"4\",\"price\":-5,\"baseTime\":\"30\",\"rentZohoId\":\"4280752000003647560\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:00:01.601Z\",\"total\":2,\"code\":null,\"endTime\":\"2020-02-13T23:09:55.666Z\",\"rating\":null,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum Cleaner 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"61b5c99b-c5d5-4ed3-acdc-965e8d0ef0a6\",\"comments\":\"Sent to Zoho\",\"item\":\"bd6588c7-ea46-4fdf-a539-055214970550\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T22:57:28.000Z\",\"zohoId\":\"4280752000001355593\",\"_id\":\"133f6907-69be-4b25-97c0-d36a19fd4d7f\",\"_createdDate\":\"2020-02-13T22:57:28.382Z\",\"passDuration\":\"4\",\"price\":-5,\"baseTime\":\"30\",\"rentZohoId\":\"4280752000003647560\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:09:55.816Z\",\"total\":2,\"code\":null,\"endTime\":\"2020-02-13T23:09:55.666Z\",\"rating\":5,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum Cleaner 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"61b5c99b-c5d5-4ed3-acdc-965e8d0ef0a6\",\"comments\":\"Sent to Zoho\",\"item\":\"bd6588c7-ea46-4fdf-a539-055214970550\"},{\"serial\":\"Printer TAU1\",\"ip\":\"a4f59581-f76e-b4c6-c901-a031d32a0b54\",\"isInRoom\":false,\"startTime\":\"2020-01-26T12:19:21.364Z\",\"_id\":\"cbf997b8-6805-4f45-861a-3588b70f6d43\",\"_createdDate\":\"2020-01-26T12:19:21.816Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:39:43.280Z\",\"total\":0.1,\"files\":\"[{\\\"label\\\":\\\"february-2020-calendar-holidays-blank-landscape.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/35270f_9f636b3d2ecd400cae6683efde80f0b0.pdf\\\",\\\"pageCount\\\":1}]\",\"code\":\"111\",\"endTime\":\"2020-01-26T12:19:22.595Z\",\"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\":\"35270ff6-133c-4908-8cda-acbb10a24667\",\"item\":\"abf60330-d8b5-475c-b94d-f77f232a1719\",\"comments\":\"Sent to Zoho\"},{\"serial\":\"Vacuum 1\",\"isInRoom\":false,\"startTime\":\"2020-01-26T13:47:08.000Z\",\"_id\":\"06582964-b18f-44ea-b7aa-ac8535bae344\",\"_createdDate\":\"2020-01-26T13:47:08.609Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:15:01.818Z\",\"total\":null,\"code\":\"00365\",\"endTime\":\"2020-01-26T13:51:51.000Z\",\"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\":\"34db1c44-301c-4d90-83fe-319ef00892ee\",\"comments\":\"Sent to Zoho\",\"item\":\"3e978b61-60da-4760-a1bc-2e6c92fe9688\",\"rating\":null,\"rentZohoId\":\"4280752000003650512\"}]","updateId":"06582964-b18f-44ea-b7aa-ac8535bae344","_id":"687b0cb8-620e-4d44-bcff-5dc49e6dc327"}}},{"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-01-26T16:26:58.000Z\",\"_id\":\"f343ff96-980e-48ff-a2e5-17212fa99c8d\",\"_createdDate\":\"2020-01-26T16:26:59.181Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:00:01.601Z\",\"total\":null,\"endTime\":\"2020-01-26T16:27:40.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"c9653637-a4a4-4697-9a07-d24ec6dcb693\",\"passPrice\":\"12\",\"isOk\":true,\"title\":\"REI\",\"room\":\"3aa51b21-0757-46b7-841c-7288a72cff1c\",\"user\":\"b5b1410f-3259-48df-8e70-2f5ac55d571c\",\"comments\":\"Sent to Zoho\",\"item\":\"801c8b38-857c-456e-86b0-de7082710a1c\",\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003657460\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-01-26T16:10:47.000Z\",\"_id\":\"8fc488b3-b736-4aac-918f-f6f97e98fb86\",\"_createdDate\":\"2020-01-26T16:10:47.739Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:00:01.601Z\",\"total\":\"6\",\"code\":\"2323\",\"endTime\":\"2020-01-26T17:25:13.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e3f8a229-e0a3-46b6-a813-6282f442db81\",\"passPrice\":\"12\",\"position\":\"4\",\"isOk\":true,\"title\":\"Electric Scooter 4\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"337e7062-27fd-4430-9979-b03d2c485927\",\"comments\":\"Sent to Zoho\",\"item\":\"2e2e3a91-e6bf-4389-9d87-771b3d09c912\",\"rating\":null,\"rentZohoId\":\"4280752000003652479\"},{\"serial\":\"Printer1\",\"ip\":\"fabb36f8-7c44-ecb0-09dc-59b4d4b6a5cd\",\"isInRoom\":false,\"startTime\":\"2020-01-26T16:26:58.000Z\",\"_id\":\"abc7b45f-8f35-4850-8b7b-ffcda54e1f86\",\"_createdDate\":\"2020-01-26T16:26:59.091Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-13T23:00:01.601Z\",\"total\":\"0.3\",\"files\":\"[{\\\"label\\\":\\\"AAAA.docx\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/7f176c_45f73130b6514affa3a35803b7df858b.docx\\\",\\\"pageCount\\\":1}]\",\"endTime\":\"2020-01-26T16:26:59.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"position\":\"1\",\"isOk\":true,\"title\":\"Printer1 EHS\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"2b5ac9fc-cf28-44a0-adbb-d25504c25182\",\"comments\":\"Sent to Zoho\",\"item\":\"f09a60f2-b63d-4e2d-bd97-7d83d2b9a9f2\",\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003658516\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-01-26T17:05:42.000Z\",\"_id\":\"45bc630d-6e5d-4be0-8b23-d125c9e14855\",\"_createdDate\":\"2020-01-26T17:05:42.792Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:00:01.601Z\",\"total\":null,\"endTime\":\"2020-01-26T17:09:27.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b5e02ca1-4536-47ba-ae5c-e06f56f1b87c\",\"passPrice\":\"12\",\"isOk\":true,\"title\":\"Steamer\",\"room\":\"3aa51b21-0757-46b7-841c-7288a72cff1c\",\"user\":\"b5b1410f-3259-48df-8e70-2f5ac55d571c\",\"comments\":\"Sent to Zoho\",\"item\":\"a40bad66-c825-4460-9c88-eac671d8c1d1\",\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003652477\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T21:24:38.000Z\",\"zohoId\":\"4280752000001364745\",\"_id\":\"0bdfb427-5d61-4c4e-8173-58993c54a2df\",\"_createdDate\":\"2020-02-13T21:24:39.208Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"rentZohoId\":\"4280752000003645367\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T21:30:01.884Z\",\"total\":8,\"code\":null,\"endTime\":\"2020-02-13T23:06:05.377Z\",\"rating\":null,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"374cb43e-f3fd-40ce-bc5c-88deb49ad2d8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Vacuum 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"2ed2ac80-7637-46de-936a-9eb9fe51df66\",\"comments\":\"Sent to Zoho\",\"item\":\"552db4d6-efbb-4157-80a7-4821714d5bd4\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T23:07:00.917Z\",\"zohoId\":\"4280752000001353558\",\"_id\":\"0b4ff67a-72fa-4ba0-b686-cf4884f6fca2\",\"_createdDate\":\"2020-02-13T23:07:01.139Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:07:01.139Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b28e3aa1-6fc9-43ef-9d58-cec6a62c5d9b\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Robot Mop 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"03ec12c6-dab2-4091-b8cb-92217c9be6f4\",\"item\":\"85487031-221f-4522-be58-2f465cffed6c\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T23:07:00.000Z\",\"zohoId\":\"4280752000001353558\",\"_id\":\"0b4ff67a-72fa-4ba0-b686-cf4884f6fca2\",\"_createdDate\":\"2020-02-13T23:07:01.139Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:07:01.139Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b28e3aa1-6fc9-43ef-9d58-cec6a62c5d9b\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Robot Mop 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"03ec12c6-dab2-4091-b8cb-92217c9be6f4\",\"item\":\"85487031-221f-4522-be58-2f465cffed6c\",\"endTime\":null,\"total\":null,\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003650428\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T22:57:28.000Z\",\"zohoId\":\"4280752000001355593\",\"_id\":\"133f6907-69be-4b25-97c0-d36a19fd4d7f\",\"_createdDate\":\"2020-02-13T22:57:28.382Z\",\"passDuration\":\"4\",\"price\":-5,\"baseTime\":\"30\",\"rentZohoId\":\"4280752000003647560\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:00:01.601Z\",\"total\":2,\"code\":null,\"endTime\":\"2020-02-13T23:09:55.666Z\",\"rating\":null,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum Cleaner 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"61b5c99b-c5d5-4ed3-acdc-965e8d0ef0a6\",\"comments\":\"Sent to Zoho\",\"item\":\"bd6588c7-ea46-4fdf-a539-055214970550\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T22:57:28.000Z\",\"zohoId\":\"4280752000001355593\",\"_id\":\"133f6907-69be-4b25-97c0-d36a19fd4d7f\",\"_createdDate\":\"2020-02-13T22:57:28.382Z\",\"passDuration\":\"4\",\"price\":-5,\"baseTime\":\"30\",\"rentZohoId\":\"4280752000003647560\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:09:55.816Z\",\"total\":2,\"code\":null,\"endTime\":\"2020-02-13T23:09:55.666Z\",\"rating\":5,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum Cleaner 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"61b5c99b-c5d5-4ed3-acdc-965e8d0ef0a6\",\"comments\":\"Sent to Zoho\",\"item\":\"bd6588c7-ea46-4fdf-a539-055214970550\"},{\"serial\":\"Printer TAU1\",\"ip\":\"a4f59581-f76e-b4c6-c901-a031d32a0b54\",\"isInRoom\":false,\"startTime\":\"2020-01-26T12:19:21.364Z\",\"_id\":\"cbf997b8-6805-4f45-861a-3588b70f6d43\",\"_createdDate\":\"2020-01-26T12:19:21.816Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:39:43.280Z\",\"total\":0.1,\"files\":\"[{\\\"label\\\":\\\"february-2020-calendar-holidays-blank-landscape.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/35270f_9f636b3d2ecd400cae6683efde80f0b0.pdf\\\",\\\"pageCount\\\":1}]\",\"code\":\"111\",\"endTime\":\"2020-01-26T12:19:22.595Z\",\"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\":\"35270ff6-133c-4908-8cda-acbb10a24667\",\"item\":\"abf60330-d8b5-475c-b94d-f77f232a1719\",\"comments\":\"Sent to Zoho\"},{\"serial\":\"Printer TAU1\",\"ip\":\"c6cdca1f-865c-4ec0-43c1-a8fead960de7\",\"isInRoom\":false,\"startTime\":\"2020-01-26T14:57:14.000Z\",\"_id\":\"1cc330df-a90c-4cdb-a690-d71b21541e16\",\"_createdDate\":\"2020-01-26T14:57:14.741Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-13T23:15:01.818Z\",\"total\":\"1.6\",\"files\":\"[{\\\"label\\\":\\\"מבוא לתכנות מערכות - תרגיל בית 4.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/7de66c_079c14309898492d92a99219b61eea2c.pdf\\\",\\\"pageCount\\\":16}]\",\"endTime\":\"2020-01-26T14:57:15.000Z\",\"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\",\"comments\":\"Sent to Zoho\",\"item\":\"569ae57a-a4ed-4645-b67c-a96da9f7a673\",\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003652631\"},{\"serial\":\"Printer TAU1\",\"ip\":\"c6cdca1f-865c-4ec0-43c1-a8fead960de7\",\"isInRoom\":false,\"startTime\":\"2020-01-26T14:19:08.000Z\",\"_id\":\"ee4a5a7a-cdd4-48b1-b72a-e4c0d7127b81\",\"_createdDate\":\"2020-01-26T14:19:08.807Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-13T23:15:01.818Z\",\"total\":\"0.4\",\"files\":\"[{\\\"label\\\":\\\"עבודות בביצוע - שאלה ממבחן_f167a276f8f7c5139f53bfcfd85d9d65.PDF\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/978983_c2ae33100bf24631a6ef2d2443b1dc84.pdf\\\",\\\"pageCount\\\":4}]\",\"endTime\":\"2020-01-26T14:19:09.000Z\",\"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\":\"8716b16c-01fa-45bc-b544-1f0fed5171f3\",\"comments\":\"Sent to Zoho\",\"item\":\"569ae57a-a4ed-4645-b67c-a96da9f7a673\",\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003652624\"}]","updateId":"ee4a5a7a-cdd4-48b1-b72a-e4c0d7127b81","_id":"687b0cb8-620e-4d44-bcff-5dc49e6dc327"}}},{"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-01-26T16:26:58.000Z\",\"_id\":\"f343ff96-980e-48ff-a2e5-17212fa99c8d\",\"_createdDate\":\"2020-01-26T16:26:59.181Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:00:01.601Z\",\"total\":null,\"endTime\":\"2020-01-26T16:27:40.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"c9653637-a4a4-4697-9a07-d24ec6dcb693\",\"passPrice\":\"12\",\"isOk\":true,\"title\":\"REI\",\"room\":\"3aa51b21-0757-46b7-841c-7288a72cff1c\",\"user\":\"b5b1410f-3259-48df-8e70-2f5ac55d571c\",\"comments\":\"Sent to Zoho\",\"item\":\"801c8b38-857c-456e-86b0-de7082710a1c\",\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003657460\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-01-26T16:10:47.000Z\",\"_id\":\"8fc488b3-b736-4aac-918f-f6f97e98fb86\",\"_createdDate\":\"2020-01-26T16:10:47.739Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:00:01.601Z\",\"total\":\"6\",\"code\":\"2323\",\"endTime\":\"2020-01-26T17:25:13.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e3f8a229-e0a3-46b6-a813-6282f442db81\",\"passPrice\":\"12\",\"position\":\"4\",\"isOk\":true,\"title\":\"Electric Scooter 4\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"337e7062-27fd-4430-9979-b03d2c485927\",\"comments\":\"Sent to Zoho\",\"item\":\"2e2e3a91-e6bf-4389-9d87-771b3d09c912\",\"rating\":null,\"rentZohoId\":\"4280752000003652479\"},{\"serial\":\"Printer1\",\"ip\":\"fabb36f8-7c44-ecb0-09dc-59b4d4b6a5cd\",\"isInRoom\":false,\"startTime\":\"2020-01-26T16:26:58.000Z\",\"_id\":\"abc7b45f-8f35-4850-8b7b-ffcda54e1f86\",\"_createdDate\":\"2020-01-26T16:26:59.091Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-13T23:00:01.601Z\",\"total\":\"0.3\",\"files\":\"[{\\\"label\\\":\\\"AAAA.docx\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/7f176c_45f73130b6514affa3a35803b7df858b.docx\\\",\\\"pageCount\\\":1}]\",\"endTime\":\"2020-01-26T16:26:59.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"position\":\"1\",\"isOk\":true,\"title\":\"Printer1 EHS\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"2b5ac9fc-cf28-44a0-adbb-d25504c25182\",\"comments\":\"Sent to Zoho\",\"item\":\"f09a60f2-b63d-4e2d-bd97-7d83d2b9a9f2\",\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003658516\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-01-26T17:05:42.000Z\",\"_id\":\"45bc630d-6e5d-4be0-8b23-d125c9e14855\",\"_createdDate\":\"2020-01-26T17:05:42.792Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:00:01.601Z\",\"total\":null,\"endTime\":\"2020-01-26T17:09:27.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"b5e02ca1-4536-47ba-ae5c-e06f56f1b87c\",\"passPrice\":\"12\",\"isOk\":true,\"title\":\"Steamer\",\"room\":\"3aa51b21-0757-46b7-841c-7288a72cff1c\",\"user\":\"b5b1410f-3259-48df-8e70-2f5ac55d571c\",\"comments\":\"Sent to Zoho\",\"item\":\"a40bad66-c825-4460-9c88-eac671d8c1d1\",\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003652477\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T21:24:38.000Z\",\"zohoId\":\"4280752000001364745\",\"_id\":\"0bdfb427-5d61-4c4e-8173-58993c54a2df\",\"_createdDate\":\"2020-02-13T21:24:39.208Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"rentZohoId\":\"4280752000003645367\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T21:30:01.884Z\",\"total\":8,\"code\":null,\"endTime\":\"2020-02-13T23:06:05.377Z\",\"rating\":null,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"374cb43e-f3fd-40ce-bc5c-88deb49ad2d8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Vacuum 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"2ed2ac80-7637-46de-936a-9eb9fe51df66\",\"comments\":\"Sent to Zoho\",\"item\":\"552db4d6-efbb-4157-80a7-4821714d5bd4\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T23:07:00.917Z\",\"zohoId\":\"4280752000001353558\",\"_id\":\"0b4ff67a-72fa-4ba0-b686-cf4884f6fca2\",\"_createdDate\":\"2020-02-13T23:07:01.139Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:07:01.139Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b28e3aa1-6fc9-43ef-9d58-cec6a62c5d9b\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Robot Mop 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"03ec12c6-dab2-4091-b8cb-92217c9be6f4\",\"item\":\"85487031-221f-4522-be58-2f465cffed6c\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T23:07:00.000Z\",\"zohoId\":\"4280752000001353558\",\"_id\":\"0b4ff67a-72fa-4ba0-b686-cf4884f6fca2\",\"_createdDate\":\"2020-02-13T23:07:01.139Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:07:01.139Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"b28e3aa1-6fc9-43ef-9d58-cec6a62c5d9b\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Robot Mop 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"03ec12c6-dab2-4091-b8cb-92217c9be6f4\",\"item\":\"85487031-221f-4522-be58-2f465cffed6c\",\"endTime\":null,\"total\":null,\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003650428\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T22:57:28.000Z\",\"zohoId\":\"4280752000001355593\",\"_id\":\"133f6907-69be-4b25-97c0-d36a19fd4d7f\",\"_createdDate\":\"2020-02-13T22:57:28.382Z\",\"passDuration\":\"4\",\"price\":-5,\"baseTime\":\"30\",\"rentZohoId\":\"4280752000003647560\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:00:01.601Z\",\"total\":2,\"code\":null,\"endTime\":\"2020-02-13T23:09:55.666Z\",\"rating\":null,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum Cleaner 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"61b5c99b-c5d5-4ed3-acdc-965e8d0ef0a6\",\"comments\":\"Sent to Zoho\",\"item\":\"bd6588c7-ea46-4fdf-a539-055214970550\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T22:57:28.000Z\",\"zohoId\":\"4280752000001355593\",\"_id\":\"133f6907-69be-4b25-97c0-d36a19fd4d7f\",\"_createdDate\":\"2020-02-13T22:57:28.382Z\",\"passDuration\":\"4\",\"price\":-5,\"baseTime\":\"30\",\"rentZohoId\":\"4280752000003647560\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:09:55.816Z\",\"total\":2,\"code\":null,\"endTime\":\"2020-02-13T23:09:55.666Z\",\"rating\":5,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum Cleaner 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"61b5c99b-c5d5-4ed3-acdc-965e8d0ef0a6\",\"comments\":\"Sent to Zoho\",\"item\":\"bd6588c7-ea46-4fdf-a539-055214970550\"},{\"serial\":\"Printer TAU1\",\"ip\":\"a4f59581-f76e-b4c6-c901-a031d32a0b54\",\"isInRoom\":false,\"startTime\":\"2020-01-26T12:19:21.364Z\",\"_id\":\"cbf997b8-6805-4f45-861a-3588b70f6d43\",\"_createdDate\":\"2020-01-26T12:19:21.816Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:39:43.280Z\",\"total\":0.1,\"files\":\"[{\\\"label\\\":\\\"february-2020-calendar-holidays-blank-landscape.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/35270f_9f636b3d2ecd400cae6683efde80f0b0.pdf\\\",\\\"pageCount\\\":1}]\",\"code\":\"111\",\"endTime\":\"2020-01-26T12:19:22.595Z\",\"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\":\"35270ff6-133c-4908-8cda-acbb10a24667\",\"item\":\"abf60330-d8b5-475c-b94d-f77f232a1719\",\"comments\":\"Sent to Zoho\"},{\"serial\":\"Printer TAU1\",\"ip\":\"c6cdca1f-865c-4ec0-43c1-a8fead960de7\",\"isInRoom\":false,\"startTime\":\"2020-01-26T13:24:11.000Z\",\"_id\":\"71ffc352-a234-4c84-ae4b-3cd37778ac92\",\"_createdDate\":\"2020-01-26T13:24:11.962Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-13T23:15:01.818Z\",\"total\":\"0.1\",\"files\":\"[{\\\"label\\\":\\\"כרטיס בהדפסה ביתית - מכבי סל (1).pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/e8d11c_16ede2cc103c4908bc223f54cd6ef382.pdf\\\",\\\"pageCount\\\":1}]\",\"endTime\":\"2020-01-26T13:24:12.000Z\",\"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\":\"e8d11c29-e30e-4866-acba-8c0ec576ea92\",\"comments\":\"Sent to Zoho\",\"item\":\"569ae57a-a4ed-4645-b67c-a96da9f7a673\",\"code\":null,\"rentZohoId\":\"4280752000003648599\"}]","updateId":"71ffc352-a234-4c84-ae4b-3cd37778ac92","_id":"687b0cb8-620e-4d44-bcff-5dc49e6dc327"}}}]

User not available