Problem populating URL from a DE

Question

I've the URLs stored in a Data Extension, and want to print them. Here's what I've done;

Below is the lookup I'm using.

%%= Lookup('Table', 'URL2', 'LANGUAGE_COUNTRY', Lowercase(@LANGUAGE_COUNTRY)) =%%

But it gives an HTTP 400 error.

Using the field LANGUAGE_COUNTRY, I'm able to localize the text using a different DE, with the following lookup;

%%= Lookup('Text_Table', 'TEXT1', 'LANGUAGE_COUNTRY', Lowercase(@LANGUAGE_COUNTRY)) =%%

So I doubt that there's something wrong with the lookup I'm using,

Can anyone help me on that? And if I haven't provided enough information, please let me know and I'll edit the question.

edit: Here's the pastebin of a portion of the code, http://pastebin.com/apvBw1gb

The values of the url are very much like the difference between https ://www.google.nl/ and https ://www.google.fr/

So the https://www.google.%%LANGUAGE_COUNTRY%% can be one of the two examples above.

Could you add the complete code? Are there any parameters in your URL? — Dr. Xavier, Feb 28, 2017 at 11:06
I've edited the question, I didn't have enough rep to post more than 2 urls in it, so please ignore the spaces after the https:// — firko, Feb 28, 2017 at 11:34
I would do the following, use a variable and assign the value of the lookup, then display the content of the variable as a text in your HTML. That should give you some idea of what is happening. Then use the variable after in href line. — Dr. Xavier, Feb 28, 2017 at 11:53
Using a variable can definitely work, but is not an ideal solution since there'll be lot of emails & a lot of links in them. Wrapping the lookup with a redirectto function will work. I'll submit an answer now. — firko, Feb 28, 2017 at 12:37

firko · Accepted Answer · 2017-02-28 12:39:53Z

2

I've wrapped the lookups of the links with RedirectTo() function, and that was it!

%%= RedirectTo(Lookup('Table', 'URL2', 'LANGUAGE_COUNTRY', Lowercase(@LANGUAGE_COUNTRY))) =%%

answered Feb 28, 2017 at 12:39

firko

3242 silver badges13 bronze badges

Add a comment |

1 Answer 1