Extract a web app report in customised format.

[Sujith_02kumar]

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

Excel output

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

Flow in web app report

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

[_Manoj_Kumar_ · Accepted solution]

Hello @Sujith_02kumar 

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