# Merge duplicates code errors **URL:** \ **Category:** APIs & Integrations\ **Tags:** workflow-extension\ **Created:** [July 24, 2024, 2:25pm UTC](https://community.hubspot.com/t/merge-duplicates-code-errors/112759 "2024-07-24T14:25:30Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![CSteinbach](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/csteinbach/32/25106_2.png) [@CSteinbach](https://community.hubspot.com/u/CSteinbach)\ **Post date:** [July 24, 2024, 2:25pm UTC](https://community.hubspot.com/t/merge-duplicates-code-errors/112759/1 "2024-07-24T14:25:30Z")
I was using the default merge duplicates code and updated the property that I need to merge contacts by which is “rim\_no” (a unique customer identifyer in our database). I have set up the API key in “Secrets” but after a lot of trouble shooting, I just can’t figure it out. Anyone have any ideas? Here’s the code: Spoiler /\*\* \* Searches for another contact with the same value of DEDUPE\_PROPERTY. \* - If no matches are found, nothing happens \* - If one match is found, the enrolled contact is merged into the matching contact \* - If more than one match is found, the action fails \*/ const DEDUPE\_PROPERTY = ‘rim\_no’; const hubspot = require(‘@hubspot/api-client’); exports.main = (event, callback) =\> { // Make sure to add your API key under “Secrets” above. const hubspotClient = new hubspot.Client({ accessToken: process.env.SECRET\_NAME, }); hubspotClient.crm.contacts.basicApi .getById(event.object.objectId, [DEDUPE\_PROPERTY]) .then(contactResult =\> { let dedupePropValue = contactResult.body.properties[DEDUPE\_PROPERTY]; // console.log(`Looking for duplicates based on ${DEDUPE_PROPERTY} = ${dedupePropValue}`); hubspotClient.crm.contacts.searchApi .doSearch({ filterGroups: [{ filters: [{ propertyName: DEDUPE\_PROPERTY, operator: ‘EQ’, value: dedupePropValue }] }] }) .then(searchResults =\> { let idsToMerge = searchResults.body.results .map(object =\> object.id) .filter(vid =\> Number(vid) !== Number(event.object.objectId)); if (idsToMerge.length == 0) { console.log(‘No matching contact, nothing to merge’); return; } else if (idsToMerge.length \> 1) { console.log(`Found multiple potential contact IDs ${idsToMerge.join(', ')} to merge`); throw new Error(“Ambiguous merge; more than one matching contact”); } let idToMerge = idsToMerge[0]; console.log(`Merging enrolled contact id=${event.object.objectId} into contact id=${idToMerge}`); hubspotClient .apiRequest({ method: ‘PATCH’, path: `/crm/v3/objects/contacts/IDOFSECONDARY`, body: { “properties”: { “dupe”: “duplicate” } } }) .then(mergeResult =\> { console.log(‘Contacts merged!’); }); }); }); }; Here’s the error log: Spoiler ```auto WARNING: The logs for this function have exceeded the 4KB limit. ... ontrol-allow-credentials\":\"false\",\"cf-cache-status\":\"DYNAMIC\",\"cf-ray\":\"8a848b6a5f2887ac-IAD\",\"connection\":\"close\",\"content-length\":\"299\",\"content-type\":\"application/json;charset=utf-8\",\"date\":\"Wed, 24 Jul 2024 14:19:20 GMT\",\"nel\":\"{\\\"success_fraction\\\":0.01,\\\"report_to\\\":\\\"cf-nel\\\",\\\"max_age\\\":604800}\",\"report-to\":\"{\\\"endpoints\\\":[{\\\"url\\\":\\\"https:\\\\/\\\\/a.nel.cloudflare.com\\\\/report\\\\/v4?s=R2f5tgv4JVSRn%2FjWX2DmhksTGsVDCYh2KRLzkRPRHy6lR2%2BLNg0brV8fmXULq03p%2F9Sy8CyIfBqFoAT0dCrNOaRLH3%2FlYCa8AbHa5WufRcjIuF7wPZB%2FR3hfQN5raPot\\\"}],\\\"group\\\":\\\"cf-nel\\\",\\\"max_age\\\":604800}\",\"server\":\"cloudflare\",\"strict-transport-security\":\"max-age=31536000; includeSubDomains; preload\",\"vary\":\"origin, Accept-Encoding\",\"x-content-type-options\":\"nosniff\",\"x-envoy-upstream-service-time\":\"4\",\"x-evy-trace-listener\":\"listener_https\",\"x-evy-trace-route-configuration\":\"listener_https/all\",\"x-evy-trace-route-service-name\":\"envoyset-translator\",\"x-evy-trace-served-by-pod\":\"iad02/hubapi-td/envoy-proxy-7dd59b876-mtwxl\",\"x-evy-trace-virtual-host\":\"all\",\"x-hubspot-auth-failure\":\"401 Unauthorized\",\"x-hubspot-correlation-id\":\"5cb63b81-60bd-445e-93de-b503bbdacda5\",\"x-request-id\":\"5cb63b81-60bd-445e-93de-b503bbdacda5\"}"," at BasicApiResponseProcessor. (/opt/nodejs/node_modules/@hubspot/api-client/lib/codegen/crm/contacts/apis/BasicApi.js:227:23)"," at Generator.next ()"," at fulfilled (/opt/nodejs/node_modules/@hubspot/api-client/lib/codegen/crm/contacts/apis/BasicApi.js:5:58)"," at processTicksAndRejections (node:internal/process/task_queues:96:5)"]},"promise":{},"stack":["Runtime.UnhandledPromiseRejection: Error: HTTP-Code: 401","Message: An error occurred.","Body: {\"status\":\"error\",\"message\":\"Authentication credentials not found. This API supports OAuth 2.0 authentication and you can find more details at https://developers.hubspot.com/docs/methods/auth/oauth-overview\",\"correlationId\":\"5cb63b81-60bd-445e-93de-b503bbdacda5\",\"category\":\"INVALID_AUTHENTICATION\"}","Headers: {\"access-control-allow-credentials\":\"false\",\"cf-cache-status\":\"DYNAMIC\",\"cf-ray\":\"8a848b6a5f2887ac-IAD\",\"connection\":\"close\",\"content-length\":\"299\",\"content-type\":\"application/json;charset=utf-8\",\"date\":\"Wed, 24 Jul 2024 14:19:20 GMT\",\"nel\":\"{\\\"success_fraction\\\":0.01,\\\"report_to\\\":\\\"cf-nel\\\",\\\"max_age\\\":604800}\",\"report-to\":\"{\\\"endpoints\\\":[{\\\"url\\\":\\\"https:\\\\/\\\\/a.nel.cloudflare.com\\\\/report\\\\/v4?s=R2f5tgv4JVSRn%2FjWX2DmhksTGsVDCYh2KRLzkRPRHy6lR2%2BLNg0brV8fmXULq03p%2F9Sy8CyIfBqFoAT0dCrNOaRLH3%2FlYCa8AbHa5WufRcjIuF7wPZB%2FR3hfQN5raPot\\\"}],\\\"group\\\":\\\"cf-nel\\\",\\\"max_age\\\":604800}\",\"server\":\"cloudflare\",\"strict-transport-security\":\"max-age=31536000; includeSubDomains; preload\",\"vary\":\"origin, Accept-Encoding\",\"x-content-type-options\":\"nosniff\",\"x-envoy-upstream-service-time\":\"4\",\"x-evy-trace-listener\":\"listener_https\",\"x-evy-trace-route-configuration\":\"listener_https/all\",\"x-evy-trace-route-service-name\":\"envoyset-translator\",\"x-evy-trace-served-by-pod\":\"iad02/hubapi-td/envoy-proxy-7dd59b876-mtwxl\",\"x-evy-trace-virtual-host\":\"all\",\"x-hubspot-auth-failure\":\"401 Unauthorized\",\"x-hubspot-correlation-id\":\"5cb63b81-60bd-445e-93de-b503bbdacda5\",\"x-request-id\":\"5cb63b81-60bd-445e-93de-b503bbdacda5\"}"," at process. (file:///var/runtime/index.mjs:1276:17)"," at process.emit (node:events:513:28)"," at emit (node:internal/process/promises:140:20)"," at processPromiseRejections (node:internal/process/promises:274:27)"," at processTicksAndRejections (node:internal/process/task_queues:97:32)"]} Unknown application error occurred Runtime.Unknown Memory: 75/128 MB Runtime: 1163.15 ms ``` ---
**Author:** ![Berangere](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/berangere/32/220784_2.png) [@Berangere](https://community.hubspot.com/u/Berangere)\ **Post date:** [July 25, 2024, 8:28am UTC](https://community.hubspot.com/t/merge-duplicates-code-errors/112759/2 "2024-07-25T08:28:53Z")
Hi @CSteinbach and welcome to the Community! We are delighted to have you join us! Thank you for asking the Community and for sharing the code! Since this a public space, please make sure that there is no confidential information. I have found this similar thread where the solution from @GJakobTriad on this post “[Custom code and Company deduplication](https://community.hubspot.com/t5/APIs-Integrations/Custom-code-and-Company-deduplication/m-p/882799)” might help you. Also, I’d like to invite a couple of subject matter experts and Community Members to this conversation: Hi @andreaska, @himanshurauthan and [@zach\_threadint](https://community.hubspot.com/t5/user/viewprofilepage/user-id/324811) do you have troubleshooting steps to help @CSteinbach, please? Thank you very much and have a great day! Best, Bérangère ---
**Author:** ![CSteinbach](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/csteinbach/32/25106_2.png) [@CSteinbach](https://community.hubspot.com/u/CSteinbach)\ **Post date:** [July 25, 2024, 7:07pm UTC](https://community.hubspot.com/t/merge-duplicates-code-errors/112759/3 "2024-07-25T19:07:12Z")
I have continued troubleshooting using the resources provided, but I’m still running into errors. Here the updated code: ```lia-code-sample /** * Searches for another contact with the same value of DEDUPE_PROPERTY. * - If no matches are found, nothing happens * - If one match is found, the enrolled contact is merged into the matching contact * - If more than one match is found, the action fails */ const DEDUPE_PROPERTY = 'rim_no'; const hubspot = require('@hubspot/api-client'); exports.main = (event, callback) => { // Make sure to add your API key under "Secrets" above. const hubspotClient = new hubspot.Client({ accessToken: process.env.[INSERT ACCESS TOKEN] }); hubspotClient.crm.contacts.basicApi .getById(event.object.objectId, [DEDUPE_PROPERTY]) .then(contactResult => { let dedupePropValue = contactResult.body.properties[DEDUPE_PROPERTY]; console.log(`Looking for duplicates based on ${DEDUPE_PROPERTY} = ${dedupePropValue}`); hubspotClient.crm.contacts.searchApi .doSearch({ filterGroups: [{ filters: [{ propertyName: DEDUPE_PROPERTY, operator: 'EQ', value: dedupePropValue }] }] }) .then(searchResults => { let idsToMerge = searchResults.body.results .map(object => object.id) .filter(vid => Number(vid) !== Number(event.object.objectId)); if (idsToMerge.length == 0) { console.log('No matching contact, nothing to merge'); return; } else if (idsToMerge.length > 1) { console.log(`Found multiple potential contact IDs ${idsToMerge.join(', ')} to merge`); throw new Error("Ambiguous merge; more than one matching contact"); } let idToMerge = idsToMerge[0]; console.log(`Merging enrolled contact id=${event.object.objectId} into contact id=${idToMerge}`); hubspotClient .apiRequest({ method: 'POST', path: `/contacts/v1/contact/merge-vids/${idToMerge}`, body: { vidToMerge: event.object.objectId } }) .then(mergeResult => { console.log('Contacts merged!'); }); }); }); }; ``` Here’s the new error: ```lia-code-sample 2024-07-25T19:04:33.715Z ERROR Unhandled Promise Rejection {"errorType":"Runtime.UnhandledPromiseRejection","errorMessage":"TypeError: Cannot read properties of undefined (reading 'properties')","reason":{"errorType":"TypeError","errorMessage":"Cannot read properties of undefined (reading 'properties')","stack":["TypeError: Cannot read properties of undefined (reading 'properties')"," at /var/task/file.js:21:48"," at processTicksAndRejections (node:internal/process/task_queues:96:5)"]},"promise":{},"stack":["Runtime.UnhandledPromiseRejection: TypeError: Cannot read properties of undefined (reading 'properties')"," at process. (file:///var/runtime/index.mjs:1276:17)"," at process.emit (node:events:513:28)"," at emit (node:internal/process/promises:140:20)"," at processPromiseRejections (node:internal/process/promises:274:27)"," at processTicksAndRejections (node:internal/process/task_queues:97:32)"]} Unknown application error occurred Runtime.Unknown Memory: 75/128 MB Runtime: 1438.88 ms ``` ---
**Author:** ![Jonas\_De\_Mets](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jonas_de_mets/32/72908_2.png) [@Jonas\_De\_Mets](https://community.hubspot.com/u/Jonas_De_Mets)\ **Post date:** [July 27, 2024, 12:09pm UTC](https://community.hubspot.com/t/merge-duplicates-code-errors/112759/4 "2024-07-27T12:09:04Z")
@CSteinbach were you able to resolve the code issue? We have created a plugin to make deduplication easy in HubSpot. Of the main feature is a [workflow action that merges contact/companies.](https://koalify.io/knowledge-base/how-to-automatically-merge-hubspot-duplicates-using-koalify-workflow-actions) I thought this might be relevant! ![Jonas_De_Mets_0-1722082019115.jpeg](https://d2qpr2jzcazej7.cloudfront.net/original/3X/a/3/a323124ade37316ec273f9aae1a6463b668c549e.jpeg) Best regards, ---
**Author:** ![zach\_threadint](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/zach_threadint/32/46318_2.png) [@zach\_threadint](https://community.hubspot.com/u/zach_threadint)\ **Post date:** [July 29, 2024, 6:03am UTC](https://community.hubspot.com/t/merge-duplicates-code-errors/112759/5 "2024-07-29T06:03:55Z")
Hi @CSteinbach 👋 Looks like you’ve just referenced some keys that weren’t present in the HubSpot API responses. Remove “body” from your “contactResult” and “searchResults” object chains. This has worked on my end, so please feel free to give it a try: ```lia-code-sample /** * Searches for another contact with the same value of DEDUPE_PROPERTY. * - If no matches are found, nothing happens * - If one match is found, the enrolled contact is merged into the matching contact * - If more than one match is found, the action fails */ const DEDUPE_PROPERTY = 'rim_no'; const hubspot = require('@hubspot/api-client'); exports.main = (event, callback) => { // Make sure to add your API key under "Secrets" above. const hubspotClient = new hubspot.Client({ accessToken: process.env.[INSERT ACCESS TOKEN] }); hubspotClient.crm.contacts.basicApi .getById(event.object.objectId, [DEDUPE_PROPERTY]) .then(contactResult => { let dedupePropValue = contactResult.properties[DEDUPE_PROPERTY]; console.log(`Looking for duplicates based on ${DEDUPE_PROPERTY} = ${dedupePropValue}`); hubspotClient.crm.contacts.searchApi .doSearch({ filterGroups: [{ filters: [{ propertyName: DEDUPE_PROPERTY, operator: 'EQ', value: dedupePropValue }] }] }) .then(searchResults => { let idsToMerge = searchResults.results .map(object => object.id) .filter(vid => Number(vid) !== Number(event.object.objectId)); if (idsToMerge.length == 0) { console.log('No matching contact, nothing to merge'); return; } else if (idsToMerge.length > 1) { console.log(`Found multiple potential contact IDs ${idsToMerge.join(', ')} to merge`); throw new Error("Ambiguous merge; more than one matching contact"); } let idToMerge = idsToMerge[0]; console.log(`Merging enrolled contact id=${event.object.objectId} into contact id=${idToMerge}`); hubspotClient .apiRequest({ method: 'POST', path: `/contacts/v1/contact/merge-vids/${idToMerge}`, body: { vidToMerge: event.object.objectId } }) .then(mergeResult => { console.log('Contacts merged!'); }); }); }); }; ``` Finally, if you’re ever looking for an app to handle the merging of Contacts via workflows, you might like to consider [**Utilities for HubSpot**](https://ecosystem.hubspot.com/marketplace/apps/productivity/workflow-automation/utilities-by-thread-integrations-2016879). I hope this proves helpful. Please let me know if you have any follow-up questions 🙂 ---
**Author:** ![CSteinbach](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/csteinbach/32/25106_2.png) [@CSteinbach](https://community.hubspot.com/u/CSteinbach)\ **Post date:** [July 29, 2024, 2:22pm UTC](https://community.hubspot.com/t/merge-duplicates-code-errors/112759/6 "2024-07-29T14:22:25Z")
[@zach\_threadint](https://community.hubspot.com/t5/user/viewprofilepage/user-id/324811) Thank you so much! I had tried to remove “body” but must have missed something! This works and I really really apprecate your help!!