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

Msg: Error - sendToBigQuery
Info: ["run: sendToBigQuery",{"data Id":"203ee193-b54d-4e98-a725-448b863152d5"},{"method":"Insert"},{"res: getTableSchema":"ok"},"run: insertToTable","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: insertToTable":"ok"},{"res: upsertTable":"ok"},"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-13T23:59:31.694Z\",\"zohoId\":\"4280752000001375727\",\"_id\":\"3408c73a-01ba-4a9f-b630-76ec24d8c574\",\"_createdDate\":\"2020-02-13T23:59:31.931Z\",\"passDuration\":\"24,72\",\"price\":1,\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:59:31.931Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"90aa3f33-ec24-4b5b-a79a-4b8be251991d\",\"passPrice\":\"6,12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Air Mattress 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"c5491041-0741-465c-96f2-6c7a77bbb786\",\"item\":\"41ade029-45aa-4412-819f-81e871b85e22\"},{\"serial\":\"Printer2\",\"ip\":\"9a1b839b-e93a-d4ae-1421-aeec7bd94b2c\",\"isInRoom\":false,\"startTime\":\"2020-01-25T15:36:58.948Z\",\"_id\":\"a72f79f5-972d-4902-a882-518879414295\",\"_createdDate\":\"2020-01-25T15:36:59.171Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:39:43.279Z\",\"total\":2.2,\"files\":\"[{\\\"label\\\":\\\"PGEOG130_PreLabB-E.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/f1c139_bdea874bd56840f68a1e73845f9806c6.pdf\\\",\\\"pageCount\\\":18},{\\\"label\\\":\\\"PGEOG130_PreLabA.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/f1c139_a75440d9200346619bc960b0728a1270.pdf\\\",\\\"pageCount\\\":4}]\",\"endTime\":\"2020-01-25T15:36:59.840Z\",\"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\":\"f1c1394e-9639-48bb-8fb9-6a61bacc7b02\",\"item\":\"a441821a-172d-4e0b-9541-c24fc4730ca0\",\"comments\":\"Sent to Zoho\"}]","updateId":"a72f79f5-972d-4902-a882-518879414295","_id":"ed17f406-4da0-4096-b1ae-025bacb33877"}}},{"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-13T23:59:31.694Z\",\"zohoId\":\"4280752000001375727\",\"_id\":\"3408c73a-01ba-4a9f-b630-76ec24d8c574\",\"_createdDate\":\"2020-02-13T23:59:31.931Z\",\"passDuration\":\"24,72\",\"price\":1,\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:59:31.931Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"90aa3f33-ec24-4b5b-a79a-4b8be251991d\",\"passPrice\":\"6,12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Air Mattress 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"c5491041-0741-465c-96f2-6c7a77bbb786\",\"item\":\"41ade029-45aa-4412-819f-81e871b85e22\"},{\"serial\":\"Waffe Maker\",\"isInRoom\":false,\"startTime\":\"2020-01-25T14:39:32.346Z\",\"_id\":\"147b6b33-2266-47c1-9148-f9316fdd0f81\",\"_createdDate\":\"2020-01-25T14:39:32.512Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:39:43.279Z\",\"total\":2,\"code\":\"\",\"endTime\":\"2020-01-25T15:09:17.482Z\",\"rating\":5,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"52aa7a49-ac80-4344-b9a9-1e1d5edcce0f\",\"passPrice\":\"12\",\"position\":0,\"isOk\":true,\"title\":\"Waffe Maker\",\"room\":\"e555aa2b-012a-4962-9f63-0614647e94c3\",\"user\":\"1221bddf-4e4e-42b8-ac45-3b6ed9f8928a\",\"item\":\"655c114d-e8d3-42b3-8e2b-5cd14e546d08\",\"comments\":\"Sent to Zoho\"}]","updateId":"147b6b33-2266-47c1-9148-f9316fdd0f81","_id":"ed17f406-4da0-4096-b1ae-025bacb33877"}}},{"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-13T23:59:31.694Z\",\"zohoId\":\"4280752000001375727\",\"_id\":\"3408c73a-01ba-4a9f-b630-76ec24d8c574\",\"_createdDate\":\"2020-02-13T23:59:31.931Z\",\"passDuration\":\"24,72\",\"price\":1,\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:59:31.931Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"90aa3f33-ec24-4b5b-a79a-4b8be251991d\",\"passPrice\":\"6,12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Air Mattress 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"c5491041-0741-465c-96f2-6c7a77bbb786\",\"item\":\"41ade029-45aa-4412-819f-81e871b85e22\"},{\"serial\":\"Printer TAU1\",\"ip\":\"a4f59581-f76e-b4c6-c901-a031d32a0b54\",\"isInRoom\":false,\"startTime\":\"2020-01-25T12:44:37.870Z\",\"_id\":\"1290dde3-cab3-48a7-972e-6719af9d60a4\",\"_createdDate\":\"2020-01-25T12:44:38.354Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:39:43.279Z\",\"total\":0.8,\"files\":\"[{\\\"label\\\":\\\"דף נוסחאות למבחן.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/c77b7a_e5378478c12040af9bde4fa89478382a.pdf\\\",\\\"pageCount\\\":8}]\",\"code\":\"111\",\"endTime\":\"2020-01-25T12:44:39.133Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"isOk\":true,\"title\":\"Printer Doorms_Bike_Room\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"user\":\"c77b7a7b-5c9d-44a4-9971-461dcf2c356c\",\"item\":\"abf60330-d8b5-475c-b94d-f77f232a1719\",\"comments\":\"Sent to Zoho\"}]","updateId":"1290dde3-cab3-48a7-972e-6719af9d60a4","_id":"ed17f406-4da0-4096-b1ae-025bacb33877"}}},{"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-13T23:59:31.694Z\",\"zohoId\":\"4280752000001375727\",\"_id\":\"3408c73a-01ba-4a9f-b630-76ec24d8c574\",\"_createdDate\":\"2020-02-13T23:59:31.931Z\",\"passDuration\":\"24,72\",\"price\":1,\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:59:31.931Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"90aa3f33-ec24-4b5b-a79a-4b8be251991d\",\"passPrice\":\"6,12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Air Mattress 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"c5491041-0741-465c-96f2-6c7a77bbb786\",\"item\":\"41ade029-45aa-4412-819f-81e871b85e22\"},{\"serial\":\"Printer TAU1\",\"ip\":\"a4f59581-f76e-b4c6-c901-a031d32a0b54\",\"isInRoom\":false,\"startTime\":\"2020-01-25T12:42:51.105Z\",\"_id\":\"203ee193-b54d-4e98-a725-448b863152d5\",\"_createdDate\":\"2020-01-25T12:42:51.539Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:39:43.279Z\",\"total\":1.2,\"files\":\"[{\\\"label\\\":\\\"דף נוסחאות מעודכן 2.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/bcee32_e2e5c9ae6dfc43b1bc7eb9cbff73a11e.pdf\\\",\\\"pageCount\\\":4}]\",\"code\":\"111\",\"endTime\":\"2020-01-25T12:42:52.327Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"isOk\":true,\"title\":\"Printer Doorms_Bike_Room\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"user\":\"c77b7a7b-5c9d-44a4-9971-461dcf2c356c\",\"item\":\"abf60330-d8b5-475c-b94d-f77f232a1719\",\"comments\":\"Sent to Zoho\"}]","updateId":"203ee193-b54d-4e98-a725-448b863152d5","_id":"ed17f406-4da0-4096-b1ae-025bacb33877"}}},{"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-13T23:59:31.694Z\",\"zohoId\":\"4280752000001375727\",\"_id\":\"3408c73a-01ba-4a9f-b630-76ec24d8c574\",\"_createdDate\":\"2020-02-13T23:59:31.931Z\",\"passDuration\":\"24,72\",\"price\":1,\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:59:31.931Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"90aa3f33-ec24-4b5b-a79a-4b8be251991d\",\"passPrice\":\"6,12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Air Mattress 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"c5491041-0741-465c-96f2-6c7a77bbb786\",\"item\":\"41ade029-45aa-4412-819f-81e871b85e22\"},{\"serial\":\"Printer1\",\"ip\":\"fabb36f8-7c44-ecb0-09dc-59b4d4b6a5cd\",\"isInRoom\":false,\"startTime\":\"2020-01-25T15:33:38.341Z\",\"_id\":\"6339dad1-b417-4510-ad80-95f9d0fb2a20\",\"_createdDate\":\"2020-01-25T15:33:38.541Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:39:43.279Z\",\"total\":0.1,\"files\":\"[{\\\"label\\\":\\\"Rishum_5_81525417.PDF\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/f1c139_3445a3726bc34308ae1499b27e69cf85.pdf\\\",\\\"pageCount\\\":1}]\",\"endTime\":\"2020-01-25T15:33:38.641Z\",\"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\":\"f1c1394e-9639-48bb-8fb9-6a61bacc7b02\",\"item\":\"f09a60f2-b63d-4e2d-bd97-7d83d2b9a9f2\",\"comments\":\"Sent to Zoho\"}]","updateId":"6339dad1-b417-4510-ad80-95f9d0fb2a20","_id":"ed17f406-4da0-4096-b1ae-025bacb33877"}}},{"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-13T23:59:31.694Z\",\"zohoId\":\"4280752000001375727\",\"_id\":\"3408c73a-01ba-4a9f-b630-76ec24d8c574\",\"_createdDate\":\"2020-02-13T23:59:31.931Z\",\"passDuration\":\"24,72\",\"price\":1,\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:59:31.931Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"90aa3f33-ec24-4b5b-a79a-4b8be251991d\",\"passPrice\":\"6,12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Air Mattress 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"c5491041-0741-465c-96f2-6c7a77bbb786\",\"item\":\"41ade029-45aa-4412-819f-81e871b85e22\"},{\"serial\":\"TRX\",\"isInRoom\":false,\"startTime\":\"2020-01-25T14:48:45.935Z\",\"_id\":\"4f680075-3199-4bbc-8217-2a19364fec9c\",\"_createdDate\":\"2020-01-25T14:48:46.103Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"2\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:39:43.280Z\",\"total\":2,\"endTime\":\"2020-01-25T15:05:34.457Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"87e8e268-4104-48ab-a45c-2e4e80880927\",\"passPrice\":\"12\",\"isOk\":true,\"title\":\"TRX\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"27db7aad-2a6f-43bd-a1de-50e99278f11f\",\"item\":\"828b6f29-752c-4576-a103-fa373a3c3f3a\",\"comments\":\"Sent to Zoho\"}]","updateId":"4f680075-3199-4bbc-8217-2a19364fec9c","_id":"ed17f406-4da0-4096-b1ae-025bacb33877"}}},"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-13T23:59:31.694Z\",\"zohoId\":\"4280752000001375727\",\"_id\":\"3408c73a-01ba-4a9f-b630-76ec24d8c574\",\"_createdDate\":\"2020-02-13T23:59:31.931Z\",\"passDuration\":\"24,72\",\"price\":1,\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:59:31.931Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"90aa3f33-ec24-4b5b-a79a-4b8be251991d\",\"passPrice\":\"6,12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Air Mattress 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"c5491041-0741-465c-96f2-6c7a77bbb786\",\"item\":\"41ade029-45aa-4412-819f-81e871b85e22\"},{\"serial\":\"Vacuum 2\",\"isInRoom\":false,\"startTime\":\"2020-01-25T15:09:07.013Z\",\"_id\":\"a69e5465-de70-48a8-a5d9-043dc6f1b5d2\",\"_createdDate\":\"2020-01-25T15:09:07.312Z\",\"passDuration\":\"4\",\"price\":5,\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:39:43.279Z\",\"total\":5,\"code\":\"00563\",\"endTime\":\"2020-01-25T15:15:42.291Z\",\"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\":\"f7b39c8f-919f-40d1-905c-d2d0949cabea\",\"item\":\"c830bcf2-511a-4626-a237-2e9b9312eea9\",\"comments\":\"Sent to Zoho\"}]","updateId":"a69e5465-de70-48a8-a5d9-043dc6f1b5d2","_id":"ed17f406-4da0-4096-b1ae-025bacb33877"}}},{"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-13T23:59:31.694Z\",\"zohoId\":\"4280752000001375727\",\"_id\":\"3408c73a-01ba-4a9f-b630-76ec24d8c574\",\"_createdDate\":\"2020-02-13T23:59:31.931Z\",\"passDuration\":\"24,72\",\"price\":1,\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:59:31.931Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"90aa3f33-ec24-4b5b-a79a-4b8be251991d\",\"passPrice\":\"6,12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Air Mattress 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"c5491041-0741-465c-96f2-6c7a77bbb786\",\"item\":\"41ade029-45aa-4412-819f-81e871b85e22\"},{\"serial\":\"Printer TAU1\",\"ip\":\"c6cdca1f-865c-4ec0-43c1-a8fead960de7\",\"isInRoom\":false,\"startTime\":\"2020-01-25T13:58:56.439Z\",\"_id\":\"5457bff3-f8e6-4d8a-8e28-a04cbad402d9\",\"_createdDate\":\"2020-01-25T13:58:56.951Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-04T12:32:15.740Z\",\"total\":0.8,\"files\":\"[{\\\"label\\\":\\\"מבחן לדוגמה תשעח סמסטר א_d8a627e521860ec989aec03d70839d23.PDF\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/978983_12b7f7162ddb458c80a58ae95fb9e3c6.pdf\\\",\\\"pageCount\\\":8}]\",\"endTime\":\"2020-01-25T13:58:57.695Z\",\"rating\":4,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"isOk\":true,\"title\":\"Printer Doorms_Lobby\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"8716b16c-01fa-45bc-b544-1f0fed5171f3\",\"item\":\"569ae57a-a4ed-4645-b67c-a96da9f7a673\",\"comments\":\"Sent to Zoho\"}]","updateId":"5457bff3-f8e6-4d8a-8e28-a04cbad402d9","_id":"ed17f406-4da0-4096-b1ae-025bacb33877"}}},{"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-13T23:59:31.694Z\",\"zohoId\":\"4280752000001375727\",\"_id\":\"3408c73a-01ba-4a9f-b630-76ec24d8c574\",\"_createdDate\":\"2020-02-13T23:59:31.931Z\",\"passDuration\":\"24,72\",\"price\":1,\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:59:31.931Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"90aa3f33-ec24-4b5b-a79a-4b8be251991d\",\"passPrice\":\"6,12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Air Mattress 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"c5491041-0741-465c-96f2-6c7a77bbb786\",\"item\":\"41ade029-45aa-4412-819f-81e871b85e22\"},{\"serial\":\"Printer TAU1\",\"ip\":\"a4f59581-f76e-b4c6-c901-a031d32a0b54\",\"isInRoom\":false,\"startTime\":\"2020-01-25T13:17:03.863Z\",\"_id\":\"22f7defe-a210-47f1-b5a9-04a4454142e5\",\"_createdDate\":\"2020-01-25T13:17:04.311Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:39:43.280Z\",\"total\":1.5,\"files\":\"[{\\\"label\\\":\\\"best work שאלון.pdf\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/987d94_57452a0a9bd948f7a21a5fd70e634902.pdf\\\",\\\"pageCount\\\":5}]\",\"code\":\"111\",\"endTime\":\"2020-01-25T13:17:05.042Z\",\"rating\":2,\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"isOk\":true,\"title\":\"Printer Doorms_Bike_Room\",\"room\":\"e6ea3108-beb7-4692-be45-a53e85601a5a\",\"user\":\"987d94fd-15bb-4e5f-8634-a94df80b3474\",\"item\":\"abf60330-d8b5-475c-b94d-f77f232a1719\",\"comments\":\"Sent to Zoho\"}]","updateId":"22f7defe-a210-47f1-b5a9-04a4454142e5","_id":"ed17f406-4da0-4096-b1ae-025bacb33877"}}},{"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-13T23:59:31.694Z\",\"zohoId\":\"4280752000001375727\",\"_id\":\"3408c73a-01ba-4a9f-b630-76ec24d8c574\",\"_createdDate\":\"2020-02-13T23:59:31.931Z\",\"passDuration\":\"24,72\",\"price\":1,\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:59:31.931Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"90aa3f33-ec24-4b5b-a79a-4b8be251991d\",\"passPrice\":\"6,12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Air Mattress 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"c5491041-0741-465c-96f2-6c7a77bbb786\",\"item\":\"41ade029-45aa-4412-819f-81e871b85e22\"},{\"serial\":\"Vacuum 3\",\"isInRoom\":false,\"startTime\":\"2020-01-25T14:39:16.966Z\",\"_id\":\"63675f3a-9625-49b6-84c6-917b3e52fd28\",\"_createdDate\":\"2020-01-25T14:39:17.270Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:39:43.279Z\",\"total\":5,\"endTime\":\"2020-01-25T14:47:45.133Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"3\",\"isOk\":true,\"title\":\"Vacuum 3\",\"room\":\"69852922-a287-45c6-81b1-41be6097320d\",\"user\":\"d0fa4f86-9f7c-45eb-a21d-b90a6ec5e754\",\"item\":\"3f66ddb6-8e3f-42ae-ba64-e8248376029f\",\"comments\":\"Sent to Zoho\"}]","updateId":"63675f3a-9625-49b6-84c6-917b3e52fd28","_id":"ed17f406-4da0-4096-b1ae-025bacb33877"}}},{"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-13T23:59:31.694Z\",\"zohoId\":\"4280752000001375727\",\"_id\":\"3408c73a-01ba-4a9f-b630-76ec24d8c574\",\"_createdDate\":\"2020-02-13T23:59:31.931Z\",\"passDuration\":\"24,72\",\"price\":1,\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:59:31.931Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"90aa3f33-ec24-4b5b-a79a-4b8be251991d\",\"passPrice\":\"6,12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Air Mattress 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"c5491041-0741-465c-96f2-6c7a77bbb786\",\"item\":\"41ade029-45aa-4412-819f-81e871b85e22\"},{\"serial\":\"Vacuum 1\",\"isInRoom\":false,\"startTime\":\"2020-01-25T14:20:52.332Z\",\"_id\":\"b5071c1b-a485-4862-ba33-af4b57bd49ef\",\"_createdDate\":\"2020-01-25T14:20:52.709Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:39:43.279Z\",\"total\":5,\"endTime\":\"2020-01-25T14:36:12.619Z\",\"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\":\"d0fa4f86-9f7c-45eb-a21d-b90a6ec5e754\",\"item\":\"c58647b8-8057-4a11-981b-c68120e5eba2\",\"comments\":\"Sent to Zoho\"}]","updateId":"b5071c1b-a485-4862-ba33-af4b57bd49ef","_id":"ed17f406-4da0-4096-b1ae-025bacb33877"}}},{"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-13T23:59:31.694Z\",\"zohoId\":\"4280752000001375727\",\"_id\":\"3408c73a-01ba-4a9f-b630-76ec24d8c574\",\"_createdDate\":\"2020-02-13T23:59:31.931Z\",\"passDuration\":\"24,72\",\"price\":1,\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:59:31.931Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"90aa3f33-ec24-4b5b-a79a-4b8be251991d\",\"passPrice\":\"6,12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Air Mattress 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"c5491041-0741-465c-96f2-6c7a77bbb786\",\"item\":\"41ade029-45aa-4412-819f-81e871b85e22\"},{\"serial\":\"Vacuum 2\",\"isInRoom\":false,\"startTime\":\"2020-01-25T14:14:03.527Z\",\"_id\":\"7d048540-f4f8-446e-b480-ebb6bd198d3e\",\"_createdDate\":\"2020-01-25T14:14:04.001Z\",\"passDuration\":\"4\",\"price\":5,\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:39:43.280Z\",\"total\":5,\"code\":\"00563\",\"endTime\":\"2020-01-25T14:22:55.117Z\",\"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\":\"0d4a27bd-adc7-416e-b360-7eed0b9232f0\",\"item\":\"c830bcf2-511a-4626-a237-2e9b9312eea9\",\"comments\":\"Sent to Zoho\"}]","updateId":"7d048540-f4f8-446e-b480-ebb6bd198d3e","_id":"ed17f406-4da0-4096-b1ae-025bacb33877"}}},{"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-13T23:59:31.694Z\",\"zohoId\":\"4280752000001375727\",\"_id\":\"3408c73a-01ba-4a9f-b630-76ec24d8c574\",\"_createdDate\":\"2020-02-13T23:59:31.931Z\",\"passDuration\":\"24,72\",\"price\":1,\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:59:31.931Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"90aa3f33-ec24-4b5b-a79a-4b8be251991d\",\"passPrice\":\"6,12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Air Mattress 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"c5491041-0741-465c-96f2-6c7a77bbb786\",\"item\":\"41ade029-45aa-4412-819f-81e871b85e22\"},{\"serial\":\"***\",\"isInRoom\":false,\"startTime\":\"2020-02-13T23:59:31.694Z\",\"zohoId\":\"4280752000001375727\",\"_id\":\"3408c73a-01ba-4a9f-b630-76ec24d8c574\",\"_createdDate\":\"2020-02-13T23:59:31.931Z\",\"passDuration\":\"24,72\",\"price\":1,\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:59:31.931Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"90aa3f33-ec24-4b5b-a79a-4b8be251991d\",\"passPrice\":\"6,12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Air Mattress 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"c5491041-0741-465c-96f2-6c7a77bbb786\",\"item\":\"41ade029-45aa-4412-819f-81e871b85e22\",\"comments\":\"Sent to Zoho\"}]","updateId":"3408c73a-01ba-4a9f-b630-76ec24d8c574","_id":"ed17f406-4da0-4096-b1ae-025bacb33877"}}},{"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-13T23:59:31.694Z\",\"zohoId\":\"4280752000001375727\",\"_id\":\"3408c73a-01ba-4a9f-b630-76ec24d8c574\",\"_createdDate\":\"2020-02-13T23:59:31.931Z\",\"passDuration\":\"24,72\",\"price\":1,\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:59:31.931Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"90aa3f33-ec24-4b5b-a79a-4b8be251991d\",\"passPrice\":\"6,12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Air Mattress 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"c5491041-0741-465c-96f2-6c7a77bbb786\",\"item\":\"41ade029-45aa-4412-819f-81e871b85e22\"},{\"serial\":\"Vacuum 2\",\"isInRoom\":false,\"startTime\":\"2020-01-25T14:48:00.000Z\",\"_id\":\"dac7b081-57e7-478b-ad00-a9b45944867a\",\"_createdDate\":\"2020-01-25T14:48:16.403Z\",\"passDuration\":\"4\",\"baseTime\":\"30\",\"baseCost\":\"5\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-02T15:39:43.279Z\",\"total\":5,\"endTime\":\"2020-01-25T15:17:00.000Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"e02a079d-0e1a-4c45-a005-9b4ea0d272f3\",\"passPrice\":\"20\",\"position\":\"2\",\"isOk\":true,\"title\":\"Vacuum 2\",\"room\":\"69852922-a287-45c6-81b1-41be6097320d\",\"user\":\"815317f9-75aa-4d13-9a53-aa7d5af5877c\",\"item\":\"0324bc08-69a5-4705-b280-509011f2b18f\",\"comments\":\"Sent to Zoho\"}]","updateId":"dac7b081-57e7-478b-ad00-a9b45944867a","_id":"ed17f406-4da0-4096-b1ae-025bacb33877"}}},{"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-13T23:59:31.694Z\",\"zohoId\":\"4280752000001375727\",\"_id\":\"3408c73a-01ba-4a9f-b630-76ec24d8c574\",\"_createdDate\":\"2020-02-13T23:59:31.931Z\",\"passDuration\":\"24,72\",\"price\":1,\"baseTime\":\"30\",\"baseCost\":\"1\",\"roomType\":\"smart\",\"_updatedDate\":\"2020-02-13T23:59:31.931Z\",\"status\":\"212b9b88-d445-464b-bcd9-2f3d2984aeed\",\"itemType\":\"90aa3f33-ec24-4b5b-a79a-4b8be251991d\",\"passPrice\":\"6,12\",\"position\":\"1\",\"isOk\":true,\"title\":\"Air Mattress 1\",\"room\":\"aea5a972-d869-4f6c-a6b2-6314faaa2778\",\"user\":\"c5491041-0741-465c-96f2-6c7a77bbb786\",\"item\":\"41ade029-45aa-4412-819f-81e871b85e22\"},{\"serial\":\"Printer TAU1\",\"ip\":\"c6cdca1f-865c-4ec0-43c1-a8fead960de7\",\"isInRoom\":false,\"startTime\":\"2020-01-25T14:27:11.324Z\",\"_id\":\"893634a0-3c87-45ab-9905-9126d69ebbe5\",\"_createdDate\":\"2020-01-25T14:27:11.756Z\",\"baseTime\":\"30\",\"baseCost\":\"0.1\",\"roomType\":\"regular\",\"_updatedDate\":\"2020-02-02T15:39:43.279Z\",\"total\":1.9,\"files\":\"[{\\\"label\\\":\\\"ד2 מערכת התנועה – שריר סופי.docx\\\",\\\"value\\\":\\\"https://docs.wixstatic.com/ugd/3385a7_560174b46965495f8d17b60229e0e720.docx\\\",\\\"pageCount\\\":19}]\",\"endTime\":\"2020-01-25T14:27:12.432Z\",\"status\":\"2ccdb14c-c119-4fd5-8e5e-9ba770cbe4d7\",\"itemType\":\"98ae3ce9-d6d2-4c23-bd90-394726344f59\",\"isOk\":true,\"title\":\"Printer Doorms_Lobby\",\"room\":\"b6f8ee29-5468-4bda-a7dd-ff32b7c9e75f\",\"user\":\"3385a77a-5216-416a-beed-ee98e9ed4ee6\",\"item\":\"569ae57a-a4ed-4645-b67c-a96da9f7a673\",\"comments\":\"Sent to Zoho\"}]","updateId":"893634a0-3c87-45ab-9905-9126d69ebbe5","_id":"ed17f406-4da0-4096-b1ae-025bacb33877"}}}]

User not available