Skip to main content
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Manoj_Kumar
Manoj_KumarAccepted solution
Community Advisor
May 7, 2021

Hello @hule 

 

You can use the query activity to pull the data from Table A. Then use the data extraction activity to create a CSV file and finally, you can attach that exported file to delivery.

 

These two links will guide on how to do the data extraction and configure attachment for the delivery.

How to use data extraction activity: https://experienceleague.adobe.com/docs/campaign-classic/using/automating-with-workflows/action-activities/extraction--file-.html?lang=en

 

Steps on how to attach a calculated file: https://experienceleague.adobe.com/docs/campaign-classic/using/sending-messages/sending-emails/attaching-files.html?lang=en#attach-a-local-file

 

 

Manoj  | https://themartech.pro
View in thread

8 replies

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity AdvisorAccepted solution
Community Advisor
May 7, 2021

Hello @hule 

 

You can use the query activity to pull the data from Table A. Then use the data extraction activity to create a CSV file and finally, you can attach that exported file to delivery.

 

These two links will guide on how to do the data extraction and configure attachment for the delivery.

How to use data extraction activity: https://experienceleague.adobe.com/docs/campaign-classic/using/automating-with-workflows/action-activities/extraction--file-.html?lang=en

 

Steps on how to attach a calculated file: https://experienceleague.adobe.com/docs/campaign-classic/using/sending-messages/sending-emails/attaching-files.html?lang=en#attach-a-local-file

 

 

Translate
Manoj  | https://themartech.pro
HuLeAuthor
Level 2
May 7, 2021

Hi Manoj, I have couple questions. Can this be done in one workflow?  what action do I need to do it?

Thanks!

Translate
HuLeAuthor
Level 2
May 7, 2021

I am still struggling how to connect 'Data extraction' to 'Delivery'

 

I want to attach the file that was created in 'Data extraction' to the email delivery.

Translate
Manoj_Kumar
Community Advisor
Manoj_KumarCommunity Advisor
Community Advisor
May 7, 2021

Hello @hule 

 

Follow these steps to get the uploaded file URL: (double click on point 3)

 

Once you have the file path Open the delivery and go to attachment and follow these steps: Click on the highlighted area

 

Let me know if that helps

 

 

Translate
Manoj  | https://themartech.pro
HuLeAuthor
Level 2
May 7, 2021
Hi Manoj, Thanks for detail explanations! Unfortunately, I still have the error message in 'Delivery' action that says "The schema for recipients specified in the transition ('nms:broadLogRcp') is not compatible with the schema defined in the delivery template ('nms:recipient'). They should be identical."
Translate
Terms & ConditionsAccessibility statement

Loading footer...