0

I want to ask regarding BULK API 2.0 Query/data downloading through workbench and postman.

Scenario I am downloading salesforce data in form of CSV. Query i am executing is "SELECT Id,Name,BillingStreet,FAX FROM Account"

Output: The result/CSV of this query is coming in alphabetically sorted order of Column Names.

"BillingStreet","Fax","Id","Name"
"","","0015400000NwqyaAAB","Robert981Carter"
"","","0015400000NwqybAAB","Robert1385311343656684448Carter"
"","","0015400000NwqycAAB","Robert1455756551741454749Carter"
"","","0015400000NwqydAAB","Robert1476149531515781847Carter"
"","","0015400000NwqyeAAB","Robert168214215136337732Carter"

Expected Output: The result/CSV should be in the order the columns are written in SOQL query.

For example

"Id","Name","BillingStreet","Fax"
 "0015400000NwqyaAAB","Robert981Carter","",""
 "0015400000NwqybAAB","Robert1385311343656684448Carter","",""
"0015400000NwqycAAB","Robert1455756551741454749Carter","",""
 "0015400000NwqydAAB","Robert1476149531515781847Carter","",""
 "0015400000NwqyeAAB","Robert168214215136337732Carter","",""

This Behaviour was not observed in BULK API 1.0

Could you please let me know if this is the behaviour of BULK API 2.0 and if we can do any change at API level to get CSV in unsorted form.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.