Fri Feb 14 2020 04:00:04 GMT+0000 (Coordinated Universal Time)

Msg: Error - sendToBigQuery
Info: ["run: sendToBigQuery",{"data Id":"7d2dfdcd-70b3-46d8-a80b-39d487a8aaea"},{"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",{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-01-18T17:06:00.000Z\",\"_id\":\"a00c6644-9ca9-421d-8898-52c11e9f4ced\",\"_createdDate\":\"2020-01-18T17:06:29.588Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":2,\"endTime\":\"2020-01-18T17:30:00.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Robot Mop 1\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"0d06f8fb-fd3d-4a8e-8456-d460a161c147\",\"item\":\"c344fdb3-f119-4750-ad5c-ad8172009a06\",\"comments\":\"Sent to Zoho\"}]","updateId":"a00c6644-9ca9-421d-8898-52c11e9f4ced","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-01-18T16:01:05.730Z\",\"_id\":\"ce302380-486b-42f9-8995-38bf88678ea7\",\"_createdDate\":\"2020-01-18T16:01:05.925Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":4,\"endTime\":\"2020-01-18T17:05:24.673Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"7db66008-93fd-4108-88a5-4b06a86251a8\",\"passPrice\":\"12\",\"position\":\"2\",\"isOk\":true,\"title\":\"Robot Mop 2\",\"room\":\"63222f08-0dca-47a8-a2af-59893100424f\",\"user\":\"0d06f8fb-fd3d-4a8e-8456-d460a161c147\",\"item\":\"0f3af78d-fd6d-46c7-aae2-efbdc4740ba1\",\"comments\":\"Sent to Zoho\"}]","updateId":"ce302380-486b-42f9-8995-38bf88678ea7","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"Window Robot 1\",\"isInRoom\":false,\"startTime\":\"2020-01-18T15:44:11.392Z\",\"_id\":\"42a40e0d-b26c-44da-a885-8940f6b80a0d\",\"_createdDate\":\"2020-01-18T15:44:11.601Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":15,\"code\":\"00761\",\"endTime\":\"2020-01-18T16:52:49.317Z\",\"rating\":5,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"3ef7be44-a5f8-432a-8554-e7aadd8efc4f\",\"passPrice\":\"20\",\"position\":\"1\",\"isOk\":true,\"title\":\"Window Robot 1\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"b4d1b722-18ad-4f63-8316-102a9aa3a036\",\"item\":\"c1004df2-2290-4f9a-8aba-67275e05781c\",\"comments\":\"Sent to Zoho\"}]","updateId":"42a40e0d-b26c-44da-a885-8940f6b80a0d","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"Vacuum 3\",\"isInRoom\":false,\"startTime\":\"2020-01-18T17:01:45.788Z\",\"_id\":\"a24dcdff-71df-4e66-a8b0-a69bbcfc2b69\",\"_createdDate\":\"2020-01-18T17:01:46.180Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":5,\"code\":\"00493\",\"endTime\":\"2020-01-18T17:21:18.690Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum 3\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"user\":\"987d94fd-15bb-4e5f-8634-a94df80b3474\",\"item\":\"d1c25ee5-6f31-401b-9cdb-ddfc7661998d\",\"comments\":\"Sent to Zoho\"}]","updateId":"a24dcdff-71df-4e66-a8b0-a69bbcfc2b69","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"Vacuum 1\",\"isInRoom\":false,\"startTime\":\"2020-01-18T19:09:00.000Z\",\"zohoId\":\"4280752000002907678\",\"_id\":\"9e0741f1-3990-41cf-870f-6fa8c2fff1c1\",\"_createdDate\":\"2020-01-18T17:09:59.453Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T09:07:49.958Z\",\"code\":\"00674\",\"endTime\":\"2020-01-18T19:17:00.000Z\",\"rating\":\"1\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"1\",\"isOk\":true,\"title\":\"Vacuum 1\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"user\":\"3fd2deb3-edbf-48f5-97d6-53baf42a4a93\",\"item\":\"b082bc4d-88fd-4b43-871e-920f1059fee4\",\"comments\":\"Sent to Zoho\"}]","updateId":"9e0741f1-3990-41cf-870f-6fa8c2fff1c1","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"Vacuum Cleaner 1\",\"isInRoom\":false,\"startTime\":\"2020-01-18T15:00:00.000Z\",\"Position_Text\":\"Available in the TULU room on the Lobby floor\",\"_id\":\"049e93f7-a34e-41d0-a3f0-6fb4becfb9a1\",\"_createdDate\":\"2020-01-18T15:00:39.901Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":1.6,\"endTime\":\"2020-01-18T15:32:00.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Vacuum Cleaner 1\",\"room\":\"74ef847f-219f-45cb-99f7-a59d64d8d05d\",\"user\":\"6df1b6b6-907c-4fd3-b67b-5f2102c38b5d\",\"item\":\"81bfdb1e-09ea-4b53-aaad-7b2263be8e1f\",\"comments\":\"Sent to Zoho\"}]","updateId":"049e93f7-a34e-41d0-a3f0-6fb4becfb9a1","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"Sewing machine\",\"isInRoom\":false,\"startTime\":\"2020-01-18T15:59:26.808Z\",\"_id\":\"05bb5913-f1e0-4b3c-8f69-3a1e3c9f84b5\",\"_createdDate\":\"2020-01-18T15:59:27.009Z\",\"passDuration\":\"24,48\",\"baseTime\":\"60\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":20,\"endTime\":\"2020-01-18T21:37:21.868Z\",\"rating\":1,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"d8dc287c-d8ca-4a33-a69e-56a4468f7377\",\"passPrice\":\"20,20\",\"isOk\":true,\"title\":\"Sewing machine\",\"room\":\"79c4d41a-0294-446b-b306-b0413963c9ac\",\"user\":\"6c8787d9-8b5d-4b86-b51f-e254933a2ebb\",\"item\":\"008c3bea-62b8-437d-94d5-acae57a98f85\",\"comments\":\"Sent to Zoho\"}]","updateId":"05bb5913-f1e0-4b3c-8f69-3a1e3c9f84b5","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"Vacuum 1\",\"isInRoom\":false,\"startTime\":\"2020-01-18T12:46:13.632Z\",\"_id\":\"7fc5ebe8-f91f-49cd-9632-62a3dadeca93\",\"_createdDate\":\"2020-01-18T12:46:14.025Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":5,\"code\":\"00746\",\"endTime\":\"2020-01-18T13:16:53.895Z\",\"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\":\"1a7c2568-46f7-47e5-a907-a2960e26f651\",\"item\":\"3e978b61-60da-4760-a1bc-2e6c92fe9688\",\"comments\":\"Sent to Zoho\"}]","updateId":"7fc5ebe8-f91f-49cd-9632-62a3dadeca93","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"Vacuum 2\",\"isInRoom\":false,\"startTime\":\"2020-01-18T13:39:32.808Z\",\"_id\":\"6ec6694b-3397-4680-b949-4d64ac79ba4a\",\"_owner\":\"9860dc55-af02-4e78-a7d5-31a87222ba31\",\"_createdDate\":\"2020-01-18T13:39:34.249Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":0,\"code\":\"00307\",\"endTime\":\"2020-01-18T13:40:45.256Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum Cleaner\",\"room\":\"662b2cbb-7848-4f71-96f8-5c1ea67adfcf\",\"user\":\"9860dc55-af02-4e78-a7d5-31a87222ba31\",\"item\":\"ab849c8f-df8b-4123-90c4-7cf31aa9820f\",\"comments\":\"Sent to Zoho\"}]","updateId":"6ec6694b-3397-4680-b949-4d64ac79ba4a","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"Window Robot\",\"isInRoom\":false,\"startTime\":\"2020-01-18T13:41:09.083Z\",\"_id\":\"63fecab5-7061-4d75-b7c8-f5e40a7bbe47\",\"_owner\":\"9860dc55-af02-4e78-a7d5-31a87222ba31\",\"_createdDate\":\"2020-01-18T13:41:10.527Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":0,\"code\":\"00778\",\"endTime\":\"2020-01-18T13:41:56.403Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"3ef7be44-a5f8-432a-8554-e7aadd8efc4f\",\"passPrice\":\"20\",\"isOk\":true,\"title\":\"Window Robot\",\"room\":\"662b2cbb-7848-4f71-96f8-5c1ea67adfcf\",\"user\":\"9860dc55-af02-4e78-a7d5-31a87222ba31\",\"item\":\"b78de822-c479-41e1-bd19-7dd3fa3a53a8\",\"comments\":\"Sent to Zoho\"}]","updateId":"63fecab5-7061-4d75-b7c8-f5e40a7bbe47","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"Scooter4\",\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2020-01-18T15:50:36.661Z\",\"_id\":\"b8d2ec9a-975f-4545-9d74-44610899014b\",\"_createdDate\":\"2020-01-18T15:50:37.103Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":30,\"positionText\":\"\",\"baseCost\":2,\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":8,\"code\":\"\",\"endTime\":\"2020-01-18T17:29:16.191Z\",\"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\":\"e3260b2a-c72a-4d1a-bfcd-4087fffa84f0\",\"item\":\"2977cd04-bf49-4920-b014-bde8e191bf06\",\"comments\":\"Sent to Zoho\"}]","updateId":"b8d2ec9a-975f-4545-9d74-44610899014b","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\",\"comments\":\"Sent to Zoho\"}]","updateId":"41151089-504a-48c9-a69f-1d8d5a02590c","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"Vacuum 1\",\"isInRoom\":false,\"startTime\":\"2020-01-18T15:38:56.665Z\",\"_id\":\"2ee6f215-53bc-45be-9ac1-ff0214002655\",\"_createdDate\":\"2020-01-18T15:38:56.862Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":0,\"code\":\"00746\",\"endTime\":\"2020-01-18T15:39:11.187Z\",\"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\":\"692bf396-4b88-472f-b7c6-49eb8ce6fec7\",\"item\":\"3e978b61-60da-4760-a1bc-2e6c92fe9688\",\"comments\":\"Sent to Zoho\"}]","updateId":"2ee6f215-53bc-45be-9ac1-ff0214002655","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"Scooter 2\",\"isInRoom\":false,\"startTime\":\"2020-01-18T13:17:09.564Z\",\"_id\":\"1f4569cb-2ed5-457f-8c6b-dfffc7cbb768\",\"_createdDate\":\"2020-01-18T13:17:09.768Z\",\"passDuration\":\"8\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":25,\"code\":\"00278\",\"endTime\":\"2020-01-18T15:28:58.430Z\",\"rating\":5,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"87b3c643-44df-4696-9fd6-ab41b28b1e1a\",\"passPrice\":\"30\",\"position\":\"2\",\"isOk\":true,\"title\":\"Scooter 2\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"user\":\"cf18a420-96e1-4fe1-8606-06a1238dffcc\",\"item\":\"a5646d03-801a-4e70-8659-685d991d60e2\",\"comments\":\"Sent to Zoho\"}]","updateId":"1f4569cb-2ed5-457f-8c6b-dfffc7cbb768","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"Vacuum 3\",\"isInRoom\":false,\"startTime\":\"2020-01-18T13:38:25.047Z\",\"_id\":\"0771ca11-4150-4df7-addd-9452d77c1b27\",\"_owner\":\"9860dc55-af02-4e78-a7d5-31a87222ba31\",\"_createdDate\":\"2020-01-18T13:38:26.545Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":0,\"code\":\"00562\",\"endTime\":\"2020-01-18T13:39:18.128Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner\",\"room\":\"662b2cbb-7848-4f71-96f8-5c1ea67adfcf\",\"user\":\"9860dc55-af02-4e78-a7d5-31a87222ba31\",\"item\":\"1dea1ba8-9564-42ec-8d9b-60300193c1c6\",\"comments\":\"Sent to Zoho\"}]","updateId":"0771ca11-4150-4df7-addd-9452d77c1b27","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"Vacuum 3\",\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2020-01-18T14:24:46.221Z\",\"_id\":\"2be8bf1a-f323-4dc5-b90b-b2a24aeb2181\",\"_createdDate\":\"2020-01-18T14:24:46.614Z\",\"passDuration\":\"24,48\",\"price\":5,\"baseTime\":60,\"positionText\":\"\",\"baseCost\":5,\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":20,\"code\":\"\",\"endTime\":\"2020-01-19T06:31:22.404Z\",\"rating\":5,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20,20\",\"position\":3,\"isOk\":true,\"title\":\"Vacuum 3\",\"room\":\"79c4d41a-0294-446b-b306-b0413963c9ac\",\"user\":\"523f90aa-764a-4c68-bd6b-85d4bb52575f\",\"item\":\"a334f789-be41-450a-80b4-7bf60649fc8c\",\"comments\":\"Sent to Zoho\"}]","updateId":"2be8bf1a-f323-4dc5-b90b-b2a24aeb2181","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"Vacuum 2\",\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2020-01-18T15:10:19.047Z\",\"_id\":\"26ddf4aa-6fd5-486b-a933-49a65174a87e\",\"_createdDate\":\"2020-01-18T15:10:19.290Z\",\"passDuration\":\"4\",\"price\":5,\"baseTime\":30,\"positionText\":\"\",\"baseCost\":5,\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":0,\"code\":\"00562\",\"endTime\":\"2020-01-18T15:10:33.347Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":2,\"isOk\":true,\"title\":\"Vacuum 2\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"9bd07ad8-8ede-4b49-a324-4fd4579e01ea\",\"item\":\"c830bcf2-511a-4626-a237-2e9b9312eea9\",\"comments\":\"Sent to Zoho\"}]","updateId":"26ddf4aa-6fd5-486b-a933-49a65174a87e","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"Scooter 1\",\"isInRoom\":false,\"startTime\":\"2020-01-18T14:56:07.141Z\",\"_id\":\"821dfdcc-8029-404d-bdb3-92553adcd050\",\"_createdDate\":\"2020-01-18T14:56:07.556Z\",\"passDuration\":\"8\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-08T11:13:24.712Z\",\"total\":5,\"code\":\"00569\",\"endTime\":\"2020-01-18T15:26:43.458Z\",\"rating\":5,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"87b3c643-44df-4696-9fd6-ab41b28b1e1a\",\"passPrice\":\"30\",\"position\":\"1\",\"isOk\":true,\"title\":\"Scooter 1\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"user\":\"f66027df-48c7-442f-af3e-009dc581b307\",\"item\":\"bae1225e-9885-49a3-a018-cd37f16af0eb\",\"comments\":\"Sent to Zoho\"}]","updateId":"821dfdcc-8029-404d-bdb3-92553adcd050","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"Vacuum 3\",\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2020-01-18T15:36:53.133Z\",\"_id\":\"776e5081-38c1-4e19-9e8a-2cf0aaf29eff\",\"_createdDate\":\"2020-01-18T15:36:53.500Z\",\"passDuration\":\"4\",\"price\":5,\"baseTime\":30,\"positionText\":\"\",\"baseCost\":5,\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.594Z\",\"total\":0,\"code\":\"00554\",\"endTime\":\"2020-01-18T15:37:06.729Z\",\"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\":\"692bf396-4b88-472f-b7c6-49eb8ce6fec7\",\"item\":\"42961a91-13f4-4989-91f5-87cba7d99b0e\",\"comments\":\"Sent to Zoho\"}]","updateId":"776e5081-38c1-4e19-9e8a-2cf0aaf29eff","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"Scooter 3\",\"isInRoom\":false,\"startTime\":\"2020-01-18T13:15:22.307Z\",\"_id\":\"a7544292-33d9-4ba8-8e0d-308206018a18\",\"_createdDate\":\"2020-01-18T13:15:22.690Z\",\"passDuration\":\"8\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":25,\"code\":\"00469\",\"endTime\":\"2020-01-18T15:28:45.112Z\",\"rating\":5,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"87b3c643-44df-4696-9fd6-ab41b28b1e1a\",\"passPrice\":\"30\",\"position\":\"3\",\"isOk\":true,\"title\":\"Scooter 3\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"user\":\"0eead063-b83c-4929-89e3-be6505fbe8c7\",\"item\":\"85f2d202-8b7e-497d-b0e4-bdb4a066ed8e\",\"comments\":\"Sent to Zoho\"}]","updateId":"a7544292-33d9-4ba8-8e0d-308206018a18","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"Scooter4\",\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2020-01-18T13:00:54.124Z\",\"_id\":\"c094e7d7-d516-4882-a6ca-d1683ad8933d\",\"_createdDate\":\"2020-01-18T13:00:54.341Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":30,\"positionText\":\"\",\"baseCost\":2,\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":4,\"code\":\"\",\"endTime\":\"2020-01-18T14:04:38.581Z\",\"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\":\"723b76ce-542f-423b-b8fe-58d046ec5475\",\"item\":\"2977cd04-bf49-4920-b014-bde8e191bf06\",\"comments\":\"Sent to Zoho\"}]","updateId":"c094e7d7-d516-4882-a6ca-d1683ad8933d","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"Scooter3\",\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2020-01-18T13:03:44.852Z\",\"_id\":\"fbcd761a-0a75-45c3-a7b6-b62ef8d02bd8\",\"_createdDate\":\"2020-01-18T13:03:45.064Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":30,\"positionText\":\"\",\"baseCost\":2,\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":4,\"code\":\"\",\"endTime\":\"2020-01-18T14:04:41.341Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"87b3c643-44df-4696-9fd6-ab41b28b1e1a\",\"passPrice\":\"12\",\"position\":3,\"isOk\":true,\"title\":\"Scooter3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"0304297a-13e4-45a5-903d-4dc6259111b3\",\"item\":\"1171c7b6-3cb8-4c71-ac38-bcfe6aa7f85e\",\"comments\":\"Sent to Zoho\"}]","updateId":"fbcd761a-0a75-45c3-a7b6-b62ef8d02bd8","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"VR Headset1\",\"isInRoom\":false,\"startTime\":\"2020-01-18T15:47:56.319Z\",\"_id\":\"58cd30a6-f012-4f41-a179-2d645398bebf\",\"_createdDate\":\"2020-01-18T15:47:56.565Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":0,\"endTime\":\"2020-01-18T15:49:41.451Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"2cfa54c9-23d3-4b98-b708-9f9e9611f706\",\"passPrice\":\"12\",\"position\":\"1\",\"isOk\":true,\"title\":\"VR Headset1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"4cacfb58-3982-4be3-8a21-106783a8e903\",\"item\":\"d17eb7fe-3744-48b9-89b0-8334f3628e33\",\"comments\":\"Sent to Zoho\"}]","updateId":"58cd30a6-f012-4f41-a179-2d645398bebf","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}},{"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-14T03:55:32.090Z\",\"zohoId\":\"4280752000001358587\",\"_id\":\"41151089-504a-48c9-a69f-1d8d5a02590c\",\"_createdDate\":\"2020-02-14T03:55:32.330Z\",\"passDuration\":\"4\",\"price\":2,\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-14T03:55:32.330Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"c859a90d-3603-4008-aa1c-b65b9837d18e\",\"passPrice\":\"12\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum Cleaner 3\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"e4c21652-5fb2-43c9-8fcc-d35c042181d6\",\"item\":\"c4c84940-ae26-4f20-bd5c-e6983a694ddb\"},{\"serial\":\"Vacuum 3\",\"ip\":\"\",\"isInRoom\":false,\"startTime\":\"2020-01-18T12:22:51.219Z\",\"_id\":\"7d2dfdcd-70b3-46d8-a80b-39d487a8aaea\",\"_createdDate\":\"2020-01-18T12:22:51.432Z\",\"passDuration\":\"4\",\"price\":5,\"baseTime\":30,\"positionText\":\"\",\"baseCost\":5,\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:40:42.595Z\",\"total\":5,\"code\":\"00554\",\"endTime\":\"2020-01-18T12:54:09.325Z\",\"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\":\"9a739be9-3f60-49db-9c00-316a3b8e7e7d\",\"item\":\"42961a91-13f4-4989-91f5-87cba7d99b0e\",\"comments\":\"Sent to Zoho\"}]","updateId":"7d2dfdcd-70b3-46d8-a80b-39d487a8aaea","_id":"a9c336d5-600f-42c8-87d0-21f396c5fe12"}}}]

User not available