Expand my Community achievements bar.

SOLVED

Extract a web app report in customised format.

Avatar

Level 3

Hi Everyone,

 

We have a requirement to send the delivery logs to my local computer.

Note:

We don't have access to SFTP access.

I have a query activity to extract delivery logs, and then I connected it with a data extraction activity to upload it to the server. Now I need to download the uploaded file to my local system. I'm expecting JavaScript code to process this request. Is there any way that I can get the files to be downloaded on my local system from a workflow? We are trying to achieve this is Adobe Campaign classic version 7. Thanks in advance.

Current flow:

QUERY >>> DATA EXTRACTION >>> JAVASCRIPT CODE?? >>> END

 

The above-mentioned is not possible; we are trying to extract the data from the web app report, so I can enter my campaign name or delivery label to get the data. The problem is that when I click on export data in Excel format, it is getting extracted in the below format, which seems unclear.


Report output

Sujith_02kumar_5-1705063752114.png

 

Excel output

Sujith_02kumar_6-1705063850550.png

Sujith_02kumar_2-1705062854958.png

 

I want the report to be in the below format, and it should be downloaded in CSV format if possible.

Sujith_02kumar_3-1705063013910.png

 

Flow in web app report

 

Sujith_02kumar_4-1705063127517.png

 

Sujith_02kumar_7-1705063991528.png

 

Also, please let me know if we can export large amounts of data without any issues.

Any help regarding my query would be appreciated. Thanks in advance.

 

Regards,

Sujith Kumar

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hello @Sujith_02kumar 

 

In your query, Apply a filter that the email is not empty.


     Manoj
     Find me on LinkedIn

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hello @Sujith_02kumar 

 

In your query, Apply a filter that the email is not empty.


     Manoj
     Find me on LinkedIn