11:51:10.526 DBServer: DevTestVM 11:51:10.526 DBName: APIWhitmore220110 11:51:10.526 UserName: vericool1 11:51:10.526 Password: AWCqnAY3Xxk6aYHdwEfj09udOZXypw 11:51:10.527 got here 5 11:51:10.543 constring is : data source=DevTestVM;initial catalog=APIWhitmore220110;user id=vericool1;password=AWCqnAY3Xxk6aYHdwEfj09udOZXypw;MultipleActiveResultSets=True;App=EntityFramework 11:51:10.550 Connection String is : metadata=res://*/CCDb.csdl|res://*/CCDb.ssdl|res://*/CCDb.msl;provider=System.Data.SqlClient;provider connection string="data source=DevTestVM;initial catalog=APIWhitmore220110;user id=vericool1;password=AWCqnAY3Xxk6aYHdwEfj09udOZXypw;MultipleActiveResultSets=True;App=EntityFramework" 11:51:10.715 Connection String is : metadata=res://*/CCDb.csdl|res://*/CCDb.ssdl|res://*/CCDb.msl;provider=System.Data.SqlClient;provider connection string="data source=DevTestVM;initial catalog=APIWhitmore220110;user id=vericool1;password=AWCqnAY3Xxk6aYHdwEfj09udOZXypw;MultipleActiveResultSets=True;App=EntityFramework" 12:08:59.715 GetCustomers count: 1511 12:09:04.532 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:09:04.533 ExternalID: 12:09:04.533 StartDate: 11/30/2021 11:59:59 PM 12:09:04.533 EndDate: 12/1/2021 12:00:00 AM 12:09:04.533 BalanceImport: True 12:09:38.344 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:09:38.344 ExternalID: 12:09:38.344 StartDate: 12/1/2021 12:00:00 AM 12:09:38.344 EndDate: 12/2/2021 12:00:00 AM 12:09:38.345 BalanceImport: False 12:10:09.814 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:10:09.815 ExternalID: 12:10:09.815 StartDate: 12/1/2021 11:00:00 PM 12:10:09.815 EndDate: 12/3/2021 12:00:00 AM 12:10:09.815 BalanceImport: False 12:10:45.012 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:10:45.012 ExternalID: 12:10:45.012 StartDate: 12/2/2021 11:00:00 PM 12:10:45.013 EndDate: 12/4/2021 12:00:00 AM 12:10:45.013 BalanceImport: False 12:11:20.077 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:11:20.077 ExternalID: 12:11:20.077 StartDate: 12/3/2021 11:00:00 PM 12:11:20.078 EndDate: 12/5/2021 12:00:00 AM 12:11:20.078 BalanceImport: False 12:11:21.023 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:11:21.023 ExternalID: 12:11:21.023 StartDate: 12/4/2021 11:00:00 PM 12:11:21.024 EndDate: 12/6/2021 12:00:00 AM 12:11:21.024 BalanceImport: False 12:11:22.825 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:11:22.825 ExternalID: 12:11:22.825 StartDate: 12/5/2021 11:00:00 PM 12:11:22.825 EndDate: 12/7/2021 12:00:00 AM 12:11:22.826 BalanceImport: False 12:12:00.641 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:12:00.643 ExternalID: 12:12:00.643 StartDate: 12/6/2021 11:00:00 PM 12:12:00.643 EndDate: 12/8/2021 12:00:00 AM 12:12:00.643 BalanceImport: False 12:12:46.967 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:12:46.968 ExternalID: 12:12:46.968 StartDate: 12/7/2021 11:00:00 PM 12:12:46.968 EndDate: 12/9/2021 12:00:00 AM 12:12:46.968 BalanceImport: False 12:13:37.475 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:13:37.476 ExternalID: 12:13:37.476 StartDate: 12/8/2021 11:00:00 PM 12:13:37.476 EndDate: 12/10/2021 12:00:00 AM 12:13:37.476 BalanceImport: False 12:14:28.701 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:14:28.702 ExternalID: 12:14:28.702 StartDate: 12/9/2021 11:00:00 PM 12:14:28.702 EndDate: 12/11/2021 12:00:00 AM 12:14:28.702 BalanceImport: False 12:15:27.013 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:15:27.013 ExternalID: 12:15:27.013 StartDate: 12/10/2021 11:00:00 PM 12:15:27.013 EndDate: 12/12/2021 12:00:00 AM 12:15:27.014 BalanceImport: False 12:15:27.718 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:15:27.718 ExternalID: 12:15:27.719 StartDate: 12/11/2021 11:00:00 PM 12:15:27.719 EndDate: 12/13/2021 12:00:00 AM 12:15:27.720 BalanceImport: False 12:15:29.710 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:15:29.711 ExternalID: 12:15:29.711 StartDate: 12/12/2021 11:00:00 PM 12:15:29.711 EndDate: 12/14/2021 12:00:00 AM 12:15:29.711 BalanceImport: False 12:16:23.743 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:16:23.743 ExternalID: 12:16:23.743 StartDate: 12/13/2021 11:00:00 PM 12:16:23.744 EndDate: 12/15/2021 12:00:00 AM 12:16:23.744 BalanceImport: False 12:17:25.452 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:17:25.453 ExternalID: 12:17:25.453 StartDate: 12/14/2021 11:00:00 PM 12:17:25.454 EndDate: 12/16/2021 12:00:00 AM 12:17:25.454 BalanceImport: False 12:18:24.287 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:18:24.287 ExternalID: 12:18:24.288 StartDate: 12/15/2021 11:00:00 PM 12:18:24.288 EndDate: 12/17/2021 12:00:00 AM 12:18:24.288 BalanceImport: False 12:19:18.515 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:19:18.515 ExternalID: 12:19:18.515 StartDate: 12/16/2021 11:00:00 PM 12:19:18.516 EndDate: 12/18/2021 12:00:00 AM 12:19:18.516 BalanceImport: False 12:20:02.531 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:20:02.531 ExternalID: 12:20:02.532 StartDate: 12/17/2021 11:00:00 PM 12:20:02.532 EndDate: 12/19/2021 12:00:00 AM 12:20:02.532 BalanceImport: False 12:20:03.110 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:20:03.110 ExternalID: 12:20:03.110 StartDate: 12/18/2021 11:00:00 PM 12:20:03.110 EndDate: 12/20/2021 12:00:00 AM 12:20:03.111 BalanceImport: False 12:20:03.239 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:20:03.240 ExternalID: 12:20:03.240 StartDate: 12/19/2021 11:00:00 PM 12:20:03.240 EndDate: 12/21/2021 12:00:00 AM 12:20:03.240 BalanceImport: False 12:20:03.769 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:20:03.769 ExternalID: 12:20:03.769 StartDate: 12/20/2021 11:00:00 PM 12:20:03.770 EndDate: 12/22/2021 12:00:00 AM 12:20:03.770 BalanceImport: False 12:20:04.287 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:20:04.287 ExternalID: 12:20:04.287 StartDate: 12/21/2021 11:00:00 PM 12:20:04.287 EndDate: 12/23/2021 12:00:00 AM 12:20:04.288 BalanceImport: False 12:20:04.436 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:20:04.436 ExternalID: 12:20:04.436 StartDate: 12/22/2021 11:00:00 PM 12:20:04.436 EndDate: 12/24/2021 12:00:00 AM 12:20:04.437 BalanceImport: False 12:20:04.597 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:20:04.598 ExternalID: 12:20:04.598 StartDate: 12/23/2021 11:00:00 PM 12:20:04.598 EndDate: 12/25/2021 12:00:00 AM 12:20:04.599 BalanceImport: False 12:20:05.010 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:20:05.010 ExternalID: 12:20:05.010 StartDate: 12/24/2021 11:00:00 PM 12:20:05.011 EndDate: 12/26/2021 12:00:00 AM 12:20:05.011 BalanceImport: False 12:20:05.191 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:20:05.192 ExternalID: 12:20:05.192 StartDate: 12/25/2021 11:00:00 PM 12:20:05.192 EndDate: 12/27/2021 12:00:00 AM 12:20:05.192 BalanceImport: False 12:20:05.314 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:20:05.314 ExternalID: 12:20:05.315 StartDate: 12/26/2021 11:00:00 PM 12:20:05.315 EndDate: 12/28/2021 12:00:00 AM 12:20:05.315 BalanceImport: False 12:20:05.570 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:20:05.570 ExternalID: 12:20:05.570 StartDate: 12/27/2021 11:00:00 PM 12:20:05.571 EndDate: 12/29/2021 12:00:00 AM 12:20:05.571 BalanceImport: False 12:20:06.172 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:20:06.172 ExternalID: 12:20:06.173 StartDate: 12/28/2021 11:00:00 PM 12:20:06.173 EndDate: 12/30/2021 12:00:00 AM 12:20:06.173 BalanceImport: False 12:20:06.310 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:20:06.310 ExternalID: 12:20:06.310 StartDate: 12/29/2021 11:00:00 PM 12:20:06.311 EndDate: 12/31/2021 12:00:00 AM 12:20:06.311 BalanceImport: False 12:20:06.433 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:20:06.433 ExternalID: 12:20:06.434 StartDate: 12/30/2021 11:00:00 PM 12:20:06.434 EndDate: 1/1/2022 12:00:00 AM 12:20:06.434 BalanceImport: False 12:20:07.112 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:20:07.112 ExternalID: 12:20:07.112 StartDate: 12/31/2021 11:00:00 PM 12:20:07.113 EndDate: 1/2/2022 12:00:00 AM 12:20:07.113 BalanceImport: False 12:20:07.574 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:20:07.574 ExternalID: 12:20:07.574 StartDate: 1/1/2022 11:00:00 PM 12:20:07.574 EndDate: 1/3/2022 12:00:00 AM 12:20:07.575 BalanceImport: False 12:20:08.513 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:20:08.513 ExternalID: 12:20:08.513 StartDate: 1/2/2022 11:00:00 PM 12:20:08.514 EndDate: 1/4/2022 12:00:00 AM 12:20:08.514 BalanceImport: False 12:20:11.301 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:20:11.301 ExternalID: 12:20:11.301 StartDate: 1/3/2022 11:00:00 PM 12:20:11.301 EndDate: 1/5/2022 12:00:00 AM 12:20:11.302 BalanceImport: False 12:20:13.210 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:20:13.210 ExternalID: 12:20:13.211 StartDate: 1/4/2022 11:00:00 PM 12:20:13.211 EndDate: 1/6/2022 12:00:00 AM 12:20:13.211 BalanceImport: False 12:20:17.571 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:20:17.571 ExternalID: 12:20:17.571 StartDate: 1/5/2022 11:00:00 PM 12:20:17.572 EndDate: 1/7/2022 12:00:00 AM 12:20:17.572 BalanceImport: False 12:21:28.947 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:21:28.948 ExternalID: 12:21:28.948 StartDate: 1/6/2022 11:00:00 PM 12:21:28.948 EndDate: 1/8/2022 12:00:00 AM 12:21:28.949 BalanceImport: False 12:21:53.257 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:21:53.258 ExternalID: 12:21:53.258 StartDate: 1/7/2022 11:00:00 PM 12:21:53.258 EndDate: 1/9/2022 12:00:00 AM 12:21:53.259 BalanceImport: False 12:21:53.761 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:21:53.761 ExternalID: 12:21:53.762 StartDate: 1/8/2022 11:00:00 PM 12:21:53.762 EndDate: 1/10/2022 12:00:00 AM 12:21:53.762 BalanceImport: False 12:21:54.802 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:21:54.802 ExternalID: 12:21:54.802 StartDate: 1/9/2022 11:00:00 PM 12:21:54.803 EndDate: 1/11/2022 12:00:00 AM 12:21:54.803 BalanceImport: False 12:22:07.783 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:22:07.783 ExternalID: 12:22:07.784 StartDate: 1/10/2022 11:00:00 PM 12:22:07.784 EndDate: 1/12/2022 12:00:00 AM 12:22:07.784 BalanceImport: False 12:22:07.909 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:22:07.909 ExternalID: 12:22:07.909 StartDate: 1/11/2022 11:00:00 PM 12:22:07.910 EndDate: 1/13/2022 12:00:00 AM 12:22:07.910 BalanceImport: False 12:22:08.810 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:22:08.811 ExternalID: 12:22:08.811 StartDate: 1/12/2022 11:00:00 PM 12:22:08.811 EndDate: 1/14/2022 12:00:00 AM 12:22:08.811 BalanceImport: False 12:22:08.969 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:22:08.969 ExternalID: 12:22:08.969 StartDate: 1/13/2022 11:00:00 PM 12:22:08.969 EndDate: 1/15/2022 12:00:00 AM 12:22:08.969 BalanceImport: False 12:22:09.113 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:22:09.113 ExternalID: 12:22:09.114 StartDate: 1/14/2022 11:00:00 PM 12:22:09.114 EndDate: 1/16/2022 12:00:00 AM 12:22:09.114 BalanceImport: False 12:22:09.276 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:22:09.276 ExternalID: 12:22:09.276 StartDate: 1/15/2022 11:00:00 PM 12:22:09.277 EndDate: 1/17/2022 12:00:00 AM 12:22:09.277 BalanceImport: False 12:22:09.421 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:22:09.421 ExternalID: 12:22:09.421 StartDate: 1/16/2022 11:00:00 PM 12:22:09.421 EndDate: 1/18/2022 12:00:00 AM 12:22:09.422 BalanceImport: False 12:22:09.853 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:22:09.854 ExternalID: 12:22:09.854 StartDate: 1/17/2022 11:00:00 PM 12:22:09.854 EndDate: 1/19/2022 12:00:00 AM 12:22:09.854 BalanceImport: False 12:22:10.159 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:22:10.160 ExternalID: 12:22:10.160 StartDate: 1/18/2022 11:00:00 PM 12:22:10.160 EndDate: 1/20/2022 12:00:00 AM 12:22:10.160 BalanceImport: False 12:22:10.554 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:22:10.554 ExternalID: 12:22:10.555 StartDate: 1/19/2022 11:00:00 PM 12:22:10.555 EndDate: 1/21/2022 12:00:00 AM 12:22:10.555 BalanceImport: False 12:22:10.881 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:22:10.882 ExternalID: 12:22:10.882 StartDate: 1/20/2022 11:00:00 PM 12:22:10.882 EndDate: 1/22/2022 12:00:00 AM 12:22:10.882 BalanceImport: False 12:22:11.254 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:22:11.254 ExternalID: 12:22:11.254 StartDate: 1/21/2022 11:00:00 PM 12:22:11.254 EndDate: 1/23/2022 12:00:00 AM 12:22:11.254 BalanceImport: False 12:22:11.434 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:22:11.435 ExternalID: 12:22:11.435 StartDate: 1/22/2022 11:00:00 PM 12:22:11.435 EndDate: 1/24/2022 12:00:00 AM 12:22:11.435 BalanceImport: False 12:22:11.607 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:22:11.607 ExternalID: 12:22:11.607 StartDate: 1/23/2022 11:00:00 PM 12:22:11.608 EndDate: 1/25/2022 12:00:00 AM 12:22:11.608 BalanceImport: False 12:22:11.763 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:22:11.763 ExternalID: 12:22:11.764 StartDate: 1/24/2022 11:00:00 PM 12:22:11.764 EndDate: 1/26/2022 12:00:00 AM 12:22:11.764 BalanceImport: False 12:22:11.950 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:22:11.950 ExternalID: 12:22:11.950 StartDate: 1/25/2022 11:00:00 PM 12:22:11.951 EndDate: 1/27/2022 12:00:00 AM 12:22:11.951 BalanceImport: False 12:22:12.119 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:22:12.119 ExternalID: 12:22:12.119 StartDate: 1/26/2022 11:00:00 PM 12:22:12.119 EndDate: 1/28/2022 12:00:00 AM 12:22:12.120 BalanceImport: False 12:22:12.290 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:22:12.290 ExternalID: 12:22:12.290 StartDate: 1/27/2022 11:00:00 PM 12:22:12.290 EndDate: 1/29/2022 12:00:00 AM 12:22:12.291 BalanceImport: False 12:22:12.460 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:22:12.460 ExternalID: 12:22:12.460 StartDate: 1/28/2022 11:00:00 PM 12:22:12.461 EndDate: 1/30/2022 12:00:00 AM 12:22:12.461 BalanceImport: False 12:22:12.583 RequestTransactions: f873f364-3c99-4d5d-9fdf-7da9577edecc 12:22:12.583 ExternalID: 12:22:12.583 StartDate: 1/29/2022 11:00:00 PM 12:22:12.583 EndDate: 1/31/2022 12:08:58 PM 12:22:12.583 BalanceImport: False