Sign in to Community
Sign in to view all badges
I want to set up a schedule job that queries table 'A' and send the result output to email address firstname.lastname@example.org as txt file or csv.
Is possible to do this kind of activity using workflow in ACC?
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
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.
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-acti...
Steps on how to attach a calculated file: https://experienceleague.adobe.com/docs/campaign-classic/using/sending-messages/sending-emails/attac...