How to iterate array of objects in Sendgrid template?

[ghost]

Mandrill provides support for Handlebars template and so looping is supported. As I read, Sendgrid doesnot support each like directive. So how do the sendgrid users tackle this shortcoming?

I want to loop through the products, as shown in below object.

products:
[ { name: 'VEEBA SWEET CHILLI SAUCE 1KG',
   qty: 2,
   price: 145,
   packSize: '1 KG',
   itemSubTotal: 290,
   comments: null },
 { name: 'Chilled French Fries',
   qty: 1,
   price: 85,
   packSize: '1 KG',
   itemSubTotal: 85,
   comments: null } ]

[thinkingserious]

Hello @sabapk,

Please open a ticket at https://support.sendgrid.com. Thanks!

[adamreisnz]

is this supported yet by the templating engine?

[thinkingserious]

@adamreisnz,

I'm checking with our product team for an update, thanks!

[thinkingserious]

@adamreisnz,

This is on our radar for implementation, but there is no estimate on timeline yet.

[adamreisnz]

Ok thanks for the update. I guess a work around would be to generate the looped HTML manually and pass that in as a substitution. Crude, but it would work.

[eupharis]

@thinkingserious I am subscribed to this issue. Is there another way I could subscribe for notifications about iterator implementation in sendgrid templates?

[thinkingserious]

Hello @eupharis,

Please make sure the email you have in your SendGrid account settings is up to date. We send product announcements to that email address.

Thanks!

Elmer

[free4ride]

Hi @thinkingserious
What is status of this issue?
When is it coming live?

[thinkingserious]

Hi @free4ride,

There is still no estimate on timeline yet.

The best option to be notified of any updates on this issue is to make sure the email you have in your SendGrid account settings is up to day.

Thanks!

Elmer

[davidhagg]

As @adamreisnz commented, sending the array in as a HTML might work, however we are experiencing problems with the substitutions being too large, exceeding 10000 bytes

[stephengardner]

Sendgrid, I thought, was a pretty good alternative to Mandrill.

No looping?

That's actually ridiculously surprising from such a large service....

It's impossible to even create a checkout order success form, because you need to loop through the items purchased and display them.

Oh well, another one down.

[thinkingserious]

Hello @stephengardner,

Have you tried using substitutions with our templates? Check this out.

If that does not fit your need, let me know and I'll try to figure out how to help you achieve the results you need.

Thanks!

With Best Regards,

Elmer

[adamreisnz]

Substitutions don't work for listing a table of purchased products for example, because they can only replace one value, and not an array of values, let alone an array of objects with more detailed values.

What we need is support to loop through products and have a template for each product that then gets repeated depending on how many products you supply for the substitution.

The only way around it is kind of half-baked -- you'd have to generate the HTML on the server, and send that whole chunk of HTML as a single substitution. Clearly that is not ideal as you then have part of the layout sitting in server side code instead of nicely in the online template where designers can edit it.

I do agree that this is a major item that's preventing us from using templates as well. As such, we have templates on our server and process them there using handlebars, which does support looping, if statements, etc. We then just send the entire HTML out as mail body, which is a bit of a waste of resources.

[thinkingserious]

Thanks @adamreisnz,

I have reached out to the product team that owns this functionality. I will update this thread when I learn more.

With Best Regards,

Elmer

[thinkingserious]

Hi @stephengardner, @adamreisnz,

Your votes have been added to give this feature higher priority for implementation.

Please make sure the email you have on file for your account is up to date, that is how we would notify you of the implementation of the feature.

With Best Regards,

Elmer

[psavard]

I would like to vote up this feature too. This is a must for you system.

Thanks ;)

[free4ride]

Completely agree. Up-vote from me and my team! Please add this feature asap.

[thinkingserious]

Thanks @free4ride, your vote has been added.

[gabzim]

+1, I was surprised to find this is not implemented yet, I assumed iterating would work. Add my vote please.

[eupharis]

+1! Iterators would be awesome!!

[thinkingserious]

@arg20, @eupharis,

Your votes have been counted, thanks!

[MaxShv]

Any ETA on this? It is ridiculous that this feature hasn't been implemented yet. Right now we are generating the email body on the server and it is getting rejected by sendgrid API because it is over the substitute limit.

[etyp]

@thinkingserious any update on this? We're likely to move off of Sendgrid in the coming week if there's no affirmative movement on it. We can't afford to compromise the quality of our emails because a standard feature like this isn't supported by a large service.

[thinkingserious]

Hi @MaxShv, @etyp,

I have added your votes and passed this additional feedback to our product team.

I don't have any new insights into the progress on this, but once I do find that there is movement, I will update this thread.

With Best Regards,

Elmer

[9mm]

The fact you don't have this is a complete a utter joke.

[thinkingserious]

You vote has been added @9mm, thanks!

[futhr]

Hi @thinkingserious, thanks for a great service, what is the progress of this? You would be so much more awesome if you can add e.g. Handlebars support without forcing your clients to use an external webhook service like Sendwithus.

Thanks

[ronneyramon]

I´m interest in this too!!!

[gferrin]

WTF is wrong with you guys. I wish I read this before signing up for SendGrid. How has it taken you OVER TWO YEARS to implement such a basic feature!

[ameesme]

We have decided to switch to Mailjet, which does support features like (multi-dimensional) looping, if-statements, variables and some functions for dynamically generating blocks, with a Node.js-wrapper on Github as well.

