FTP from Salesforce SOQL to csv file has blank columns


1 comment

  • Kathyana Queeman Community moderator Technical Writer
    Celigo University Level 2: Seasoned

    Tim Jones, could you provide some further details for your issue? It would be great if you could share a screenshot, also. Redact any sensitive information or protected data from the screenshot.

    What type of file are you generating from the records? Since you're talking about blank columns, I assume it's CSV, but I want to confirm. 

    This article on Importing or transferring files to an FTP server might help. Specifically, the section on the CSV generator helper. It might also be helpful to learn about transforming your data records, which you can use to remove unwanted fields before sending them to the FTP server. To remove unwanted fields, exclude them from the transformation. In the example below, the "Age" field was removed from the final output. 

    Warning: Any fields not included in the transformation rules will be automatically deleted. If you want to include a field in your output, you must add it to the rules. You don’t need to change the field, but you must include it. 

    Please let me know if you have more questions. 



Please sign in to leave a comment.