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"}}}]

User not available