Sat Feb 15 2020 19:00:05 GMT+0000 (Coordinated Universal Time)

Msg: Error - sendToBigQuery
Info: ["run: sendToBigQuery",{"data Id":"6d60eb55-0d34-41ad-81c5-b3e7e79f82f1"},{"method":"Insert"},"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":"[{\"isInRoom\":false,\"startTime\":\"2019-07-24T10:43:18.000Z\",\"email\":\"ben@repark.me\",\"_id\":\"0c439237-cc63-454b-b25a-dc816ab50458\",\"_owner\":\"b08ce99b-f9cd-4cbe-b844-f7cd00c1cb70\",\"_createdDate\":\"2019-07-24T10:43:21.905Z\",\"price\":0,\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-15T18:45:01.058Z\",\"total\":null,\"files\":\"[{\\\"label\\\":\\\"פתרון למשבר הפקקים בישראל_ נתיבי תחבורה ציבורית בכבישים בינעירוניים_ כביש 2, 1, 4 ו-5.docx\\\",\\\"value\\\":\\\"wix:document://v1/3ec3dc_c9fc23c61efc4722a9dc429e03eb1fa5.docx/פתרון למשבר הפקקים בישראל_ נתיבי תחבורה ציבורית בכבישים בינעירוניים_ כביש 2, 1, 4 ו-5.docx\\\"}]\",\"endTime\":\"2019-07-24T10:44:39.000Z\",\"rating\":\"5\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"0cc44936-f18e-4c6a-b4d5-424b51115727\",\"isOk\":true,\"title\":\"Printer\",\"room\":\"d141bb0f-d3ae-4981-93a4-c85ca17f7ea9\",\"user\":\"b08ce99b-f9cd-4cbe-b844-f7cd00c1cb70\",\"comments\":\"Sent to Zoho\",\"item\":\"d373136a-dac1-4d41-a36d-70ed4f614e38\",\"code\":null,\"rentZohoId\":\"4280752000003827362\"},{\"ip\":\"http://89.138.184.32:5000\",\"isInRoom\":false,\"startTime\":\"2019-07-23T11:44:13.000Z\",\"_id\":\"f77db733-97b9-4fc0-845a-4b1bf42836e2\",\"_owner\":\"b08ce99b-f9cd-4cbe-b844-f7cd00c1cb70\",\"_createdDate\":\"2019-07-23T11:44:13.939Z\",\"price\":5,\"roomType\":\"regular\",\"maxUsageTime\":5,\"_updatedDate\":\"2020-02-15T18:45:01.057Z\",\"total\":\"25\",\"code\":\"692\",\"endTime\":\"2019-07-24T10:42:04.000Z\",\"rating\":\"5\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"f073848c-a830-4a1c-9d28-1c5c026467b0\",\"maxPrice\":25,\"isOk\":true,\"title\":\"Washer\",\"room\":\"662b2cbb-7848-4f71-96f8-5c1ea67adfcf\",\"user\":\"b08ce99b-f9cd-4cbe-b844-f7cd00c1cb70\",\"comments\":\"Sent to Zoho\",\"item\":\"6df4a55d-f1f1-4072-88bf-d5ea882c2b35\",\"rentZohoId\":\"4280752000003830218\"},{\"ip\":\"http://37.142.66.54:5000/washer\",\"isInRoom\":false,\"startTime\":\"2019-07-24T17:58:17.000Z\",\"email\":\"\",\"_id\":\"0751be06-4b14-4360-a388-ac3359be753a\",\"_createdDate\":\"2019-07-24T17:58:17.288Z\",\"price\":5,\"roomType\":\"smart\",\"maxUsageTime\":8,\"_updatedDate\":\"2020-02-15T18:45:01.057Z\",\"total\":\"10\",\"code\":\"789\",\"endTime\":\"2019-07-24T18:33:23.000Z\",\"rating\":\"5\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"f073848c-a830-4a1c-9d28-1c5c026467b0\",\"maxPrice\":20,\"position\":0,\"isOk\":true,\"title\":\"Washer\",\"room\":\"76199668-5950-4c41-b428-578a5c9e0b70\",\"user\":\"ee915678-32a3-403b-b96e-1d5c593e39e3\",\"comments\":\"Sent to Zoho\",\"item\":\"3da7e725-ca78-4041-aeb3-3527501cb22f\",\"rentZohoId\":\"4280752000003829184\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-15T18:40:31.000Z\",\"zohoId\":\"4280752000001373652\",\"_id\":\"4a275109-71d3-4bd2-b9e4-dbe1182978e7\",\"_createdDate\":\"2020-02-15T18:40:31.902Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"rentZohoId\":\"4280752000003826242\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T18:45:01.058Z\",\"total\":2,\"code\":null,\"endTime\":\"2020-02-15T18:54:31.965Z\",\"rating\":null,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum Cleaner 2\",\"room\":\"e555aa2b-012a-4962-9f63-0614647e94c3\",\"user\":\"5de0df48-b7f5-43d2-86ad-77590a928630\",\"comments\":\"Sent to Zoho\",\"item\":\"c0ae6018-ace1-4ca1-bd17-5ede49e97566\"},{\"serial\":\"Vacuum 1\",\"isInRoom\":false,\"startTime\":\"2020-02-15T18:57:05.201Z\",\"zohoId\":\"4280752000001397113\",\"_id\":\"dc1687e3-8358-4009-86f1-785364ad3f75\",\"_createdDate\":\"2020-02-15T18:57:05.552Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T18:57:05.552Z\",\"code\":\"00628\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"1\",\"isOk\":true,\"title\":\"Vacuum 1\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"16610d0a-030b-4fbb-b666-ebc2db0da4ed\",\"item\":\"3e978b61-60da-4760-a1bc-2e6c92fe9688\"},{\"serial\":\"Vacuum 1\",\"isInRoom\":false,\"startTime\":\"2020-02-15T18:57:05.000Z\",\"zohoId\":\"4280752000001397113\",\"_id\":\"dc1687e3-8358-4009-86f1-785364ad3f75\",\"_createdDate\":\"2020-02-15T18:57:05.552Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-15T18:57:05.552Z\",\"code\":\"00628\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"1\",\"isOk\":true,\"title\":\"Vacuum 1\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"16610d0a-030b-4fbb-b666-ebc2db0da4ed\",\"item\":\"3e978b61-60da-4760-a1bc-2e6c92fe9688\",\"endTime\":null,\"total\":null,\"rating\":null,\"rentZohoId\":\"4280752000003827398\"},{\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2019-07-19T18:50:15.176Z\",\"email\":\"\",\"_id\":\"0d3f8943-1f31-4114-b025-f25c76c66abb\",\"_owner\":\"ee915678-32a3-403b-b96e-1d5c593e39e3\",\"_createdDate\":\"2019-07-19T18:50:16.197Z\",\"price\":5,\"roomType\":\"regular\",\"maxUsageTime\":8,\"_updatedDate\":\"2020-02-02T15:51:38.140Z\",\"total\":10,\"code\":\"789\",\"endTime\":\"2019-07-19T19:31:02.754Z\",\"rating\":1,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"f073848c-a830-4a1c-9d28-1c5c026467b0\",\"maxPrice\":25,\"isOk\":true,\"title\":\"Washer\",\"room\":\"76199668-5950-4c41-b428-578a5c9e0b70\",\"user\":\"ee915678-32a3-403b-b96e-1d5c593e39e3\",\"item\":\"3da7e725-ca78-4041-aeb3-3527501cb22f\",\"comments\":\"Sent to Zoho\"},{\"isInRoom\":false,\"startTime\":\"2019-07-19T09:21:58.000Z\",\"_id\":\"a571a11a-abca-41a5-9641-2c2bc174c795\",\"_createdDate\":\"2019-07-19T09:21:58.476Z\",\"price\":5,\"roomType\":\"smart\",\"maxUsageTime\":8,\"_updatedDate\":\"2020-02-02T15:51:38.141Z\",\"total\":\"30\",\"endTime\":\"2019-07-19T12:18:29.000Z\",\"rating\":\"5\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"87b3c643-44df-4696-9fd6-ab41b28b1e1a\",\"maxPrice\":30,\"position\":2,\"isOk\":true,\"title\":\"Scooter 2\",\"room\":\"69852922-a287-45c6-81b1-41be6097320d\",\"user\":\"85e62c72-4117-4475-86db-10a3c713b21c\",\"item\":\"06e0d77b-29cc-47ac-a58d-065c823f00ff\",\"code\":null,\"rentZohoId\":\"4280752000003827434\"},{\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2019-07-19T18:50:15.000Z\",\"email\":\"\",\"_id\":\"0d3f8943-1f31-4114-b025-f25c76c66abb\",\"_owner\":\"ee915678-32a3-403b-b96e-1d5c593e39e3\",\"_createdDate\":\"2019-07-19T18:50:16.197Z\",\"price\":5,\"roomType\":\"regular\",\"maxUsageTime\":8,\"_updatedDate\":\"2020-02-02T15:51:38.140Z\",\"total\":\"10\",\"code\":\"789\",\"endTime\":\"2019-07-19T19:31:02.000Z\",\"rating\":\"1\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"f073848c-a830-4a1c-9d28-1c5c026467b0\",\"maxPrice\":25,\"isOk\":true,\"title\":\"Washer\",\"room\":\"76199668-5950-4c41-b428-578a5c9e0b70\",\"user\":\"ee915678-32a3-403b-b96e-1d5c593e39e3\",\"item\":\"3da7e725-ca78-4041-aeb3-3527501cb22f\",\"rentZohoId\":\"4280752000003825372\"},{\"isInRoom\":false,\"startTime\":\"2019-07-19T06:33:19.000Z\",\"_id\":\"da0d2f13-7eae-4d71-83e8-d3ee25af7161\",\"_createdDate\":\"2019-07-19T06:33:19.540Z\",\"price\":5,\"roomType\":\"smart\",\"maxUsageTime\":5,\"_updatedDate\":\"2020-02-02T15:51:38.141Z\",\"total\":\"10\",\"endTime\":\"2019-07-19T07:13:52.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"3ef7be44-a5f8-432a-8554-e7aadd8efc4f\",\"isOk\":true,\"title\":\"Window Robot\",\"room\":\"69852922-a287-45c6-81b1-41be6097320d\",\"user\":\"26c83cdc-e467-4779-8dda-07d0ef326005\",\"item\":\"882560f1-c569-4f2d-b3ad-a8b46832f7d7\",\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003832001\"},{\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2019-07-19T12:21:57.000Z\",\"email\":\"\",\"_id\":\"181208c4-125c-4a55-a042-78488450e512\",\"_owner\":\"f19d395d-af19-4abd-bb51-6ce7c4dce707\",\"_createdDate\":\"2019-07-19T12:21:58.528Z\",\"price\":5,\"roomType\":\"regular\",\"maxUsageTime\":8,\"_updatedDate\":\"2020-02-15T19:00:04.892Z\",\"total\":\"15\",\"code\":\"456\",\"endTime\":\"2019-07-19T13:22:57.000Z\",\"rating\":\"1\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"c70cd8f1-1f75-443d-94ee-e7295edc4462\",\"maxPrice\":25,\"isOk\":true,\"title\":\"Dryer\",\"room\":\"76199668-5950-4c41-b428-578a5c9e0b70\",\"user\":\"f19d395d-af19-4abd-bb51-6ce7c4dce707\",\"comments\":\"Sent to Zoho\",\"item\":\"c4ac966d-4dc9-4e79-a199-d9feff8d43de\",\"rentZohoId\":\"4280752000003829220\"},{\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2019-07-20T11:33:23.000Z\",\"email\":\"\",\"_id\":\"6d60eb55-0d34-41ad-81c5-b3e7e79f82f1\",\"_owner\":\"b08ce99b-f9cd-4cbe-b844-f7cd00c1cb70\",\"_createdDate\":\"2019-07-20T11:33:25.972Z\",\"price\":5,\"roomType\":\"regular\",\"maxUsageTime\":8,\"_updatedDate\":\"2020-02-15T19:00:04.892Z\",\"total\":\"25\",\"code\":\"789\",\"endTime\":\"2019-07-20T15:26:03.000Z\",\"rating\":\"5\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"f073848c-a830-4a1c-9d28-1c5c026467b0\",\"maxPrice\":25,\"isOk\":true,\"title\":\"Washer\",\"room\":\"76199668-5950-4c41-b428-578a5c9e0b70\",\"user\":\"b08ce99b-f9cd-4cbe-b844-f7cd00c1cb70\",\"comments\":\"Sent to Zoho\",\"item\":\"3da7e725-ca78-4041-aeb3-3527501cb22f\",\"rentZohoId\":\"4280752000003821629\"}]","updateId":"6d60eb55-0d34-41ad-81c5-b3e7e79f82f1","_id":"f740cc7a-8560-442b-acee-68ed4bc70775"}}}]

User not available