Finservdna active

user 2026-03-05 18:45:51

in our database it seems the hs record 92234119004 has age 45 but in hubspot didn't got updated and it is still 44 can you understand why? No code changes, only debug pls

assistant 2026-03-05 18:45:51

You're out of extra usage · resets Mar 6, 9am (UTC)

user 2026-03-05 18:45:51

in our database it seems the hs record 92234119004 has age 45 but in hubspot didn't got updated and it is still 44 can you understand why? No code changes, only debug pls

assistant 2026-03-05 18:45:51

You're out of extra usage · resets Mar 6, 9am (UTC)

user 2026-03-04 20:15:23

did we sync the hs id 92234119004 lately?

assistant 2026-03-04 20:27:00

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

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

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?

user 2026-02-10 10:38:54

the three sh commands are used to sync a private db to hubspot 10 2 * * * /var/www/mssql.danmarcrm.com/finservdna/__startAll.sh 10 4 * * * /var/www/mssql.danmarcrm.com/finservdna/__shortTermSync.sh 10 6 * * * /var/www/mssql.danmarcrm.com/finservdna/__longTermSync.sh but it seems we keep updating 7405881198 over and over again. In __HasIDDDDDDDDDDDDD.log I've grepped grep -ir '7405881198' *.log some additional logs should be found in logs/ folder Can you understand what is going on and why we keep updtaing this record id and also link for example about 4000 accounts?

assistant 2026-02-10 10:38:59

I'll investigate this by exploring the codebase structure, the sync scripts, and the relevant logs in parallel.

assistant 2026-02-10 10:48:10

Let me verify the critical code sections before writing the plan.

assistant 2026-02-10 10:48:17

Let me also check the sync selection logic and the `procOpp` function to understand why records are re-selected for processing.

assistant 2026-02-10 10:48:24

Let me check how `hs_last_sent` gets updated and the main processing loop.

assistant 2026-02-10 10:48:32

Let me check the send logic and what happens with `hs_last_sent` on error vs success.

assistant 2026-02-10 10:48:38

Let me find where the `__HasIDDDDDDDDDDDDD.log` is written and check the `procOpp` function's contact handling more closely.

assistant 2026-02-10 10:50:03

Let me check how the code decides between create vs update in HubSpot.

assistant 2026-02-10 10:50:39

Now I have a complete understanding of both issues. Let me write the plan with root cause analysis and fixes.

assistant 2026-02-10 10:51:38

Here's what I found: ## The Two Root Causes **Why 7405881198 keeps getting updated:** HubSpot contact 7405881198 belongs to **JERMAINE LOPEZ** (jlopez1529@gmail.com). But many other leads in your local DB have been **incorrectly stamped** with `hs_vid_c = '7405881198'`. This happened through the "Contact already exists" handler at [dmcHSSender.php:1409-1416](custom/dmcHSSender.php#L1409-L1416) — when a lead tried to create a contact and HubSpot said "already exists with ID 7405881198", the code blindly assigned that VID to the local lead, even if the emails don't actually match. Then the `longTerm` sync (`ORDER BY hs_last_sent ASC`) keeps cycling through these corrupted leads, trying to update contact 7405881198 with the wrong person's email (na@na.com, mat.chiddix@gmail.com, etc.), getting VALIDATION_ERRORs, updating `hs_last_sent` anyway, and repeating forever. **Why ~4000 accounts keep getting linked:** The association code at [dmcHSSender.php:1484-1500](custom/dmcHSSender.php#L1484-L1500) sends a `sendAssociation` request **unconditionally** every time a lead is processed — no check for whether it was already linked. Since the `longTerm` sync reprocesses all leads in a loop, every lead with an account re-sends its association every cycle. The plan file has the full analysis with 5 specific fixes. Before I proceed, I have some questions:

assistant 2026-02-10 10:54:18

Understood — you want a full diagnosis first, and you'll implement fixes yourself. Let me update the plan to be a diagnostic report with queries you can run.

assistant 2026-02-10 10:55:25

