I have only recently started using the salesforce marketing cloud (exact target) to send out emails, so if there's something conceptually wrong with my question, forgive me :).
So let's say I have email - with some text - where I would like to display a list of items in a form of:
Dear %%Name%%. Your items are:
<table>
<tr>
<td> Item one id </td>
<td> Item one text </td>
</tr>
<tr>
<td> Item two id </td>
<td> Item two text </td>
</tr>
</table>
This email is than sent out as a triggered send via api calls.
To populate this email with data I have created a Data Extension, where I defined a few fields, but I'm stuck on how to define the data for my list. So in this setup, what would be the best way of handling this situation?
I started looking into it and it seems like I can't simply create an array type in my data extension. So I was wondering if maybe I should pass my items in text - either as xml/json serialize -, that I can later on somehow loop through in the email to build up the list?
But I didn't really get anywhere.
Any help is greatly appreciated.