What is the best way to send an order confirmation email from Marketing cloud when an order with multiple lines is created in Sales Cloud.
Here we using two custom objects from Sales Cloud to capture the Order created data.
The Solution I am thinking is to create a Journey with one single object and create an email with ampscript to retrieve the Salesforce Objects and its not working for some reason.
Please see the attached script I am using.
When trying to activate the journey, I am getting the following error.
Looking forward for the help.
Kind Regards, Harry