Extract attribute-data from a url

[smarh]

I have an event attribute "page_url" with a value of the structure "abc&def=123&ghi=456&jkl=789"

I want to extract the information "456" and store this value as a visitor attribute. I tried the string-enrichment "join", because it's the only one I found where I can define a delimiter. But using the delimiter "&" first and then "ghi=" results in the same value as page_url, so no effect. How can I solve this?

[FlorianSchluett]

Hi @smarh,

the structure of your "page_url" attribute looks like querystrings in a URL, if this is the case you can simply use an event attribute of type "Querystring" that is named like the querystring you want to extract. 

In your example, if the url is: https://www.yourwebsite.com?abc&def=123&ghi=456&jkl=789 you would just use a event attribute "ghi" of type Querystring and afterwards create an visitor attribute of type string that is enriched by event attribute "ghi". 

If it's not about querystrings, you need to use a transformation function. This requires some JavaScript Skills. If you are not comfortable with this, you can referr to the Tealium support. They helped me with a similar issue in the past.

Regards,
Florian

[smarh]

Hello @FlorianSchluett ,

thanks for the hint and the instruction. I created a querystring attribute and that worked fine for TiQ events. I see the querystring attribute e.g. on the section Live Events. But we also use Kafka events and for those events I don't see any information for the querystring attribute. Any knowledge about the workflow for Kafka events? If not, still thanks a lot, at least it helped me to get a part of what i need.

Best regards,

Steffen

[FlorianSchluett]

Hi @smarh,

unfortunately I'm not familiar with Kafka events. I guess that could be a topic for the Tealium Support as pointed out in my previous post :) 

Best,
Florian