FTP from Salesforce SOQL to csv file has blank columns
I have a SOQL query successfully pulling records from Salesforce and sending them to a FTP server.
But each row has two blank columns and a column with the salesforce ID that are not part of my SOQL.
Is there a way to prevent these blank columns from generating in the file?
0
Comments
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.
Thanks!
Please sign in to leave a comment.