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

Msg: Error - sendToBigQuery
Info: ["run: sendToBigQuery",{"data Id":"51937b3e-3cd3-4324-9ef7-2278191943fb"},{"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":"[{\"serial\":\"Bluetooth Speaker1\",\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2020-02-05T22:12:43.000Z\",\"zohoId\":\"4280752000001373510\",\"_id\":\"ccd966cd-d078-4b0c-b9bf-469d112d8ec0\",\"_createdDate\":\"2020-02-05T22:12:43.381Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":30,\"positionText\":\"\",\"baseCost\":1,\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T12:45:01.979Z\",\"total\":\"4\",\"code\":null,\"endTime\":\"2020-02-05T23:56:37.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"f63190a5-81cc-4f84-ba8e-b0edaf62b276\",\"passPrice\":\"6\",\"position\":1,\"isOk\":true,\"title\":\"Bluetooth Speaker1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"edc743a0-37e3-450a-ad5a-13b0c3dc464d\",\"comments\":\"Sent to Zoho\",\"item\":\"927b7590-66be-4929-8d66-6f9c3bc9057e\",\"rating\":null,\"rentZohoId\":\"4280752000003538410\"},{\"serial\":\"Bluetooth Speaker2\",\"isInRoom\":false,\"startTime\":\"2020-02-05T21:57:02.000Z\",\"zohoId\":\"4280752000001374592\",\"_id\":\"29d54445-55a8-456c-9690-7a0b7c16c37a\",\"_createdDate\":\"2020-02-05T21:57:03.051Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T12:45:01.979Z\",\"total\":\"1\",\"endTime\":\"2020-02-05T22:08:09.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"f63190a5-81cc-4f84-ba8e-b0edaf62b276\",\"passPrice\":\"6\",\"position\":\"2\",\"isOk\":true,\"title\":\"Bluetooth Speaker2\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"edc743a0-37e3-450a-ad5a-13b0c3dc464d\",\"comments\":\"Sent to Zoho\",\"item\":\"a1874147-6680-4977-a28d-8b8579b31fd9\",\"rating\":null,\"code\":null,\"rentZohoId\":\"4280752000003537579\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-05T16:52:22.000Z\",\"zohoId\":\"4280752000001354803\",\"_id\":\"f341d7cb-08cb-4a13-807f-87ffbc4dc23b\",\"_createdDate\":\"2020-02-05T16:52:23.150Z\",\"passDuration\":\"12\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T12:45:01.979Z\",\"total\":\"2\",\"code\":\"2323\",\"endTime\":\"2020-02-05T17:07:21.000Z\",\"rating\":null,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e3f8a229-e0a3-46b6-a813-6282f442db81\",\"passPrice\":\"12\",\"position\":\"5\",\"isOk\":true,\"title\":\"Electric Scooter 5\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"ee935651-2f10-49ed-a6c0-2c68b15d4034\",\"comments\":\"Sent to Zoho\",\"item\":\"d32fbd0e-03ed-4ec5-b3f7-09a9eb3d416d\",\"rentZohoId\":\"4280752000003540828\"},{\"serial\":\"Vacuum 1\",\"isInRoom\":false,\"startTime\":\"2020-02-05T17:15:44.000Z\",\"zohoId\":\"4280752000001365523\",\"_id\":\"dba72a48-9e7e-4f93-95d0-16253b772190\",\"_owner\":\"5c659dbb-2ee7-41a3-b815-d6bc1586a677\",\"_createdDate\":\"2020-02-05T17:15:46.142Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-13T12:45:01.979Z\",\"total\":null,\"code\":\"00936\",\"endTime\":\"2020-02-05T17:16:00.000Z\",\"rating\":null,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"1\",\"isOk\":true,\"title\":\"Vacuum Cleaner\",\"room\":\"f76dc6f0-e820-4ef4-86b4-66550f7b095e\",\"user\":\"5c659dbb-2ee7-41a3-b815-d6bc1586a677\",\"comments\":\"Sent to Zoho\",\"item\":\"af50c3da-cadf-4cdb-bc7e-a5a805079351\",\"rentZohoId\":\"4280752000003577177\"},{\"serial\":\"Vacuum 1\",\"isInRoom\":false,\"startTime\":\"2020-02-13T12:28:56.000Z\",\"zohoId\":\"4280752000001368709\",\"_id\":\"49b3bd31-db5f-42ff-a041-d0f8b3dea6c9\",\"_createdDate\":\"2020-02-13T12:28:56.679Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"rentZohoId\":\"4280752000003554400\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T12:30:01.774Z\",\"total\":5,\"code\":null,\"endTime\":\"2020-02-13T12:50:25.520Z\",\"rating\":null,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"1\",\"isOk\":true,\"title\":\"Vacuum 1\",\"room\":\"69852922-a287-45c6-81b1-41be6097320d\",\"user\":\"815317f9-75aa-4d13-9a53-aa7d5af5877c\",\"comments\":\"Sent to Zoho\",\"item\":\"c58647b8-8057-4a11-981b-c68120e5eba2\"},{\"serial\":\"Vacuum 1\",\"isInRoom\":false,\"startTime\":\"2020-02-13T12:57:12.921Z\",\"zohoId\":\"4280752000001397113\",\"_id\":\"5bc6e802-b024-4004-a1cc-be781d944c63\",\"_createdDate\":\"2020-02-13T12:57:13.135Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T12:57:13.135Z\",\"code\":\"00127\",\"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\":\"57d6d0cd-23a1-444e-b6d6-5346e8234a4f\",\"item\":\"3e978b61-60da-4760-a1bc-2e6c92fe9688\"},{\"serial\":\"Vacuum 1\",\"isInRoom\":false,\"startTime\":\"2020-02-13T12:57:12.000Z\",\"zohoId\":\"4280752000001397113\",\"_id\":\"5bc6e802-b024-4004-a1cc-be781d944c63\",\"_createdDate\":\"2020-02-13T12:57:13.135Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T12:57:13.135Z\",\"code\":\"00127\",\"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\":\"57d6d0cd-23a1-444e-b6d6-5346e8234a4f\",\"item\":\"3e978b61-60da-4760-a1bc-2e6c92fe9688\",\"endTime\":null,\"total\":null,\"rating\":null,\"rentZohoId\":\"4280752000003538539\"},{\"serial\":\"Dryer\",\"ip\":\"http://77.139.186.173:5000/dryer\",\"isInRoom\":false,\"startTime\":\"2020-02-05T14:59:15.000Z\",\"zohoId\":\"4280752000001354929\",\"_id\":\"bd3e9686-2675-4eb1-be14-e72dea39f1f0\",\"_createdDate\":\"2020-02-05T14:59:17.664Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T09:07:29.583Z\",\"total\":10,\"code\":null,\"endTime\":\"2020-02-05T17:16:34.070Z\",\"rating\":null,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"c70cd8f1-1f75-443d-94ee-e7295edc4462\",\"passPrice\":\"10\",\"isOk\":true,\"title\":\"Dryer\",\"room\":\"76199668-5950-4c41-b428-578a5c9e0b70\",\"user\":\"f19d395d-af19-4abd-bb51-6ce7c4dce707\",\"item\":\"c4ac966d-4dc9-4e79-a199-d9feff8d43de\",\"comments\":\"Sent to Zoho\"},{\"serial\":\"Scooter 4\",\"isInRoom\":false,\"startTime\":\"2020-02-05T16:47:21.000Z\",\"zohoId\":\"4280752000001570283\",\"_id\":\"2fce7c19-e6b8-4b27-af4a-cd6a7f6d4e93\",\"_createdDate\":\"2020-02-05T16:47:21.915Z\",\"passDuration\":\"8\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T13:00:01.137Z\",\"total\":\"30\",\"code\":\"00574\",\"endTime\":\"2020-02-05T19:58:19.000Z\",\"rating\":\"2\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"87b3c643-44df-4696-9fd6-ab41b28b1e1a\",\"passPrice\":\"30\",\"position\":\"4\",\"isOk\":true,\"title\":\"Scooter 4\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"user\":\"ffa7c831-87a5-419a-bfbc-4d113d9c5367\",\"comments\":\"Sent to Zoho\",\"item\":\"8a6d4763-40b9-4fb4-8a3f-7a186042800b\",\"rentZohoId\":\"4280752000003576282\"},{\"serial\":\"Printer1\",\"ip\":\"fabb36f8-7c44-ecb0-09dc-59b4d4b6a5cd\",\"isInRoom\":false,\"startTime\":\"2020-02-05T16:48:30.000Z\",\"zohoId\":\"4280752000001354845\",\"_id\":\"b9e9d885-6a54-487d-b599-4ff1a63261b5\",\"_createdDate\":\"2020-02-05T16:48:30.901Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-13T13:00:01.137Z\",\"total\":\"0.3\",\"files\":\"[{\\\"label\\\":\\\"Page 20.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/9e57c7_682d5e221b2345b2849a2ff315496a29.pdf\\\",\\\"pageCount\\\":3}]\",\"code\":null,\"endTime\":\"2020-02-05T16:48:31.000Z\",\"rating\":null,\"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\":\"9e57c788-2ce6-461e-814e-f0967a083b32\",\"comments\":\"Sent to Zoho\",\"item\":\"f09a60f2-b63d-4e2d-bd97-7d83d2b9a9f2\",\"rentZohoId\":\"4280752000003578529\"}]","updateId":"b9e9d885-6a54-487d-b599-4ff1a63261b5","_id":"bbed72f2-d6a8-4e64-bb91-0cd949539b5b"}}}]

User not available