+ Start a Discussion
Ruslans ScelkunovsRuslans Scelkunovs 

Export data in CSV format with custom header

We have the following requirements for CSV data file export:
  • a header row consisting of today's date in CCYYMMDD format + client reference number (hardcoded string);
  • customer's data in each row: reference number, 'I' (for individual), Title, Forename, Middle Initial, Surname, [empty string], Date Of Birth in CCYYMMDD format;

Example:

Example file format

could someone confirm or deny whether it is possible to export such a file using SalesForce WebAPI? Preferably using RESTful GET over https.
Anuj PatelAnuj Patel
Hi,

You can do it using CLI (Commend line interface).
To resolve this issue, you need to create a Mapping file with your desired headers. 
Go to the PDF link and on page # 35 for all the steps.
http://resources.docs.salesforce.com/198/17/en-us/sfdc/pdf/salesforce_data_loader.pdf

Please let me know if you still have any questions.

Please mark it as the best answer if you find it useful.
Thanks,
Anuj.
 
Ruslans ScelkunovsRuslans Scelkunovs
Thanks Anuj. Is it possible to download genereted data file using SalesForce WebAPI over HTTPS?
Anuj PatelAnuj Patel

Hi, 
I dont think that salesforce would allow, but Ohh well. 

That could be a separate new question, May be someone might have done it somewhere.

Im sorry, I do not have any idea on that.


Thanks,
Anuj.