The plan is complete with the full diagnostic report. Here's the summary: **7 issues identified**, all traced to specific code locations: 1. **The "Contact already exists" handler** ([dmcHSSender.php:1409](custom/dmcHSSender.php#L1409)) blindly assigns an existing HubSpot VID to any lead that triggers a duplicate email error — this is how many leads ended up pointing to contact 7405881198 (JERMAINE LOPEZ) 2. **The longTerm sync creates an infinite loop** because `hs_last_sent` is updated even on errors ([dmcHSSender.php:1464](custom/dmcHSSender.php#L1464)), pushing error leads to the back of the queue to be retried forever 3. **No early return on error** — even failed contact updates proceed to send associations 4. **No association dedup** — every sync cycle re-sends ~4000 association requests 5. **Duplicate association** — Company→Contact is sent in both `procLead()` and `procOpp()` 6. **No error-lead exclusion** in the longTerm query 7. **`na@na.com` placeholder** emails are the root data quality issue feeding into #1 The plan includes 9 diagnostic SQL queries you can run to assess the full scope before making any changes.

user 2026-02-10 11:34:08

[Request interrupted by user for tool use]

user 2026-02-10 11:34:48

how many remote records we get from their endpoint as not hubspot have na@na.com as email address?

assistant 2026-02-10 11:34:59

Let me check the database connection details and query for that.

assistant 2026-02-10 11:35:41

Found the DB: `finservdna` on localhost. Let me query it.

user 2026-02-10 11:35:50

[Request interrupted by user for tool use]

user 2026-02-10 11:36:10

check the cronjob to find how we connect to remote, is not a local db is the first cronjob

assistant 2026-02-10 11:36:30

So the scripts call `php -f dmcFinServ.php`. Let me trace how it fetches from the remote FinServ API and where emails get stored.

assistant 2026-02-10 11:36:58

Now I can see the full picture. Let me also check the raw API data to confirm where `na@na.com` originates.

assistant 2026-02-10 11:37:37

Here's the full chain for how the first cronjob connects to the remote FinServ endpoint: **Connection flow:** 1. `__startAll.sh` → calls `php -f dmcFinServ.php -- 'offset=500&limit=200'` (and similar for each offset) 2. [dmcFinServ.php:73](dmcFinServ.php#L73) → `require_once("__dmcConnectV1.php")` which defines `class dmcConnect` connecting to the remote API 3. [__dmcConnectV1.php:19](/__dmcConnectV1.php#L19) → Remote base URL: `https://api.envistacu.com:30950` 4. [__dmcConnectV1.php:51](/__dmcConnectV1.php#L51) → Fetches contacts via: `GET /DNABusinessServices/Persons/QUERY/NAME/?PageNumber={page}&Sort=addDate&PageSize=20&include=AllAddresses,AccountAndUserFieldInfo` 5. [__dmcConnectV1.php:133-155](/__dmcConnectV1.php#L133-L155) → `saveContacts()` iterates the `messageBody` array from the API response and calls `createUpdateLeads()` for each person 6. [dmcFinServ.php:761-772](dmcFinServ.php#L761-L772) → Email is extracted from the API's `emailAddressList[].emailAddress` field: ```php if (is_array($v['emailAddressList'])){ foreach ($v['emailAddressList'] as $ke => $ve){ if ($ve['emailAddress'] != ""){ if ($email1 == ""){ $email1 = $ve['emailAddress']; } } } if ($email1 != "") $lead->set("email1", $email1); } ``` **Key finding:** `na@na.com` is **NOT generated by the sync code** — there is no placeholder/default email logic. It comes directly from the FinServ API's `emailAddressList` for those person records. The bank's own system has `na@na.com` stored as the email for these contacts. To count how many remote records have `na@na.com`, the local DB mirrors the remote data exactly (stored in `leads.email1`). We could also check the raw API responses stored in `leads_cstm.all_content` (base64-encoded JSON). Would you like me to run the MySQL query to get the count, or would you prefer to run it yourself? ```sql SELECT COUNT(*) FROM leads WHERE email1 = 'na@na.com' AND deleted = 0; ```

