topic Custom Code - Get firstname & lastname from email address in Data Hub

Custom Code - Get firstname & lastname from email address

MSaurat — Fri, 01 Sep 2023 15:15:56 GMT

Hi,

I'm not a developper of any sort but I'm trying to understand custom code for worflows. I'd like to be able to get the firstname & lastname of a contact when the email address looks like this "firstame.lastname@domain.com".

I've used this python code:

import re

def extract_name_from_hubspot_email(email):
# Define a regular expression pattern to match HubSpot email format
pattern = r'^([a-zA-Z]+)\.([a-zA-Z]+)@.*$'

# Use re.match to extract the first name and last name
match = re.match(pattern, email)

if match:
first_name = match.group(1)
last_name = match.group(2)
return first_name, last_name

# If the email doesn't match the expected HubSpot format, return None
return None, None

# Example usage:
email = "john.doe@hubspot.com"
first_name, last_name = extract_name_from_hubspot_email(email)
if first_name and last_name:
print("First Name:", first_name)
print("Last Name:", last_name)
else:
print("Unable to extract first name and last name from the email.")

But not really sure how to do it with the custom code.

Any help appreciated.

Thank you

Betreff: Custom Code - Get firstname & lastname from email address

MiaSrebrnjak — Mon, 04 Sep 2023 13:20:20 GMT

Hi @MSaurat,

Thank you for reaching out to the Community!

I found this code on GitHub which could be helpful: @coldrickjack shared how to split the full name provided by a contact using a custom coded workflow action.

@coldrickjack do you think @MSaurat could do something similar with the first & lastname of a contact's email address? Thank you!

Cheers
Mia, Community Team

Re: Custom Code - Get firstname & lastname from email address

DanielJeal — Thu, 07 Sep 2023 08:27:10 GMT

What do you want to do with the name when you get it? Update the Contacts name in HubSpot? Also, what if their email is lastname.firstname?!

Re: Custom Code - Get firstname & lastname from email address

MSaurat — Mon, 11 Sep 2023 07:48:01 GMT

Hey Dan,

Yes basically extract FN & LN and add the corresponding fields. I'm not worried about the email address having LN.FN@ as we're dealing with professional accounts and 99% are FN.LN@

Re: Custom Code - Get firstname & lastname from email address

Maciek-Magic — Tue, 12 Sep 2023 10:24:04 GMT

That should do the trick.

Re: Custom Code - Get firstname & lastname from email address

DamianKnapp — Wed, 04 Oct 2023 12:35:34 GMT

So - this one brings up an error as per below. should this be "import from" on line 1?

[ERROR] Runtime.UserCodeSyntaxError: Syntax error in module 'hubspotHandler': invalid syntax (file.py, line 1)
Traceback (most recent call last):
  File "/var/task/file.py" Line 1
    const hubspot = require('@hubspot/api-client');
Memory: 37/128 MB
Runtime: 1.52 ms

Re: Custom Code - Get firstname & lastname from email address

Maciek-Magic — Wed, 04 Oct 2023 12:53:11 GMT

Above script is for Node.js and your error have .py extenson which indicates that you are using Python.
Change Language to node.js (drop down at very top of Custom code window)

Re: Custom Code - Get firstname & lastname from email address

DamianKnapp — Wed, 04 Oct 2023 16:03:04 GMT

Ahh ok - cool. So, i have changed this to node but i am now getting a new error

