File extraction with headers only, no data | Community
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.
Best answer by Tobias_Lohmann

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

2 replies

Darren_Bowers
Darren_Bowers
Level 9
February 1, 2022

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

    Tobias_Lohmann
    Adobe Employee
    Tobias_LohmannAdobe EmployeeAccepted solution
    Adobe Employee
    February 1, 2022

    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

      Terms & ConditionsAccessibility statement

      Loading footer...