Extract a web app report in customised format. | Community
Skip to main content
Level 4
January 12, 2024
Solved

Extract a web app report in customised format.

  • January 12, 2024
  • 1 reply
  • 760 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Manoj_Kumar

Hello @sujith_02kumar 

 

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

1 reply

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity AdvisorAccepted solution
Community Advisor
January 14, 2024

Hello @sujith_02kumar 

 

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

Manoj     Find me on LinkedIn