โ02-07-2018 07:12 AM
Hello. Letโs say I have JSON like the following:
[
{
โOwnerNameโ: โMike Waltzโ,
โOwnerEmailโ: โmwaltz@testcompany.comโ,
โLeadNameโ: โJohn Doeโ,
โLastModifiedDateโ: โ2017-10-05T13:43:39.000+0000โ
},
{
โOwnerNameโ: โMike Waltzโ,
โOwnerEmailโ: โmwaltz@testcompany.comโ,
โLeadNameโ: โJane Smithโ,
โLastModifiedDateโ: โ2017-10-05T18:32:46.000+0000โ
}
]
How can I convert that into an HTML table to send in an email via the Email Sender Snap? Example is from an online source that does it to get the desired output from the JSON from this URL: Best Online JSON to HTML Converter:Display JSON into HTML format
โ02-07-2018 08:37 AM
@matt.bostrom,
In itโs simplest form, you can do something like this:
With HTML table selected, the payload specified by the Table-data path is injected inside the <table></table> elements. You can add CSS to pretty it up as needed.
โ05-03-2018 09:43 AM
Hi Del. In this example it seems that its still only sending to 1 single email address even though I have the $groupBy.OwnerEmail in the TO variable of the email snap. I have it broken out into 2 groups and confirm that via the JSON i see multiple groupByโs with emails yet its only sending one this way. Any ideas?
โ05-03-2018 10:01 AM
actually i believe its the โBatch Sizeโ attribute that fixes this. When i change it from 100 to 1 it seems to behave the way I expect.
โ02-08-2018 07:33 AM
@del this is FANTASTIC. Works like a charm thank you for the insight.