WARNING: The logs for this function have exceeded the 4KB limit.
...
th\":\"299\",\"content-type\":\"application/json;charset=utf-8\",\"date\":\"Wed, 04 Oct 2023 14:13:54 GMT\",\"nel\":\"{\\\"success_fraction\\\":0.01,\\\"report_to\\\":\\\"cf-nel\\\",\\\"max_age\\\":604800}\",\"report-to\":\"{\\\"endpoints\\\":[{\\\"url\\\":\\\"https:\\\\/\\\\/a.nel.cloudflare.com\\\\/report\\\\/v3?s=R1xxowtx0mun4hENbLNfeB6D8pGV9PDfJdYRMKneCXYxWPhTz5c7SUkOIVZbZ80AMu1zh9phiTEUAvMyfQP4MJt9SPrbkf5tNih%2FZymAXLdV%2FPvFnKBXbJ8a7cJA0F88\\\"}],\\\"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\":\"3\",\"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-5b5c96c966-58hgh\",\"x-evy-trace-virtual-host\":\"all\",\"x-hubspot-auth-failure\":\"401 Unauthorized\",\"x-hubspot-correlation-id\":\"d648677e-8e57-436f-937d-be9d4aea1ebb\",\"x-request-id\":\"d648677e-8e57-436f-937d-be9d4aea1ebb\",\"x-trace\":\"2BF72E4BDF67F1EE00D32853021FA9998311A5AE28000000000000000000\"}","    at BasicApiResponseProcessor.<anonymous> (/opt/nodejs/node_modules/@hubspot/api-client/lib/codegen/crm/contacts/apis/BasicApi.js:247:23)","    at Generator.next (<anonymous>)","    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\":\"d648677e-8e57-436f-937d-be9d4aea1ebb\",\"category\":\"INVALID_AUTHENTICATION\"}","Headers: {\"access-control-allow-credentials\":\"false\",\"cf-cache-status\":\"DYNAMIC\",\"cf-ray\":\"810e0734ae500497-FRA\",\"connection\":\"close\",\"content-length\":\"299\",\"content-type\":\"application/json;charset=utf-8\",\"date\":\"Wed, 04 Oct 2023 14:13:54 GMT\",\"nel\":\"{\\\"success_fraction\\\":0.01,\\\"report_to\\\":\\\"cf-nel\\\",\\\"max_age\\\":604800}\",\"report-to\":\"{\\\"endpoints\\\":[{\\\"url\\\":\\\"https:\\\\/\\\\/a.nel.cloudflare.com\\\\/report\\\\/v3?s=R1xxowtx0mun4hENbLNfeB6D8pGV9PDfJdYRMKneCXYxWPhTz5c7SUkOIVZbZ80AMu1zh9phiTEUAvMyfQP4MJt9SPrbkf5tNih%2FZymAXLdV%2FPvFnKBXbJ8a7cJA0F88\\\"}],\\\"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\":\"3\",\"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-5b5c96c966-58hgh\",\"x-evy-trace-virtual-host\":\"all\",\"x-hubspot-auth-failure\":\"401 Unauthorized\",\"x-hubspot-correlation-id\":\"d648677e-8e57-436f-937d-be9d4aea1ebb\",\"x-request-id\":\"d648677e-8e57-436f-937d-be9d4aea1ebb\",\"x-trace\":\"2BF72E4BDF67F1EE00D32853021FA9998311A5AE28000000000000000000\"}","    at process.<anonymous> (file:///var/runtime/index.mjs:1250: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: 74/128 MB
Runtime: 1546.15 ms

Re: Custom Code - Get firstname & lastname from email address

Maciek-Magic — Thu, 05 Oct 2023 07:42:39 GMT

Looks like you didn't change SECRET_NAME to your Secret name with Private App token.

I'll walk you through.

Navigate to HubSpot Settings

In Left menu find INTEGRATIONS > PRIVATE APPS

Click Crate a Private app button
In Basic Info give it a name - ex. Contact

In Scopes in CRM find crm.objects.contacts and select Read and Write for it

Click Create App button and Continue creating in pop-up

Click Show token and Copy

Now go to you Custom Code step in workflow
Second from Top there is a Dropdown list with Secrets, click it

Click Add Secret,

Give it a name best would be same as you gave to you Private App ie. Contact so you know what is what
In Secret Value paste token you copied from Private App. And Save it.

Now go to your code and change this

accessToken: process.env.SECRET_NAME

to this

accessToken: process.env.Contact

Re: Custom Code - Get firstname & lastname from email address

DamianKnapp — Thu, 05 Oct 2023 09:41:42 GMT

Awesome - Ok.

Thanks for getting my training wheels on with this. Its really helped me out.