In today’s continuous integration solution built for Salesforce, if you need to load sample data into Salesforce then either we use command line dataloader or custom tool built to import export records.
With Salesforce DX, we can import and export records right from Salesforce DX. Again, if you are new to Salesforce DX, then first read this blog post to quickly understand what is Salesforce DX.
We don’t need Developer Hub or Scratch Orgs to use Salesforce DX for import and export. In this blog post, I have used my regular developer org for demo.
First step as always, to make sure if Salesforce DX CLI is connected to your Org or not ? If its not connected then use below command to connect and give alias which is easy to remember.
sfdx force:auth:web:login --setalias jzaa1
Export records using Salesforce DX
Below command can be used to export 10 Account records. We can change this SOQL as per requirement
sfdx force:data:tree:export -q "SELECT Id,Name FROM Account limit 10" -d ./ilovenag -u ilovenagpur@gmail.com
Where
-q : SOQL query
-d : directory, where exported json file can be saved
-u : Salesforce user to perform operation
Import records using Salesforce DX
Use below command to Import records in Salesforce instance, which we just exported in previous step
sfdx force:data:tree:import -f ilovenag/Account.json -u jzaa1
Where
-f : JSON file to be imported
-u : Salesforce user to perform operation
Leave a Reply