did we sync the hs id 92234119004 lately?

Finservdna claude-opus-4-6 2026-03-04 20:15 5 messages
claude-code auto-imported
user 2026-03-04 20:15:23
did we sync the hs id 92234119004 lately?
assistant 2026-03-04 20:27:00 claude-opus-4-6
No trace of HubSpot ID **92234119004** was found anywhere in the project — not in log files, data files, results, sync records, or source code. This was searched across all `.log`, `.dat`, `.json`, `.csv`, `.txt`, and `.php` files including archived logs in `__logs20260216/`. This means either: - This HS ID was **never synced** through this system - Any logs referencing it have been **rotated/purged** - It may exist only in HubSpot's CRM but hasn't been pulled into a local sync Would you like me to check the database directly (if there's a DB connection configured) or look into the sync scripts to see how you could trigger a sync for this specific ID?
user 2026-03-04 20:31:39
in leads table we have it as row below. why __shortTermSync.sh and neither __longTermSync.sh sent this record to hubspot? 'jared.hitchens@envistacu.com', '92234119004', '2025-01-13 20:30:51', '2026-01-15 20:07:50', '91970a64-26cf-9728-c0bb-678577cc6ac0', '0', '2025-01-13 20:30:51', '2026-01-15 20:07:50', '1', '1', '1', '0', '2009-03-03', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'JARED', 'HITCHENS', NULL, NULL, NULL, NULL, 'New', NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'jared.hitchens@envistacu.com', 'JAREDHITCHENS86@GMAIL.COM', '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'eyJzdGF0dXMiOiJlcnJvciIsIm1lc3NhZ2UiOiJDYW5ub3Qgc2V0IFByb3BlcnR5VmFsdWVDb29yZGluYXRlc3twb3J0YWxJZD00NDQyODg5Nywgb2JqZWN0VHlwZUlkPU9iamVjdFR5cGVJZHtsZWdhY3lPYmplY3RUeXBlPUNPTlRBQ1R9LCBwcm9wZXJ0eU5hbWU9ZW1haWwsIHZhbHVlPWphcmVkLmhpdGNoZW5zQGVudmlzdGFjdS5jb219IG9uIDkyMjM0MTE5MDA0LiAxMjA0NzYwNzcxMzQgYWxyZWFkeSBoYXMgdGhhdCB2YWx1ZS4iLCJjb3JyZWxhdGlvbklkIjoiNjZmNWNiNzEtMzRlOS00NWUxLTljNmQtY2E3Mzc4NGQ1ZWYxIiwiY2F0ZWdvcnkiOiJWQUxJREFUSU9OX0VSUk9SIn0=', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, '0', '0', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '91970a64-26cf-9728-c0bb-678577cc6ac0', '92234119004', NULL, '0', '', '', '', '0', '', NULL, '0', '', NULL, '0', '', NULL, '', '', '', '0', '0', '', '', '', '', '', '0', '0', NULL, '0', NULL, NULL, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL, NULL, NULL, '33864', 'eyJpZCI6IjMzODY0IiwicGVyc29uTnVtYmVyIjozMzg2NCwicmVzaWRlbnRUYXhDb3VudHJ5Q29kZSI6IlVTQSIsImxhc3ROYW1lIjoiSElUQ0hFTlMiLCJmaXJzdE5hbWUiOiJKQVJFRCIsIm1pZGRsZUluaXRpYWwiOiJNIiwidGF4SWQiOiIqKiotKiotMTQ3NCIsImFkZERhdGUiOiIyMDA5LTAzLTAzIiwiYmlydGhEYXRlIjoiMTk4MC0wOS0xNSIsInRheENlcnRpZmljYXRpb25EYXRlIjoiMjAwOS0wMy0wMyIsIm9jY3VwYXRpb25Db2RlIjoiT1RIUiIsImlzVmFsaWQiOnRydWUsImxhc3RNYWludGFpbmVkIjoiMjAyNS0wMy0wNlQxMjozMDo1My4wMDAtMDY6MDAiLCJsYXN0TmFtZVVwcGVyIjoiSElUQ0hFTlMiLCJmaXJzdE5hbWVVcHBlciI6IkpBUkVEIiwiaXNSZXBvcnQxMDQycyI6ZmFsc2UsImlzUHJpdmFjeSI6ZmFsc2UsImlzUHVyZ2UiOmZhbHNlLCJmdWxsTmFtZVdpdGhTZWNvbmRTdXJOYW1lIjoiSkFSRUQgTS4gSElUQ0hFTlMiLCJ1cmwiOiJcL1BlcnNvbnNcLzMzODY0IiwiYWdlIjo0NSwibWVtYmVyTnVtYmVyIjoxMjE4NDAsIm5hbWVGdWxsIjoiSkFSRUQgTS4gSElUQ0hFTlMiLCJ0aW1lV2l0aEluc3RpdHV0aW9uIjoiMTYgWWVhcnMsIDEwIE1vbnRocyIsIm5hbWVMYXN0Rmlyc3QiOiJISVRDSEVOUyBKQVJFRCIsImZpcnN0TWlkZGxlSW5pdGlhbExhc3RTdWZmaXgiOiJKQVJFRCBNLiBISVRDSEVOUyIsIm5hbWVMYXN0Rmlyc3RJbml0aWFsIjoiSElUQ0hFTlMsIEouIiwibmFtZUxhc3RGaXJzdE1pZGRsZVN1ZmZpeCI6IkhJVENIRU5TLCBKQVJFRCBNLiIsIm5hbWVMYXN0Rmlyc3RNaWRkbGUiOiJISVRDSEVOUywgSkFSRUQgTS4iLCJuYW1lRmlyc3RMYXN0IjoiSkFSRUQgSElUQ0hFTlMiLCJuYW1lRmlyc3RNaWRkbGVMYXN0IjoiSkFSRUQgTSBISVRDSEVOUyIsInByaW1hcnlJZERvY3VtZW50TnVtYmVyIjoiIiwiYWxsb3dzUHJvbW90aW9uYWxDb250YWN0Ijp0cnVlLCJhY2NvdW50cyI6W3siYWNjb3VudE51bWJlciI6NTA5NDcsInByb2R1Y3RDYXRlZ29yeUNvZGUiOiJMT0FOIiwicHJvZHVjdENhdGVnb3J5RGVzY3JpcHRpb24iOiJMb2FuIiwicHJvZHVjdFR5cGVDb2RlIjoiTVRHIiwicHJvZHVjdFR5cGVEZXNjcmlwdGlvbiI6Ik1vcnRnYWdlIExvYW4iLCJjdXJyZW50UHJvZHVjdENvZGUiOiJNRzE4IiwicHJvZHVjdE5hbWUiOiJJbnZlc3RvciBNb3J0Z2FnZSIsImRpc3BsYXlOYW1lIjoiTW9ydGdhZ2UgTG9hbiBJbnZlc3RvciBNb3J0Z2FnZSIsImN1cnJlbnRBY2NvdW50U3RhdHVzQ29kZSI6IkNMUyIsImN1cnJlbnRBY2NvdW50U3RhdHVzRGVzY3JpcHRpb24iOiJDbG9zZWQiLCJ1c2VyRmllbGRzIjpbeyJ1c2VyRmllbGRDb2RlIjoiQ1BJVCIsInZhbHVlIjoiWSIsInVzZXJGaWVsZERlc2NyaXB0aW9uIjoiVHJhY2sgQ1BJIiwiZGF0YVR5cGVDb2RlIjoiWU4ifV19LHsiYWNjb3VudE51bWJlciI6NjE2MTgsInByb2R1Y3RDYXRlZ29yeUNvZGUiOiJMT0FOIiwicHJvZHVjdENhdGVnb3J5RGVzY3JpcHRpb24iOiJMb2FuIiwicHJvZHVjdFR5cGVDb2RlIjoiTVRHIiwicHJvZHVjdFR5cGVEZXNjcmlwdGlvbiI6Ik1vcnRnYWdlIExvYW4iLCJjdXJyZW50UHJvZHVjdENvZGUiOiJNRzE4IiwicHJvZHVjdE5hbWUiOiJJbnZlc3RvciBNb3J0Z2FnZSIsImRpc3BsYXlOYW1lIjoiTW9ydGdhZ2UgTG9hbiBJbnZlc3RvciBNb3J0Z2FnZSIsImN1cnJlbnRBY2NvdW50U3RhdHVzQ29kZSI6IkFDVCIsImN1cnJlbnRBY2NvdW50U3RhdHVzRGVzY3JpcHRpb24iOiJBY3RpdmUiLCJ1c2VyRmllbGRzIjpbeyJ1c2VyRmllbGRDb2RlIjoiQ1BJVCIsInZhbHVlIjoiWSIsInVzZXJGaWVsZERlc2NyaXB0aW9uIjoiVHJhY2sgQ1BJIiwiZGF0YVR5cGVDb2RlIjoiWU4ifV19LHsiYWNjb3VudE51bWJlciI6NjE2MzgsInByb2R1Y3RDYXRlZ29yeUNvZGUiOiJMT0FOIiwicHJvZHVjdENhdGVnb3J5RGVzY3JpcHRpb24iOiJMb2FuIiwicHJvZHVjdFR5cGVDb2RlIjoiTVRHIiwicHJvZHVjdFR5cGVEZXNjcmlwdGlvbiI6Ik1vcnRnYWdlIExvYW4iLCJjdXJyZW50UHJvZHVjdENvZGUiOiJNRzE4IiwicHJvZHVjdE5hbWUiOiJJbnZlc3RvciBNb3J0Z2FnZSIsImRpc3BsYXlOYW1lIjoiTW9ydGdhZ2UgTG9hbiBJbnZlc3RvciBNb3J0Z2FnZSIsImN1cnJlbnRBY2NvdW50U3RhdHVzQ29kZSI6IkFDVCIsImN1cnJlbnRBY2NvdW50U3RhdHVzRGVzY3JpcHRpb24iOiJBY3RpdmUiLCJ1c2VyRmllbGRzIjpbeyJ1c2VyRmllbGRDb2RlIjoiQ1BJVCIsInZhbHVlIjoiWSIsInVzZXJGaWVsZERlc2NyaXB0aW9uIjoiVHJhY2sgQ1BJIiwiZGF0YVR5cGVDb2RlIjoiWU4ifV19LHsiYWNjb3VudE51bWJlciI6NjIwNDQ1MSwicHJvZHVjdENhdGVnb3J5Q29kZSI6IkRFUCIsInByb2R1Y3RDYXRlZ29yeURlc2NyaXB0aW9uIjoiRGVwb3NpdCIsInByb2R1Y3RUeXBlQ29kZSI6IlNBViIsInByb2R1Y3RUeXBlRGVzY3JpcHRpb24iOiJTYXZpbmdzIiwiY3VycmVudFByb2R1Y3RDb2RlIjoiU1YwMSIsInByb2R1Y3ROYW1lIjoiU2hhcmUiLCJkZXNjcmlwdGlvbiI6IlJFR1VMQVIgU0hBUkVTIiwiZGlzcGxheU5hbWUiOiJSRUdVTEFSIFNIQVJFUyIsImN1cnJlbnRBY2NvdW50U3RhdHVzQ29kZSI6IkFDVCIsImN1cnJlbnRBY2NvdW50U3RhdHVzRGVzY3JpcHRpb24iOiJBY3RpdmUiLCJ1c2VyRmllbGRzIjpbXX0seyJhY2NvdW50TnVtYmVyIjoxMjE4NDA1MSwicHJvZHVjdENhdGVnb3J5Q29kZSI6IkRFUCIsInByb2R1Y3RDYXRlZ29yeURlc2NyaXB0aW9uIjoiRGVwb3NpdCIsInByb2R1Y3RUeXBlQ29kZSI6IlNBViIsInByb2R1Y3RUeXBlRGVzY3JpcHRpb24iOiJTYXZpbmdzIiwiY3VycmVudFByb2R1Y3RDb2RlIjoiU1YwMSIsInByb2R1Y3ROYW1lIjoiU2hhcmUiLCJkZXNjcmlwdGlvbiI6IlJFR1VMQVIgU0hBUkVTIiwiZGlzcGxheU5hbWUiOiJSRUdVTEFSIFNIQVJFUyIsImN1cnJlbnRBY2NvdW50U3RhdHVzQ29kZSI6IkFDVCIsImN1cnJlbnRBY2NvdW50U3RhdHVzRGVzY3JpcHRpb24iOiJBY3RpdmUiLCJ1c2VyRmllbGRzIjpbXX0seyJhY2NvdW50TnVtYmVyIjoxMjE4NDA1OSwicHJvZHVjdENhdGVnb3J5Q29kZSI6IkRFUCIsInByb2R1Y3RDYXRlZ29yeURlc2NyaXB0aW9uIjoiRGVwb3NpdCIsInByb2R1Y3RUeXBlQ29kZSI6IkNLIiwicHJvZHVjdFR5cGVEZXNjcmlwdGlvbiI6IkNoZWNraW5nIiwiY3VycmVudFByb2R1Y3RDb2RlIjoiQ0swMiIsInByb2R1Y3ROYW1lIjoiQmFzaWMiLCJkZXNjcmlwdGlvbiI6IkJhc2ljIENoZWNraW5nIiwiZGlzcGxheU5hbWUiOiJCYXNpYyBDaGVja2luZyIsImN1cnJlbnRBY2NvdW50U3RhdHVzQ29kZSI6IkFDVCIsImN1cnJlbnRBY2NvdW50U3RhdHVzRGVzY3JpcHRpb24iOiJBY3RpdmUiLCJ1c2VyRmllbGRzIjpbeyJ1c2VyRmllbGRDb2RlIjoiUFNNWCIsInZhbHVlIjoiWSIsInVzZXJGaWVsZERlc2NyaXB0aW9uIjoiSW4gT2QgUHJvZ3JhbSBZTiIsImRhdGFUeXBlQ29kZSI6IllOIn0seyJ1c2VyRmllbGRDb2RlIjoiUFNPRCIsInZhbHVlIjoiMSIsInVzZXJGaWVsZERlc2NyaXB0aW9uIjoiT2QgUHJvZ3JhbSBTdGF0dXMiLCJkYXRhVHlwZUNvZGUiOiJWQyJ9XX0seyJhY2NvdW50TnVtYmVyIjoxMjE4NDA1MTAsInByb2R1Y3RDYXRlZ29yeUNvZGUiOiJERVAiLCJwcm9kdWN0Q2F0ZWdvcnlEZXNjcmlwdGlvbiI6IkRlcG9zaXQiLCJwcm9kdWN0VHlwZUNvZGUiOiJTQVYiLCJwcm9kdWN0VHlwZURlc2NyaXB0aW9uIjoiU2F2aW5ncyIsImN1cnJlbnRQcm9kdWN0Q29kZSI6IlNWUlQiLCJwcm9kdWN0TmFtZSI6IklSQSIsImRpc3BsYXlOYW1lIjoiSVJBIFNhdmluZ3MiLCJjdXJyZW50QWNjb3VudFN0YXR1c0NvZGUiOiJBQ1QiLCJjdXJyZW50QWNjb3VudFN0YXR1c0Rlc2NyaXB0aW9uIjoiQWN0aXZlIiwidXNlckZpZWxkcyI6W119LHsiYWNjb3VudE51bWJlciI6MTk5Nzk2MzMzNTAsInByb2R1Y3RDYXRlZ29yeUNvZGUiOiJSVE1UIiwicHJvZHVjdENhdGVnb3J5RGVzY3JpcHRpb24iOiJSZXRpcmVtZW50IiwicHJvZHVjdFR5cGVDb2RlIjoiUlRNVCIsInByb2R1Y3RUeXBlRGVzY3JpcHRpb24iOiJSZXRpcmVtZW50IEFjY291bnQiLCJjdXJyZW50UHJvZHVjdENvZGUiOiJJUkEiLCJwcm9kdWN0TmFtZSI6IklSQSBUcmFkaXRpb25hbCBQbGFuIiwiZGlzcGxheU5hbWUiOiJJUkEgVHJhZGl0aW9uYWwgUGxhbiBSZXRpcmVtZW50IEFjY291bnQiLCJjdXJyZW50QWNjb3VudFN0YXR1c0NvZGUiOiJBQ1QiLCJjdXJyZW50QWNjb3VudFN0YXR1c0Rlc2NyaXB0aW9uIjoiQWN0aXZlIiwidXNlckZpZWxkcyI6W119LHsiYWNjb3VudE51bWJlciI6MTk5Nzk5NTk0NTQsInByb2R1Y3RDYXRlZ29yeUNvZGUiOiJMT0FOIiwicHJvZHVjdENhdGVnb3J5RGVzY3JpcHRpb24iOiJMb2FuIiwicHJvZHVjdFR5cGVDb2RlIjoiQ05TIiwicHJvZHVjdFR5cGVEZXNjcmlwdGlvbiI6IkNvbnN1bWVyIExvYW4iLCJjdXJyZW50UHJvZHVjdENvZGUiOiJDTjAxIiwicHJvZHVjdE5hbWUiOiJVc2VkIFZlaGljbGUiLCJkaXNwbGF5TmFtZSI6IkNvbnN1bWVyIExvYW4gVXNlZCBWZWhpY2xlIiwiY3VycmVudEFjY291bnRTdGF0dXNDb2RlIjoiQUNUIiwiY3VycmVudEFjY291bnRTdGF0dXNEZXNjcmlwdGlvbiI6IkFjdGl2ZSIsInVzZXJGaWVsZHMiOlt7InVzZXJGaWVsZENvZGUiOiJDUElUIiwidmFsdWUiOiJZIiwidXNlckZpZWxkRGVzY3JpcHRpb24iOiJUcmFjayBDUEkiLCJkYXRhVHlwZUNvZGUiOiJZTiJ9LHsidXNlckZpZWxkQ29kZSI6IkRBVEUiLCJ2YWx1ZSI6IjIwMjEtMDktMjciLCJ1c2VyRmllbGREZXNjcmlwdGlvbiI6IkNyZWRpdCBMaWZlIENyZWRpdCBEaXNhYmlsaXR5IERhdGUiLCJkYXRhVHlwZUNvZGUiOiJEQVRFIn0seyJ1c2VyRmllbGRDb2RlIjoiUFJPQyIsInZhbHVlIjoiU2FsYXphciwgTmlja2kiLCJ1c2VyRmllbGREZXNjcmlwdGlvbiI6IkxvYW4gUHJvY2Vzc29yXC9PcmlnaW5hdG9yIiwiZGF0YVR5cGVDb2RlIjoiU1RSIn0seyJ1c2VyRmllbGRDb2RlIjoiR0FQIiwidmFsdWUiOiJZIiwidXNlckZpZWxkRGVzY3JpcHRpb24iOiJHQVAiLCJkYXRhVHlwZUNvZGUiOiJTVFIifV19LHsiYWNjb3VudE51bWJlciI6MTk5ODA3MzE3ODQsInByb2R1Y3RDYXRlZ29yeUNvZGUiOiJMT0FOIiwicHJvZHVjdENhdGVnb3J5RGVzY3JpcHRpb24iOiJMb2FuIiwicHJvZHVjdFR5cGVDb2RlIjoiTVRHIiwicHJvZHVjdFR5cGVEZXNjcmlwdGlvbiI6Ik1vcnRnYWdlIExvYW4iLCJjdXJyZW50UHJvZHVjdENvZGUiOiJNRzE2IiwicHJvZHVjdE5hbWUiOiIybmQgTW9ydGdhZ2UiLCJkaXNwbGF5TmFtZSI6Ik1vcnRnYWdlIExvYW4gMm5kIE1vcnRnYWdlIiwiY3VycmVudEFjY291bnRTdGF0dXNDb2RlIjoiQUNUIiwiY3VycmVudEFjY291bnRTdGF0dXNEZXNjcmlwdGlvbiI6IkFjdGl2ZSIsInVzZXJGaWVsZHMiOlt7InVzZXJGaWVsZENvZGUiOiJCTkNIIiwidmFsdWUiOiIxMHRoIiwidXNlckZpZWxkRGVzY3JpcHRpb24iOiJPcmlnaW5hdGluZyBCcmFuY2giLCJkYXRhVHlwZUNvZGUiOiJTVFIifSx7InVzZXJGaWVsZENvZGUiOiJDTENEIiwidmFsdWUiOiJEcmVoZXIsIER5bGFuIiwidXNlckZpZWxkRGVzY3JpcHRpb24iOiJDcmVkaXQgTGlmZSBDcmVkaXQgRGlzYWJpbGl0eSBTb2xkIEJ5IiwiZGF0YVR5cGVDb2RlIjoiU1RSIn0seyJ1c2VyRmllbGRDb2RlIjoiQ1BJVCIsInZhbHVlIjoiWSIsInVzZXJGaWVsZERlc2NyaXB0aW9uIjoiVHJhY2sgQ1BJIiwiZGF0YVR5cGVDb2RlIjoiWU4ifSx7InVzZXJGaWVsZENvZGUiOiJEQVRFIiwidmFsdWUiOiIyMDI0LTEyLTIzIiwidXNlckZpZWxkRGVzY3JpcHRpb24iOiJDcmVkaXQgTGlmZSBDcmVkaXQgRGlzYWJpbGl0eSBEYXRlIiwiZGF0YVR5cGVDb2RlIjoiREFURSJ9LHsidXNlckZpZWxkQ29kZSI6IlBST0MiLCJ2YWx1ZSI6IkRyZWhlciwgRHlsYW4iLCJ1c2VyRmllbGREZXNjcmlwdGlvbiI6IkxvYW4gUHJvY2Vzc29yXC9PcmlnaW5hdG9yIiwiZGF0YVR5cGVDb2RlIjoiU1RSIn0seyJ1c2VyRmllbGRDb2RlIjoiU0NSQyIsInZhbHVlIjoiV2FsayBJbiIsInVzZXJGaWVsZERlc2NyaXB0aW9uIjoiQXBwbGljYXRpb24gU291cmNlIiwiZGF0YVR5cGVDb2RlIjoiU1RSIn1dfV0sImlzT3RoZXJQZXJzb25zVXBkYXRlZCI6ZmFsc2UsInNwb3VzZUZ1bGxOYW1lIjoiIiwidWlkIjoiQlMyMzZEOUU5NF8zMzg2NCIsImlzRW1wbG95ZWUiOnRydWUsInBvc3RhbEFkZHJlc3NMaXN0IjpbeyJhZGRyZXNzVXNlQ29kZSI6IkFMMDEiLCJhZGRyZXNzVXNlRGVzY3JpcHRpb24iOiJBbHRlcm5hdGUgMDEiLCJhZGRyZXNzTnVtYmVyIjozODY4OCwiYWRkcmVzc0xpbmUxIjoiNzExIFNXIE1FUlJJQU0gQ1QiLCJhZGRyZXNzTGluZVR5cGVDb2RlMSI6IlNUIiwiY2l0eU5hbWUiOiJUT1BFS0EiLCJjb3VudHJ5U3ViZGl2aXNpb25Db2RlIjoiS1MiLCJjb3VudHJ5U3ViZGl2aXNpb25OYW1lIjoiS2Fuc2FzIiwicG9zdGFsQ29kZSI6IjY2NjExIiwiemlwUGx1cyI6IjEyMTQiLCJjb3VudHJ5Q29kZSI6IlVTQSIsImNvdW50cnlOYW1lIjoiVW5pdGVkIFN0YXRlcyIsImVmZmVjdGl2ZURhdGUiOiIyMDE0LTEyLTA0In0seyJhZGRyZXNzVXNlQ29kZSI6IkFMMDIiLCJhZGRyZXNzVXNlRGVzY3JpcHRpb24iOiJBbHRlcm5hdGUgMDIiLCJhZGRyZXNzTnVtYmVyIjo4NzMwMCwiYWRkcmVzc0xpbmUxIjoiNzExIFNXIE1FUklBTSBDT1VSVCBUT1BFS0EsIEtTIDY2NjExIiwiYWRkcmVzc0xpbmVUeXBlQ29kZTEiOiJTVCIsImNpdHlOYW1lIjoiVE9QRUtBIiwiY291bnRyeVN1YmRpdmlzaW9uQ29kZSI6IktTIiwiY291bnRyeVN1YmRpdmlzaW9uTmFtZSI6IkthbnNhcyIsInBvc3RhbENvZGUiOiI2NjYwNiIsImNvdW50cnlDb2RlIjoiVVNBIiwiY291bnRyeU5hbWUiOiJVbml0ZWQgU3RhdGVzIiwiZWZmZWN0aXZlRGF0ZSI6IjIwMjAtMTAtMzEifSx7ImFkZHJlc3NVc2VDb2RlIjoiQUwwMyIsImFkZHJlc3NVc2VEZXNjcmlwdGlvbiI6IkFsdGVybmF0ZSAwMyIsImFkZHJlc3NOdW1iZXIiOjg3MzAxLCJhZGRyZXNzTGluZTEiOiIyMjIwIFNXIEhBWkVMVE9OIENPVVJUIiwiYWRkcmVzc0xpbmVUeXBlQ29kZTEiOiJTVCIsImNpdHlOYW1lIjoiVE9QRUtBIiwiY291bnRyeVN1YmRpdmlzaW9uQ29kZSI6IktTIiwiY291bnRyeVN1YmRpdmlzaW9uTmFtZSI6IkthbnNhcyIsInBvc3RhbENvZGUiOiI2NjYwNiIsImNvdW50cnlDb2RlIjoiVVNBIiwiY291bnRyeU5hbWUiOiJVbml0ZWQgU3RhdGVzIiwiZWZmZWN0aXZlRGF0ZSI6IjIwMjAtMTAtMzEifSx7ImFkZHJlc3NVc2VDb2RlIjoiQUxUIiwiYWRkcmVzc1VzZURlc2NyaXB0aW9uIjoiQWx0ZXJuYXRlIiwiYWRkcmVzc051bWJlciI6MjU3NDM4LCJhZGRyZXNzTGluZTEiOiIyMjIwIFNXIEhBWkVMVE9OIENUIiwiYWRkcmVzc0xpbmVUeXBlQ29kZTEiOiJTVCIsImNpdHlOYW1lIjoiVE9QRUtBIiwiY291bnRyeVN1YmRpdmlzaW9uQ29kZSI6IktTIiwiY291bnRyeVN1YmRpdmlzaW9uTmFtZSI6IkthbnNhcyIsInBvc3RhbENvZGUiOiI2NjYwNiIsImNvdW50cnlDb2RlIjoiVVNBIiwiY291bnRyeU5hbWUiOiJVbml0ZWQgU3RhdGVzIiwiZWZmZWN0aXZlRGF0ZSI6IjIwMjEtMDktMjgifSx7ImFkZHJlc3NVc2VDb2RlIjoiUFJJIiwiYWRkcmVzc1VzZURlc2NyaXB0aW9uIjoiUHJpbWFyeSIsImFkZHJlc3NOdW1iZXIiOjM4Njg3LCJhZGRyZXNzTGluZTEiOiI3MTEgU1cgTUVSUklBTSBDVCIsImFkZHJlc3NMaW5lVHlwZUNvZGUxIjoiU1QiLCJjaXR5TmFtZSI6IlRPUEVLQSIsImNvdW50cnlTdWJkaXZpc2lvbkNvZGUiOiJLUyIsImNvdW50cnlTdWJkaXZpc2lvbk5hbWUiOiJLYW5zYXMiLCJwb3N0YWxDb2RlIjoiNjY2MTEiLCJ6aXBQbHVzIjoiMTIxNCIsImNvdW50cnlDb2RlIjoiVVNBIiwiY291bnRyeU5hbWUiOiJVbml0ZWQgU3RhdGVzIiwiZWZmZWN0aXZlRGF0ZSI6IjIwMjQtMTItMzAifV0sImVtYWlsQWRkcmVzc0xpc3QiOlt7ImFkZHJlc3NVc2VDb2RlIjoiRUJVUyIsImFkZHJlc3NOdW1iZXIiOjM3MzY4NiwiYWRkcmVzc1VzZURlc2NyaXB0aW9uIjoiQnVzaW5lc3MgRS1NYWlsIiwiZW1haWxBZGRyZXNzIjoiamFyZWQuaGl0Y2hlbnNAZW52aXN0YWN1LmNvbSJ9LHsiYWRkcmVzc1VzZUNvZGUiOiJFTTAxIiwiYWRkcmVzc051bWJlciI6MTI4NTUyLCJhZGRyZXNzVXNlRGVzY3JpcHRpb24iOiJIb21lIEVtYWlsIDAxIiwiZW1haWxBZGRyZXNzIjoiSkFSRURISVRDSEVOUzg2QEdNQUlMLkNPTSJ9LHsiYWRkcmVzc1VzZUNvZGUiOiJFTUwiLCJhZGRyZXNzTnVtYmVyIjoxMDQ5MjIsImFkZHJlc3NVc2VEZXNjcmlwdGlvbiI6IkUtTWFpbCBBZGRyZXNzIiwiZW1haWxBZGRyZXNzIjoiSkFSRURISVRDSEVOUzg2QEdNQUlMLkNPTSJ9XSwiaXNDdXJyZW5jeVRyYW5zYWN0aW9uUmVwb3J0aW5nRXhlbXB0IjpmYWxzZSwibm9USU5SZXF1aXJlZEZvcjEwNDJzIjpmYWxzZX0=', NULL, NULL, '', '', 'eyJpZCI6IjMzODY0IiwicGVyc29uTnVtYmVyIjozMzg2NCwicmVzaWRlbnRUYXhDb3VudHJ5Q29kZSI6IlVTQSIsImxhc3ROYW1lIjoiSElUQ0hFTlMiLCJmaXJzdE5hbWUiOiJKQVJFRCIsIm1pZGRsZUluaXRpYWwiOiJNIiwidGF4SWQiOiIqKiotKiotMTQ3NCIsImFkZERhdGUiOiIyMDA5LTAzLTAzIiwiYmlydGhEYXRlIjoiMTk4MC0wOS0xNSIsInRheENlcnRpZmljYXRpb25EYXRlIjoiMjAwOS0wMy0wMyIsIm9jY3VwYXRpb25Db2RlIjoiT1RIUiIsImlzVmFsaWQiOnRydWUsImxhc3RNYWludGFpbmVkIjoiMjAyNS0wMy0wNlQxMjozMDo1My4wMDAtMDY6MDAiLCJsYXN0TmFtZVVwcGVyIjoiSElUQ0hFTlMiLCJmaXJzdE5hbWVVcHBlciI6IkpBUkVEIiwiaXNSZXBvcnQxMDQycyI6ZmFsc2UsImlzUHJpdmFjeSI6ZmFsc2UsImlzUHVyZ2UiOmZhbHNlLCJmdWxsTmFtZVdpdGhTZWNvbmRTdXJOYW1lIjoiSkFSRUQgTS4gSElUQ0hFTlMiLCJ1cmwiOiJcL1BlcnNvbnNcLzMzODY0IiwiYWdlIjo0NSwibWVtYmVyTnVtYmVyIjoxMjE4NDAsIm5hbWVGdWxsIjoiSkFSRUQgTS4gSElUQ0hFTlMiLCJ0aW1lV2l0aEluc3RpdHV0aW9uIjoiMTYgWWVhcnMsIDEwIE1vbnRocyIsIm5hbWVMYXN0Rmlyc3QiOiJISVRDSEVOUyBKQVJFRCIsImZpcnN0TWlkZGxlSW5pdGlhbExhc3RTdWZmaXgiOiJKQVJFRCBNLiBISVRDSEVOUyIsIm5hbWVMYXN0Rmlyc3RJbml0aWFsIjoiSElUQ0hFTlMsIEouIiwibmFtZUxhc3RGaXJzdE1pZGRsZVN1ZmZpeCI6IkhJVENIRU5TLCBKQVJFRCBNLiIsIm5hbWVMYXN0Rmlyc3RNaWRkbGUiOiJISVRDSEVOUywgSkFSRUQgTS4iLCJuYW1lRmlyc3RMYXN0IjoiSkFSRUQgSElUQ0hFTlMiLCJuYW1lRmlyc3RNaWRkbGVMYXN0IjoiSkFSRUQgTSBISVRDSEVOUyIsInByaW1hcnlJZERvY3VtZW50TnVtYmVyIjoiIiwiYWxsb3dzUHJvbW90aW9uYWxDb250YWN0Ijp0cnVlLCJhY2NvdW50cyI6W3siYWNjb3VudE51bWJlciI6NTA5NDcsInByb2R1Y3RDYXRlZ29yeUNvZGUiOiJMT0FOIiwicHJvZHVjdENhdGVnb3J5RGVzY3JpcHRpb24iOiJMb2FuIiwicHJvZHVjdFR5cGVDb2RlIjoiTVRHIiwicHJvZHVjdFR5cGVEZXNjcmlwdGlvbiI6Ik1vcnRnYWdlIExvYW4iLCJjdXJyZW50UHJvZHVjdENvZGUiOiJNRzE4IiwicHJvZHVjdE5hbWUiOiJJbnZlc3RvciBNb3J0Z2FnZSIsImRpc3BsYXlOYW1lIjoiTW9ydGdhZ2UgTG9hbiBJbnZlc3RvciBNb3J0Z2FnZSIsImN1cnJlbnRBY2NvdW50U3RhdHVzQ29kZSI6IkNMUyIsImN1cnJlbnRBY2NvdW50U3RhdHVzRGVzY3JpcHRpb24iOiJDbG9zZWQiLCJ1c2VyRmllbGRzIjpbeyJ1c2VyRmllbGRDb2RlIjoiQ1BJVCIsInZhbHVlIjoiWSIsInVzZXJGaWVsZERlc2NyaXB0aW9uIjoiVHJhY2sgQ1BJIiwiZGF0YVR5cGVDb2RlIjoiWU4ifV19LHsiYWNjb3VudE51bWJlciI6NjE2MTgsInByb2R1Y3RDYXRlZ29yeUNvZGUiOiJMT0FOIiwicHJvZHVjdENhdGVnb3J5RGVzY3JpcHRpb24iOiJMb2FuIiwicHJvZHVjdFR5cGVDb2RlIjoiTVRHIiwicHJvZHVjdFR5cGVEZXNjcmlwdGlvbiI6Ik1vcnRnYWdlIExvYW4iLCJjdXJyZW50UHJvZHVjdENvZGUiOiJNRzE4IiwicHJvZHVjdE5hbWUiOiJJbnZlc3RvciBNb3J0Z2FnZSIsImRpc3BsYXlOYW1lIjoiTW9ydGdhZ2UgTG9hbiBJbnZlc3RvciBNb3J0Z2FnZSIsImN1cnJlbnRBY2NvdW50U3RhdHVzQ29kZSI6IkFDVCIsImN1cnJlbnRBY2NvdW50U3RhdHVzRGVzY3JpcHRpb24iOiJBY3RpdmUiLCJ1c2VyRmllbGRzIjpbeyJ1c2VyRmllbGRDb2RlIjoiQ1BJVCIsInZhbHVlIjoiWSIsInVzZXJGaWVsZERlc2NyaXB0aW9uIjoiVHJhY2sgQ1BJIiwiZGF0YVR5cGVDb2RlIjoiWU4ifV19LHsiYWNjb3VudE51bWJlciI6NjE2MzgsInByb2R1Y3RDYXRlZ29yeUNvZGUiOiJMT0FOIiwicHJvZHVjdENhdGVnb3J5RGVzY3JpcHRpb24iOiJMb2FuIiwicHJvZHVjdFR5cGVDb2RlIjoiTVRHIiwicHJvZHVjdFR5cGVEZXNjcmlwdGlvbiI6Ik1vcnRnYWdlIExvYW4iLCJjdXJyZW50UHJvZHVjdENvZGUiOiJNRzE4IiwicHJvZHVjdE5hbWUiOiJJbnZlc3RvciBNb3J0Z2FnZSIsImRpc3BsYXlOYW1lIjoiTW9ydGdhZ2UgTG9hbiBJbnZlc3RvciBNb3J0Z2FnZSIsImN1cnJlbnRBY2NvdW50U3RhdHVzQ29kZSI6IkFDVCIsImN1cnJlbnRBY2NvdW50U3RhdHVzRGVzY3JpcHRpb24iOiJBY3RpdmUiLCJ1c2VyRmllbGRzIjpbeyJ1c2VyRmllbGRDb2RlIjoiQ1BJVCIsInZhbHVlIjoiWSIsInVzZXJGaWVsZERlc2NyaXB0aW9uIjoiVHJhY2sgQ1BJIiwiZGF0YVR5cGVDb2RlIjoiWU4ifV19LHsiYWNjb3VudE51bWJlciI6NjIwNDQ1MSwicHJvZHVjdENhdGVnb3J5Q29kZSI6IkRFUCIsInByb2R1Y3RDYXRlZ29yeURlc2NyaXB0aW9uIjoiRGVwb3NpdCIsInByb2R1Y3RUeXBlQ29kZSI6IlNBViIsInByb2R1Y3RUeXBlRGVzY3JpcHRpb24iOiJTYXZpbmdzIiwiY3VycmVudFByb2R1Y3RDb2RlIjoiU1YwMSIsInByb2R1Y3ROYW1lIjoiU2hhcmUiLCJkZXNjcmlwdGlvbiI6IlJFR1VMQVIgU0hBUkVTIiwiZGlzcGxheU5hbWUiOiJSRUdVTEFSIFNIQVJFUyIsImN1cnJlbnRBY2NvdW50U3RhdHVzQ29kZSI6IkFDVCIsImN1cnJlbnRBY2NvdW50U3RhdHVzRGVzY3JpcHRpb24iOiJBY3RpdmUiLCJ1c2VyRmllbGRzIjpbXX0seyJhY2NvdW50TnVtYmVyIjoxMjE4NDA1MSwicHJvZHVjdENhdGVnb3J5Q29kZSI6IkRFUCIsInByb2R1Y3RDYXRlZ29yeURlc2NyaXB0aW9uIjoiRGVwb3NpdCIsInByb2R1Y3RUeXBlQ29kZSI6IlNBViIsInByb2R1Y3RUeXBlRGVzY3JpcHRpb24iOiJTYXZpbmdzIiwiY3VycmVudFByb2R1Y3RDb2RlIjoiU1YwMSIsInByb2R1Y3ROYW1lIjoiU2hhcmUiLCJkZXNjcmlwdGlvbiI6IlJFR1VMQVIgU0hBUkVTIiwiZGlzcGxheU5hbWUiOiJSRUdVTEFSIFNIQVJFUyIsImN1cnJlbnRBY2NvdW50U3RhdHVzQ29kZSI6IkFDVCIsImN1cnJlbnRBY2NvdW50U3RhdHVzRGVzY3JpcHRpb24iOiJBY3RpdmUiLCJ1c2VyRmllbGRzIjpbXX0seyJhY2NvdW50TnVtYmVyIjoxMjE4NDA1OSwicHJvZHVjdENhdGVnb3J5Q29kZSI6IkRFUCIsInByb2R1Y3RDYXRlZ29yeURlc2NyaXB0aW9uIjoiRGVwb3NpdCIsInByb2R1Y3RUeXBlQ29kZSI6IkNLIiwicHJvZHVjdFR5cGVEZXNjcmlwdGlvbiI6IkNoZWNraW5nIiwiY3VycmVudFByb2R1Y3RDb2RlIjoiQ0swMiIsInByb2R1Y3ROYW1lIjoiQmFzaWMiLCJkZXNjcmlwdGlvbiI6IkJhc2ljIENoZWNraW5nIiwiZGlzcGxheU5hbWUiOiJCYXNpYyBDaGVja2luZyIsImN1cnJlbnRBY2NvdW50U3RhdHVzQ29kZSI6IkFDVCIsImN1cnJlbnRBY2NvdW50U3RhdHVzRGVzY3JpcHRpb24iOiJBY3RpdmUiLCJ1c2VyRmllbGRzIjpbeyJ1c2VyRmllbGRDb2RlIjoiUFNNWCIsInZhbHVlIjoiWSIsInVzZXJGaWVsZERlc2NyaXB0aW9uIjoiSW4gT2QgUHJvZ3JhbSBZTiIsImRhdGFUeXBlQ29kZSI6IllOIn0seyJ1c2VyRmllbGRDb2RlIjoiUFNPRCIsInZhbHVlIjoiMSIsInVzZXJGaWVsZERlc2NyaXB0aW9uIjoiT2QgUHJvZ3JhbSBTdGF0dXMiLCJkYXRhVHlwZUNvZGUiOiJWQyJ9XX0seyJhY2NvdW50TnVtYmVyIjoxMjE4NDA1MTAsInByb2R1Y3RDYXRlZ29yeUNvZGUiOiJERVAiLCJwcm9kdWN0Q2F0ZWdvcnlEZXNjcmlwdGlvbiI6IkRlcG9zaXQiLCJwcm9kdWN0VHlwZUNvZGUiOiJTQVYiLCJwcm9kdWN0VHlwZURlc2NyaXB0aW9uIjoiU2F2aW5ncyIsImN1cnJlbnRQcm9kdWN0Q29kZSI6IlNWUlQiLCJwcm9kdWN0TmFtZSI6IklSQSIsImRpc3BsYXlOYW1lIjoiSVJBIFNhdmluZ3MiLCJjdXJyZW50QWNjb3VudFN0YXR1c0NvZGUiOiJBQ1QiLCJjdXJyZW50QWNjb3VudFN0YXR1c0Rlc2NyaXB0aW9uIjoiQWN0aXZlIiwidXNlckZpZWxkcyI6W119LHsiYWNjb3VudE51bWJlciI6MTk5Nzk2MzMzNTAsInByb2R1Y3RDYXRlZ29yeUNvZGUiOiJSVE1UIiwicHJvZHVjdENhdGVnb3J5RGVzY3JpcHRpb24iOiJSZXRpcmVtZW50IiwicHJvZHVjdFR5cGVDb2RlIjoiUlRNVCIsInByb2R1Y3RUeXBlRGVzY3JpcHRpb24iOiJSZXRpcmVtZW50IEFjY291bnQiLCJjdXJyZW50UHJvZHVjdENvZGUiOiJJUkEiLCJwcm9kdWN0TmFtZSI6IklSQSBUcmFkaXRpb25hbCBQbGFuIiwiZGlzcGxheU5hbWUiOiJJUkEgVHJhZGl0aW9uYWwgUGxhbiBSZXRpcmVtZW50IEFjY291bnQiLCJjdXJyZW50QWNjb3VudFN0YXR1c0NvZGUiOiJBQ1QiLCJjdXJyZW50QWNjb3VudFN0YXR1c0Rlc2NyaXB0aW9uIjoiQWN0aXZlIiwidXNlckZpZWxkcyI6W119LHsiYWNjb3VudE51bWJlciI6MTk5Nzk5NTk0NTQsInByb2R1Y3RDYXRlZ29yeUNvZGUiOiJMT0FOIiwicHJvZHVjdENhdGVnb3J5RGVzY3JpcHRpb24iOiJMb2FuIiwicHJvZHVjdFR5cGVDb2RlIjoiQ05TIiwicHJvZHVjdFR5cGVEZXNjcmlwdGlvbiI6IkNvbnN1bWVyIExvYW4iLCJjdXJyZW50UHJvZHVjdENvZGUiOiJDTjAxIiwicHJvZHVjdE5hbWUiOiJVc2VkIFZlaGljbGUiLCJkaXNwbGF5TmFtZSI6IkNvbnN1bWVyIExvYW4gVXNlZCBWZWhpY2xlIiwiY3VycmVudEFjY291bnRTdGF0dXNDb2RlIjoiQUNUIiwiY3VycmVudEFjY291bnRTdGF0dXNEZXNjcmlwdGlvbiI6IkFjdGl2ZSIsInVzZXJGaWVsZHMiOlt7InVzZXJGaWVsZENvZGUiOiJDUElUIiwidmFsdWUiOiJZIiwidXNlckZpZWxkRGVzY3JpcHRpb24iOiJUcmFjayBDUEkiLCJkYXRhVHlwZUNvZGUiOiJZTiJ9LHsidXNlckZpZWxkQ29kZSI6IkRBVEUiLCJ2YWx1ZSI6IjIwMjEtMDktMjciLCJ1c2VyRmllbGREZXNjcmlwdGlvbiI6IkNyZWRpdCBMaWZlIENyZWRpdCBEaXNhYmlsaXR5IERhdGUiLCJkYXRhVHlwZUNvZGUiOiJEQVRFIn0seyJ1c2VyRmllbGRDb2RlIjoiUFJPQyIsInZhbHVlIjoiU2FsYXphciwgTmlja2kiLCJ1c2VyRmllbGREZXNjcmlwdGlvbiI6IkxvYW4gUHJvY2Vzc29yXC9PcmlnaW5hdG9yIiwiZGF0YVR5cGVDb2RlIjoiU1RSIn0seyJ1c2VyRmllbGRDb2RlIjoiR0FQIiwidmFsdWUiOiJZIiwidXNlckZpZWxkRGVzY3JpcHRpb24iOiJHQVAiLCJkYXRhVHlwZUNvZGUiOiJTVFIifV19LHsiYWNjb3VudE51bWJlciI6MTk5ODA3MzE3ODQsInByb2R1Y3RDYXRlZ29yeUNvZGUiOiJMT0FOIiwicHJvZHVjdENhdGVnb3J5RGVzY3JpcHRpb24iOiJMb2FuIiwicHJvZHVjdFR5cGVDb2RlIjoiTVRHIiwicHJvZHVjdFR5cGVEZXNjcmlwdGlvbiI6Ik1vcnRnYWdlIExvYW4iLCJjdXJyZW50UHJvZHVjdENvZGUiOiJNRzE2IiwicHJvZHVjdE5hbWUiOiIybmQgTW9ydGdhZ2UiLCJkaXNwbGF5TmFtZSI6Ik1vcnRnYWdlIExvYW4gMm5kIE1vcnRnYWdlIiwiY3VycmVudEFjY291bnRTdGF0dXNDb2RlIjoiQUNUIiwiY3VycmVudEFjY291bnRTdGF0dXNEZXNjcmlwdGlvbiI6IkFjdGl2ZSIsInVzZXJGaWVsZHMiOlt7InVzZXJGaWVsZENvZGUiOiJCTkNIIiwidmFsdWUiOiIxMHRoIiwidXNlckZpZWxkRGVzY3JpcHRpb24iOiJPcmlnaW5hdGluZyBCcmFuY2giLCJkYXRhVHlwZUNvZGUiOiJTVFIifSx7InVzZXJGaWVsZENvZGUiOiJDTENEIiwidmFsdWUiOiJEcmVoZXIsIER5bGFuIiwidXNlckZpZWxkRGVzY3JpcHRpb24iOiJDcmVkaXQgTGlmZSBDcmVkaXQgRGlzYWJpbGl0eSBTb2xkIEJ5IiwiZGF0YVR5cGVDb2RlIjoiU1RSIn0seyJ1c2VyRmllbGRDb2RlIjoiQ1BJVCIsInZhbHVlIjoiWSIsInVzZXJGaWVsZERlc2NyaXB0aW9uIjoiVHJhY2sgQ1BJIiwiZGF0YVR5cGVDb2RlIjoiWU4ifSx7InVzZXJGaWVsZENvZGUiOiJEQVRFIiwidmFsdWUiOiIyMDI0LTEyLTIzIiwidXNlckZpZWxkRGVzY3JpcHRpb24iOiJDcmVkaXQgTGlmZSBDcmVkaXQgRGlzYWJpbGl0eSBEYXRlIiwiZGF0YVR5cGVDb2RlIjoiREFURSJ9LHsidXNlckZpZWxkQ29kZSI6IlBST0MiLCJ2YWx1ZSI6IkRyZWhlciwgRHlsYW4iLCJ1c2VyRmllbGREZXNjcmlwdGlvbiI6IkxvYW4gUHJvY2Vzc29yXC9PcmlnaW5hdG9yIiwiZGF0YVR5cGVDb2RlIjoiU1RSIn0seyJ1c2VyRmllbGRDb2RlIjoiU0NSQyIsInZhbHVlIjoiV2FsayBJbiIsInVzZXJGaWVsZERlc2NyaXB0aW9uIjoiQXBwbGljYXRpb24gU291cmNlIiwiZGF0YVR5cGVDb2RlIjoiU1RSIn1dfV0sImlzT3RoZXJQZXJzb25zVXBkYXRlZCI6ZmFsc2UsInNwb3VzZUZ1bGxOYW1lIjoiIiwidWlkIjoiQlMyMzZEOUU5NF8zMzg2NCIsImlzRW1wbG95ZWUiOnRydWUsInBvc3RhbEFkZHJlc3NMaXN0IjpbeyJhZGRyZXNzVXNlQ29kZSI6IkFMMDEiLCJhZGRyZXNzVXNlRGVzY3JpcHRpb24iOiJBbHRlcm5hdGUgMDEiLCJhZGRyZXNzTnVtYmVyIjozODY4OCwiYWRkcmVzc0xpbmUxIjoiNzExIFNXIE1FUlJJQU0gQ1QiLCJhZGRyZXNzTGluZVR5cGVDb2RlMSI6IlNUIiwiY2l0eU5hbWUiOiJUT1BFS0EiLCJjb3VudHJ5U3ViZGl2aXNpb25Db2RlIjoiS1MiLCJjb3VudHJ5U3ViZGl2aXNpb25OYW1lIjoiS2Fuc2FzIiwicG9zdGFsQ29kZSI6IjY2NjExIiwiemlwUGx1cyI6IjEyMTQiLCJjb3VudHJ5Q29kZSI6IlVTQSIsImNvdW50cnlOYW1lIjoiVW5pdGVkIFN0YXRlcyIsImVmZmVjdGl2ZURhdGUiOiIyMDE0LTEyLTA0In0seyJhZGRyZXNzVXNlQ29kZSI6IkFMMDIiLCJhZGRyZXNzVXNlRGVzY3JpcHRpb24iOiJBbHRlcm5hdGUgMDIiLCJhZGRyZXNzTnVtYmVyIjo4NzMwMCwiYWRkcmVzc0xpbmUxIjoiNzExIFNXIE1FUklBTSBDT1VSVCBUT1BFS0EsIEtTIDY2NjExIiwiYWRkcmVzc0xpbmVUeXBlQ29kZTEiOiJTVCIsImNpdHlOYW1lIjoiVE9QRUtBIiwiY291bnRyeVN1YmRpdmlzaW9uQ29kZSI6IktTIiwiY291bnRyeVN1YmRpdmlzaW9uTmFtZSI6IkthbnNhcyIsInBvc3RhbENvZGUiOiI2NjYwNiIsImNvdW50cnlDb2RlIjoiVVNBIiwiY291bnRyeU5hbWUiOiJVbml0ZWQgU3RhdGVzIiwiZWZmZWN0aXZlRGF0ZSI6IjIwMjAtMTAtMzEifSx7ImFkZHJlc3NVc2VDb2RlIjoiQUwwMyIsImFkZHJlc3NVc2VEZXNjcmlwdGlvbiI6IkFsdGVybmF0ZSAwMyIsImFkZHJlc3NOdW1iZXIiOjg3MzAxLCJhZGRyZXNzTGluZTEiOiIyMjIwIFNXIEhBWkVMVE9OIENPVVJUIiwiYWRkcmVzc0xpbmVUeXBlQ29kZTEiOiJTVCIsImNpdHlOYW1lIjoiVE9QRUtBIiwiY291bnRyeVN1YmRpdmlzaW9uQ29kZSI6IktTIiwiY291bnRyeVN1YmRpdmlzaW9uTmFtZSI6IkthbnNhcyIsInBvc3RhbENvZGUiOiI2NjYwNiIsImNvdW50cnlDb2RlIjoiVVNBIiwiY291bnRyeU5hbWUiOiJVbml0ZWQgU3RhdGVzIiwiZWZmZWN0aXZlRGF0ZSI6IjIwMjAtMTAtMzEifSx7ImFkZHJlc3NVc2VDb2RlIjoiQUxUIiwiYWRkcmVzc1VzZURlc2NyaXB0aW9uIjoiQWx0ZXJuYXRlIiwiYWRkcmVzc051bWJlciI6MjU3NDM4LCJhZGRyZXNzTGluZTEiOiIyMjIwIFNXIEhBWkVMVE9OIENUIiwiYWRkcmVzc0xpbmVUeXBlQ29kZTEiOiJTVCIsImNpdHlOYW1lIjoiVE9QRUtBIiwiY291bnRyeVN1YmRpdmlzaW9uQ29kZSI6IktTIiwiY291bnRyeVN1YmRpdmlzaW9uTmFtZSI6IkthbnNhcyIsInBvc3RhbENvZGUiOiI2NjYwNiIsImNvdW50cnlDb2RlIjoiVVNBIiwiY291bnRyeU5hbWUiOiJVbml0ZWQgU3RhdGVzIiwiZWZmZWN0aXZlRGF0ZSI6IjIwMjEtMDktMjgifSx7ImFkZHJlc3NVc2VDb2RlIjoiUFJJIiwiYWRkcmVzc1VzZURlc2NyaXB0aW9uIjoiUHJpbWFyeSIsImFkZHJlc3NOdW1iZXIiOjM4Njg3LCJhZGRyZXNzTGluZTEiOiI3MTEgU1cgTUVSUklBTSBDVCIsImFkZHJlc3NMaW5lVHlwZUNvZGUxIjoiU1QiLCJjaXR5TmFtZSI6IlRPUEVLQSIsImNvdW50cnlTdWJkaXZpc2lvbkNvZGUiOiJLUyIsImNvdW50cnlTdWJkaXZpc2lvbk5hbWUiOiJLYW5zYXMiLCJwb3N0YWxDb2RlIjoiNjY2MTEiLCJ6aXBQbHVzIjoiMTIxNCIsImNvdW50cnlDb2RlIjoiVVNBIiwiY291bnRyeU5hbWUiOiJVbml0ZWQgU3RhdGVzIiwiZWZmZWN0aXZlRGF0ZSI6IjIwMjQtMTItMzAifV0sImVtYWlsQWRkcmVzc0xpc3QiOlt7ImFkZHJlc3NVc2VDb2RlIjoiRUJVUyIsImFkZHJlc3NOdW1iZXIiOjM3MzY4NiwiYWRkcmVzc1VzZURlc2NyaXB0aW9uIjoiQnVzaW5lc3MgRS1NYWlsIiwiZW1haWxBZGRyZXNzIjoiamFyZWQuaGl0Y2hlbnNAZW52aXN0YWN1LmNvbSJ9LHsiYWRkcmVzc1VzZUNvZGUiOiJFTTAxIiwiYWRkcmVzc051bWJlciI6MTI4NTUyLCJhZGRyZXNzVXNlRGVzY3JpcHRpb24iOiJIb21lIEVtYWlsIDAxIiwiZW1haWxBZGRyZXNzIjoiSkFSRURISVRDSEVOUzg2QEdNQUlMLkNPTSJ9LHsiYWRkcmVzc1VzZUNvZGUiOiJFTUwiLCJhZGRyZXNzTnVtYmVyIjoxMDQ5MjIsImFkZHJlc3NVc2VEZXNjcmlwdGlvbiI6IkUtTWFpbCBBZGRyZXNzIiwiZW1haWxBZGRyZXNzIjoiSkFSRURISVRDSEVOUzg2QEdNQUlMLkNPTSJ9XSwiaXNDdXJyZW5jeVRyYW5zYWN0aW9uUmVwb3J0aW5nRXhlbXB0IjpmYWxzZSwibm9USU5SZXF1aXJlZEZvcjEwNDJzIjpmYWxzZX0=', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-03-06T12:30:53.000-06:00', 'Array\n(\n [id] => 33864\n [personNumber] => 33864\n [residentTaxCountryCode] => USA\n [lastName] => HITCHENS\n [firstName] => JARED\n [middleInitial] => M\n [taxId] => ***-**-1474\n [addDate] => 2009-03-03\n [birthDate] => 1980-09-15\n [taxCertificationDate] => 2009-03-03\n [occupationCode] => OTHR\n [isValid] => 1\n [lastMaintained] => 2025-03-06T12:30:53.000-06:00\n [lastNameUpper] => HITCHENS\n [firstNameUpper] => JARED\n [isReport1042s] => \n [isPrivacy] => \n [isPurge] => \n [fullNameWithSecondSurName] => JARED M. HITCHENS\n [url] => /Persons/33864\n [age] => 45\n [memberNumber] => 121840\n [nameFull] => JARED M. HITCHENS\n [timeWithInstitution] => 16 Years, 10 Months\n [nameLastFirst] => HITCHENS JARED\n [firstMiddleInitialLastSuffix] => JARED M. HITCHENS\n [nameLastFirstInitial] => HITCHENS, J.\n [nameLastFirstMiddleSuffix] => HITCHENS, JARED M.\n [nameLastFirstMiddle] => HITCHENS, JARED M.\n [nameFirstLast] => JARED HITCHENS\n [nameFirstMiddleLast] => JARED M HITCHENS\n [primaryIdDocumentNumber] => \n [allowsPromotionalContact] => 1\n [accounts] => Array\n (\n [0] => Array\n (\n [accountNumber] => 50947\n [productCategoryCode] => LOAN\n [productCategoryDescription] => Loan\n [productTypeCode] => MTG\n [productTypeDescription] => Mortgage Loan\n [currentProductCode] => MG18\n [productName] => Investor Mortgage\n [displayName] => Mortgage Loan Investor Mortgage\n [currentAccountStatusCode] => CLS\n [currentAccountStatusDescription] => Closed\n [userFields] => Array\n (\n [0] => Array\n (\n [userFieldCode] => CPIT\n [value] => Y\n [userFieldDescription] => Track CPI\n [dataTypeCode] => YN\n )\n\n )\n\n )\n\n [1] => Array\n (\n [accountNumber] => 61618\n [productCategoryCode] => LOAN\n [productCategoryDescription] => Loan\n [productTypeCode] => MTG\n [productTypeDescription] => Mortgage Loan\n [currentProductCode] => MG18\n [productName] => Investor Mortgage\n [displayName] => Mortgage Loan Investor Mortgage\n [currentAccountStatusCode] => ACT\n [currentAccountStatusDescription] => Active\n [userFields] => Array\n (\n [0] => Array\n (\n [userFieldCode] => CPIT\n [value] => Y\n [userFieldDescription] => Track CPI\n [dataTypeCode] => YN\n )\n\n )\n\n )\n\n [2] => Array\n (\n [accountNumber] => 61638\n [productCategoryCode] => LOAN\n [productCategoryDescription] => Loan\n [productTypeCode] => MTG\n [productTypeDescription] => Mortgage Loan\n [currentProductCode] => MG18\n [productName] => Investor Mortgage\n [displayName] => Mortgage Loan Investor Mortgage\n [currentAccountStatusCode] => ACT\n [currentAccountStatusDescription] => Active\n [userFields] => Array\n (\n [0] => Array\n (\n [userFieldCode] => CPIT\n [value] => Y\n [userFieldDescription] => Track CPI\n [dataTypeCode] => YN\n )\n\n )\n\n )\n\n [3] => Array\n (\n [accountNumber] => 6204451\n [productCategoryCode] => DEP\n [productCategoryDescription] => Deposit\n [productTypeCode] => SAV\n [productTypeDescription] => Savings\n [currentProductCode] => SV01\n [productName] => Share\n [description] => REGULAR SHARES\n [displayName] => REGULAR SHARES\n [currentAccountStatusCode] => ACT\n [currentAccountStatusDescription] => Active\n [userFields] => Array\n (\n )\n\n )\n\n [4] => Array\n (\n [accountNumber] => 12184051\n [productCategoryCode] => DEP\n [productCategoryDescription] => Deposit\n [productTypeCode] => SAV\n [productTypeDescription] => Savings\n [currentProductCode] => SV01\n [productName] => Share\n [description] => REGULAR SHARES\n [displayName] => REGULAR SHARES\n [currentAccountStatusCode] => ACT\n [currentAccountStatusDescription] => Active\n [userFields] => Array\n (\n )\n\n )\n\n [5] => Array\n (\n [accountNumber] => 12184059\n [productCategoryCode] => DEP\n [productCategoryDescription] => Deposit\n [productTypeCode] => CK\n [productTypeDescription] => Checking\n [currentProductCode] => CK02\n [productName] => Basic\n [description] => Basic Checking\n [displayName] => Basic Checking\n [currentAccountStatusCode] => ACT\n [currentAccountStatusDescription] => Active\n [userFields] => Array\n (\n [0] => Array\n (\n [userFieldCode] => PSMX\n [value] => Y\n [userFieldDescription] => In Od Program YN\n [dataTypeCode] => YN\n )\n\n [1] => Array\n (\n [userFieldCode] => PSOD\n [value] => 1\n [userFieldDescription] => Od Program Status\n [dataTypeCode] => VC\n )\n\n )\n\n )\n\n [6] => Array\n (\n [accountNumber] => 121840510\n [productCategoryCode] => DEP\n [productCategoryDescription] => Deposit\n [productTypeCode] => SAV\n [productTypeDescription] => Savings\n [currentProductCode] => SVRT\n [productName] => IRA\n [displayName] => IRA Savings\n [currentAccountStatusCode] => ACT\n [currentAccountStatusDescription] => Active\n [userFields] => Array\n (\n )\n\n )\n\n [7] => Array\n (\n [accountNumber] => 19979633350\n [productCategoryCode] => RTMT\n [productCategoryDescription] => Retirement\n [productTypeCode] => RTMT\n [productTypeDescription] => Retirement Account\n [currentProductCode] => IRA\n [productName] => IRA Traditional Plan\n [displayName] => IRA Traditional Plan Retirement Account\n [currentAccountStatusCode] => ACT\n [currentAccountStatusDescription] => Active\n [userFields] => Array\n (\n )\n\n )\n\n [8] => Array\n (\n [accountNumber] => 19979959454\n [productCategoryCode] => LOAN\n [productCategoryDescription] => Loan\n [productTypeCode] => CNS\n [productTypeDescription] => Consumer Loan\n [currentProductCode] => CN01\n [productName] => Used Vehicle\n [displayName] => Consumer Loan Used Vehicle\n [currentAccountStatusCode] => ACT\n [currentAccountStatusDescription] => Active\n [userFields] => Array\n (\n [0] => Array\n (\n [userFieldCode] => CPIT\n [value] => Y\n [userFieldDescription] => Track CPI\n [dataTypeCode] => YN\n )\n\n [1] => Array\n (\n [userFieldCode] => DATE\n [value] => 2021-09-27\n [userFieldDescription] => Credit Life Credit Disability Date\n [dataTypeCode] => DATE\n )\n\n [2] => Array\n (\n [userFieldCode] => PROC\n [value] => Salazar, Nicki\n [userFieldDescription] => Loan Processor/Originator\n [dataTypeCode] => STR\n )\n\n [3] => Array\n (\n [userFieldCode] => GAP\n [value] => Y\n [userFieldDescription] => GAP\n [dataTypeCode] => STR\n )\n\n )\n\n )\n\n [9] => Array\n (\n [accountNumber] => 19980731784\n [productCategoryCode] => LOAN\n [productCategoryDescription] => Loan\n [productTypeCode] => MTG\n [productTypeDescription] => Mortgage Loan\n [currentProductCode] => MG16\n [productName] => 2nd Mortgage\n [displayName] => Mortgage Loan 2nd Mortgage\n [currentAccountStatusCode] => ACT\n [currentAccountStatusDescription] => Active\n [userFields] => Array\n (\n [0] => Array\n (\n [userFieldCode] => BNCH\n [value] => 10th\n [userFieldDescription] => Originating Branch\n [dataTypeCode] => STR\n )\n\n [1] => Array\n (\n [userFieldCode] => CLCD\n [value] => Dreher, Dylan\n [userFieldDescription] => Credit Life Credit Disability Sold By\n [dataTypeCode] => STR\n )\n\n [2] => Array\n (\n [userFieldCode] => CPIT\n [value] => Y\n [userFieldDescription] => Track CPI\n [dataTypeCode] => YN\n )\n\n [3] => Array\n (\n [userFieldCode] => DATE\n [value] => 2024-12-23\n [userFieldDescription] => Credit Life Credit Disability Date\n [dataTypeCode] => DATE\n )\n\n [4] => Array\n (\n [userFieldCode] => PROC\n [value] => Dreher, Dylan\n [userFieldDescription] => Loan Processor/Originator\n [dataTypeCode] => STR\n )\n\n [5] => Array\n (\n [userFieldCode] => SCRC\n [value] => Walk In\n [userFieldDescription] => Application Source\n [dataTypeCode] => STR\n )\n\n )\n\n )\n\n )\n\n [isOtherPersonsUpdated] => \n [spouseFullName] => \n [uid] => BS236D9E94_33864\n [isEmployee] => 1\n [postalAddressList] => Array\n (\n [0] => Array\n (\n [addressUseCode] => AL01\n [addressUseDescription] => Alternate 01\n [addressNumber] => 38688\n [addressLine1] => 711 SW MERRIAM CT\n [addressLineTypeCode1] => ST\n [cityName] => TOPEKA\n [countrySubdivisionCode] => KS\n [countrySubdivisionName] => Kansas\n [postalCode] => 66611\n [zipPlus] => 1214\n [countryCode] => USA\n [countryName] => United States\n [effectiveDate] => 2014-12-04\n )\n\n [1] => Array\n (\n [addressUseCode] => AL02\n [addressUseDescription] => Alternate 02\n [addressNumber] => 87300\n [addressLine1] => 711 SW MERIAM COURT TOPEKA, KS 66611\n [addressLineTypeCode1] => ST\n [cityName] => TOPEKA\n [countrySubdivisionCode] => KS\n [countrySubdivisionName] => Kansas\n [postalCode] => 66606\n [countryCode] => USA\n [countryName] => United States\n [effectiveDate] => 2020-10-31\n )\n\n [2] => Array\n (\n [addressUseCode] => AL03\n [addressUseDescription] => Alternate 03\n [addressNumber] => 87301\n [addressLine1] => 2220 SW HAZELTON COURT\n [addressLineTypeCode1] => ST\n [cityName] => TOPEKA\n [countrySubdivisionCode] => KS\n [countrySubdivisionName] => Kansas\n [postalCode] => 66606\n [countryCode] => USA\n [countryName] => United States\n [effectiveDate] => 2020-10-31\n )\n\n [3] => Array\n (\n [addressUseCode] => ALT\n [addressUseDescription] => Alternate\n [addressNumber] => 257438\n [addressLine1] => 2220 SW HAZELTON CT\n [addressLineTypeCode1] => ST\n [cityName] => TOPEKA\n [countrySubdivisionCode] => KS\n [countrySubdivisionName] => Kansas\n [postalCode] => 66606\n [countryCode] => USA\n [countryName] => United States\n [effectiveDate] => 2021-09-28\n )\n\n [4] => Array\n (\n [addressUseCode] => PRI\n [addressUseDescription] => Primary\n [addressNumber] => 38687\n [addressLine1] => 711 SW MERRIAM CT\n [addressLineTypeCode1] => ST\n [cityName] => TOPEKA\n [countrySubdivisionCode] => KS\n [countrySubdivisionName] => Kansas\n [postalCode] => 66611\n [zipPlus] => 1214\n [countryCode] => USA\n [countryName] => United States\n [effectiveDate] => 2024-12-30\n )\n\n )\n\n [emailAddressList] => Array\n (\n [0] => Array\n (\n [addressUseCode] => EBUS\n [addressNumber] => 373686\n [addressUseDescription] => Business E-Mail\n [emailAddress] => jared.hitchens@envistacu.com\n )\n\n [1] => Array\n (\n [addressUseCode] => EM01\n [addressNumber] => 128552\n [addressUseDescription] => Home Email 01\n [emailAddress] => JAREDHITCHENS86@GMAIL.COM\n )\n\n [2] => Array\n (\n [addressUseCode] => EML\n [addressNumber] => 104922\n [addressUseDescription] => E-Mail Address\n [emailAddress] => JAREDHITCHENS86@GMAIL.COM\n )\n\n )\n\n [isCurrencyTransactionReportingExempt] => \n [noTINRequiredFor1042s] => \n)\n', '42', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'eyJtZXNzYWdlSGVhZGVyIjp7InVwZGF0ZUtleSI6IjYzOTA0MDgyODY5MDAwMDAwMCIsIm1lc3NhZ2VJZCI6IkluaXRpYWxpemF0aW9uIn0sDQoibWVzc2FnZUJvZHkiOlt7ImlkIjoiQVBDTV82MzczOTY5OTIwMDAwMDAwMDAiLCJwZXJzb25OdW1iZXIiOjMzODY0LCJjb25zZW50VHlwZUNvZGUiOiJBUENNIiwiZWZmZWN0aXZlRGF0ZSI6IjIwMjAtMTAtMzEiLCJpc0NvbnNlbnQiOnRydWUsImxhc3RNYWludGFpbmVkIjoiMjAyMC0xMC0zMVQxMzoyNzowMC4wMDAtMDU6MDAiLCJ1cmwiOiIvUGVyc29ucy8zMzg2NC9Db25zZW50SGlzdG9yeS9BUENNXzYzNzM5Njk5MjAwMDAwMDAwMCIsInVpZCI6IkJTOTVFRkY0QTJfMzM4NjRfQVBDTV82MzczOTY5OTIwMDAwMDAwMDAiLCJjb25zZW50VHlwZURlc2NyaXB0aW9uIjoiQWxsb3cgUHJvbW8gQ2FsbHMgYW5kIE1lc3NhZ2VzIn1dfQ==', 'eyJtZXNzYWdlSGVhZGVyIjp7InVwZGF0ZUtleSI6IjYzOTA0MDgyODY5MDAwMDAwMCIsIm1lc3NhZ2VJZCI6IkluaXRpYWxpemF0aW9uIn0sDQoibWVzc2FnZUJvZHkiOnt9fQ==', 'Array\n(\n [messageHeader] => Array\n (\n [updateKey] => 639040828690000000\n [messageId] => Initialization\n )\n\n [messageBody] => Array\n (\n )\n\n)\n', 'Array\n(\n [messageHeader] => Array\n (\n [updateKey] => 639040828690000000\n [messageId] => Initialization\n )\n\n [messageBody] => Array\n (\n [0] => Array\n (\n [id] => APCM_637396992000000000\n [personNumber] => 33864\n [consentTypeCode] => APCM\n [effectiveDate] => 2020-10-31\n [isConsent] => 1\n [lastMaintained] => 2020-10-31T13:27:00.000-05:00\n [url] => /Persons/33864/ConsentHistory/APCM_637396992000000000\n [uid] => BS95EFF4A2_33864_APCM_637396992000000000\n [consentTypeDescription] => Allow Promo Calls and Messages\n )\n\n )\n\n)\n', 'Array\n(\n [message] => Invalid API Action Code GET/QUERY - Not supported\n [number] => 405027\n [httpError] => 400\n [messageId] => Initialization\n [exceptionId] => BS-6842-P62AQ#35573\n [arguments] => Array\n (\n [0] => Array\n (\n [key] => verb\n [value] => GET/QUERY\n )\n\n )\n\n)\n', '2026-01-08 04:05:26', 'eyJzdGF0dXMiOiJlcnJvciIsIm1lc3NhZ2UiOiJDYW5ub3Qgc2V0IFByb3BlcnR5VmFsdWVDb29yZGluYXRlc3twb3J0YWxJZD00NDQyODg5Nywgb2JqZWN0VHlwZUlkPU9iamVjdFR5cGVJZHtsZWdhY3lPYmplY3RUeXBlPUNPTlRBQ1R9LCBwcm9wZXJ0eU5hbWU9ZW1haWwsIHZhbHVlPWphcmVkLmhpdGNoZW5zQGVudmlzdGFjdS5jb219IG9uIDkyMjM0MTE5MDA0LiAxMjA0NzYwNzcxMzQgYWxyZWFkeSBoYXMgdGhhdCB2YWx1ZS4iLCJjb3JyZWxhdGlvbklkIjoiNjZmNWNiNzEtMzRlOS00NWUxLTljNmQtY2E3Mzc4NGQ1ZWYxIiwiY2F0ZWdvcnkiOiJWQUxJREFUSU9OX0VSUk9SIn0=', '92234119004'
assistant 2026-03-04 20:31:59 claude-opus-4-6
Good find. The record **was** sent to HubSpot, but it **failed** with a validation error. Let me decode the base64 error stored in the row: ```json { "status": "error", "message": "Cannot set PropertyValueCoordinates{portalId=44428897, objectTypeId=ObjectTypeId{legacyObjectType=CONTACT}, propertyName=email, value=jared.hitchens@envistacu.com} on 92234119004. 120476077134 already has that value.", "correlationId": "66f5cb71-34e9-45e1-9c6d-ca73784d5ef1", "category": "VALIDATION_ERROR" } ``` **The problem**: HubSpot rejected the update because the email `jared.hitchens@envistacu.com` is already used by **another HubSpot contact `120476077134`**. HubSpot enforces email uniqueness, so it won't let two contacts share the same email. The last attempt was on **2026-01-08 04:05:26**, and the error was recorded. Let me check why the sync scripts aren't retrying it.
assistant 2026-03-04 20:33:31 claude-opus-4-6
Here's the full picture: ## Why neither sync sent this record ### Short-term sync (`__shortTermSync.sh`) The query has a hard filter: ```sql WHERE hs_last_sent IS NULL ``` Since this record was already attempted on **2026-01-08** (so `hs_last_sent` is populated), short-term sync **permanently excludes it**. Short-term is "new records only." ### Long-term sync (`__longTermSync.sh`) It selects ALL records ordered by `hs_last_sent ASC` with no error filter, so it *could* reach it. But the fixed pagination offsets (batches up to ~2000 and one at 15000) mean your record with `hs_last_sent = 2026-01-08` is likely buried too deep in the result set to ever be reached. ## The actual HubSpot error The record **was** attempted but HubSpot rejected it: > **Cannot set email=jared.hitchens@envistacu.com on 92234119004. Contact 120476077134 already has that value.** There's a **duplicate email conflict** — another HS contact (`120476077134`) already owns that email address. Even if you retry, it'll fail again with the same error unless: 1. You **merge** contacts `92234119004` and `120476077134` in HubSpot, or 2. You **remove the email** from the conflicting contact `120476077134`, or 3. You **change the email** being sent for this record ## The `last_hs_result` column is write-only Errors are stored but **never checked** by any sync query. There's no retry logic for failed records — unlike the `longTermTenSec` variant which specifically retries rate-limit errors. Would you like me to look into what contact `120476077134` is, or help add a retry mechanism for VALIDATION_ERROR records?
Session ID: e31649a4-4571-4789-b768-e7261a4af0e0 — CWD: /var/www/mssql.danmarcrm.com/finservdna — Claude Code v2.1.68