Column’s order when exporting

I know many of you have asked this question, so I wanted to share some information on how the column's order is defined when exporting:

When using Query Builder with Batch API.

  • The column's order in a CSV file is defined by the order in which the objects are listed in the Query Builder (The fields on the left side of the Query Builder’s UI under the title 'Fields'). 
  • The column's headers are returned as field labels. 

When using Query Builder with Bulk API.

  • The column's order in a CSV file is defined by the order in which the objects are listed in the Query Builder (The fields on the left side of the Query Builder’s UI under the title 'Fields'). 
  • The column's headers are returned as API Names. 


When using a Custom SOQL

  • The column's order in a CSV can be changed by customizing SOQL query. 
  • The headers are returned as API Names (not field labels). 

 

dataloader.io Team

Have more questions? Submit a request

Comments

  • Avatar
    David Raimist

    For Custom SOQL i am able to control the order of the column on output. FYI. The order matches the SOQL

Please sign in to leave a comment.