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

Msg: Error - sendToBigQuery
Info: ["run: sendToBigQuery",{"data Id":"3b029986-0da8-4f4c-8c4f-026c5a002c53"},{"method":"Insert"},"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":"[{\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2019-12-01T15:59:18.000Z\",\"email\":\"\",\"weekendPrice\":0,\"_id\":\"1a5b719c-bfaa-4648-8710-666705faeda8\",\"_createdDate\":\"2019-12-01T15:59:19.380Z\",\"price\":2,\"roomType\":\"smart\",\"maxUsageTime\":10,\"_updatedDate\":\"2020-02-14T23:15:02.858Z\",\"total\":null,\"code\":null,\"endTime\":\"2019-12-01T16:01:16.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"c3da9ecf-aaa8-4384-b724-fcf1758b43e8\",\"maxPrice\":0,\"position\":2,\"isOk\":true,\"title\":\"Windows Cleaning Robot 2\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"7e5a742d-cb6b-4438-8c5a-912016acca18\",\"reservationPrice\":0,\"comments\":\"Sent to Zoho\",\"item\":\"ce1e62c1-3648-418a-a4a7-1aa11a8d7d2d\",\"rating\":null,\"rentZohoId\":\"4280752000003780477\"},{\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2019-12-01T02:47:32.000Z\",\"email\":\"\",\"weekendPrice\":0,\"_id\":\"b728573f-6d14-43b6-a0f2-1d748c02ce9d\",\"_createdDate\":\"2019-12-01T02:47:33.291Z\",\"price\":2,\"roomType\":\"smart\",\"maxUsageTime\":10,\"_updatedDate\":\"2020-02-14T23:15:02.858Z\",\"total\":\"8\",\"code\":null,\"endTime\":\"2019-12-01T04:27:45.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"maxPrice\":0,\"position\":1,\"isOk\":true,\"title\":\"Vacuum Cleaner 1\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"3dcb7380-6ece-4be4-9ffd-333a3547c048\",\"reservationPrice\":0,\"comments\":\"Sent to Zoho\",\"item\":\"81bfdb1e-09ea-4b53-aaad-7b2263be8e1f\",\"rating\":null,\"rentZohoId\":\"4280752000003781201\"},{\"isInRoom\":false,\"startTime\":\"2019-12-01T11:14:32.000Z\",\"_id\":\"a03227db-e628-4be1-988b-f56de9107480\",\"_createdDate\":\"2019-12-01T11:14:33.679Z\",\"price\":5,\"roomType\":\"smart\",\"maxUsageTime\":3,\"_updatedDate\":\"2020-02-14T23:15:02.858Z\",\"total\":\"5\",\"code\":null,\"endTime\":\"2019-12-01T11:36:49.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"maxPrice\":null,\"position\":3,\"isOk\":true,\"title\":\"Vacuum 3\",\"room\":\"69852922-a287-45c6-81b1-41be6097320d\",\"user\":\"815317f9-75aa-4d13-9a53-aa7d5af5877c\",\"comments\":\"Sent to Zoho\",\"item\":\"3f66ddb6-8e3f-42ae-ba64-e8248376029f\",\"rating\":null,\"rentZohoId\":\"4280752000003770988\"},{\"isInRoom\":false,\"startTime\":\"2019-12-01T12:29:53.000Z\",\"_id\":\"a985dd1d-73db-4c3d-a660-7252561465fb\",\"_createdDate\":\"2019-12-01T12:29:54.009Z\",\"price\":2.5,\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T23:15:02.857Z\",\"total\":\"2.5\",\"code\":null,\"endTime\":\"2019-12-01T12:35:58.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"3ef7be44-a5f8-432a-8554-e7aadd8efc4f\",\"position\":3,\"isOk\":true,\"title\":\"Window Robot 3\",\"room\":\"79c4d41a-0294-446b-b306-b0413963c9ac\",\"user\":\"e8d11c29-e30e-4866-acba-8c0ec576ea92\",\"comments\":\"Sent to Zoho\",\"item\":\"c1004df2-2290-4f9a-8aba-67275e05781c\",\"rating\":null,\"rentZohoId\":\"4280752000003775641\"},{\"isInRoom\":false,\"startTime\":\"2019-12-01T12:20:21.000Z\",\"_id\":\"6c4bc181-dfd9-4d0c-bb6a-87739651a97c\",\"_createdDate\":\"2019-12-01T12:20:22.009Z\",\"price\":2.5,\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T23:15:02.858Z\",\"total\":\"2.5\",\"endTime\":\"2019-12-01T12:41:35.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"9be3eed6-9d05-485d-ae58-a331e55c06f4\",\"position\":1,\"isOk\":true,\"title\":\"Projector 1\",\"room\":\"79c4d41a-0294-446b-b306-b0413963c9ac\",\"user\":\"e8d11c29-e30e-4866-acba-8c0ec576ea92\",\"comments\":\"Sent to Zoho\",\"item\":\"e10616a6-6ba2-40ea-b566-a950df0dac43\",\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003783567\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T23:18:51.650Z\",\"zohoId\":\"4280752000001355593\",\"_id\":\"1255be62-e32b-4fa9-9f89-3f50242bcad9\",\"_createdDate\":\"2020-02-14T23:18:51.841Z\",\"passDuration\":\"4\",\"price\":-5,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T23:18:51.841Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum Cleaner 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"84f52e66-da36-4631-b24c-90b296c443d8\",\"item\":\"bd6588c7-ea46-4fdf-a539-055214970550\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T23:18:51.000Z\",\"zohoId\":\"4280752000001355593\",\"_id\":\"1255be62-e32b-4fa9-9f89-3f50242bcad9\",\"_createdDate\":\"2020-02-14T23:18:51.841Z\",\"passDuration\":\"4\",\"price\":-5,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T23:18:51.841Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum Cleaner 2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"84f52e66-da36-4631-b24c-90b296c443d8\",\"item\":\"bd6588c7-ea46-4fdf-a539-055214970550\",\"endTime\":null,\"total\":null,\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003776601\"},{\"serial\":\"Scooter4\",\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2020-01-27T01:23:39.000Z\",\"_id\":\"76be657c-8a8e-452c-af06-3e90add93bc8\",\"_createdDate\":\"2020-01-27T01:23:39.321Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":30,\"positionText\":\"\",\"rentZohoId\":\"4280752000003645706\",\"baseCost\":2,\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T22:30:08.671Z\",\"total\":\"8\",\"code\":null,\"endTime\":\"2020-01-27T03:02:10.000Z\",\"rating\":null,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"87b3c643-44df-4696-9fd6-ab41b28b1e1a\",\"passPrice\":\"12\",\"position\":4,\"isOk\":true,\"title\":\"Scooter4\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"788e805c-8728-4698-9004-723c9f4e6f04\",\"comments\":\"Sent to Zoho\",\"item\":\"2977cd04-bf49-4920-b014-bde8e191bf06\"},{\"serial\":\"Vacuum 2\",\"isInRoom\":false,\"startTime\":\"2020-02-14T23:19:42.634Z\",\"zohoId\":\"4280752000001397211\",\"_id\":\"b53336bf-f905-41c1-8af7-3a1f913010aa\",\"_createdDate\":\"2020-02-14T23:19:42.803Z\",\"passDuration\":\"4\",\"price\":5,\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T23:19:42.803Z\",\"code\":\"00197\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum 2\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"a156987c-44ff-486f-bb38-765aca7554d1\",\"item\":\"c830bcf2-511a-4626-a237-2e9b9312eea9\"},{\"serial\":\"Vacuum 2\",\"isInRoom\":false,\"startTime\":\"2020-02-14T23:19:42.000Z\",\"zohoId\":\"4280752000001397211\",\"_id\":\"b53336bf-f905-41c1-8af7-3a1f913010aa\",\"_createdDate\":\"2020-02-14T23:19:42.803Z\",\"passDuration\":\"4\",\"price\":5,\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T23:19:42.803Z\",\"code\":\"00197\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum 2\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"a156987c-44ff-486f-bb38-765aca7554d1\",\"item\":\"c830bcf2-511a-4626-a237-2e9b9312eea9\",\"endTime\":null,\"total\":null,\"rating\":null,\"rentZohoId\":\"4280752000003772689\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T23:23:56.745Z\",\"zohoId\":\"4280752000002201214\",\"_id\":\"df7aeacc-2ee0-4ba7-9e5e-8b61f5790980\",\"_createdDate\":\"2020-02-14T23:23:56.918Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T23:23:56.918Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"e30e22ac-5c99-4793-ad6f-f27fd47c86c5\",\"passPrice\":\"12\",\"isOk\":true,\"title\":\"Home Theater Projector\",\"room\":\"8c460d4c-50f6-4f31-bf08-1f1323b8fb2c\",\"user\":\"c098cdd9-35ca-47d5-b7b8-e7ca52f3466e\",\"item\":\"368d92d9-2a66-4d0a-a32a-a8b7512dd0c6\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T23:23:56.000Z\",\"zohoId\":\"4280752000002201214\",\"_id\":\"df7aeacc-2ee0-4ba7-9e5e-8b61f5790980\",\"_createdDate\":\"2020-02-14T23:23:56.918Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T23:23:56.918Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"e30e22ac-5c99-4793-ad6f-f27fd47c86c5\",\"passPrice\":\"12\",\"isOk\":true,\"title\":\"Home Theater Projector\",\"room\":\"8c460d4c-50f6-4f31-bf08-1f1323b8fb2c\",\"user\":\"c098cdd9-35ca-47d5-b7b8-e7ca52f3466e\",\"item\":\"368d92d9-2a66-4d0a-a32a-a8b7512dd0c6\",\"endTime\":null,\"total\":null,\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003776661\"},{\"ip\":\"37316c62-33e5-e35a-21e0-c86ba5be8735\",\"isInRoom\":false,\"startTime\":\"2019-11-30T17:50:24.922Z\",\"email\":\"\",\"_id\":\"cbc612fa-78b1-4564-855d-bc4ee48178f1\",\"_createdDate\":\"2019-11-30T17:50:25.300Z\",\"price\":0.1,\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:46:12.561Z\",\"total\":1,\"files\":\"[{\\\"label\\\":\\\"חוזה 2019 נחליאלי קומה 3 עורפית (2).docx\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/306765_2c267173cd7e4a5398d2b5c0d4f0bf3e.docx\\\",\\\"pageCount\\\":5}]\",\"code\":\"\",\"endTime\":\"2019-11-30T17:50:25.433Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"0cc44936-f18e-4c6a-b4d5-424b51115727\",\"position\":0,\"isOk\":true,\"title\":\"Printer\",\"room\":\"69852922-a287-45c6-81b1-41be6097320d\",\"user\":\"306765e3-55f4-4c3e-9d2a-02c3dd2d5a39\",\"item\":\"d373136a-dac1-4d41-a36d-70ed4f614e38\",\"comments\":\"Sent to Zoho\"},{\"ip\":\"37316c62-33e5-e35a-21e0-c86ba5be8735\",\"isInRoom\":false,\"startTime\":\"2019-11-30T17:54:03.000Z\",\"email\":\"\",\"_id\":\"15f32915-5f77-4df9-b381-6b1e707b7c99\",\"_createdDate\":\"2019-11-30T17:54:04.337Z\",\"price\":0.1,\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-14T23:30:02.522Z\",\"total\":\"0.5\",\"files\":\"[{\\\"label\\\":\\\"חוזה 2019 נחליאלי קומה 3 עורפית (2).docx\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/306765_9531ea2453874b1bbff1505127469e75.docx\\\",\\\"pageCount\\\":5}]\",\"code\":null,\"endTime\":\"2019-11-30T17:54:05.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"0cc44936-f18e-4c6a-b4d5-424b51115727\",\"position\":0,\"isOk\":true,\"title\":\"Printer\",\"room\":\"69852922-a287-45c6-81b1-41be6097320d\",\"user\":\"306765e3-55f4-4c3e-9d2a-02c3dd2d5a39\",\"comments\":\"Sent to Zoho\",\"item\":\"d373136a-dac1-4d41-a36d-70ed4f614e38\",\"rating\":null,\"rentZohoId\":\"4280752000003776697\"},{\"isInRoom\":false,\"startTime\":\"2019-11-30T18:15:00.000Z\",\"_id\":\"98920297-a286-42de-a180-e66bbfad45ea\",\"_owner\":\"ad002d46-5812-45af-8dab-aa76c125601a\",\"_createdDate\":\"2019-11-30T18:15:23.467Z\",\"price\":2,\"roomType\":\"regular\",\"maxUsageTime\":5,\"_updatedDate\":\"2020-02-14T23:30:02.522Z\",\"total\":null,\"code\":\"00137\",\"endTime\":\"2019-11-30T18:15:56.000Z\",\"status\":\"cb0d99ee-0fc2-4497-9817-3b8b311dc3b8\",\"itemType\":\"2ce758d6-79b1-414d-97f2-5e430c8dcffd\",\"position\":0,\"isOk\":true,\"title\":\"Catan\",\"room\":\"f76dc6f0-e820-4ef4-86b4-66550f7b095e\",\"user\":\"ad002d46-5812-45af-8dab-aa76c125601a\",\"comments\":\"Sent to Zoho\",\"item\":\"0b2b8483-8322-4cd0-bbf1-4e6bc5be04b6\",\"rating\":null,\"rentZohoId\":\"4280752000003775693\"}]","updateId":"98920297-a286-42de-a180-e66bbfad45ea","_id":"b4e339a4-e75f-414c-b91a-c30b9b36e249"}}}]

User not available