1 Accepted solution
Merge duplicates code errors
SOLVEHi @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:
/**
* 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.
I hope this proves helpful. Please let me know if you have any follow-up questions 🙂
All the best,
Zach
--
|
| Zach Klein |
 |
 | If my post helped answer your query, please consider marking it as a solution. |
Merge duplicates code errors
SOLVEHi @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:
/**
* 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.
I hope this proves helpful. Please let me know if you have any follow-up questions 🙂
All the best,
Zach
--
|
| Zach Klein |
|
| If my post helped answer your query, please consider marking it as a solution. |
Merge duplicates code errors
SOLVE@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.
I thought this might be relevant!
Best regards,
Jonas De Mets |
| Did my reply help answer your question? Please mark it as a solution. |
Merge duplicates code errors
SOLVEHi @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" 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 do you have troubleshooting steps to help @CSteinbach, please?
Thank you very much and have a great day!
Best,
Bérangère
|
HubSpot’s AI-powered customer agent resolves up to 50% of customer queries instantly, with some customers reaching up to 90% resolution rates. Learn More. |
 | Saviez vous que la Communauté est disponible en français? Rejoignez les discussions francophones en changeant votre langue dans les paramètres! ! |
