We are trying to bring into our emails dynamic content from our websites; I am working on a way to achieve this. I imported a sample of the XMLs that we would generate of the website into a Data Extension and I am trying to reference these via amp script. I do not get an error message I just receive a blank screen.
I saved the xmls in a non sendable data extension. Code I wrote is below:
%%[ var @SubscriberKey SET @rows = LookupOrderedRows('EE_BookingExtensions_Cris',0,'[Tour Number] desc','SubscriberKey',SubscriberKey) SET @rowcount = RowCount(@rows) if @rowcount > 0 then for @i = 1 to @rowcount do set @row = row(@rows,@i) set @tour = field(@row,"Tour Number") ]%% %%[next @i]%% Tour Code from Sendable DE:%%=v(@tour)=%%<br> %%[endif]%% <br> %%[ SET @xml = Lookuprows('XML_CRISSS','TourCode',@tour) for @j = 1 to rowcount(@xml) do SET @xmlrows = row(@xml,@j) SET @xmlls = field(@xmlrows,"CODE__HTML") SET @brochure = BuildRowsetFromXML(@xmlls,'/TourInfo/SellingCompanies/SellingCompany/Brochure/Name',1) set @TourName = BuildRowsetFromXML(@xmlls,'/TourInfo/TourName',1) ]%% %%[ next @j ]%% <br>Your brochure is: %%=v(@brochure)=%% <br>Your Tour Name is: %%=v(@TourName)=%%
Any guidance is appreciated.