Html not recognized in email template while using custom macros

Dear Oleksii,

Thanks for reaching out.

Could you please provide us an example of macros you are trying to insert into your email template?

Thanks in advance. 

Best regards,

Anastasiia

Anastasiia Marushenko,

namespace Terrasoft.Configuration
{
	using System;
	using Terrasoft;
	using Terrasoft.Common;
	using Terrasoft.Core;
	using Terrasoft.Core.Entities;
	using Terrasoft.Core.DB;
	using Newtonsoft.Json;
 
	public class NewEmailMacros : IMacrosInvokable
    {
        public UserConnection UserConnection {
            get;
            set;
        }
        public string GetMacrosValue(object arguments) {
//        	var sjson = JsonConvert.SerializeObject(arguments);
//        	var templ = new {Key = String.Empty, Value = String.Empty};
        	var currencyId = "c1057119-53e6-df11-971b-001d60e938c6";
        	var esq = new EntitySchemaQuery(UserConnection.EntitySchemaManager, “Object"); 
            var colCode = esq.AddColumn("Column1"); 
            var colPercentage = esq.AddColumn("Column2"); 
            var colCurrency = esq.AddColumn("Column3");
            var colType = esq.AddColumn("Column4");
            var colDate = esq.AddColumn("Column5");
	        var colDay = esq.AddColumn("Column6"); 
          	var CurrencyFilter = esq.CreateFilterWithParameters(
    		FilterComparisonType.Equal, "Column3.Id", currencyId); 
	          esq.Filters.Add(CurrencyFilter);
           EntityCollection entities = esq.GetEntityCollection(UserConnection);
 var html = "<table><tr><td>Percentage</td><td><th>Code</th></td><td>Currency</td><td>Type</td><td>Date</td><td>Day</td></tr&gt";
            foreach (Entity entity in entities) {
 	          	html += "<tr>";
 	          	html += "<td>" + entity.GetColumnValue(colPercentage.Name).ToString() + "</td>";
            	html += "<td>" + entity.GetColumnValue(colCode.Name).ToString() + "</td>";
     	      	html += "<td>" + entity.GetColumnValue(colCurrency.Name).ToString() + "</td>";
      	     	html += "<td>" + entity.GetColumnValue(colType.Name).ToString() + "</td>";
         	  	html += "<td>" + entity.GetColumnValue(colDate.Name).ToString() + "</td>";
				html += "<td>" + entity.GetColumnValue(colDay.Name).ToString() + "</td>";
            	html += "</tr>";
            }
				html += "</table>";
            	return html;
        }
    }
}

Anastasiia Marushenko,

I dont know why it kept changing the code, and adding the amp*

html += "</table>";

 

Oleksii Protsiuk,

Hello,

&amp;lt; means that there should've been < in the code. I believe there is an issue with the html code translation in your template. You need to replace:

&amp;lt; with <

&amp;gt; with >

&amp;gt with > either

using Notepad++ replacement for example (I've modified the code you sent using this text editor). As a result I received a correct code, but after that the HTML should be checked. This can be done via the tests in Visual Studio and receivig the HTML code result and verifying it for example here. You can use some test values instead of entity.GetColumnValue(colPercentage.Name).ToString() to verify the code.

Oleg Drobina,

Thank you very much!

That helped.

You can use the Enhanced template macros for Creatio app from Marketplace.

You won't need to write additional code.

https://marketplace.creatio.com/app/enhanced-template-macros-creatio