Thu Feb 13 2020 15:45:02 GMT+0000 (Coordinated Universal Time)

Msg: Error - sendToBigQuery
Info: ["run: sendToBigQuery",{"data Id":"9c08dcfb-6d64-43d2-aafd-1a48ef27775c"},{"method":"Insert"},{"res: insertToTable":"ok"},{"res: upsertTable":"ok"},"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: 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-13T15:38:32.154Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"19c5dc59-7c4b-4692-b7aa-e6b3b10ad40a\",\"_createdDate\":\"2020-02-13T15:38:32.360Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T15:38:32.360Z\",\"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\":\"56d52c6c-3a24-4688-891c-e87c4d29c3d0\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T15:38:32.154Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"19c5dc59-7c4b-4692-b7aa-e6b3b10ad40a\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T15:38:45.066Z\",\"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\":\"56d52c6c-3a24-4688-891c-e87c4d29c3d0\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Vacuum 3\",\"isInRoom\":false,\"startTime\":\"2020-02-03T12:15:09.583Z\",\"zohoId\":\"4280752000001397225\",\"_id\":\"7e81d942-ce6f-4dc5-8cd7-634cbfe7817e\",\"_createdDate\":\"2020-02-03T12:15:09.827Z\",\"passDuration\":\"4\",\"price\":5,\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-03T12:15:46.415Z\",\"total\":0,\"code\":\"00794\",\"endTime\":\"2020-02-03T12:15:39.629Z\",\"rating\":5,\"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\":\"e8d11c29-e30e-4866-acba-8c0ec576ea92\",\"item\":\"42961a91-13f4-4989-91f5-87cba7d99b0e\",\"comments\":\"Sent to Zoho\"}]","updateId":"7e81d942-ce6f-4dc5-8cd7-634cbfe7817e","_id":"439574d7-797d-451c-80b7-db46f533f211"}}},{"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-13T15:38:32.154Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"19c5dc59-7c4b-4692-b7aa-e6b3b10ad40a\",\"_createdDate\":\"2020-02-13T15:38:32.360Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T15:38:32.360Z\",\"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\":\"56d52c6c-3a24-4688-891c-e87c4d29c3d0\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T15:38:32.154Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"19c5dc59-7c4b-4692-b7aa-e6b3b10ad40a\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T15:38:45.066Z\",\"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\":\"56d52c6c-3a24-4688-891c-e87c4d29c3d0\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Printer1\",\"ip\":\"fabb36f8-7c44-ecb0-09dc-59b4d4b6a5cd\",\"isInRoom\":false,\"startTime\":\"2020-02-03T13:07:53.921Z\",\"zohoId\":\"4280752000001354845\",\"_id\":\"22456ac3-b1a1-4c0b-86cb-125871f661b7\",\"_createdDate\":\"2020-02-03T13:07:54.178Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-03T13:08:19.764Z\",\"total\":0.1,\"files\":\"[{\\\"label\\\":\\\"Untitled document.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/6f4c9e_ceb535b7b97e47e2847b834758cb77ef.pdf\\\",\\\"pageCount\\\":1}]\",\"endTime\":\"2020-02-03T13:07:54.914Z\",\"rating\":1,\"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\":\"6f4c9e0d-4ac0-408c-863d-1fdf53bd5ece\",\"item\":\"f09a60f2-b63d-4e2d-bd97-7d83d2b9a9f2\",\"comments\":\"Sent to Zoho\"}]","updateId":"22456ac3-b1a1-4c0b-86cb-125871f661b7","_id":"439574d7-797d-451c-80b7-db46f533f211"}}},{"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-13T15:38:32.154Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"19c5dc59-7c4b-4692-b7aa-e6b3b10ad40a\",\"_createdDate\":\"2020-02-13T15:38:32.360Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T15:38:32.360Z\",\"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\":\"56d52c6c-3a24-4688-891c-e87c4d29c3d0\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T15:38:32.154Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"19c5dc59-7c4b-4692-b7aa-e6b3b10ad40a\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T15:38:45.066Z\",\"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\":\"56d52c6c-3a24-4688-891c-e87c4d29c3d0\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Printer2\",\"ip\":\"9a1b839b-e93a-d4ae-1421-aeec7bd94b2c\",\"isInRoom\":false,\"startTime\":\"2020-02-03T07:42:21.000Z\",\"zohoId\":\"4280752000001374578\",\"_id\":\"050b5fef-f3c4-4511-862b-a8244787d3f2\",\"_createdDate\":\"2020-02-03T07:42:21.694Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-13T09:07:15.511Z\",\"total\":\"0.2\",\"files\":\"[{\\\"label\\\":\\\"DB#3B - Differences In Articles.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/7c3831_8e75b5d131e44a67b1e4d0ebc52d95ae.pdf\\\",\\\"pageCount\\\":2}]\",\"endTime\":\"2020-02-03T07:42:21.000Z\",\"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\",\"item\":\"a441821a-172d-4e0b-9541-c24fc4730ca0\",\"comments\":\"Sent to Zoho\"}]","updateId":"050b5fef-f3c4-4511-862b-a8244787d3f2","_id":"439574d7-797d-451c-80b7-db46f533f211"}}},{"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-13T15:38:32.154Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"19c5dc59-7c4b-4692-b7aa-e6b3b10ad40a\",\"_createdDate\":\"2020-02-13T15:38:32.360Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T15:38:32.360Z\",\"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\":\"56d52c6c-3a24-4688-891c-e87c4d29c3d0\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T15:38:32.154Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"19c5dc59-7c4b-4692-b7aa-e6b3b10ad40a\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T15:38:45.066Z\",\"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\":\"56d52c6c-3a24-4688-891c-e87c4d29c3d0\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Printer1\",\"ip\":\"fabb36f8-7c44-ecb0-09dc-59b4d4b6a5cd\",\"isInRoom\":false,\"startTime\":\"2020-02-03T13:09:24.095Z\",\"zohoId\":\"4280752000001354845\",\"_id\":\"6163c40a-a3ff-4d25-8fb7-e674f005c86c\",\"_createdDate\":\"2020-02-03T13:09:24.340Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-03T13:09:28.429Z\",\"total\":0.4,\"files\":\"[{\\\"label\\\":\\\"Evans-Pritchard; Introduction (WOM Azande)(1).pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/6f4c9e_a085c710255a46439a3846b392857c34.pdf\\\",\\\"pageCount\\\":4}]\",\"endTime\":\"2020-02-03T13:09:24.455Z\",\"rating\":5,\"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\":\"6f4c9e0d-4ac0-408c-863d-1fdf53bd5ece\",\"item\":\"f09a60f2-b63d-4e2d-bd97-7d83d2b9a9f2\",\"comments\":\"Sent to Zoho\"}]","updateId":"6163c40a-a3ff-4d25-8fb7-e674f005c86c","_id":"439574d7-797d-451c-80b7-db46f533f211"}}},{"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-13T15:38:32.154Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"19c5dc59-7c4b-4692-b7aa-e6b3b10ad40a\",\"_createdDate\":\"2020-02-13T15:38:32.360Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T15:38:32.360Z\",\"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\":\"56d52c6c-3a24-4688-891c-e87c4d29c3d0\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T15:38:32.154Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"19c5dc59-7c4b-4692-b7aa-e6b3b10ad40a\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T15:38:45.066Z\",\"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\":\"56d52c6c-3a24-4688-891c-e87c4d29c3d0\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Scooter4\",\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2020-02-03T02:44:52.497Z\",\"zohoId\":\"4280752000001374564\",\"_id\":\"9e86d193-0503-48f1-b77a-c6729b32ed26\",\"_createdDate\":\"2020-02-03T02:44:52.710Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":30,\"positionText\":\"\",\"baseCost\":2,\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-03T02:45:15.680Z\",\"total\":0,\"code\":\"\",\"endTime\":\"2020-02-03T02:45:15.522Z\",\"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\":\"c5696fa1-4b61-47a5-b153-5fcf4f5f8f6d\",\"item\":\"2977cd04-bf49-4920-b014-bde8e191bf06\",\"comments\":\"Sent to Zoho\"}]","updateId":"9e86d193-0503-48f1-b77a-c6729b32ed26","_id":"439574d7-797d-451c-80b7-db46f533f211"}}},"run: getTableSchema",{"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-13T15:38:32.154Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"19c5dc59-7c4b-4692-b7aa-e6b3b10ad40a\",\"_createdDate\":\"2020-02-13T15:38:32.360Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T15:38:32.360Z\",\"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\":\"56d52c6c-3a24-4688-891c-e87c4d29c3d0\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T15:38:32.154Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"19c5dc59-7c4b-4692-b7aa-e6b3b10ad40a\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T15:38:45.066Z\",\"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\":\"56d52c6c-3a24-4688-891c-e87c4d29c3d0\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Printer2\",\"ip\":\"9a1b839b-e93a-d4ae-1421-aeec7bd94b2c\",\"isInRoom\":false,\"startTime\":\"2020-02-03T04:06:33.937Z\",\"zohoId\":\"4280752000001374578\",\"_id\":\"c93431ad-4da2-40e6-b504-86a5bd3aba10\",\"_createdDate\":\"2020-02-03T04:06:34.341Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-03T04:06:35.158Z\",\"total\":0.2,\"files\":\"[{\\\"label\\\":\\\"Doc1.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/672346_bae0366f681e43fdb5cf2caf4fed663a.pdf\\\",\\\"pageCount\\\":2}]\",\"endTime\":\"2020-02-03T04:06:35.012Z\",\"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\":\"672346fd-3336-4cf9-baf0-f0a1ece33bc1\",\"item\":\"a441821a-172d-4e0b-9541-c24fc4730ca0\",\"comments\":\"Sent to Zoho\"}]","updateId":"c93431ad-4da2-40e6-b504-86a5bd3aba10","_id":"439574d7-797d-451c-80b7-db46f533f211"}}},{"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-13T15:38:32.154Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"19c5dc59-7c4b-4692-b7aa-e6b3b10ad40a\",\"_createdDate\":\"2020-02-13T15:38:32.360Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T15:38:32.360Z\",\"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\":\"56d52c6c-3a24-4688-891c-e87c4d29c3d0\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T15:38:32.154Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"19c5dc59-7c4b-4692-b7aa-e6b3b10ad40a\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T15:38:45.066Z\",\"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\":\"56d52c6c-3a24-4688-891c-e87c4d29c3d0\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Vacuum 2\",\"isInRoom\":false,\"startTime\":\"2020-02-03T05:13:45.411Z\",\"zohoId\":\"4280752000001367550\",\"_id\":\"c080f240-a786-4c8b-bbec-7dc91511cca5\",\"_createdDate\":\"2020-02-03T05:13:45.639Z\",\"passDuration\":\"24,48\",\"price\":5,\"baseTime\":\"60\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-03T08:59:57.992Z\",\"total\":20,\"endTime\":\"2020-02-03T08:59:31.425Z\",\"rating\":5,\"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\":\"9ad042fa-1d9c-4f4f-a42c-c4353f2e76f0\",\"item\":\"bb92e0d1-7c5e-4999-9510-319af5e3d34b\",\"comments\":\"Sent to Zoho\"}]","updateId":"c080f240-a786-4c8b-bbec-7dc91511cca5","_id":"439574d7-797d-451c-80b7-db46f533f211"}}},{"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-13T15:38:32.154Z\",\"zohoId\":\"4280752000001980068\",\"_id\":\"19c5dc59-7c4b-4692-b7aa-e6b3b10ad40a\",\"_createdDate\":\"2020-02-13T15:38:32.360Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T15:38:32.360Z\",\"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\":\"56d52c6c-3a24-4688-891c-e87c4d29c3d0\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T15:38:32.154Z\",\"zohoId\":\"4280752000001980113\",\"_id\":\"19c5dc59-7c4b-4692-b7aa-e6b3b10ad40a\",\"_createdDate\":\"2020-01-10T23:12:34.794Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T15:38:45.066Z\",\"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\":\"56d52c6c-3a24-4688-891c-e87c4d29c3d0\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\"},{\"serial\":\"Printer2\",\"ip\":\"9a1b839b-e93a-d4ae-1421-aeec7bd94b2c\",\"isInRoom\":false,\"startTime\":\"2020-02-03T07:42:23.000Z\",\"zohoId\":\"4280752000001374578\",\"_id\":\"70b87bd4-0402-4f83-a5ef-9a61681f86e3\",\"_createdDate\":\"2020-02-03T07:42:23.556Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-13T09:07:58.325Z\",\"total\":\"0.2\",\"files\":\"[{\\\"label\\\":\\\"DB#3B - Differences In Articles.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/7c3831_8e75b5d131e44a67b1e4d0ebc52d95ae.pdf\\\",\\\"pageCount\\\":2}]\",\"endTime\":\"2020-02-03T07:42:23.000Z\",\"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\",\"item\":\"a441821a-172d-4e0b-9541-c24fc4730ca0\",\"comments\":\"Sent to Zoho\"}]","updateId":"70b87bd4-0402-4f83-a5ef-9a61681f86e3","_id":"439574d7-797d-451c-80b7-db46f533f211"}}}]

User not available