The development of this feature takes way too long.

[thinkingserious]

Thanks for all of the additional votes to get this completed, we can't wait for this to be released also!

This feature is already in active development and if you would like to be added to the beta, please send an email to [email protected].

Thanks!

[adamreisnz]

@thinkingserious and it's looking good! :)

[iBet7o]

The turn of the corner seems too far away!

I'm waiting too

[miller-aaron]

+1 need this as well

[subratbasnet]

Definitely +1 - on the verge of switching to another provider just because of this feature.
I have emailed @ben-grid to see if we can have it enabled for our account.

[bcarradini]

We will also be emailing @ben-grid to get on this beta. +1

[giedriusr]

Can't believe it doesn't have such a basic feature.

[subratbasnet]

It looks like in the beta, this feature is now there under "transactional" templates. The old templates seems to have been renamed to "legacy"

How do I access this via API @ben-grid , do we have docs for this? The 3.0 API does not seem to have it.

Thanks

[dbalayan]

+1
need this to migrate on SendGrid completely without any crutches!

[ben-grid]

Hey all,

I just wanted to give an update here. First of all, A BIG thank you to everyone who has participated in interviews and the beta program. Your feedback has been invaluable! Second, thank you to EVERYONE on this thread for your patience. I've read all of your comments and, candidly, your frustration is completely understandable. You've waited a long time for a very critical feature and I couldn't be happier that we are finally closing that gap.

If you don't have access already and need it, shoot me an email @ [email protected] to get into the beta. We'll also be rolling this out to ALL users just around the corner, and I'll update this thread soon with a firm date.

Thanks again, you all rock!

[TimoWestland]

Hi @ben-grid I've emailed you to get access to the beta but I'm not getting any replies. Is there any way we can get access to this asap? We would really like to use sendgrid as our e-mail engine but this is blocking us...

[loeklj]

@ben-grid same here 👍 Please let us know when we would be able to get Beta access.

[catamphetamine]

2 years and still not implemented.
People are hitting the 10000 limit which even lies about it because I made parameters less than 10000 bytes by splitting them in half and it still complains that "Substitutions are limited to 10000 bytes per personalization block".

[thinkingserious]

Hello @catamphetamine,

This feature is hitting GA very shortly. If you would like beta access prior to that, please reach out to [email protected].

Thanks!

With Best Regards,

Elmer

[sendgrid-ryan]

Hey all! Great news––

Dynamic content for Transactional Templates is here!

This morning, our team publicly launched dynamic content for transactional templates. It is now available for all customers sending over v3 of our Mail Send API. Iterate over lists, handle conditionals and more, thanks to native support for a subset of Handlebars syntax!

More information can be found in our blog post announcement.

Documentation:

• How to Send an Email With Dynamic Transactional Templates
• Using Handlebars
• API Docs

Thank you, on behalf of the entire SendGrid team, for all of the feedback throughout the beta program. 🙌🏻

[adamreisnz]

Great news, good work team 💯

[dougdonohoe]

This dynamic template stuff is great. Nice work and great timing for us :-)

[token-appsolzone]

  {{#each attendee}}
    <table style="border: 1px solid #ccc;
box-shadow: 0 0 3px #000; font-size: 13px; font-weight: 600">
<tr>
      <td style="width:120px;">Attendee Name</td>
      <td>:</td>
      <td>{{attendeeName}}</td>
    </tr>
    <tr>
      <td style="width:120px;">Email</td>
      <td>:</td>
      <td>{{attendeeEmail}}</td>
    </tr>
    <tr>
      <td style="width:120px;">Phone</td>
      <td>:</td>
      <td>{{attendeePhone}}</td>
    </tr>

</table>
{{/each}}

data--
{
"attendee":[
{
"attendeeEmail":"[email protected]",
"attendeeName":"Token",
"attendeePhone":"12345678"
},
{
"attendeeEmail":"[email protected]",
"attendeeName":"Arnab",
"attendeePhone":"6483652"
},
{
"attendeeEmail":"[email protected]",
"attendeeName":"Musha",
"attendeePhone":"9735427"
}

    ]
}

[azizjawad]

Thanks, bro that was really helpful

[rastiehaiev]

Hi! Is there any way to have iteration inside iteration?

[token-appsolzone]

yes nested iteration is possible
{{#each first array}}

{{#each innerarray}}
your html or data presentation
{{/each}}

{{/each}}

[StavoG]

Thanks a lot for this. It helped me so much

[sourabhCofoundry]

Hello, token-appsolzone Please help me Please create send grid code for this data
{
"publisResult": [
{
"key": {
"SearchTerm": "flower"
},
"data": [
{
"PublisImgUrl": "https://picsum.photos/200/300.jpg",
"Name": "Jhon",
"Title": "gardenflowershop",
"Description": "OnlineFlower"
},
{
"PublisImgUrl": "https://picsum.photos/200",
"Name": "Tommy",
"Title": "weddings",
"Description": "Wedding"
}
]
},
{
"key": {
"SearchTerm": "Pizza"
},
"data": [
{
"PublisImgUrl": "https://picsum.photos/200/300",
"Name": "Harry",
"Title": "benny-drinnon.com",
"Description": "TAMELAC"
},
{
"PublisImgUrl": "https://picsum.photos/200/300",
"Name": "Roma",
"Title": "benny",
"Description": "Michelle"
}
]
}
]
}

[sourabhCofoundry]

Any update on it.