Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Export Data using Workflow

Avatar

Avatar
Level 1
gnals12
Level 1

Likes

0 likes

Total Posts

10 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
gnals12
Level 1

Likes

0 likes

Total Posts

10 posts

Correct Reply

0 solutions
View profile
gnals12
Level 1

07-05-2021

Hi,

 

I want to set up a schedule job that queries table 'A' and send the result output to email address first.last@dummycompany.com as txt file or csv.

Is possible to do this kind of activity using workflow in ACC?

 

Thanks!

Accepted Solutions (0)

Answers (3)

Answers (3)

Avatar

Avatar
Validate 1
MVP
_Manoj_Kumar
MVP

Likes

111 likes

Total Posts

310 posts

Correct Reply

97 solutions
Top badges earned
Validate 1
Contributor
Ignite 1
Shape 1
Give Back 5
View profile

Avatar
Validate 1
MVP
_Manoj_Kumar
MVP

Likes

111 likes

Total Posts

310 posts

Correct Reply

97 solutions
Top badges earned
Validate 1
Contributor
Ignite 1
Shape 1
Give Back 5
View profile
_Manoj_Kumar
MVP

07-05-2021

Hello @gnals12 

 

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

_Manoj_Kumar_0-1620416000180.png

 

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

_Manoj_Kumar_1-1620416136117.png

 

Let me know if that helps

 

 

Avatar

Avatar
Level 1
gnals12
Level 1

Likes

0 likes

Total Posts

10 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
gnals12
Level 1

Likes

0 likes

Total Posts

10 posts

Correct Reply

0 solutions
View profile
gnals12
Level 1

07-05-2021

gnals12_0-1620413901009.png

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.

Avatar

Avatar
Validate 1
MVP
_Manoj_Kumar
MVP

Likes

111 likes

Total Posts

310 posts

Correct Reply

97 solutions
Top badges earned
Validate 1
Contributor
Ignite 1
Shape 1
Give Back 5
View profile

Avatar
Validate 1
MVP
_Manoj_Kumar
MVP

Likes

111 likes

Total Posts

310 posts

Correct Reply

97 solutions
Top badges earned
Validate 1
Contributor
Ignite 1
Shape 1
Give Back 5
View profile
_Manoj_Kumar
MVP

07-05-2021

Hello @gnals12 

 

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...