topic Re: Extracting Param Value From URL Path Using Custom Code in Data Hub

Extracting Param Value From URL Path Using Custom Code

JoshuaW — Thu, 11 Apr 2024 21:47:34 GMT

Does anyone know workflow custom code that would extract a specific parameter from the "Last Page Seen" contact property URL to then apply that value to another property for the contact? For example: If the "Last Page Seen" value is the following URL and I'm looking for the param value of "npsevent", I would want the action to copy "CaptureThisValue" to another property.

examplewebsite.com/event?npsevent=CaptureThisValue

I can predict the parameter of "npsevent" will always be present, but the value could be different for different contacts and is unpredicable.

The workflow the action is in would trigger off of update to "Last Page Seen" property with filter for it to include the specific parameter I need to capture the value of.

Re: Extracting Param Value From URL Path Using Custom Code

karstenkoehler — Fri, 12 Apr 2024 04:42:42 GMT

Hi @JoshuaW,

This should be possible with a regex replace:

I'm not a regex expert but this code snippet should correspond to anything before the parameter:

^.*\?npsevent=

Explanation:

^: Matches the beginning of the string.
.*: Matches any character (including spaces) zero or more times. This captures everything before "?npsevent=".
\?npsevent=: Matches the exact string "?npsevent=".

Replacement Text: Leave the replacement text empty (""). This effectively removes the matched portion of the string.

You should then be able to save the remaining parameter into a new property. I haven't tested this but it feels doable 🙂

Best regards!

Re: Extracting Param Value From URL Path Using Custom Code

JoshuaW — Tue, 18 Jun 2024 14:31:58 GMT

Hi Karsten,

Thanks for the response. It helped me get part way to my goal, but not fully isolate value needed.

Using the following does copy over the value of the parameter, but it is also copying over everything else after it.

Below is example of the value it currently creates, but I want to capture what is green and what I need still removed in red. Meet%20the%20Business%20Network%20Newsroom&utm_campaign=2024_MTN&utm_medium=email&_hsenc=00000JQJR_KdgJ0E4&_hsmi=000008085&utm_content=000008085&utm_source=hs_email

I want only what is after "&npseventname=" and before "&utm_campaign". I'd then want to unencode it to finally paste the result in another custom property.

Re: Extracting Param Value From URL Path Using Custom Code

KKolodinsky — Fri, 07 Mar 2025 15:31:01 GMT

Hey Joshua,

Thanks for posting this and Karsten for the first step. I've come across this post as I was looking to do something similar and adapted code from another community post to push across the finish line: https://community.hubspot.com/t5/9881-Operations-Hub/Custom-code-Format-Data-split-full-name-property/m-p/740086

Sharing here in case it's helpful for you or anyone else that stumbles across this post. Big disclaimer, I'm not an expert in any of this so it's possible that there's a better way to do it.. this is just what worked for me.

---

My use case: Extract utm_content from Last Page Seen

Example Last Page Seen value: https://yourdomain.com/?utm_source=example_source&utm_medium=example_medium&utm_content=content_type&utm_campaign=example_campaign

Enrollment Filter: Last Page Seen contains utm_content

1. Format data with regex_replace: ^.*utm_content=

Example output: content_type&utm_campaign=example_campaign

2. Custom code (Python 3.9)

Property to include in code: input_string = Action outputs - [String] value from step 1

Use this code, customizing for your output field names

def main(event):

content_string = event.get("inputFields").get("input_string")

string_list = content_string.split("&")

utm_content = string_list[0]


return {
"outputFields": {
"utm_content": utm_content,
}
}

Example output: content_type

3. Edit record, setting the property value to the string identified in 2. Custom code