How to create dynamic table in email based on data uploaded weekly
We would like to send customers their purchase history in dynamic table using information uploaded to CDO on a weekly basis? Upon upload, the CDO will trigger a service to push the contacts into the same campaign and send out the email to all the records within the CDO.
This will be an evergreen campaign so there should not need to reactivate the campaign weekly and the contacts may or may not repeat, depending if they had made any purchase the previous week.
Understand that Eloqua can only retrieve ONE record per contact via CDO + Field Merge, which is not what we want.
There's also a CDO Content APP (https://support.sureshot.io/hc/en-us/articles/360020570411-CDO-User-Guide) available on the market we can use but I got "502 Bad Gateway" when trying to access Oracle MarketPlace.
Not sure if there any anyway to go around Eloqua system limitation to produce this. Appreciate any enlightenment. Thank you.