Skip to main content
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Tobias_Lohmann
Tobias_LohmannAccepted solution
Adobe Employee
Feb 1, 2022 3:14 PM UTC

Hi all,

you could also use the File class (https://experienceleague.adobe.com/developer/campaign-api/api/c-File.html?hl=file) to achieve this:

var f = new File("/path/to/output/file.csv");
f.open("a"); // opens file in "append" mode
f.writeln("Header 1;Header 2; Header 3");
f.close();

Cheers, Tobias

View in thread

2 replies

Darren_Bowers
Darren_Bowers
Level 9
Feb 1, 2022 4:51 AM UTC

Hi @rebeccat1844660 - I don't think the File Extraction activity will output a header-only CSV file. You have to have at least one data row for it to output the header. Strangely it will create a blank file if there are no rows.

I would use a simple JS execCommand activity to create your header-only CSV e.g.

 

execCommand("echo header_1,header_2,header_3 > /sftp/your/path/goes/here/output_file.csv");

Cheers

 

Darren

Translate
    Tobias_Lohmann
    Adobe Employee
    Tobias_LohmannAdobe EmployeeAccepted solution
    Adobe Employee
    Feb 1, 2022 3:14 PM UTC

    Hi all,

    you could also use the File class (https://experienceleague.adobe.com/developer/campaign-api/api/c-File.html?hl=file) to achieve this:

    var f = new File("/path/to/output/file.csv");
f.open("a"); // opens file in "append" mode
f.writeln("Header 1;Header 2; Header 3");
f.close();

    Cheers, Tobias

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...