Saving SOQL result as CSV using SFDX command
1. Login to Salesforce environment using below command
sfdx force:auth:web:login -r https://test.salesforce.com -a devEnv
2. Then execute below statement to extract soql data into a csv file
sfdx force:data:soql:query -u devEnv-r csv -q "Select Id FROM Account" > ./csv/account_uat.csv
3. Below script executes soql from text file. Save the script in a test.batch file and run the batch file in command prompt after login to Salesforce in SFDX
@echo off
FOR /F "tokens=1,2,3 delims==" %%G IN (soql.txt) DO (
@echo %%H %%I
sfdx force:data:soql:query -u devEnv -r csv -q "%%G" > ./csv/%%I/%%H.csv
)
soql.txt
SELECT Id,Name from Account=filename1=foldername1
SELECT Id,Name from Contact=filename2=foldername2
SELECT Id,Name from Lead=filename3=foldername3
Comments