assistant 2026-02-10 11:42:15

We can't directly query the remote API at `api.envistacu.com:30950` for a count — their API only supports paginated person listing via `/DNABusinessServices/Persons/QUERY/NAME/` with `PageNumber` and `PageSize`, not filtering by email. However, the local DB is a **direct mirror** of the remote data. Here's how: 1. The remote API returns each person's `emailAddressList` array 2. [dmcFinServ.php:761-772](dmcFinServ.php#L761-L772) copies the first `emailAddress` into `leads.email1` 3. [dmcFinServ.php:778-780](dmcFinServ.php#L778-L780) also stores the **raw API response** as base64-encoded JSON in `leads_cstm.all_content` So we have two ways to verify against the remote source data: 1. **Check `leads.email1`** — the extracted email from the remote response 2. **Check `leads_cstm.all_content`** — the actual raw JSON from `api.envistacu.com:30950`, base64-decoded, would contain `"emailAddress":"na@na.com"` in the `emailAddressList` Both confirm what the remote API returned. Querying the local DB `SELECT COUNT(*) FROM leads WHERE email1 = 'na@na.com'` effectively answers "how many records from the remote endpoint have na@na.com".

user 2026-02-10 11:46:55

[Request interrupted by user for tool use]

user 2025-12-09 11:16:37

pls use code flow analyzer agent to follow the full track of code execution for the next three cronjobs. we need to understand the code flow, execution endpoints, data being fetched etc 10 2 * * * /var/www/mssql.danmarcrm.com/finservdna/__startAll.sh 10 4 * * * /var/www/mssql.danmarcrm.com/finservdna/__shortTermSync.sh 10 6 * * * /var/www/mssql.danmarcrm.com/finservdna/__longTermSync.sh Do not edit any of the code

user 2025-12-09 11:32:27

I've created a folder ../finservdna122025 pls create a .sh code to copy relevant files and folders there. please create in that folder an explanatory file with how data flows. if possible I would need a sample of what the envista endpoints return but do not triger any endpoint, only if you can find through logs

user 2025-12-09 18:41:58

in finservdna1225 pls create a .doc or .docx document and answer to the questions below: Data Pull Frequency & Update Behavior Can you confirm how often the Fiserv → HubSpot integration runs? Is it scheduled, event-driven, or only triggered when certain fields change? When the integration runs, does it push all fields every time, or only fields that have changed in Fiserv? Does the integration update existing HubSpot contacts that were originally added via CSV import, or does it ignore them? Should fields like age and other demographic data always update in HubSpot when they change in Fiserv? Unique Identifier & Matching Logic What field(s) is the integration currently using to match Fiserv records to existing HubSpot contacts? (Email, Member Number, something else?) Is the Person Number (individual ID in Fiserv) available in the API response we’re pulling from? If Person Number is available, can we use it as the universal unique identifier to prevent duplicates? Duplicate Contact Creation Under what exact conditions does the integration create a brand-new contact in HubSpot? Why are we receiving contacts from the integration that have no email, no member number, and no associated deal or account? Can we add guardrails so the integration does not create contacts unless they include at least one required identifier (e.g., email or person number)? Deal & Account Association What logic is currently being used to associate deals/accounts with contacts? Is it possible to prevent contacts from coming in with a member number but no deals/accounts? Can we filter out members if they don’t have a unique identifier (member number or person number)? Field Mapping & Missing Data Can you provide the full JSON payload or schema that the integration receives from the DNA API so we can verify which fields we do and don’t have access to? How does the integration handle overwriting? For example, does it overwrite fields in HubSpot even when the values haven’t changed? Handling Imported Contacts Does the integration attempt to match against contacts that were imported manually into HubSpot? If not, can we enable matching using Member Number or Person Number so we avoid duplicate creation?

user 2025-12-10 14:45:44

pls create a mapping description of data that goes to hubspot from envista

user 2025-12-10 14:49:16

pls create a mapping for envista received fields to hubspot, do not mention the interim database